这里是业务逻辑层
- //获得所有的用户信息public ArrayList < Users > getAllUsers() { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; ArrayList < Users > list = new ArrayList < Users > (); //用户集合 try { conn = DBHelper.getConnection(); String sql = "select * from Users;"; //SQL语句 stmt = conn.prepareStatement(sql); //语句对象 rs = stmt.executeQuery(); //获得一个数据集 while (rs.next()) { Users user = new Users(); user.setUsername(rs.getString("username")); user.setPassword(rs.getString("password")); list.add(user); //把一个用户加入集合 } return list; //返回集合 } catch(Exception ex) { ex.printStackTrace(); return null; } finally { //释放数据集对象 if (rs != null) { try { rs.close(); rs = null; } catch(Exception ex) { ex.printStackTrace(); } } //释放语句对象 if (stmt != null) { try { stmt.close(); stmt = null; } catch(Exception ex) { ex.printStackTrace(); } } }}
就爱阅读 www.92to.com 网友整理上传, 为您提供最全的知识大全, 期待您的分享,转载请注明出处。
来源: