public List getAllTypeList(String sql, Class clazz) {
List list = new ArrayList();
ResultSet rs = null;
PreparedStatement ps = null;
Connection conn = new DBConnection().getConn();
try {
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
ResultSetMetaData md = rs.getMetaData();
int count = md.getColumnCount();
while (rs.next()) {
Object o = clazz.newInstance();
for (int i = 1; i <= count; i++) {
Field f = clazz.getDeclaredField(md.getColumnName(i));
f.setAccessible(true);
f.set(o, rs.getObject(i));
}
list.add(o);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
c.detach(rs, ps,conn);
}
return list;
}