mybatis 中IN 查询写法

这个问题昨天困扰了我2个小时，终于在同事的开导下，这么写出来了，其实这种方法以前也写过，但是忘记了，现在发表到博客上面备忘。

Java代码

1. /**
2. * 获取性别分析指标
3. *
4. * @author shangql
5. * @date 2013-1-17
6. * @param date
7. * @return
8. * @return List<Map<String,Object>>
9. */
10. @Override
11. public List<Map<String, Object>> getGender(String countValue, String date, Integer[] brandIds)throws Exception {
12. Map<String, Object> inParamMap = new HashMap<String, Object>();
13. inParamMap.put("countValue", countValue);
14. inParamMap.put("date", date);
15. inParamMap.put("brandIdsList", parseToParam(brandIds));
16. inParamMap.put("size", EmptyUtil.isEmpty(brandIds)?0:brandIds.length);
17. List<Map<String, Object>> resultList = dao.queryForList("ConsumerInfoServiceImpl/getGender", inParamMap);
18. return nonEmpty(resultList);
19. }
21. /**
22. * 判断非空数据
23. *
24. * @author shangql
25. * @date 2013-1-23
26. * @param srcList
27. * @return
28. * @return List<Map<String,Object>>
29. */
30. private List<Map<String, Object>> nonEmpty(List<Map<String, Object>> srcList) {
31. List<Map<String, Object>> resultList = new ArrayList<Map<String, Object>>();
32. Map<String, Object> itemMap = null;
33. if (EmptyUtil.isEmpty(srcList)) {
34. itemMap = new HashMap<String, Object>();
35. itemMap.put("name", "暂无数据");
36. itemMap.put("data1", 0);
37. resultList.add(itemMap);
38. return resultList;
39. } else {
40. return srcList;
41. }
42. }
46. /**
47. * 装配条件参数
48. *
49. * @author shangql
50. * @date 2013-1-24
51. * @param brandNames
52. * @return
53. * @return String
54. */
55. private List<Map<String, Object>> parseToParam(Integer[] brandIds)throws Exception{
56. List<Map<String, Object>> resultList = new ArrayList<Map<String,Object>>();
57. Map<String, Object> itemMap = null;
58. if(!EmptyUtil.isEmpty(brandIds)){
59. for (Integer i : brandIds) {
60. itemMap = new HashMap<String, Object>();
61. itemMap.put("brandId", i);
62. resultList.add(itemMap);
63. }
64. }
65. return resultList;
66. }