MySQL JDBC 使用反射解析结果集

最新推荐文章于 2021-08-20 18:54:43 发布

转载最新推荐文章于 2021-08-20 18:54:43 发布 · 189 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wangguoofme/p/11157221.html

文章标签：

#数据库

Connection connection = DriverManager.getConnection("jdbc:mysql://192.168.1.10:3306/person", "root", "123456");
ResultSet resultSet = connection.createStatement().executeQuery("SELECT * FROM user");
List<User> users = new ArrayList<User>();
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);
}

转载于:https://www.cnblogs.com/wangguoofme/p/11157221.html