一、封装到User对象中
1-UserMapper.java
//需求:根据用户名和用户角色, 模糊查询用户列表--封装到实体类
//public List<User> getUserListByUserNameAndUserRole(String userName,Integer userRole);
public List<User> getUserListByUserNameAndUserRole(User user);
2-UserMapper.xml
<!--需求:根据用户名和用户角色, 模糊查询用户列表:#{
必须对象的属性名,能随便写}-->
<select id="getUserListByUserNameAndUserRole" parameterType="User" resultType="User">
SELECT *
FROM smbms_user
WHERE userName
LIKE CONCAT('%',#{
userName},'%')
AND userRole=#{
userRole}
</select>
3-测试类
@Test
public void getUserListByUserNameAndUserRoleTest(