java中 sql查询结果集转换成javabean

1.

public List<Map> findBySql(String sql,Class cls) {
if (logger.isDebugEnabled()) {
logger.debug("findBySql(String, Class) - start"); //$NON-NLS-1$
}


SQLQuery q = getCurrentSession().createSQLQuery(sql).addEntity(cls);
List<Map> returnList = q.list();
if (logger.isDebugEnabled()) {
logger.debug("findBySql(String, Class) - end"); //$NON-NLS-1$
}
return returnList;
}

hibernate的addEntity(),addScalar()等方式

2.

今天碰到的,因为接收到值是一个json格式字符串{"org_no":xxx,"sys_no":"xxx","age":11}之类的格式

public String removeSpace(String str){
Map<String,Object> map = new HashMap<String,Object>();
if(StringUtils.isNotBlank(str)){
JSONObject jo = JSONObject.parseObject(str);
Set <String> keys =jo.keySet();
for(String k :keys){
String key = "\""+k.replaceAll("(.+)_(\\w)(.*?)", "$1$2$3")+"\"";
Object value = jo.get(k);
map.put(key, value);
}
}
String s =JSON.toJSONString(map);
return s;
}

先去除了key的下划线

JSONObject.parseObject(removeSpace(str), WhsReceiptM.class)

转换成javabean