首頁猿問為什么會提示ArrayList錯誤呢？

為什么會提示ArrayList錯誤呢？

Java

慕妹3242003 2023-03-12 15:11:49

代碼如下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 回答

喵喵時光機(jī)

TA貢獻(xiàn)1846條經(jīng)驗(yàn) 獲得超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;
}