首页 > 其他 > 详细

map操作

时间:2016-04-13 18:32:51      阅读:132      评论:0      收藏:0      [点我收藏+]

http://blog.csdn.net/liu826710/article/details/9001254

Map<String, Object> oldMap = beanToMap(object);
Map<String, Object> map = new HashMap<String, Object>();

List<String> validateParm = getValidateParm(conn, tableName,config);
for (String stringKey : validateParm) {
if(oldMap.containsKey(stringKey)) {
map.put(stringKey, oldMap.get(stringKey));
}
}

StringBuilder sql = new StringBuilder();
sql.append("UPDATE ");
sql.append(" " + tableName + " ");
sql.append(" SET ");
List<Object> list = new ArrayList<Object>();

Iterator<Entry<String, Object>> it = map.entrySet().iterator();
while (it.hasNext()){
Map.Entry<String, Object> pairs = (Map.Entry<String, Object>)it.next();
sql.append(" " + pairs.getKey() + "=?,");
list.add(pairs.getValue());
}
sql.deleteCharAt(sql.length()-1);
if (sWhere != null && !"".equals(sWhere)) {
sql.append(" ");
sql.append(sWhere);
} else {
sql.append(" where 1=2");
}
QueryRunner queryRunner = new QueryRunner(DATABASE_TYPE_ORACLE.equals(config.getDriverType()));
return queryRunner.update(conn, sql.toString(), list.toArray());

map操作

原文:http://www.cnblogs.com/zshboke-2015/p/5387907.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!