<!--List<Emp> getEmpByCondition(Emp emp);--><selectid="getEmpByConditionOne"resultType="Emp"><!--if根据标签中test属性对应的判断条件,判断下面语句是否拼接到SQL语句中-->
select * from t_emp where 1 = 1
<iftest="empName != null and empName !=''">
emp_name = #{empName}
</if><iftest="age != null and age !=''">
and age = #{age}
</if><iftest="sex != null and sex !=''">
and sex = #{sex}
</if><iftest="email != null and email !=''">
and email = #{email}
</if></select>
where
当where标签中有内容时,会自动生成where关键字,并能去除多余的and或or标签
当where标签中无内容时,此时where标签没有任何效果
注:where标签不能将其中内容后面多余的and或or去除
<selectid="getEmpByConditionTwo"resultType="Emp"><!--
where:当where标签中有内容时,会自动生成where关键字,并能去除多余的and或or标签
当where标签中无内容时,此时where标签没有任何效果
注:where标签不能将其中内容后面多余的and或or去除-->
select * from t_emp
<where><iftest="empName != null and empName !=''">
emp_name = #{empName}
</if><iftest="age != null and age !=''">
and age = #{age}
</if><iftest="sex != null and sex !=''">
and sex = #{sex}
</if><iftest="email != null and email !=''">
and email = #{email}
</if></where></select>
<selectid="getEmpByConditionThree"resultType="Emp"><!--
trim:
prefix|suffix:将trim标签中内容前面和后面添加指定内容
suffixOverrides|prefixOverrides:将trim标签中内容前面或后面去掉指定内容
若标签中没有内容时,trim标签没有任何效果
-->
select * from t_emp
<trimprefix="where"suffixOverrides="and|or"><iftest="empName != null and empName !=''">
emp_name = #{empName} and
</if><iftest="age != null and age !=''">
age = #{age} and
</if><iftest="sex != null and sex !=''">
sex = #{sex} and
</if><iftest="email != null and email !=''">
email = #{email}
</if></trim></select>
choose,when,otherwise
相当于if…else if…else
when至少有一个,otherwise最多只能有一个
<!--List<Emp> getEmpByChoose(Emp emp);--><!-- 设置SQL片断--><sqlid="empColumns">
eid,emp_name,age,sex,email
</sql><selectid="getEmpByChoose"resultType="Emp"><!--
choose,when,otherwise相当于if..else if..else
when至少有一个,otherwise最多只能有一个
--><!-- include引用SQL片断-->
select <includerefid="empColumns"/> from t_emp
<where><choose><whentest="empName != null and empName !=''">
emp_name=#{empName}
</when><whentest="age != null and age !=''">
age=#{age}
</when><whentest="sex != null and sex !=''">
sex=#{sex}
</when><whentest="email != null and email !=''">
email=#{email}
</when><otherwise>
did = 1
</otherwise></choose></where></select>
foreach
collection:设置需要循环的数组或集合
item:表示数组或集合中每一个数据
sperator:循环之间分割符
open:foreach标签所循环的所有内容的开始符
close:foreach标签所循环的所有内容的结束符
<!--
foreach
collection:设置需要循环的数组或集合
item:表示数组或集合中每一个数据
sperator:循环之间分割符
open:foreach标签所循环的所有内容的开始符
close:foreach标签所循环的所有内容的结束符
--><!--int deleteMoreByArray(@Param("eids") Integer[] eids);--><deleteid="deleteMoreByArrayOne">
delete from t_emp where eid in
<foreachcollection="eids"item="eid"separator=","open="("close=")">
#{eid}
</foreach></delete><deleteid="deleteMoreByArray">
delete from t_emp where eid in
<foreachcollection="eids"item="eid"separator="or"open="("close=")">
eid = #{eid}
</foreach></delete><!--int insertMoreByList(List<Emp> emps);--><insertid="insertMoreByList">
insert into t_emp values
<foreachcollection="emps"item="emp"separator=",">
(null,#{emp.empName},#{emp.age},#{emp.sex},#{emp.email},null)
</foreach></insert>