代碼如下public ArrayList<UserBean> getUsersByPage(int pageNow){try{ArrayList<UserBean> al=new ArrayList<UserBean>();ct=new ConnDB().getConn();rs=sm.executeQuery("select top "+pageSize+" * from users where userId not in(select top "+pageSize*(pageNow-1)+" userId from users) " );while(rs.next()){UserBean ub=new UserBean();ub.setUserId(rs.getInt(1));ub.setUserName(rs.getString(2));ub.setPasswd(rs.getString(3));ub.setEmail(rs.getString(4));ub.setGrade(rs.getInt(5));al.add(ub);}}catch(Exception e){e.printStackTrace();}finally{this.close(); }return al;}
2 回答
喵喵時光機
TA貢獻1846條經驗 獲得超7個贊
public List<UserBean> getUsersByPage(int pageNow)
{
List<UserBean> al=new ArrayList<UserBean>();
try
{
ct=new ConnDB().getConn();
rs=sm.executeQuery("select top "+pageSize+" * from users where userId not in(select top "+pageSize*(pageNow-1)+" userId from users) " );
while(rs.next())
{
UserBean ub=new UserBean();
ub.setUserId(rs.getInt(1));
ub.setUserName(rs.getString(2));
ub.setPasswd(rs.getString(3));
ub.setEmail(rs.getString(4));
ub.setGrade(rs.getInt(5));
al.add(ub);
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
this.close();
}
return al;
}
幕布斯7119047
TA貢獻1794條經驗 獲得超8個贊
ArrayList<UserBean> al=new ArrayList<UserBean>();
改成 如下
List<UserBean> al = new ArrayList<UserBean>();
添加回答
舉報
0/150
提交
取消