📄 list.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" language="java" import="java.sql.*,java.util.*;" errorPage="err.jsp"%>
<html>
<head>
<title>学籍管理系统</title>
</head>
<body bgcolor="#ffffff">
<div align="center">
<p><font color="#000000" size="5">学籍管理系统</font></p>
<p><a href=login?action=loginout>注销 </a><a href=modiinfo.jsp>修改密码</a> </p>
<% String xuehao =null;
int currentPage = 1 ;
int pageSize = 10 ;
%>
<% xuehao = request.getParameter("xuehao") ;%>
</div>
<%
try
{
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=D:/university.mdb" ;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(1004,1008);
String sql = "select * from student";
ResultSet rs=stmt.executeQuery(sql);
String spage=request.getParameter("page");
int count=0;
rs.beforeFirst();
while(rs.next())
count++; //计算记录数
rs.first();
%>
<%
try
{
currentPage = Integer.parseInt(request.getParameter("cp")) ;
}
catch(Exception e)
{}
%>
<form name="spage" action="list.jsp">
<div align="center">
<%
if(count>0)
{
%>
<input type="button" value="首页" onClick="openPage(1)" <%=currentPage==1?"disabled":""%>>
<input type="button" value="上一页" onClick="openPage(<%=currentPage-1%>)" <%=currentPage==1?"disabled":""%>>
<input type="button" value="下一页" onClick="openPage(<%=currentPage+1%>)" <%=currentPage==pageSize?"disabled":""%>>
<input type="button" value="尾页" onClick="openPage(<%=pageSize%>)" <%=currentPage==pageSize?"disabled":""%>>
<input type="hidden" name="cp" value="">
<font color="red" size="5"><%=currentPage%></font>
/
<font color="red" size="5"><%=pageSize%></font>
跳转到
<select name="selpage" onChange="selOpenPage()">
<%
for(int x=1;x<=pageSize;x++)
{
%>
<option value="<%=x%>" <%=currentPage==x?"selected":""%>><%=x%></option>
<%
}
%>
</select>
页
<%
}
%>
</div>
</form>
<script language="javaScript">
function openPage(curpage)
{
document.spage.cp.value = curpage ;
// alert(cupage) ;
document.spage.submit() ;
}
function selOpenPage()
{
document.spage.cp.value = document.spage.selpage.value ;
document.spage.submit() ;
}
</script>
<form name="form1" action="search_query.jsp?xuehao=<%=xuehao%>" >
<div align="center">请输入学号
<input name="xuehao" type="text" id="xuehao" value="<%=xuehao==null?"":xuehao%>" >
<input name="kw" type="submit" id="s" value="查询">
<a href="insert.jsp">添加新记录</a>
<div align="center"></div>
</div>
<table width="75%" border="1" cellspacing="1" cellpadding="1" align="center">
<tr>
<td width=16% align=center>学号</td>
<td width=16% align=center>姓名</td>
<td width=8% align=center>性别</td>
<td width=8% align=center>年龄</td>
<td width=16% align=center>籍贯</td>
<td width=12% align=center>院系</td>
<td width=12% align=center>更改</td>
<td width=12% align=center>删除</td>
</tr>
<%
int a=count%pageSize;
int b=count/pageSize;
int pagecount=a==0?(b):(b+1);
//int nowpage=1;
if(spage!=null&&!spage.equals("")){
try{currentPage=Integer.parseInt(spage);
}catch(Exception e){}
}
if(currentPage<1|| currentPage>pagecount)
currentPage=1;
int pagetop=(currentPage-1) * pageSize ;
int pagebottom=Math.min(count-1,pagetop+pageSize-1);
for(int x=0;x<pagetop;x++)
{
rs.next();
}
for(int i=pagetop;i<=pagebottom;i++){
//while(rs.next()){
String sno=rs.getString(1);
%>
<tr>
<td width=16% align=center><%=sno%></td>
<td width=16% align=center><%=rs.getString(2)%></td>
<td width=8% align=center><%=rs.getString(3)%></td>
<td width=8% align=center><%=rs.getString(4)%></td>
<td width=16% align=center><%=rs.getString(5)%></td>
<td width=12% align=center><%=rs.getString(6)%></td>
<td width=12% align=center><a href="change.jsp?xuehao=<%=sno%>" >改修</a></td>
<td width=12% align=center><a href="del.jsp?xuehao=<%=sno%>">删除</a></td>
</tr>
<%
rs.next();
}
%>
</table>
</form>
<%
rs.close();
stmt.close(); //关闭语句对象
conn.close();
}catch(Exception e){
out.println(e);
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -