📄 updateclass_confirm.jsp

📁 学生/教师信息管理系统,用JSP+ACCESS开发

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>更新班级</title>
</head>
<jsp:useBean id="classp" scope="request" class="stu.classp"/>
<jsp:useBean id="sqlB" scope="request" class="stu.sqlBean"/>
<body bgcolor="#4692B3" text="#FFFFFF" link="#00FF00">
<p align="center"> 
  <%
String admin_id = (String)session.getAttribute("id"); 
if(admin_id==null){response.sendRedirect("login.jsp");} 
String id=(String )session.getAttribute("id");
try{
if(id==null || id.equals("") ) throw new Exception("错误，班级号不能为空！！");
boolean f=true;
f=classp.hasMoretea();
if(f==false)
throw new Exception("错误,教师不能再同一时间上两门课程!!!");
f=classp.hasMoreroom();
if(f==false)
throw new Exception("错误,同一教室不能再同一时间上两门课程!!!");
else out.print("祝贺你!更新成功!<br>");
String cour_id=request.getParameter("cour_id");
out.print("课程ID:   "+cour_id+"<br>");
String tea_id=request.getParameter("tea_id");
out.print("教师ID:    "+tea_id+"<br>");
String room_id=request.getParameter("room_id");
out.print("上课地点：  "+room_id+"<br>");
String cour_time=request.getParameter("cour_time");
out.print("上课时间:   "+cour_time+"<br>");
String sql="update classes "+
                 " set tea_id='"+tea_id+"',cour_id='"+cour_id+"',"+
                 "room_id='"+room_id+"',cour_time='"+cour_time+"'  "+
                 " where id='"+id+"' ";         
  
  		sqlB.executeInsert(sql);
}catch(Exception e){
out.print(e.toString());
}
%>
</p>
<p align="center">&nbsp; </p>
<p><a href="updateclass.jsp">&lt;&lt;back</a></p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -