2016年8月6日13:53:00
---------------------------
List<Map<String, Object>> List集合新增列
则需要:
List<Map<String, Object>> list_new = new ArrayList<Map<String, Object>>(); //新建list集合对象,用于存储新的数据 for (Map<String, Object> map : list) {//list为数据库查询出来的数据 Long jxjhid=Long.valueOf(map.get("jxjhid").toString()); //上面的是获取jxjh的值 String mc_new=""; if(jxjhid==1){ mc_new="计划"; }else{ mc_new="不计划"; } map.put("sfjh", mc_new); list_new .add(map); }
//另外一种方式
//不要下面两行代码
List<Map<String, Object>> list_new = new ArrayList<Map<String, Object>>();
list_new .add(map);
------------------------------
List<Map<String, Object>> List集合删除map中的某个元素
粒子:
List<Map<String, Object>> list_new = new ArrayList<Map<String, Object>>(); Map<String, Object> map1=new HashMap<String, Object>(); map1.put("ks", "01"); map1.put("js", "10"); list_new.add(map1); Map<String, Object> map2=new HashMap<String, Object>(); map2.put("ks", "01"); map2.put("js", "10"); list_new.add(map2); for (Map<String, Object> map : list_new) { map.remove("js"); }
List<Map<String, Object>> List集合修改map中的元素
粒子:
List<Map<String, Object>> list_new = new ArrayList<Map<String, Object>>(); Map<String, Object> map1=new HashMap<String, Object>(); map1.put("ks", "01"); map1.put("js", "10"); list_new.add(map1); Map<String, Object> map2=new HashMap<String, Object>(); map2.put("ks", "01"); map2.put("js", "10"); list_new.add(map2); for (Map<String, Object> map : list_new) { map.put("js","11"); }
List<Map<String, Object>> List集合查询数据库数据
//公司wh框架的使用方法
String sql="select * from jxap " // + " left outer join (select jxjhid,ks from jxjh) jxjh on jxjh.jxjhid=jxap.jxjhid" + " where jxap.jlztm=51 and jxap.bjid=:bjid and jxap.jxjhid in(select jxjhid from jxjh where xqm=:xqm )"; SqlCommandImpl sci=new SqlCommandImpl(sql); sci.setInt("bjid", bjid); sci.setInt("xqm", xqm); List<Map<String, Object>> list=gdba.selectAsMapList(sci,jxap);
//普通的框架
List<Map<String, Object>> list = new ArrayList<Map<String, Object>>(); // 关闭连接flag boolean colseFlag = false; // 打开DB链接 if (this.connection == null) { this.connection = this.getDbConnection(); colseFlag = true; } PreparedStatement preStat = null; preStat = this.connection.prepareStatement(sql); ResultSet rs = null; Map<String, Object> map = null; rs = preStat.executeQuery(); // 生成ResultSetMetaData ResultSetMetaData rsMeta = preStat.getMetaData(); while (rs.next()) { map = this.Result2Map(rs, rsMeta); // 追加到list中 list.add(map); }