📄 addclass.jsp

📁 在线教育平台：从小学
💻 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">
<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>
<script language="javascript">
<!--
function usercheck1(){
var grade1;
grade1=document.form3.grade.value;
if(grade1==""){
alert("学历不能为空!");
return false;}
}
function usercheck2(){
var grade2;
grade2=document.form1.grade.value;
if(grade2==""){
alert("学历不能为空!");
return false;}
}
function usercheck3(){
var classes1;
classes1=document.form4.classes.value;
if(classes1==""){
alert("年级不能为空!");
return false;}
}
function usercheck4(){
var classes2;
classes2=document.form2.classes.value;
if(classes2==""){
alert("年级不能为空!");
return false;}
}
function usercheck5(){
var subject1;
subject1=document.myform.subject.value;
if(subject1==""){
alert("科目不能为空!");
return false;}
if(document.myform.class_id.options[document.myform.class_id.selectedIndex].value==""){
alert("请选择年级!");
return false;}
}
//-->    
</script>
<link rel="stylesheet" href="style.css" type="text/css">
</head>

<%
	ResultSet rs_class = classs.getClasses();
	ResultSet rs_subject = subjects.getSubjects();
	int grade_id = 0, class_id = 0, subject_id = 0;
	String grade = "", u_id = null, classes = "", subject = "", name = "", sort = "";
	try {
		name = session.getAttribute("name").toString();
		sort = session.getAttribute("sort").toString();
	} catch (NullPointerException e) {
	}
	if (name == null || name.equalsIgnoreCase("null")
			|| !sort.equalsIgnoreCase("admin"))
		response.sendRedirect("error_ad.jsp");
%>

<script language="javascript">
<!-- 
function getconfirm(str)
{
    if (confirm(str))
    return ture;
    else 
    return false;
} 
var onecount; 
onecount=0; 
subcat = new Array(); 
        <% 
        int count = 0; 
        try{
        while(rs_class.next()){ 
        %> 
subcat[<%=count%>] = new Array("<%=rs_class.getString("class")%>","<%=rs_class.getInt("class_id")%>","<%=rs_class.getInt("grade_id")%>"); 
        <% 
        count++; 
        } }catch(NullPointerException e){}
        rs_class.close(); 
        %> 
onecount=<%=count%>;
function changelocation(locationid) 
    { 
    document.myform.class_id.length = 0; 

    var locationid=locationid; 
    var i; 
    for (i=0;i < onecount; i++) 
        { 
            if (subcat[i][2] == locationid) 
            { 
                document.myform.class_id.options[document.myform.class_id.length] = new Option(subcat[i][0], subcat[i][1]); 
            }        
        } 
        
    }
