?? addteacher.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="myBeans.SQLBean"%>
<html>
<head>
<link href="Inc/student_com.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>增加教師</title>
</head>
<p>
<%
String admin_id = (String)session.getAttribute("id");
if(admin_id==null){response.sendRedirect("login.jsp");}
String dep = (String)session.getAttribute("dep");
if(dep==null){response.sendRedirect("login.jsp");}
SQLBean db = new SQLBean();
String sql = "select ID,DEPARTMENT,ENTRYYEAR from teacher";
ResultSet rs = db.executeQuery(sql);
%>
</p>
<script language="javascript">
var onecount;
onecount=0;
subcat = new Array();
<%
int count = 0;
int sum = 0;
while(rs.next()){
%>
subcat[<%=count%>] = new Array("<%=rs.getString("DEPARTMENT")%>","<%=rs.getString("ENTRYYEAR").substring(0,4)%>","<%=rs.getString("ID")%>");
<%
count++;
}
rs.close();%>
onecount=<%=count%>;
function getTea_id(){
var year = form1.entryyear.value;
var depid = form1.dep.value;
var i,j;j=0;
for(i=0;i<onecount;i++){
if(subcat[i][0]==depid && subcat[i][1]==year){
j++;
}
}j++;
if(j<9)
values=depid+year+0+j;
else
values=depid+year+j;
for(i=0;i<onecount;i++){
if(subcat[i][2]==values){
j++;
if(j<9)
values=depid+year+0+j;
else
values=depid+year+j;
}
}
form1.id.value=values;
}
</script>
<body bgcolor="#0099FF" text="#FFFFFF" link="#66FF00">
<jsp:useBean id="tea" scope="page" class="myBean.Teacher"/>
<p align="center"><font color="#00FF00" size="+3" face="華文行楷">新增教師</font></p>
<form name="form1" method="post" action="TeacherSvlt">
<input type="hidden" name="action" value="new">
<p> </p>
<div align="center">
<table width="420" border="0" cellpadding="2" cellspacing="1" bgcolor="#DEDFDE">
<tr>
<td width="33%" bgcolor="#FFFFFF">教師姓名</td>
<td width="67%" bgcolor="#FFFFFF"><input name="name" type="text" id="name"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">密碼</td>
<td bgcolor="#FFFFFF"><input name="password" type="text" id="password" value="8888"></td>
</tr>
<tr>
<td bgcolor="#FFFFFF">職稱</td>
<td bgcolor="#FFFFFF"><select name="title" size="1" id="title">
<option>助教</option>
<option>講師</option>
<option>副教授</option>
<option>教授</option>
<option>博導</option>
</select></td>
</tr>
<tr><td bgcolor="#FFFFFF">院系</td>
<td bgcolor="#FFFFFF">
<select name="dep" id="dep" size="1">
<%
rs = tea.getDep(dep);
while(rs.next()){
String id = rs.getString("ID");
String name = rs.getString("NAME");%>
<option value="<%=id%>"><%=name%></option>
<%}%></td>
</tr>
<tr><td bgcolor="#FFFFFF">開始執教</td>
<td bgcolor="#FFFFFF">
<select name="entryyear" id="entryyear" size="1" onChange="getTea_id()">
<%java.util.Date date=new java.util.Date();
int year=date.getYear()+1900;
for(int i=year;i>year-10;i--){%>
<option value=<%=i%>><%=i%></option>
<%}%></select></td></tr>
<tr>
<td bgcolor="#FFFFFF">教師號</td>
<td bgcolor="#FFFFFF"><input name="id" type="text" id="id"></td>
</tr>
</table>
<p>
<input name="確定" type="submit" id="確定" value="提交">
</p>
</div>
</form>
<p> </p>
<p align="center"><a href="getTeacher.jsp">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -