📄 index.jsp
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page import="java.sql.*,bean.PageBean"%>
<%!ResultSet rs = null;
//页面大小
int pageSize = 5;
//第几页
int pages = 1;
//总页数
int totalPage = 0;
String str = "";
public String showOnePage(ResultSet rs, int pages, int pageSize) {
str = "";
// 将记录指针定位到相应的位置
try {
rs.absolute( (pages-1) * pageSize + 1);
}catch(SQLException e) {
}
for(int i=1; i<=pageSize; i++) {
str += displayOneResult(rs);
try {
if(!rs.next()) break;
}catch(Exception e) {
e.printStackTrace();
}
}
return str;
}
// 显示单行记录方法
public String displayOneResult( ResultSet rs ) {
String text= "";
try {
text += "<tr>";
text += "<td>" + rs.getString("id") + "</td>";
text += "<td>" + rs.getString("name") + "</td>";
text += "<td>" + rs.getString("phone") + "</td>";
text += "<td>" + rs.getString("mobile") + "</td>";
text += "<td>" + rs.getString("address") + "</td>";
text += "<td>" + rs.getString("email") + "</td>";
text += "<td>" + rs.getString("qq") + "</td>";
text += "</tr>";
}catch(Exception e) {
e.printStackTrace();
}
return text;
}%>
<%
try {
rs = PageBean.getAllResults();
}catch(Exception e) {
out.println("访问数据库出错！");
}
%>
<html>
<head>
<title>显示成员</title>
</head>
<body bgcolor="#FFFFFF">
<div align="center"><font size="6" color="red"><font face="微软雅黑">学生信息管理系统</font></font></div><div align="left"><font size="6" color="red"> </font>
<h3><font size="4" face="微软雅黑">欢迎，<%=request.getAttribute("SSOUser")%> ！</font></h3>
<font face="微软雅黑"><a href="info.jsp?uid=<%=request.getAttribute("SSOUser")%>">我的信息</a></font>
<font face="微软雅黑"><a href="index.jsp?action=logout">注销</a></font>
<br>
</div><div align="right">
</div><h3><p><td align="right"><div align="right">
<a href="add.jsp">增加记录</a>
<a href="delete.jsp">删除记录</a>
<a href="search.jsp">搜索记录</a></div>
<hr>
<div align="center"><font size="5" color="red" align="right">学生信息</font></div>
<center>
<table border="1">
<tr bgcolor="lightblue">
<th>ID</th>
<th>姓名</th>
<th>电话</th>
<th>手机</th>
<th>地址</th>
<th>Email</th>
<th>QQ</th>
</tr>
<%
totalPage = PageBean.getTotalPage(5);
try {
if(request.getParameter("Page")==null ||
request.getParameter("Page").equals(""))
pages = 1;
else
pages = Integer.parseInt(request.getParameter("Page"));
} catch(java.lang.NumberFormatException e) {
// 处理用户从浏览器地址拦直接输入pages=ab等所造成的异常
pages = 1;
}
if(pages < 1) pages = 1;
if(pages > totalPage) pages = totalPage;
out.println(showOnePage(rs, pages, pageSize));
%>
</table>
<form action="index.jsp" method="get" style="">
<%
if(pages != 1) {
out.println("<a href= index.jsp?Page=1>首页</A>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -