public void retrieve(List<Object> param,PageInfo page) {
DBTool db = new DBTool();
String query = "查询SQL";
Record[] record = db.executeQuery(query, param, page);
this.assembleList(record);
}
//组装List
public List<BusiLawLoveApplyApproveVo> assembleList(Record[] record){
List<BusiLawLoveApplyApproveVo> vos = new ArrayList<BusiLawLoveApplyApproveVo>();
for (Record record2 : record) {
BusiLawLoveApplyApproveVo approves = new BusiLawLoveApplyApproveVo();
Field[] fields = approves.getClass().getDeclaredFields();
for (Field field : fields) {
field.setAccessible(true);
if(!field.getName().equals("serialVersionUID")){
String name = field.getName();
//转成大写字符串
Object ob = record2.get(name.toUpperCase());
try {
//BigDecimal转换成Long报强制转换异常
if(ob instanceof java.math.BigDecimal){
field.set(approves, Long.valueOf(ob.toString()));
}else{
field.set(approves, ob);
}
} catch (IllegalArgumentException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
}
}
}
vos.add(approves);
}
return vos;
}