exTime的類型為varchar 存儲的數據格式為yyy-MM-ddTHH:mm:ss,查詢時傳進來的時間格式也需要為yyy-MM-ddTHH:mm:ss格式

    @Query(value = "SELECT * FROM test_fbep  fbep WHERE delFlag = 1 " +"AND IF(?1 != '' AND ?1 IS NOT NULL, fbep.passId = ?1, TRUE) " +"AND IF(?2 != '' AND ?2 IS NOT NULL, fbep.vehicleId LIKE CONCAT('%', ?2, '%'), TRUE) " +"AND IF(?3 != '' AND ?3 IS NOT NULL, STR_TO_DATE(fbep.exTime, '%Y-%m-%dT%H:%i:%s') >= STR_TO_DATE(?3, '%Y-%m-%dT%H:%i:%s'), TRUE) " +"AND IF(?4 != '' AND ?4 IS NOT NULL, STR_TO_DATE(fbep.exTime, '%Y-%m-%dT%H:%i:%s') <= STR_TO_DATE(?4, '%Y-%m-%dT%H:%i:%s'), TRUE) " +"ORDER BY STR_TO_DATE(fbep.exTime, '%Y-%m-%dT%H:%i:%s') ASC", nativeQuery = true)List<InfoVO> findListInfo(@Param("passId") String passId,@Param("vehicleId") String vehicleId,@Param("exStartTime") String exStartTime,@Param("exEndTime") String exEndTime);

exTime的類型為datetime 存儲的數據格式為yyy-MM-dd HH:mm:ss,查詢時傳進來的時間格式也需要為yyy-MM-dd HH:mm:ss格式

    @Query(value = "SELECT * FROM test_fbep fbep WHERE delFlag = 1 " +"AND IF(?1 != '' AND ?1 IS NOT NULL, fbep.passId = ?1, TRUE) " +"AND IF(?2 != '' AND ?2 IS NOT NULL, fbep.vehicleId LIKE CONCAT('%', ?2, '%'), TRUE) " +"AND IF(?3 != '' AND ?3 IS NOT NULL, fbep.businessDateTime >= ?3, TRUE) " +"AND IF(?4 != '' AND ?4 IS NOT NULL, fbep.businessDateTime <= ?4, TRUE) " +"ORDER BY fbep.businessDateTime ASC", nativeQuery = true)List<InfoVO> findListInfo2(@Param("passId") String passId,@Param("vehicleId") String vehicleId,@Param("exStartTime") String exStartTime,@Param("exEndTime") String exEndTime);