sql语句有时候书写正确但是在数据库有值的情况下查不出值，可用下面sql做对应修改

最新推荐文章于 2024-06-22 22:10:29 发布

猿帥

最新推荐文章于 2024-06-22 22:10:29 发布

阅读量777

点赞数

本文链接：https://blog.csdn.net/han_shuai_/article/details/117607853

版权

 @Query(value = "SELECT * from map_patrol_plan " +
     " where if(:planId !='', plan_id = :planId,1=1) " +
     " AND if(:planName !='', plan_name like :planName,1=1) " +
     " AND if(:patrolType !='', patrol_type = :patrolType,1=1) " +
     " AND if(:state !='', statee = :state,1=1),nativeQuery = true)
Page<Map<String, Object>> getPatrolPlanList (String planId, String planName, String 
patrolType, String state,String beginDate,String endDate,Pageable pageable);

@Query(value = "SELECT *" +
        " COUNT(tab2.doneTime) as countDoneTime,tab2.doneTime " +
        "FROM ( SELECT " +
        "   LEFT (tab1.done_time, 10) AS doneTime,tab1.* " +
        "  FROM " +
        "   jc_main_form tab1 " +
        "  WHERE " +
        "   tab1.process_state = '已完成' " +
        "  AND tab1.is_delete = 0 " +
        "AND tab1.done_time BETWEEN ?2 AND ?3 " +
        "and if( ?1 != '', tab1.province = ?1 ,1=1) ) tab2 "
        + "GROUP BY tab2.doneTime "
        ,nativeQuery = true)
List<JcMainForm> getProvinceNum2(String province,String beginDate, String endDate);