/**
 * @program: Connection
 * @description: 针对于book_info表的查询操作
 * @author: Mr.Fan
 * @create: 2021-05-29 10:50
 **/
public class Book_infoForQuery {
    public Book_info queryForBook_info(String sql,Object ...args) throws Exception {
        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
            ResultSetMetaData metaData = rs.getMetaData();
            //获取结果集中的列数
            int columnCount = metaData.getColumnCount();

            if(rs.next()){
                Book_info book = new Book_info();


                for (int i = 0; i < columnCount; i++) {
                    Object columnValue = rs.getObject(i + 1);

                    //获取每个列的列名
                    String columnName = metaData.getColumnName(i+1);

                    //给book对象指定的columnName属性赋值为columnValue,通过反射
                    Field field = Book_info.class.getDeclaredField(columnName);
                    field.setAccessible(true);
                    field.set(book, columnValue);

                    //给book对象的某个属性赋值为value
                }
                return book;

            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        JDBCUtils.closeResource(conn, ps, rs);
        return null;
    }
}