MyBatis参数传递

1 使用map接口传递参数

public List<Role> findRolesByMap(Map<String,Object> parameterMap);
<select id="findRoleByMap" parameterType="map" resultMap="role">
	select id ,role_name,note from t_tole 
	where role_name like concat('%',#{rolename},'%')
	and not like concat('%',#{note},'%')
</select>

2 使用注解传递多个参数

public List<Role> findRolesByAnnotation(@Param("roleName")String roleName,@Param("note")String note);
<select id="findRoleByMap" resultMap="role">
	select id ,role_name,note from t_tole 
	where role_name like concat('%',#{rolename},'%')
	and not like concat('%',#{note},'%')
</select>

3 通过JavaBean传递多个参数

public Class RoleParams{
	private String roleName;
	private String note;
}

接口方法定义

public List<Role> findRolesByBean(RoleParams roleParams);

xml文件

<select id="findRoleByMap" parameterType="com.musi.param.RoleParams" resultMap="role">
	select id ,role_name,note from t_tole 
	where role_name like concat('%',#{rolename},'%')
	and not like concat('%',#{note},'%')
</select>

4 混合使用

public Class PageParams{
	private int start;
	private int limit;
}

接口如下：

public List<Role> findByMix(@Param("params")RoleParams roleParams,@Param("page")PagePrams pageParam);

xml文件

<select id="findRoleByMix" resultMap="role">
	select id ,role_name,note from t_tole 
	where role_name like concat('%',#{params.rolename},'%')
	and not like concat('%',#{params.note},'%') limit 
	#{page.start},#{page.limit}
</select>