代码如下
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;
}
喵喵时光机
幕布斯7119047
相关分类