springboot mybatis 下使用注解组织查询语句（有查询条件传入）

 1  @Select("<script>" +
 2             "select cab.brandpre_id,cab.brandpre_num_app,cab.id,cab.brandpre_num_approve,cab.brandpre_moneyamount,cab.pid ,\n" +
 3             "cbp.material_code,cbp.material_identification,cbp.material_name,cbp.price from crm_activity_brandpre cab \n" +
 4             "left join crm_brand_presentation cbp on cab.brandpre_id=cbp.id\n" +
 5             "<where> " +
 6             "cab.dr=0 " +
 7             "<if test='map !=null'>" +
 8             "<choose>" +
 9             "<when test='map.keys.size > 0'>" +
10             "   <foreach collection='map.keys' item='key' open='and' separator='AND'>" +
11             "           cab.${key} like concat('%',#{map[${key}]},'%') " +
12             "   </foreach>" +
13             "</when>" +
14             "<otherwise>" +
15             "  and  1=1 " +
16             "</otherwise>" +
17             "</choose>" +
18             "</if>" +
19             "</where>" +
20             "LIMIT #{pageindex},#{pagenum} " +
21             "</script>")
22     List<ActivityAppBrandpreInfoDO> selectAppBrandpreAll(@Param("pageindex") Integer pageindex,
23                                                          @Param("pagenum") Integer pagenum, @Param("map") Map<String, String> map);

 

转载于:https://www.cnblogs.com/yangxiaobo-blog/p/11511065.html