mysql解析结果集_MySQL JDBC 使用反射解析结果集

Connection connection = DriverManager.getConnection("jdbc:mysql://192.168.1.10:3306/person", "root", "123456");

ResultSet resultSet = connection.createStatement().executeQuery("SELECT * FROM user");

List users = new ArrayList();

ResultSetMetaData metaData = resultSet.getMetaData();

while (resultSet.next()) {

User user = User.class.newInstance();

for (int i = 0; i < metaData.getColumnCount(); i++) {

String columnName = metaData.getColumnName(i + 1);

Object object = resultSet.getObject(columnName);

Field field = User.class.getDeclaredField(columnName);

field.setAccessible(true);

field.set(user, object);

}

users.add(user);

}