MyBatis Like

MyBatis动态SQL示例

最新推荐文章于 2024-07-28 15:44:03 发布

原创最新推荐文章于 2024-07-28 15:44:03 发布 · 98 阅读

0 ·

CC 4.0 BY-SA版权

MySQL：

<select id="listByPidsLikeName" resultType="com.xdt.ibs.environ.device.bean.Environ">
        SELECT id,pid,logicid,`name`,`type`,ip_addr AS ipAddr,`port`,modbus_addr AS modbusAddr,pm25_h AS pm25H,
　　　　　　pm10_h AS pm10H,temp_h AS tempH,humi_h AS humiH,co2_h AS co2H,tvoc_h AS tvocH,conn_status AS connStatus,
　　　　　　update_time AS updateTime,create_time AS createTime
        FROM environ
        WHERE pid IN 
        <foreach collection="list" index="index" item="item" open="(" separator="," close=")">
            #{item}
        </foreach>
        <if test="name != null and name != ''">
            AND `name` like CONCAT('%',#{name},'%')
        </if>
    </select>