ResultSetDynaClass rsdc;
DynaProperty[] dp;
Iterator rows;
public List<Entity> getAll() throws Exception {
List<Entity> entitis = new ArrayList<Entity>();
pStmt = db.connDb().prepareStatement(SELECT_ALL);
rs = pStmt.executeQuery();
rsdc = new ResultSetDynaClass(rs,false);
dp = rsdc.getDynaProperties();
rows = rsdc.iterator();
while(rows.hasNext()){
Entity entity = new Entity();
DynaBean row = (DynaBean) rows.next();
PropertyUtils.copyProperties(entity ,row);
entitis.add(entity );
}
pStmt.close();
rs.close();
db.closeDb();
return entitis;
}
但要求Entity中的属性与数据库中的字段命名相同否则 PropertyUtils.copyProperties(entity ,row);出错。
DynaProperty[] dp;
Iterator rows;
public List<Entity> getAll() throws Exception {
List<Entity> entitis = new ArrayList<Entity>();
pStmt = db.connDb().prepareStatement(SELECT_ALL);
rs = pStmt.executeQuery();
rsdc = new ResultSetDynaClass(rs,false);
dp = rsdc.getDynaProperties();
rows = rsdc.iterator();
while(rows.hasNext()){
Entity entity = new Entity();
DynaBean row = (DynaBean) rows.next();
PropertyUtils.copyProperties(entity ,row);
entitis.add(entity );
}
pStmt.close();
rs.close();
db.closeDb();
return entitis;
}
但要求Entity中的属性与数据库中的字段命名相同否则 PropertyUtils.copyProperties(entity ,row);出错。