public <T> List<T> getForList(Class<T> clazz,String sql ,Object ...args){
Connection conn =null;
PreparedStatement ps =null;
ResultSet rs =null;
try {
conn= JDBCUtils.getConnection();
ps = conn.prepareStatement(sql);
for (int i = 0; i < args.length; i++) {
ps.setObject(i + 1, args[i]);
}
rs = ps.executeQuery();
ResultSetMetaData rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
// 创建集合对象
ArrayList<T> list = new ArrayList<T>();
while (rs.next()) {
T t = clazz.newInstance();
for (int i = 0; i < columnCount; i++) {
Object columnValue = rs.getObject(i + 1);
//获取列的列名
//String columnName = rsmd.getColumnName(i + 1);
String columnLabel = rsmd.getColumnLabel(i + 1);
Field filed = clazz.getDeclaredField(columnLabel);
filed.setAccessible(true);
filed.set(t, columnValue);
}
list.add(t);
}
return list;
}catch (Exception e){
e.printStackTrace();
}finally {
JDBCUtils.closwResource(conn,ps,rs);
}
return null;
}
测试方法:
@Test
public void testGetForList(){
String sql = "select id,name,email from customers where id<?";
List<Customer> list = getForList(Customer.class,sql,12);
list.forEach(e->System.out.println(e)) ;
//list.forEach(System.out::println);
}