1.传实体 当mapper配置文件中没有相对应的数据库字段,或是实体与数据库不同时,可以直接使用实体类进行传值,如 parameterType="java.com.entity"//对应实体类
<select id="queryByNameAndSex" parameterType="java.com.entity.Student" resultMap="student">
2.传多个参数
- 使用@Param注解(不需要些parameterType)
public List<Student> queryByNameAndSex(@Param("name")String name,@Param("age")String age);
<select id="queryByNameAndSex" resultMap="student">
select * from student where 1=1
<if test="null != name and '' != name">
and name like CONCAT('%','${name}','%' )
</if>
<if test="null != age and '' != age">
and sex = #{age}
</if>
</selcet>
- 直接使用下标
public List<Student> queryByNameAndSex(String name,String sex);
<select id="queryByNameAndSex" resultMap="student">
select * from student where 1=1
<if test="null != name and '' != name">
and name like CONCAT('%','${0}','%' )
</if>
<if test="null != age and '' != age">
and sex = #{1}
</if>
</selcet>