?? 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 + -