1. 参数处理
1.1 参数
单个参数: #{name}
多个参数:
mybatis多个参数会被封装成map
- key:param1, param2, …
- value:传入的参数值
public void getEmployeeByIdAndLastName(Integer id, String lastName);
<select id="getEmployeeByIdAndLastName" resultType="xxx.xxx.xxx.Employee">
select * from employee where id=#{param1} and last_name=#{param2}
</select>
1.2 明确指定key值
public void getEmployeeByIdAndLastName(@Param("id")Integer id, @Param("lastName")String lastName);
<select id="getEmployeeByIdAndLastName" resultType="xxx.xxx.xxx.Employee">
select * from employee where id=#{id} and last_name=#{lastName}
</select>
1.3 pojo 和 map 类型参数
如果多个参数正好是我们业务逻辑的数据模型,可以直接传入pojo,#{属性名}取出属性值
如果不是pojo,可以传入map
public Employee getEmployee(Map<String, Object> param);
<