public List<UserVO> queryAll() throws Exception{
Connection conn=DBUtil.connectDB();
String sql="SELECT*FROM tbl_user_info";
List<UserVO>userList=new ArrayList<UserVO>();
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
UserVO user=new UserVO();
user.setId(rs.getInt("id"));
user.setUserName(rs.getString("user_name"));
user.setAge(rs.getInt("age"));
user.setSex(rs.getInt("sex"));
user.setCreateDt(rs.getDate("create_dt"));
userList.add(user);
}
return userList;
}
queryAll
最新推荐文章于 2024-04-15 01:14:07 发布