利用元数据加反射封装表数据到实体类

创建实体类

public class User{
    private int id;
    private String name;
    private int age;
    ...
   }

封装数据到实体类

    @Test
public void testGetUser() throws Exception {
   Connection connection = ConnectionManager.get();
        PreparedStatement preparedStatement = connection.prepareStatement(" select * from user ");
        ResultSet resultSet = preparedStatement.executeQuery();
        ResultSetMetaData metaData = resultSet.getMetaData();
        Class<User> userClass = User.class;
        while (resultSet.next()) {
            Object bean = userClass.newInstance();
            for (int i = 0; i < metaData.getColumnCount(); i++) {
                String columnName = metaData.getColumnName(i + 1);
                Object value = resultSet.getObject(i + 1);
                Field declaredField = userClass.getDeclaredField(columnName);
                declaredField.setAccessible(true);
                declaredField.set(bean, value);
            }
            System.out.println(bean);
        }
}