hibernate sql 对象转java对象

修改了一下，增加类型转换。用到了apache的beanutils工具包。

1. public static <T> List<T> getEntityObjectListByFullSql(
2. final String fullSql, final Class<T> clzz) throws Exception {
3. return getHibernateTemplate().execute(
4. new HibernateCallback<List<T>>() {
5. @Override
6. public List<T> doInHibernate(Session session)
7. throws HibernateException, SQLException {
8. SQLQuery sqlQuery = session.createSQLQuery(fullSql);
9. sqlQuery.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP);
10. @SuppressWarnings("unchecked")
11. List<Map<String, Object>> list = (List<Map<String, Object>>) sqlQuery
12. .list();
13. if (CollectionUtils.isEmpty(list)) {
14. return null;
15. }
16. List<T> result = new ArrayList<T>();
17. try {
18. PropertyDescriptor[] props = Introspector
19. .getBeanInfo(clzz).getPropertyDescriptors();
20. for (Map<String, Object> map : list) {
21. T t = clzz.newInstance();
22. for (Entry<String, Object> entry : map
23. .entrySet()) {
24. String attrName = entry.getKey()
25. .toLowerCase();
26. for (PropertyDescriptor prop : props) {
27. if (!attrName.equals(prop.getName())) {
28. continue;
29. }
30. Method method = prop.getWriteMethod();
31. Object value = entry.getValue();
32. if (value != null) {
33. value = ConvertUtils.convert(value,
34. prop.getPropertyType());
35. }
36. method.invoke(t, value);
37. }
38. }
39. result.add(t);
40. }
41. } catch (Exception e) {
42. throw new RuntimeException(e);
43. }
44. return result;
45. }
46. });
47. }