67,515
社区成员
发帖
与我相关
我的任务
分享
UserBeanCl.java:
public class UserBeanCl {
private ArrayList al=new ArrayList();
private int pagesize=3;
private int pagecount=0;
private int rowcount=0;
private Connection conn=null;
private Statement sm=null;
private ResultSet rs=null;
private UserBean ub=new UserBean();
public int getPageSize()
{
return pagesize;
}
public int getPagecount()
{
try{
conn=new ConnDB().getConn();
sm=conn.createStatement();
rs=sm.executeQuery("select count(*) from users");
if (rs.next())
{
rowcount=rs.getInt(1);
}
if(rowcount%pagesize==0)
pagecount=rowcount/pagesize;
else
pagecount=rowcount/pagesize+1;
}catch(Exception e)
{
e.printStackTrace();
}finally{
this.close();
}
return pagecount;
}
public ArrayList getUsersByPage(int pagenow){
try{
conn=new ConnDB().getConn();
sm=conn.createStatement();
rs=sm.executeQuery("select * from users limit "+((pagenow-1)*pagesize)+","+pagesize);
int i=-1;
while(rs.next())
{
i++;
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);
System.out.println(((UserBean)al.get(i)).getUserId()+"\t"+i); }
}
catch(Exception e)
{
e.printStackTrace();
}finally
{
this.close();
}
return al;
}
private void close()
{
try{
if(rs!=null){
rs.close();
rs=null;
}
if(sm!=null){
sm.close();
sm=null;
}
if(conn!=null){
conn.close();
conn=null;
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
Wel.jsp的片段:
<body>
<center><h1>登陆成功!</h1><br>
<%
int pagenow=1;
String getpage=request.getParameter("page");
if(getpage!=null) pagenow=Integer.parseInt(getpage);
Connection conn=new ConnDB().getConn();
Statement sm=conn.createStatement();
ResultSet rs=sm.executeQuery("select count(*) from users");
UserBeanCl ubc=new UserBeanCl();
ArrayList al=ubc.getUsersByPage(pagenow);
int pagecount=ubc.getPagecount();
int pagesize=ubc.getPageSize();
%>
<table border=1>
<tr><th>userId</th><th>username</th><th>passwd</th><th>email</th><th>grade</th></tr>
<% for(int i=0;i<al.size();i++){
UserBean ub=(UserBean)al.get(i);
System.out.println(((UserBean)al.get(i)).getUserId()+"\t"+i);
%>
<tr><td><%=ub.getUserId() %></td><td><%=ub.getUsername() %></td><td><%=ub.getPasswd() %></td><td><%=ub.getEmail() %></td><td><%=ub.getGrade() %></td></tr>
<%} %>
</table>
<%if(pagenow!=1){ %>
<a href=wel.jsp?page=<%=pagenow-1 %>>上一页</a> <%} %>
<%
for(int i=pagenow;i<=(pagecount>(pagesize+pagenow-1)?(pagesize+pagenow-1):pagecount);i++){
%>
<a href=wel.jsp?page=<%=i %>><%=i %></a>
<%} %>
<%if(pagenow!=pagecount){ %>
<a href=wel.jsp?page=<%=pagenow+1 %>>下一页</a> <%} %>
<hr><a href="login.jsp">返回登陆界面</a></center>
</body>
while(rs.next())
{
i++;
ub.setUserId(rs.getInt(1));
ub.setUsername(rs.getString(2));
ub.setPasswd(rs.getString(3));
while(rs.next())
{
ub = new UserBean(); // 具体哪个类我就不管了,总之你要new一下
i++;
ub.setUserId(rs.getInt(1));
ub.setUsername(rs.getString(2));
ub.setPasswd(rs.getString(3));