首页 static List<User> list = new ArrayList<>(); static { try { ResultSet rs = Demo.queryData("selct * from user"); while (rs.next()){ int id = rs.getInt(1); String name = rs.getString(2); String pasword4 = rs.getString(3); User user = new User(id,name,pasword4); list.add(user); } } catch (SQLException e) { throw new RuntimeException(e); } }检查并修改

static List<User> list = new ArrayList<>(); static { try { ResultSet rs = Demo.queryData("selct * from user"); while (rs.next()){ int id = rs.getInt(1); String name = rs.getString(2); String pasword4 = rs.getString(3); User user = new User(id,name,pasword4); list.add(user); } } catch (SQLException e) { throw new RuntimeException(e); } }检查并修改

时间: 2024-02-14 09:11:29 浏览: 353

在代码中，SQL语句的写法错误，应该是select而不是selct。另外，在finally块中应该关闭ResultSet、PreparedStatement和Connection对象，释放资源。代码修改如下： ``` static List<User> list = new ArrayList<>(); static { try (ResultSet rs = Demo.queryData("select * from user")) { while (rs.next()) { int id = rs.getInt(1); String name = rs.getString(2); String password = rs.getString(3); User user = new User(id, name, password); list.add(user); } } catch (SQLException e) { throw new RuntimeException(e); } } ``` 这样，当try语句块结束时，会自动关闭ResultSet、PreparedStatement和Connection对象，无需手动调用close()方法。

阅读全文