mybatis 模糊查询

最新推荐文章于 2024-08-10 16:15:08 发布

weixin_34088838

最新推荐文章于 2024-08-10 16:15:08 发布

阅读量109

点赞数

文章标签： java

原文链接：http://www.cnblogs.com/1234cjq/p/6859933.html

版权

<mapper namespace="com.edc.dao.organize.OrganizeInfoMapper" > //对应相应的mapper.java文件

<select id="findBySearch" resultMap="BaseResultMap" parameterType="java.util.Map" >
    SELECT i.* FROM t_organize_info i,t_location_city ci,t_location_country co,t_location_province p
   WHERE i.provinceId=p.provinceId AND i.countryId=co.countryId AND i.cityId=ci.cityId
    <if test="region!=null and region!=''">
          and (co.countryName LIKE CONCAT(CONCAT('%', #{region}),'%')
          or p.provinceName LIKE CONCAT(CONCAT('%', #{region}),'%')
          or ci.cityName LIKE CONCAT(CONCAT('%', #{region}),'%'))
    </if>
    <if test="organizename!=null and organizename!=''">
          and i.organizename LIKE CONCAT(CONCAT('%', #{organizename}),'%')
    </if>
    <if test="type!=null and type!=''">
        AND i.type LIKE CONCAT(CONCAT('%', #{type}),'%')
    </if>

<if test="searchendmoney!=null and searchendmoney!=''">
       <![CDATA[ AND Approved_num < #{searchendmoney}]]> // 代码块
   </if>
    and i.del=0 order by i.createtime desc
</select>

转载于:https://www.cnblogs.com/1234cjq/p/6859933.html