📄 index.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.io.*"%>
<html><head><title>用JDBC访问SQL Server并实现分页功能</title></head>
<body background="bg.jpg">
<center><font size="5" color="red" face="楷体_gb2312">
<hr><table border="1">
<tr><td>标题</td><td>作者</td><td>时间</td></tr></center>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rst=null;
String strSQL="";
int PageSize=5;
int Page=1;
int totalPage=1;
int totalrecord=0;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=luntan";
String user="sa";
String password="sa";
conn= DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
strSQL="select count(*) as recordcount from luntan";
rst=stmt.executeQuery(strSQL);
if(rst.next()) totalrecord=rst.getInt("recordcount");
strSQL="select * from luntan";
rst=stmt.executeQuery(strSQL);
if(totalrecord%PageSize==0)
totalPage=totalrecord/PageSize;
else
totalPage=(int)Math.floor(totalrecord/PageSize)+1;
if(totalPage==0) totalPage=1;
if(request.getParameter("Page")==null||request.getParameter("Page").equals(""))
Page=1;
else
try{
Page=Integer.parseInt(request.getParameter("Page"));
}
catch(java.lang.NumberFormatException e){
Page=1;
}
if(Page<1) Page=1;
if(Page>totalPage) Page=totalPage;
rst.absolute((Page-1)*PageSize+1);
for(int iPage=1;iPage<=PageSize;iPage++)
{
out.println("<tr>");
out.println("<td>"+rst.getString("name")+"</td>");
out.println("<td>"+rst.getString("filename")+"</td>");
out.println("<td>"+rst.getDate("date")+"</td>");
out.println("</tr>");
//out.println("<td>"+rst.getString("xsmm")+"</td>");
if(!rst.next()) break;
}
}
catch(SQLException e){
System.out.println(e.getMessage());
}
%>
</table></font>
<form action="index.jsp" method="get">
<%
if(Page!=1){
out.print("<p>");
out.print("<center>");
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<br>");
out.print("<a href=show.jsp?Page=1>第一页</a>");
out.print(" ");
out.print("<a href=show.jsp?Page="+(Page-1)+">上一页</a>");
out.print(" ");
}
if(Page!=totalPage){
// out.print("<center>");
out.print("<a href=show.jsp?Page="+(Page+1)+">下一页</a>");
out.print(" ");
out.print("<a href=show.jsp?Page="+totalPage+">最后一页</a>");
out.print("</p>");
}
%>
<p align="center" >输入页数：<input type="text" name="Page" size="3">
<input type="submit" value="确定">
页数：<font color="red"><%=Page%>|<%=totalPage%></font></p>
</form>
<p align="center"> 我要留言 </p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -