- <select id="query" parameterType="map" resultMap="userInfoMap">
- <include refid="selectBase" />
- <if test="id != null">and a.id=#{id}</if>
- <if test="UserName != null">and a.UserName like #{UserName}</if>
- </select>
当采用map的形式动态传递查询参数的时候,需要注意#{UserName},这个"UserName"一定要和map中的key一致。不然会找不到参数报错.
- UserInfoDAO dao = new UserInfoDAO();
- Map<String, String> map = new HashMap<String, String>();
- map.put("UserName","%test%");
- List<UserInfo> list = dao.query(map);
- for (UserInfo role : list) {
- System.out.println(role.getId()+","+role.getUserName());
- }
比如你写的...... like #{userName},然后map key为UserName,编译可以通过,但是运行时会报错,找不到参数。简单点理解就是map的key和{}中的名字要一样。虽然我这里是按数据库的UserName字段模糊查询,但是我可以写成 like #{aaa},然后map key设置的时候设置为map.put("aaa","%test%"),这样也是可以的,注意大小写都要一致啊。
- <select id="query" parameterType="map" resultMap="userInfoMap">
- <include refid="selectBase" />
- <if test="id != null">and a.id=#{id}</if>
- <if test="aaa != null">and a.UserName like #{aaa}</if>
- </select>
- @Test
- public void doQuery()
- {
- UserInfoDAO dao = new UserInfoDAO();
- Map<String, String> map = new HashMap<String, String>();
- map.put("aaa","%test%");
- List<UserInfo> list = dao.query(map);
- for (UserInfo role : list) {
- System.out.println(role.getId()+","+role.getUserName());
- }
- }
欢迎加我的qq技术群425783133