使用object数组可以遍历取值
for (Object[] objects : result) {
String message_id = objects[0].toString();
String app_id = objects[1].toString();
System.out.println(message_id+","+app_id);
}
使用setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP)方法
String sql = "SELECT PKID,USERS AS VAL FROM BAS_TABLE";
List<Map<String, Object>> result = session.getSession().createSQLQuery(sql);
result.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
for (Map<String, Object> str : result) {
String key = (String) str.get("PKID");
String value = (String) str.get("VAL");
}
直接返回Map,可以直接根据key取相应的值了,更加灵活