81,091
社区成员
发帖
与我相关
我的任务
分享
package sqlbean;
import java.sql.ResultSet;
import java.sql.SQLException;
import datebase.JDBC;
public class AttendstatusPage {
int pagenow;
int pagecount;
int pagesize;
int rowcount;
public AttendstatusPage() {
pagenow = 1;
pagecount = 0;
pagesize = 20;
rowcount = 0;
}
public int fpage(String spagenow) {
AttendstatusPage pb = new AttendstatusPage();
int pagecount = pb.countpage();
if (spagenow != null) {
pagenow = Integer.parseInt(spagenow);
if (pagenow > pagecount)
pagenow = pagecount;
} else {
pagenow = 1;
}
return pagenow;
}
public int countpage() {
JDBC db = new JDBC();
String sql = "select count(*) from ZC_Attendstatus";
ResultSet rs = db.query(sql);
try {
while (rs.next())
rowcount = rs.getInt(1);
} catch (SQLException e) {
e.printStackTrace();
}
if (rowcount % pagesize == 0)
pagecount = rowcount / pagesize;
else
pagecount = rowcount / pagesize + 1;
return pagecount;
}
public int rowpage() throws SQLException {
JDBC db = new JDBC();
String sql = "select count(*) from ZC_Attendstatus";
for (ResultSet rs = db.query(sql); rs.next();)
rowcount = rs.getInt(1);
return rowcount;
}
}
String spagenow = request.getParameter("pagenow");
int pagesize = 20;//每页显示的记录
int pagenow = spage.fpage(spagenow);//希望显示第几页
int rowcount = spage.rowpage();//共有几条记录(查表获得)
int pagecount = spage.countpage();//共有几页(计算)
List list = sq.specialtySetupQuery(pagesize,pagenow);
<%
if(pagenow!=1){%>
<html:link page="/specialtysetuppage.do?pagenow=1">首页</html:link>
<%}%>
[当前是第
<font color="red"><%=pagenow %></font>页] [共有
<font color="red"><%=rowcount %></font>记录][共有
<font color="red"><%=pagecount %></font>页]
<%if(pagenow!=1){%>
<html:link page="<%="/specialtysetuppage.do?pagenow="+(pagenow-1) %>">上一页</html:link>
<%} %>
<%if(pagenow<pagecount){%>
<html:link page="<%="/specialtysetuppage.do?pagenow="+(pagenow+1) %>">下一页</html:link>
<%}%>
<%
if(pagenow!=pagecount){%>
<html:link page="<%="/specialtysetuppage.do?pagenow="+pagecount %>">尾页</html:link>
<%}%>