📄 index.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" %>
<html>
<head>
<title>
index
</title>
</head>
<body bgcolor="#ffffff">
<%
if(request.getParameter("search_kind")==null){
%>
<form action=index method=post>
<input type=text name=id>
<select size=1 name=search_kind>
<option selected></option>
<option value=1>按姓名搜索</option>
<option value=2>按学号搜索</option>
</select>
<input type=submit value='确定'>
</form>
<br><br>
<form action=index.jsp>
<select size=1 name=search_kind>
<option value=1 selected>按学号排序</option>
<option value=2>按年级排序</option>
</select>
<input type=submit value="查看所有记录">
</form>
<%
}
else{
String kind=request.getParameter("search_kind");
info.ReadDB readDB=new info.ReadDB(application.getRealPath("/"),kind);
info.Init init=new info.Init(application.getRealPath("/"));
int pageView=init.getPageView();//每页显示的记录数
String getNowpage=request.getParameter("page");
int nowpage;//取得当前页
int pageMax;//总页数
if(getNowpage==null) nowpage=1;
else{
try{
nowpage=Integer.parseInt(getNowpage);
}
catch(NumberFormatException e){
nowpage=1;
}
if (nowpage<1) nowpage=1;
}
pageMax=(readDB.getRowcount()+pageView-1)/pageView;
if (nowpage>pageMax) nowpage=pageMax;
int start=pageView*(nowpage-1)+1;
if(pageView>readDB.getRowcount()) pageView=readDB.getRowcount();
%>
<table border=1>
<tr>
<td>学号</td><td>姓名</td><td>性别</td><td>年级</td><td>出生日期</td>
<%
for (int i=1;i<=readDB.getNum()-2;i++)
out.println("<td>class"+i+"</td>");
%>
<td>时间</td><td>管理</td>
</tr>
<%
for (int i=0;i<pageView;i++){
readDB.readSQL(start);
start++;
%>
<tr>
<td><%=readDB.getID()%></td>
<td><%=readDB.getS_name()%></td>
<td><%=readDB.getS_sex()%></td>
<td><%=readDB.getS_grade()%></td>
<td><%=readDB.getS_birth()%></td>
<%
for (int t=1;t<=readDB.getNum()-2;t++){
float[] classname=readDB.getclassname();
out.println("<td>"+classname[t-1]+"</td>");
}
%>
<td><%=readDB.getS_time()%></td>
<td><a href=manage?action=change&id=<%=readDB.getID()%> target=_blank>修改</a>/<a href=manage?action=del&id=<%=readDB.getID()%> target=_blank>删除</a></td>
</tr>
<%
if(start>readDB.getRowcount()) break;
}
readDB.close();
%>
</table>
<%
for (int i=1;i<=pageMax;i++){
%>
<a href="index.jsp?search_kind=<%=kind%>&page=<%=i%>"> <%=i%> </a>
<%
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -