May 16, 2021 MyBatis
The first step is to convert the condition to a timestamp
- long startTime = TimeUtil.parseTimestamp(start);
- long endTime = TimeUtil.parseTimestamp(end);
-
- /*对应工具类*/
- public static long parseTimestamp(String datetime){
- try{
- SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- Date date = dateformat.parse(datetime);
- return date.getTime()/1000;
- }catch(Exception e){
- e.printStackTrace();
- }
-
- return 0;
- }
Then Mapper uses .xml and in the to_timestamp
- <if test="startDate !=null and startDate !='' and endDate !=null and endDate !=''">
- AND tdnm.create_time BETWEEN to_timestamp(#{startDate}) AND to_timestamp(#{endDate})
- </if>