public List showMenuByRoleId(String role_id){
String sql = "select MENU_ID from tlb_role_menu where ROLE_ID = "+role_id;
return this.jdbcTemplate.queryForList(sql);
}
String sql = "select MENU_ID from tlb_role_menu where ROLE_ID = "+role_id;
return this.jdbcTemplate.queryForList(sql);
}
queryForList返回的不是list 而是一个ListOrderedMap,就是说list里面放的是一个,以列名为key,值为value的map
for(Object o : list){
Map m = (Map) o;
System.out.println(m.get( "menu_id"));
}
Map m = (Map) o;
System.out.println(m.get( "menu_id"));
}
转载于:https://blog.51cto.com/237451446/604198