1.传递一个参数
传递一个参数一般情况下直接用就可以,不需要map,不需要实体
- public List<PageData> findUserDetail(String id);
- <select id="selectUser" parameterType="java.lang.String" resultMap="pd">
- select * from t_user where user_id=#{id}
- </select>
2.传递两个或多个参数
(1)通过序号传递,不使用parameterType
- public List<PageData> findUserDetail(String username,String sex);
- <select id="selectUser" resultMap="pd">
- select * from t_user where user_name=#{0} and sex=#{1}
- </select>
(2)map传参
- Map paramMap=new hashMap();
- paramMap.put("username","对应具体的参数值");
- paramMap.put("sex","对应具体的参数值");
- List<User> userList=xxx.getUserList(paramMap);
- public List<User> getUserList(HashMap map);
- <select id="getUserList" parameterType="hashmap" resultType="xxx.xxx.user">
- select * from t_user where username=#{username} and sex= #{sex}
- </select>
(3)实体传参
- //给用户收藏表赋值
- User user=new User();
- user.setUserName("www");
- user.setSex("女");
- List<User> userList=xxx.getUserList(user);
- <select id="getUserList" parameterType="xxx.xxx.User" resultType="xxx.xxx.user">
- select * from t_user where username=#{username} and sex= #{sex}
- </select>
(4)@param通过单个参数名传递
- Public User selectUser(@param("username")String name,@param(“sex”)String sex);
- <select id="getUser" resultType="xxx.xxx.user">
- select * from t_user where username=#{username} and sex= #{sex}
- </select>
3.参数是一个list集合,使用in
- public List<XXXBean> getXXXBeanList(List<String> idlist);
- <select id="getUserList" resultType="xxx.xxx.user">
- select * from t_user where user_id in
- <foreach item="id" index="index" collection="list" open="(" separator="," close=")">
- #{id}
- </foreach>
- </select>
4.参数既包括单个参数也包括list集合
参数放到map中,然后xml中遍历list
- Map<String, Object> map = new HashMap<String, Object>();
- map.put("idlist", idlist);
- map.put("sex", "女");
- <select id="getUserList" resultType="xxx.xxx.user">
- select * from t_user where sex=#{sex} and user_id in
- <foreach item="id" index="index" collection="list" open="(" separator="," close=")">
- #{id}
- </foreach>
- </select>
http://blog.csdn.net/ww130929/article/details/60480449