Mybatis使用where标签动态生成SQL语句的sql语句智能化生成用法解析-----Mybatis框架

﹏ヽ暗。殇╰゛Y 2024-03-03 08:27 73阅读 0赞

>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <!DOCTYPE mapper
>             PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>             "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="com.powernode.mybatis.mappers.CarMapper">
>     
>     
>     
>     
>     
>     
>         <select id="selectByMultiCondition" resultType="Car">
>             select * from t_car where 1 = 1
>             <if test="brand != null and brand != ''">
>                 and brand like '%${brand}%'
>             </if>
>             <if test="guidePrice != null and guidePrice != ''">
>                 and guide_price > #{guidePrice}
>             </if>
>             <if test="carType != null and carType != ''">
>                 and car_type = #{carType}
>             </if>
>         </select>
>     
>     
>     
>         <select id="selectByMultiConditionWithWhere" resultType="Car">
>             select * from t_car
>             <where>
>                 <if test="brand != null and brand != ''">
>                     brand like '%${brand}%'
>                 </if>
>                 <if test="guidePrice != null and guidePrice != ''">
>                     and guide_price > #{guidePrice}
>                 </if>
>                 <if test="carType != null and carType != ''">
>                     and car_type = #{carType}
>                 </if>
>             </where>
>         </select>
>     </mapper>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     
>     <!DOCTYPE mapper
>             PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
>             "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
>     
>     <mapper namespace="com.powernode.mybatis.mappers.CarMapper">
>     
>     
>     
>     
>     
>     
>         <select id="selectByMultiCondition" resultType="Car">
>             select * from t_car where 1 = 1
>             <if test="brand != null and brand != ''">
>                 and brand like '%${brand}%'
>             </if>
>             <if test="guidePrice != null and guidePrice != ''">
>                 and guide_price > #{guidePrice}
>             </if>
>             <if test="carType != null and carType != ''">
>                 and car_type = #{carType}
>             </if>
>         </select>
>     
>     
>     
>         <select id="selectByMultiConditionWithWhere" resultType="Car">
>             select * from t_car
>             <where>
>                 <if test="brand != null and brand != ''">
>                     brand like '%${brand}%'
>                 </if>
>                 <if test="guidePrice != null and guidePrice != ''">
>                     and guide_price > #{guidePrice}
>                 </if>
>                 <if test="carType != null and carType != ''">
>                     and car_type = #{carType}
>                 </if>
>             </where>
>         </select>
>     </mapper>