📄 addtzhxx.jsp

📁 基于Java实现的聊天室功能
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="Date.*,shujuku.*,java.util.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
   request.setCharacterEncoding("gb2312");
   String shenfen = (String)session.getAttribute("shenfen");
   if(shenfen == null||shenfen.equals("admin") == false){
      response.sendRedirect("../errer.jsp");
   }
   String action = (String)request.getParameter("action");
   String id = (String)request.getParameter("id");
   String name = (String)request.getParameter("name");
   String password = (String)request.getParameter("password");
   String sex = (String)request.getParameter("sexgroup");
   String colleg = (String)request.getParameter("college");
   String dep = (String)request.getParameter("dep");
   String yid = (String)request.getParameter("yid");
   Data data = new Data();
   if(id!=null&&action!=null&&action.equals("add")){
	  String sql = "insert into teacherinfo(Teacher_ID,Teacher_name,Teacher_password,Teacher_sex,"+
	         "Teacher_college_ID,Teacher_dep_ID)values('"+id+"','"+name+"',"+
	        "'"+password+"','"+sex+"','"+colleg+"','"+dep+"')";
	  System.out.println(sql);
	  if(data.addInof(sql))
	  {
	      out.print("<script>alert('添加成功！')</script>");
	  }else out.print("<script>alert('添加失败！')</script>");
   }else if(id!=null&&action!=null&&action.equals("update")){
       String sql = "update teacherinfo set Teacher_ID='"+id+"',Teacher_name='"+name+"',Teacher_password="
       +"'"+password+"',Teacher_sex='"+sex+"',Teacher_college_ID='"+colleg+"',"+
       "Teacher_dep_ID='"+dep+"' where Teacher_ID='"+yid+"'";
      if(data.addInof(sql))
	  {
	      out.print("<script>alert('修改成功！')</script>");
	  }else out.print("<script>alert('修改失败！')</script>");
   }
   ArrayList<College> list = data.getCollegeAndDep();
%>
<link href="../css/css.css" rel="stylesheet" type="text/css">
</head>
<script language="javascript">
var text = new Array(<%=list.size()%>);
for(var i=0;i<<%=list.size()%>;i++){
text[i] = new Array();
text[i].length=0;
}
var value = new Array(<%=list.size()%>);
for(var i=0;i<<%=list.size()%>;i++){
value[i] = new Array();
value[i].length=0;
}
function init(){
<%
College college = null;
for(int i=0;i<list.size();i++){
  college = list.get(i);%>
var oOption = document.createElement("OPTION");
oOption.value="<%=college.getCollege_ID()%>";
oOption.text="<%=college.getCollege_name()%>";
usersForm.college.add(oOption);
<%
  for(int j=0;j<college.getDepList().size();j++)
  {
%>
text[<%=i%>].length++;
text[<%=i%>][text[<%=i%>].length-1]="<%=college.getDepList().get(j).getDep_name()%>";
value[<%=i%>].length++;
value[<%=i%>][value[<%=i%>].length-1]="<%=college.getDepList().get(j).getDep_ID()%>";
<%      
  }
}
%>
opchange(1);
}
function isok(){
   var str=document.usersForm.id.value;
   if(str==""){
      alert("教号不能为空！");
	  document.usersForm.id.focus();
	  return false;
   }
   var str2=document.usersForm.password.value;
   if(str2==""){
      alert("密码不能为空！");
	  document.usersForm.password.focus();
	  return false;
   }
   var str3 = document.usersForm.name.value;
   if(str3==""){
      alert("姓名不能为空！");
	  document.usersForm.name.focus();
	  return false;
   }
}
</script>
<body onLoad="init()">
<form name="usersForm" method="post" action="addtzhxx.jsp?action=<%=action%>" onSubmit="return isok();">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="1" bordercolor="#FFFFFF" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" >
  <tr>
    <td height="22" colspan="2" align="left" ><strong class="text13"><%=action%>教师信息</strong></td>
  </tr>
    <tr>
      <td width="33%" height="22" align="center" >教师学号：</td>
      <td width="67%" height="22" align="left" ><input name="id" type="text" class="input" id="id" maxlength="10">
        <span class="text13">(*）10个字符以内</span></td>
    </tr>
    <tr>
      <td height="22" align="center" >教师姓名：</td>
      <td width="67%" height="22" align="left" ><input name="name" type="text" class="input" id="name" maxlength="10">
          <span class="text13">(*) 10个字符以内 </span></td>
    </tr>
    <tr>
      <td width="33%" height="22" align="center" >登陆密码：</td>
      <td height="22" align="left" ><input name="password" type="text" class="input" maxlength="20" >
          <span class="text13">(*) 20个字符以内 </span></td>
    </tr>
    <tr>
      <td width="33%" height="22" align="center" >性别：</td>
      <td height="22" align="left" ><p>
        <label>
          <input name="sexgroup" type="radio" value="男" checked>
          男</label>
        <label>
          <input type="radio" name="sexgroup" value="女">
          女</label>
        <br>
      </p></td>
    </tr>
    <tr>
      <td height="1" align="center" >教师所在学院：</td>
      <td height="1" align="left" class="text13"><select name="college" onChange="opchange(this.value)">
      </select>
      (*) </td>
    </tr>
    <tr>
      <td height="1" align="center" >教师所在系别：</td>
      <td height="1" align="left" class="text13"><select name="dep">
      </select>
      (*) </td>
    </tr>
    <tr>
      <td height="15" colspan="2" align="center" ><input name="Submit" type="submit" class="button" value="提交">
&nbsp;&nbsp;
<input name="Submit2" type="reset" class="button" value="重置"></td>
    </tr>
</table>
</form>
</body>
</html>
<script language="javascript">
function opchange(id)
{
   usersForm.dep.length=0;
   for(var i=0;i<text[id-1].length;i++)
   {
       var oOption = document.createElement("OPTION");
       oOption.value=value[id-1][i];
       oOption.text=text[id-1][i];
       usersForm.dep.add(oOption);
   }
}
</script>
⌨️ 快捷键说明

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