MyBatis当多个请求参数时处理方式<select id="getUserByNameAndPassword" par

通过Map

例如我们要查询username和password为root的用户信息

List<User> getUserByNameAndPassword(Map<String,Object> map);

<select id="getUserByNameAndPassword" parameterType="map" resultType="com.hzy.pojo.User">
    select id,username,password from user where username = #{username} and password = #{password}
</select>

Map<String,Object> map = new HashMap<String, Object>();
map.put("username", "root");
map.put("password", "root");
List<User> userList = userMapper.getUserByNameAndPassword(map);

通过@parm注解

List<User> getUserByNameAndPassword(@Param("username") String username,@Param("password") String password);

<select id="getUserByNameAndPassword" resultType="com.hzy.pojo.User">
    select id,username,password from user where username = #{username} and password = #{password}
</select>

List<User> userList = userMapper.getUserByNameAndPassword("root","root");