簡単なJSPページング
4096 ワード
:
<%@page import="java.sql.*" pageEncoding="gbk" contentType="text/html;charset=gbk"%>
<html>
<head>
<title>My Template</title>
<script type="text/javascript" src="images/beijinss.js"></script>
</head>
<%
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://192.168.0.111:3306/test";
String user = "root";
String password = "root";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
ResultSet rs = null;
%>
<body>
<center>
<h3>
</h3>
</center>
<hr>
<div align="center">
<a href="addStudent.jsp"> </a>
<table width="300" border="1">
<tbody>
<tr>
<td>
<%
rs = stmt.executeQuery("SELECT count(*) FROM student");
int stuSum = 0;
if(rs.next()) {
stuSum = rs.getInt(1);
}
%>
<%=stuSum%>
</td>
<td><%
rs = stmt.executeQuery("SELECT count(*) FROM student WHERE sex='m'");
int boySum = 0;
if(rs.next()) {
boySum = rs.getInt(1);
}
%>
<%=boySum%>
</td>
<td><%
rs = stmt.executeQuery("SELECT count(*) FROM student WHERE sex='f'");
int girlSum = 0;
if(rs.next()) {
girlSum = rs.getInt(1);
}
%>
<%=girlSum %>
</td>
</tr>
</tbody>
</table>
<%//
int pageId = 1;//
int pageSize = 5;//
int pageSum = (stuSum-1)/pageSize+1;//
String pid = request.getParameter("pid");
if(null==pid) {
pageId = 1;
}else {
pageId = Integer.parseInt(pid);
}
if(pageId<1) {
pageId = 1;
}else if(pageId>pageSum) {
pageId = pageSum;
}
%>
<table width="300" border="1">
<tbody>
<tr>
<td colspan="3" align="right">
<%=pageId%> / <%=pageSum%>
<a href="showStudent.jsp?pid=<%=pageId-1%>"> </a>
<a href="showStudent.jsp?pid=<%=pageId+1%>"> </a>
</td>
</tr>
<tr>
<th>
</th>
<th>
</th>
<th>
</th>
</tr>
<%
String sql = "SELECT * FROM student limit "+(pageId-1)*pageSize+","+pageSize;
rs = stmt.executeQuery(sql);
while(rs.next()) {
%>
<tr>
<td>
<a href="stuInfo.jsp?id=<%=rs.getInt("sid")%>"><%=rs.getString("sname")%></a>
</td>
<td>
<%=rs.getString("school")%>
</td>
<td>
<a href="delete.jsp?id=<%=rs.getInt("sid")%>"> </a>
</td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
</tbody>
</table>
</div>
</body>
</html>