- if sql的parameterType为对象,对象中哪个属性有赋值不确定,所以应该根据对象有被赋值的属性值来动态生成sql语句,语法是 <if test = "属性名称 != null(或者其他)"> </if>,完整的select如下
<select id="findAll" resultMap="emp" parameterType="Emp2"> select * from tbl_employee where 1=1 <if test="empId != null"> and id = #{empId} </if> <if test="empLastName != null"> and last_name = #{empLastName} </if> </select>
Mybatis 细节(8)if 标签
最新推荐文章于 2024-04-03 18:30:00 发布