<%
int dipage=1;//定义当前页
String pages=request.getParameter("dipage");//本页的局部变量
if(pages==null)//判断本页条件
{
pages="1";
}
try
{
dipage=Integer.parseInt(pages);
}
catch(Exception e)
{
dipage=1;
}
%>
<%int countrecord=0;//总记录
int countpagerecord=5;//每页的记录
int countpage=0;//总页数
ResultSet rs=null;//数据集
SQL sql=null;//调用的SQL
try
{
sql = new SQL("driver={Microsoft Access Driver (*.mdb)};DBQ=C://Documents and Settings//Administrator//My Documents//JSP//JSP//Exam.mdb", "Exam", "", "", 1);//调用类
rs=sql.getData("select * from Teacher");//调用类
rs.last();//把指针放到最后一行
countrecord=rs.getRow();//得到总记录
if(countrecord%countpagerecord==0)//判断总记录能否被页记录整除,若能,则直接整除否则出后加1
countpage=countrecord/countpagerecord;
else
countpage=countrecord/countpagerecord+1;
if((dipage-1)*countpagerecord==0)//若是第一页则返回到第一记录之前
rs.beforeFirst();
else
rs.absolute((dipage-1)*countpagerecord);否则返回到本页最后一条记录
}
catch(SQLException e)
{
}
try {
//输出查询结果
int i=0;
while (rs.next()) {
out.print("<tr>");
out.print("<td align=center height=2 width='16%'>" + rs.getString("Tea_Number") + "</td>");
out.print("<td align=center height=2 width='18%'>" + rs.getString("Tea_Name") + "</td>");
out.print("<td align=center height=2 width='16%'>" + rs.getString("Tea_Sex") + "</td>");
out.print("<td align=center height=2 width='18%'>" + rs.getString("Tea_Phone") + "</td>");
out.print("<td align=center height=2 width='18%'>" + rs.getString("Tea_Type") + "</td>");
out.print("<td align=center height=2 width='10%'><a href=''>修改</a></td>");
out.print("<td align=center height=2 width='10%'><a href=''>删除</a></td>");
out.print("</tr>");
i++;
if(i>=countpagerecord)break;
}
out.print("<tr><td colspan='7' height=2 align=right>");
out.print("一共的"+countrecord+"个教师基本信息,当前第"+dipage+"页");
out.print("/b"+"/b"+"/b");
if(dipage==1)//若是当前地一页
{out.print("首页");
out.print("上一页");
}
else
{
out.print("<a href=Main.jsp?dipage=1>首页</a>");否则执行
if(dipage<=1)
out.print("上一页");
else
out.print("<a href=Main.jsp?dipage="+(dipage-1)+">上一页</a>");
}
if(dipage==countpage)
{
out.print("下一页");
out.print("末页");
}
else
{
out.print("<a href=Main.jsp?dipage="+(dipage+1)+">下一页</a>");
out.print("<a href=Main.jsp?dipage="+countpage+">末页</a>");
}
out.print("</td></tr>");
rs.close();
java分页
最新推荐文章于 2024-07-23 21:37:49 发布