📄 opcourse.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");
   Data data = new Data();
   String name = (String)request.getParameter("name");
   String teacher = (String)request.getParameter("teacher");
   String num = (String)request.getParameter("num");
   String yid = (String)request.getParameter("yid");
   if(name!=null&&action!=null&&action.equals("add")){
	  String sql = "insert into courseinfo(Course_name,Course_num,Course_teacher_ID)values('"+name+"','"+num+"','"+teacher+"')";
	  if(data.addInof(sql))
	  {
	      out.print("<script>alert('添加成功！')</script>");
	  }else out.print("<script>alert('添加失败！')</script>");
   }else if(name!=null&&action!=null&&action.equals("update")){
      String sql = "update courseinfo set Course_name='"+name+"',Course_teacher_ID='"+teacher+"',Course_num='"+num+"' where Course_ID='"+yid+"'";
      System.out.println(sql);
	  if(data.addInof(sql))
	  {
	      out.print("<script>alert('修改成功！')</script>");
	  }else out.print("<script>alert('修改失败！')</script>");
   }
   String sq = "select Teacher_ID,Teacher_name,Teacher_password,Teacher_sex,"+
   "College_name,Dep_name from teacherinfo,college,dep where Teacher_college_ID=College_ID and "+
   "Teacher_dep_ID=Dep_ID";
   ArrayList<Teacher> list = data.getTeacherList(sq);
   int size = list.size();
%>
<link href="../css/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<form name="usersForm" method="post" action="opcourse.jsp?action=<%=action%>&&yid=<%=yid%>" 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="name" type="text" class="input" id="id" maxlength="20">
        <span class="text13">(*）20个字符以内        </span></td>
    </tr>
	<tr>
      <td height="7" align="center" >讲课教师：</td>
      <td height="7" align="left" ><select name="teacher">
	  <%for(int i=0;i<size;i++){%>
        <option value="<%=list.get(i).getTeacher_ID()%> "><%=list.get(i).getTeacher_name()%></option>
      <%}%>
	  </select></td>
    </tr>
    <tr>
      <td height="3" align="center" >课程学分：</td>
      <td height="3" align="left" ><label>
        <input type="text" name="num">
        <span class="text13">(*）20个字符以内</span></label></td>
    </tr>
    <tr>
      <td height="7" 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 isok(){
   var str2=document.usersForm.name.value;
   if(str2==""){
      alert("课程名不能为空！");
	  document.usersForm.name.focus();
	  return false;
   }
   var str3 =document.usersForm.teacher.value;
   if(str3==""){
      alert("教师不能为空！");
      document.usersForm.teacher.focus();
      return false;
   }
   var str4=document.usersForm.num.value;
   if(Str4==""){
      alert("学分不能为空！");
      document.usersForm.num.focus();
      return false;
   }
}
</script>
⌨️ 快捷键说明

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