jdbc preparedStatement针对于不同的表的通用的查询操作，返回表中的一条记录

public class PreparedStatementQueryTest {

    @Test
    public void testGetInstance(){
        String sql = "select id,name,email from customers where id=?";
        Customer customer = getInstance(Customer.class, sql, 12);
        System.out.println(customer);
    }

    public <T>T getInstance(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();
            if(rs.next()){
                Constructor<T> declaredConstructor = clazz.getDeclaredConstructor();
                T t = declaredConstructor.newInstance();
                for (int i=0;i<columnCount;i++){
                    //得到结果集中的列名
                    String columnName = rsmd.getColumnLabel(i + 1);
                    //得到结果集中的值
                    Object columnValue = rs.getObject(i + 1);
                    //通过反射得到Customer对应的字段
                    Field field= clazz.getDeclaredField(columnName);
                    field.setAccessible(true);
                    field.set(t,columnValue);
                }
                return t;
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(conn,ps,rs);
        }
        return null;
    }
}