public List<Map<String, Object>> showMenuByRoleid(String menuId) { NamedParameterJdbcTemplate namedParameterJdbcTemplate = new NamedParameterJdbcTemplate(jdbcTemplate); /* MapSqlParameterSource paramsMap = new MapSqlParameterSource(); paramsMap.addValue("menuid",Arrays.asList(menuId.split(","))); System.out.println(paramsMap);*/ Map<String, Object> paramsMap = new HashMap<String, Object>(); paramsMap.put("menuid", Arrays.asList(menuId.split(","))); String sql = "SELECT * FROM sys_menu WHERE menuid IN (:menuid)"; List<Map<String, Object>> mapList = namedParameterJdbcTemplate.queryForList(sql, paramsMap); return namedParameterJdbcTemplate.queryForList(sql,paramsMap); }
注意:1通过 NamedParameterJdbcTemplate来查询
2,传递参数为map,键与你要查询的字段一致,值为一个list集合