📄 adminsubject.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB18030"
pageEncoding="GB18030"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<link rel="stylesheet" href="style.css" type="text/css">
<jsp:useBean id="grades" scope="page" class="edu.GradeBean" />
<jsp:useBean id="classs" scope="page" class="edu.ClassBean" />
<jsp:useBean id="subjects" scope="page" class="edu.SubjectBean" />
<title>Insert title here</title>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
</head>
<script type="text/javascript">
function getconfirm(str)
{
if (confirm(str))
return ture;
else
return false;
}
function usercheck(){
var subject;
subject=document.form5.subject.value;
if(subject==""){
alert("科目不能为空!");
return false;}
}
</script>
<body>
<table width="750" border="0" align="center">
<tr>
<td width="17%"> </td>
<td width="8%"><strong>序号</strong></td>
<td width="10%"><strong>学历</strong></td>
<td width="10%"><strong>年级</strong></td>
<td width="16%"><strong>科目</strong></td>
<td width="7%"><strong>更新</strong></td>
<td width="32%"><strong>删除</strong></td>
</tr>
<%
int grade_id = 0, class_id = 0, subject_id = 0;
int allrow = 0, pagesize = 10, intpage = 1;
String sort = "";
try {
sort = session.getAttribute("sort").toString();
} catch (NullPointerException e) {
}
if (!sort.equals("admin"))
response.sendRedirect("error_ad.jsp");
String grade = null, u_id = null, classes = null, subject = null, name = "";
try {
intpage = Integer.valueOf(request.getParameter("intpage"))
.intValue();
} catch (NumberFormatException e) {
}
ResultSet rs = subjects.getCount();
if (rs.next())
allrow = rs.getInt(1);
rs.close();
int allpage = (allrow + pagesize - 1) / pagesize;
// 调整待显示的页码
if (intpage > allpage)
intpage = allpage;
if (intpage < 1)
intpage = 1;
int startrow = (intpage - 1) * pagesize;
subjects.setStartpage(startrow);
subjects.setPagesize(pagesize);
ResultSet rs_subject = subjects.getSubjectss();
while (rs_subject.next()) {
subject = rs_subject.getString("subject");
subject_id = rs_subject.getInt("subject_id");
grade_id = rs_subject.getInt("grade_id");
class_id = rs_subject.getInt("class_id");
ResultSet rs_grade = grades.getGrades(grade_id);
while (rs_grade.next()) {
grade = rs_grade.getString("grade");
}rs_grade.close();
ResultSet rs_class = classs.getClasss(class_id);
while (rs_class.next()) {
classes = rs_class.getString("class");
}rs_class.close();
%>
<tr>
<form name="form5" method="post" action="Servletsubject">
<input name="action" type="hidden" id="action" value="update">
<input name="class_id" type="hidden" id="class_id" value="<%=class_id%>">
<input name="grade_id" type="hidden" id="grade_id"
value="<%=grade_id%>"> <input name="subject_id" type="hidden"
id="subject_id" value="<%=subject_id%>">
<td> </td>
<td><%=subject_id%></td>
<td><%=grade%></td>
<td><%=classes%></td>
<td><label> <input name="subject" type="text"
id="subject" value="<%=subject%>" size="10"> </label></td>
<td><label> <input type="submit" name="Submit6"
onClick="return usercheck()" value="更新"> </label></td>
</form>
<form name="form" method="post" action="Servletsubject">
<td><label> <input name="action" type="hidden"
id="action" value="delete"> <input name="subject_id"
type="hidden" id="subject_id" value="<%=subject_id%>"> <input
type="Submit" name="Submit7" onClick="return getconfirm('您确定要删除吗？')"
value="删除"> </label></td>
</form>
</tr>
<%
}rs_subject.close();
%>
</table>
<div align="center">
<table width="750" border="0">
<tr>
<td width="30%" height="30">
<div align="center">共<span class="STYLE1"><%=allrow %></span>条记录 当前第<span class="STYLE1"><%=intpage %></span>页/共<span class="STYLE1"><%=allpage %></span>页</div></td>
<td width="70%" ><div align="center"><a href="adminsubject.jsp">首页</a>
<%
int tenpage=((int)(intpage/10))*10;
if(intpage-10>0) {%>
<a href="adminsubject.jsp?intpage=<%=intpage-10%>">上十页</a>
<%} %>
<a href="adminsubject.jsp?intpage=<%=intpage-1%>">上一页</a>
<%if(tenpage+10<=allpage){
for(int i=1;i<=10;i++){%>
<a href="adminsubject.jsp?intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}}if(tenpage+10>allpage){
for(int i=1;i+tenpage<=allpage;i++){%>
<a href="adminsubject.jsp?intpage=<%=tenpage+i %>"><%=tenpage+i %></a>
<%}} %>
<a href="adminsubject.jsp?intpage=<%=intpage+1%>">下一页</a>
<%if(intpage+10<=allpage) {%>
<a href="adminsubject.jsp?intpage=<%=intpage+10%>">下十页</a>
<%} %>
<a href="adminsubject.jsp?intpage=<%=allpage%>">
尾页</a></div></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -