＜if ＞与＜where＞标签实现动态sql

最新推荐文章于 2022-11-01 18:25:31 发布

好名字972

最新推荐文章于 2022-11-01 18:25:31 发布

阅读量131

点赞数

文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_67283973/article/details/126777956

版权

接口

/**
 * 批量添加员工
 * @param emps
 * @return
 */
boolean insertEmp(@Param("emps") List<Emp> emps);

sql

<insert id="insertEmp">
    insert into emp values
                        <foreach collection="emps" item="emp" separator=",">
                            (null,#{emp.empName},#{emp.age},#{emp.gender},null)
                        </foreach>
</insert>

/**
 * 通过名字批量删除数据
 * @param 
 * @return
 */
boolean deleteEmp(@Param("empName") String[] empName);

<delete id="deleteEmp">
    DELETE FROM emp WHERE emp_name in
    (
    <foreach collection="empName" item="emp" separator=",">
        #{emp}
    </foreach>
    )
</delete>

List<Emp>selectUserEmp(Emp emp);

   <select id="selectUserEmp" resultMap="empResultMap1">
        select * from emp 
<where>
<if test="empName != null and empName !=''">
    emp_name = #{empName}
</if>
<if test="age != null and age !=''">
   and age = #{age}
</if>
<if test="gender != null and gender !=''">
   and gender = #{gender}
</if>
</where>
    </select>