Question

mybatis查询时传入参数是map集合动态sql语句应该怎么写

Answer 1

在MyBatis中可以用以下的方式来传递多个参数1. 用java.util.Map来传递, Code 如下public List<User> getAllUsersByUserName(String username, int start, int limit){ Map<String,Object> params = new HashMap<String, Object>(3); params.put("username",username); params.put("start",start); params.put("limit",limit); return userMapper.getAllUsersByUserName(params); } 对应的XXMapper.xml文件中如下:<select id="getAllUsersByUserName" parameterType="map" resultType="User"> SELECT u.* FROM User u WHERE u.username LIKE #{username} '%' LIMIT #{start}, #{limit} </select>2. 用JavaBean的方式来传递, Code如下:public List<User> getUsersByUserName(String username){ User user = new User(); user.setUsername(username); return userMapper.getUserByUsername(user); }对应的XXMapper.xml文件中如下:<select id="getAllUsersByUserName" parameterType="User" resultType="User"> SELECT u.* FROM User u WHERE u.username = #{username} </select>OK, 就介绍这两种方法吧!!!