ShowUser.jsp
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用戶展示界面</title>
</head>
<body>
<body bgcolor="#2EFEF7">
<center>
<%@include file="title.jsp" %>
<br>
<h1><a href="index.jsp">返回重新登錄</a>
<a href="success.jsp">返回管理界面 </a>
</h1>
<br>
<hr>
<br><br><br>
<%
int pageSize=3;
int pageNow=1;//默認(rèn)顯示第一頁
int rowCount=0;//從數(shù)據(jù)庫中獲得
int pageCount;//計算得到
//接收pageNow
String tmpPageNow=request.getParameter("pageNow");
if(tmpPageNow!=null)
{
//接收到pageNow
pageNow=Integer.parseInt(tmpPageNow);
}
//鏈接數(shù)據(jù)庫，驗證密碼
//1.加載驅(qū)動
// 驅(qū)動程序名
String driver = "com.mysql.jdbc.Driver";
Class.forName(driver);
//2.得到鏈接
// URL指向要訪問的數(shù)據(jù)庫名world
String url = "jdbc:mysql://localhost:3306/db_01";
Connection conn=DriverManager.getConnection(url,"root","root");
//3.得到statement
Statement statement = conn.createStatement();
//4查詢數(shù)據(jù)庫
String sql="select count(*) from user";
ResultSet rs = statement.executeQuery(sql);
if(rs.next())
{
rowCount=rs.getInt(1);
}
if(rowCount%pageSize==0)
{
pageCount=rowCount/pageSize;
}
else
{
pageCount=rowCount/pageSize+1;
}
sql="select * from user limit "+(pageNow-1)*pageSize+","+pageSize;
rs=statement.executeQuery(sql);
%>
<table border="1px">
<tr><td>用戶名</td><td>密碼</td><td>性別</td><td>出生日期</td><td>畢業(yè)學(xué)校</td><td>學(xué) 歷</td><td>通 信 地 址</td><td>聯(lián) 系 電 話</td><td>Email</td></tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
<td><%=rs.getString(7)%></td>
<td><%=rs.getString(8)%></td>
<td><%=rs.getString(9)%></td>
<td><%=rs.getString(10)%></td>
</tr>
<%
}
%>
</table>
<%
//上一頁
if(pageNow>1)
{
out.println("<a href='showUser.jsp?pageNow="+(pageNow-1)+"'>["+"上一頁"+"]</a>");
}
for(int i=0;i<pageCount;i++)
{
out.println("<a href='showUser.jsp?pageNow="+(i+1)+"'>["+(i+1)+"]</a>");
}
//下一頁
if(pageNow<pageCount)
{
out.println("<a href='showUser.jsp?pageNow="+(pageNow+1)+"'>["+"下一頁"+"]</a>");
}
%>
<br><br><br>
<%@include file="footer.jsp" %>
</center>
</body>
</html>
查看后續(xù)代碼請看這里??后續(xù)代碼