//-->    
</script>
<body>
<%
ResultSet rs = grades.getGrades();
%>
<table width="750" border="0" align="center">
	<tr>
		<td>&nbsp;</td>
		<td><strong>添加：</strong></td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
		<form name="form1" onSubmit="return usercheck2()" method="post"
			action="Servletgrade"><input name="action" type="hidden"
			id="action" value="new">
		<table width="100%" border="0">
			<tr>
				<td width="10%">学历：</td>
				<td><label> <input name="grade" type="text" id="grade">
				</label> <label> <input type="submit" name="Submit3"
					onClick="return usercheck2()" value="添加学历"> </label></td>
			</tr>
		</table>
		</form>
		</td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
		<form name="form2" onSubmit="return usercheck4()" method="post"
			action="Servletclass"><input name="action" type="hidden"
			id="action" value="new">
		<table width="100%" border="0">
			<tr>
				<td width="10%">请选择：</td>
				<td width="6%"><label> <select name="grade_id"
					id="grade_id">
					<%
							try {
							while (rs.next()) {
								grade_id = rs.getInt("grade_id");
								grade = rs.getString("grade");
					%>
					<option value="<%=grade_id %>"><%=grade%></option>
					<%
						}
						} catch (NullPointerException e) {
						}
					%>
				</SELECT> </label></td>
				<td width="9%">年级：</td>
				<td><label> <input name="classes" type="text"
					id="classes"> <input type="submit"
					onClick="return usercheck4()" name="Submit2" value="添加年级">
				</label></td>
			</tr>
		</table>
		</form>
		</td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
		<form name="myform" onSubmit="return usercheck5()" method="post"
			action="Servletsubject"><input name="action" type="hidden"
			id="action" value="new">
		<TABLE width="100%" align="lift">
			<TR>
				<TD width="64">请选择：</TD>
				<TD width="38"><SELECT name="grade_id"
					onChange="changelocation(document.myform.grade_id.options[document.myform.grade_id.selectedIndex].value)"
					size="1">
					<%
						rs = grades.getGrades();
						try {
							while (rs.next()) {
								grade_id = rs.getInt("grade_id");
								grade = rs.getString("grade");
					%>
					<option value="<%=grade_id %>"><%=grade%></option>
					<%
						}
						} catch (NullPointerException e) {
						}
					%>
				</SELECT></TD>
				<TD width="48">年级：</TD>
				<TD width="84"><SELECT name="class_id" size="1">
					<option selected>选择年级</option>
				</SELECT></TD>
				<TD width="48">科目：</TD>
				<TD width="276"><label> <input name="subject"
					type="text" id="subject"> <input type="submit"
					onClick="return usercheck5()" name="Submit" value="添加科目"> </label></TD>
			</TR>
		</TABLE>
		</form>
		</td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td><strong>列表：</strong></td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
		<table width="100%" border="0">
			<tr>
				<td width="17%">&nbsp;</td>
				<td width="8%"><strong>序号</strong></td>
				<td width="36%"><strong>学历</strong></td>
				<td width="7%"><strong>更新</strong></td>
				<td width="10%"><strong>删除</strong></td>
				<td width="22%">&nbsp;</td>
			</tr>
			<%
				rs = grades.getGrades();
				int i = 0;
				while (rs.next()) {
					i++;
					grade_id = rs.getInt("grade_id");
					grade = rs.getString("grade");
			%>

			<tr>
				<form name="form3" method="post" action="Servletgrade">
				<input	name="action" type="hidden" id="action" value="update">
<input	name="grade_id" type="hidden" id="grade_id" value="<%=grade_id%>">
				<td>&nbsp;</td>
				<td><%=i%></td>

				<td><label> <input name="grade" type="text" id="grade"
					value="<%=grade%>" size="10"> </label></td>
				<td><label> <input type="submit"
					onClick="return usercheck1()" name="Submit4" value="更新"> </label></td>
				</form>
				<form name="form" method="post" action="Servletgrade">
				<td><label> <input name="action" type="hidden"
					id="action" value="delete"> <input name="grade_id"
					type="hidden" id="grade_id" value="<%=grade_id%>"> <input
					type="Submit" name="Submit7"
					onClick="return getconfirm('你确定要删除吗？')" value="删除"> </label></td>
				</form>
				<td>&nbsp;</td>
			</tr>
			<%
			}
			%>
		</table>

		</td>
		<td>&nbsp;</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
		<td>
		<table width="100%" border="0">
			<tr>
				<td width="17%">&nbsp;</td>
				<td width="8%"><strong>序号</strong></td>
				<td width="10%"><strong>学历</strong></td>
				<td width="26%"><strong>年级</strong></td>
				<td width="7%"><strong>更新</strong></td>
				<td width="10%"><strong>删除</strong></td>
				<td width="22%">&nbsp;</td>
			</tr>
			<%
				rs_class = classs.getClasses();
				int j = 0;
				while (rs_class.next()) {
					j++;
					class_id = rs_class.getInt("class_id");
					grade_id = rs_class.getInt("grade_id");
					classes = rs_class.getString("class");
					rs = grades.getGrades(grade_id);
					while (rs.next()) {
						grade = rs.getString("grade");
			%>
			<tr>
				<form name="form4" method="post" action="Servletclass"><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%>">
				<td>&nbsp;</td>
				<td><%=j%></td>

				<td><%=grade%></td>
				<td><label> <input name="classes" type="text"
					id="classes" value="<%=classes%>" size="10"> </label></td>
				<td><label> <input type="submit"
					onClick="return usercheck3()" name="Submit5" value="更新"> </label></td>
				</form>
				<form name="form" method="post" action="Servletclass">
				<td><label> <input name="action" type="hidden"
					id="action" value="delete"> <input name="class_id"
					type="hidden" id="class_id" value="<%=class_id%>"> <input
					type="Submit" name="Submit7" onClick="return getconfirm('你确定要删除吗？')"
					value="删除"> </label></td>
				</form>
				<td>&nbsp;</td>
			</tr>
			<%
				}
				}rs.close();
				rs_class.close();
			%>
		</table>

		</td>
		<td>&nbsp;</td>
	</tr>

</table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -