List>相关

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);
}
上一篇:python中print不换行


下一篇:python处理文件的换行符