P23 PreparedStatement实现针对于不同表的通用的查询操作

使用PreparedStatement实现针对于不同表的通用的查询操作

@Test
public void testGetForList(){
    String sql="select id,name,email from customers where id<?";
    List<Customer> list = getForList(Customer.class, sql, 12);
    list.forEach(System.out::println);

    String sql1="select order_id orderId,order_name orderName from `order` where order_id";
    List<Order> list1 = getForList(Order.class, sql1);
    list1.forEach(System.out::println);
}
/*
返回多条记录
 */
public <T> List<T> getForList(Class<T> clazz,String sql,Object ...args){
    Connection conn = null;
    PreparedStatement ps = null;
    ResultSet rs = null;
    try {
        conn = JDBCUtil.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<>();
        while (rs.next()){
            T t = clazz.newInstance();
            //给t对象指定的属性赋值
            for (int i=0;i<columnCount;i++){
                //获取每个列的值:通过ResultSet
                Object columnValue = rs.getObject(i + 1);
                //获取每个列的列名：通过ResultSetMetaData

                //获取的是列名
                //String columnName = rsmd.getColumnName(i + 1);

                //获取列的别名
                String columnLabel = rsmd.getColumnLabel(i + 1);

                //通过反射将对象指定名columnName的属性赋值给指定的值columnValue
                Field field =clazz.getDeclaredField(columnLabel);
                field.setAccessible(true);
                field.set(t, columnValue);
            }
            list.add(t);
        }
        return list;
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        JDBCUtil.closeResource(conn, ps,rs);
    }

    return null;
}