📄 quertstudent.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<jsp:directive.page import="sql.SQLPag"/>
<jsp:directive.page import="javabean.JavaBean;"/>
<jsp:useBean id="pages" scope="page" class="javabean.JavaPag"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%!
int pageSize=5;//每页记录数
String sqlStr="";
String sqlTabel="";
int showPage=1;//当前页
%>
<%
sqlStr="select * from users where property='student'";
sqlTabel="users";
session.setAttribute("sqlTabel",sqlTabel);
String strPage=null;
pages.initialize(sqlStr,pageSize);
strPage=request.getParameter("showPage");//最下面的提交跳转
if(strPage==null)
{
showPage=1;
}
else
{
try
{
showPage=Integer.parseInt(strPage);
}
catch(NumberFormatException ex)
{
showPage=1;
}
if(showPage<1)
{
showPage=1;
}
if(showPage>pages.getPageCount())
{
showPage=pages.getPageCount();//JavaBean.java中的方法 获得逻辑页数
}
}
//取的要显示的数据集合
Vector vData=pages.getPage(showPage); //JavaBean.java中的方法传入参数为当前页数
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>学生信息</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body bgcolor="#50DBD6">
<h1 align=center>学生信息</h1>
<div align=center>
<table border="1" cellspacing="0" cellpadding="0" width="80%">
<tr align="center">
<th width=12%>帐号</th>
<th width=12%>姓名</th>
<th width=12%>属性</th>
<th width=12%>年龄</th>
<th width=12%>性别</th>
<th width=12%>班级</th>
<th width=12%>操作</th>
</tr>
<%
for(int i=0;i<vData.size();i++)
{
//显示数据数
String[] sData=(String[])vData.get(i);
%>
<tr align="center">
<td><%=sData[0]%></td>
<td><%=sData[1]%></td>
<td><%=sData[3]%></td>
<td><%=sData[4]%></td>
<td><%=sData[5]%></td>
<td><%=sData[6]%></td>
<td><a href="http://127.0.0.1:8080/project/Delete?id=<%=sData[0]%>" onclick="return check();">删除记录</a>
</tr>
<%} %>
</table>
<p>
<form action="Admin/QuertStudent.jsp" method="get" target="_self">
<p>共<font color=red><%=pages.getRowCount()%></font>条 <%=pageSize%>条/页 第<font color=red><%=showPage%></font>页/共<font color=red><%=pages.getPageCount()%></font>页 [<a href="Admin/QuertStudent.jsp?showPage=1" target="_self">首页</a>]
<%
//判断“上一页”连接是否要显示
if(showPage>1){
%>
[<a href="Admin/QuertStudent.jsp?showPage=<%=showPage-1%>" target="_self">上一页</a>]
<%
}
else{
%>
[上一页]
<%}
//判断下一页是否连接
if(showPage<pages.getPageCount())
{
%>
[<a href="Admin/QuertStudent.jsp?showPage=<%=showPage+1%>" target="_self">下一页</a>]
<%
}
else{
%>
[下一页]
<%} %>
[<a href="Admin/QuertStudent.jsp?showPage=<%=pages.getPageCount()%>" target="_self">尾页</a>] 转到
<select name="select">
<%
for(int x=1;x<pages.getPageCount();x++)
{
%>
<option value="<%=x %>"
<%
if(showPage==x){
out.println("selected");
}
%>><%=x %></option>
<%} %>
</select>
页
<input type="submit" name="go" value="提交"/>
</p>
</form>
</div>
</body>
</html>
<script language="javascript">
function check()
{
if(confirm("删除确认"))
{
return true;
}
return false;
}
</script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -