oracle 查询转换位实体

package com.experian.app.common.util;import java.lang.reflect.Field;import java.lang.reflect.InvocationTargetException;import java.math.BigDecimal;import java.sql.Timestamp;import java.util.ArrayList;import java.util.Date;import java.util.List;import java.util.Map;import org.hibernate.criterion.DetachedCriteria;import org.hibernate.criterion.Order;import org.hibernate.criterion.Restrictions;import com.experian.activity.util.BeanUtil;public class JavaBeanConvert {/** * Oracle 字段转化为对象 * @param clazz * @param maps * @return * @throws InstantiationException * @throws IllegalAccessException * @throws InvocationTargetException */@SuppressWarnings({ "rawtypes", "unchecked" })public static List convert(Class clazz ,List<Map<String,Object>> maps) throws Exception{List  list = new ArrayList();Field[] fds = clazz.getDeclaredFields();Field[] superfds ={};if(clazz.getSuperclass()!=null){superfds = clazz.getSuperclass().getDeclaredFields();}for(int i=0;i<maps.size();i++){Object dto =clazz.newInstance();Map<String,Object> map = maps.get(i);for(int k=0;k<fds.length;k++){Field fd =  fds[k];String fieldName =fd.getName();Object fieldValue = map.get(fieldName.toUpperCase());if(fd.getType().equals(BigDecimal.class) && null == fieldValue){fieldValue = BigDecimal.ZERO;}if(!(fd.getType().equals(Date.class) && null == fieldValue)&& !(fd.getType().equals(Timestamp.class) && null == fieldValue)){org.apache.commons.beanutils.BeanUtils.setProperty(dto, fieldName, fieldValue);}}if(superfds.length>0){for(int k=0;k<superfds.length;k++){Field fd =  superfds[k];String fieldName =fd.getName();Object fieldValue = map.get(fieldName.toUpperCase());if(fd.getType().equals(BigDecimal.class) && null == fieldValue){fieldValue = BigDecimal.ZERO;}if(!(fd.getType().equals(Date.class) && null == fieldValue)&& !(fd.getType().equals(Timestamp.class) && null == fieldValue)){org.apache.commons.beanutils.BeanUtils.setProperty(dto, fieldName, fieldValue);}}}list.add(dto);}return list;}/** * 构造hibernate参数 * @param obj * @return */@SuppressWarnings("unchecked")public static DetachedCriteria getDetachedCriteria(Object obj){DetachedCriteria dc = DetachedCriteria.forClass(obj.getClass());Map<String, Object> map=BeanUtil.getFiledsInfo(obj);for (Map.Entry<String, Object> entry : map.entrySet()) {  dc.add(Restrictions.like(entry.getKey(), entry.getValue()));}dc.addOrder(Order.desc("createTime"));return dc;}@SuppressWarnings({ "rawtypes", "unchecked" })public static DetachedCriteria getDetachedCriteria(Class clazz,Object obj){DetachedCriteria dc = DetachedCriteria.forClass(clazz);Map<String, Object> map=BeanUtil.getFiledsInfo(obj);for (Map.Entry<String, Object> entry : map.entrySet()) {  dc.add(Restrictions.like(entry.getKey(), entry.getValue()));}dc.addOrder(Order.desc("createTime"));return dc;}}

SQLQuery query = withholdDetailDao.getCurrSession().createSQLQuery(sql.toString());

List<Map<String,Object>> maps = query.list();

List<WithholdContractVO> list =JavaBeanConvert.convert(WithholdContractVO.class, maps);