📄 addcourse_confirm.jsp

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

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<jsp:useBean id="course" scope="request" class="stu.course"/>
<jsp:useBean id="sqlB" scope="request" class="stu.sqlBean"/>
</head>
<body bgcolor="#4692B3" text="#FFFFFF" link="#66FF00">
<div align="center">
  <p>
    <%
String admin_id = (String)session.getAttribute("id"); 
if(admin_id==null){response.sendRedirect("login.jsp");} 
boolean flag=true;
String prepareDep="null";
int mark=0;
//try{
String name=new String(request.getParameter("name").getBytes("iso8859_1"),"gbk");
String id=request.getParameter("id");
String prepare=request.getParameter("prepare");
String dep=new String(request.getParameter("dep").getBytes("iso8859_1"),"gbk");//该课程所在系
mark = Integer.parseInt(request.getParameter("mark"));
if(name==null || name.equals("")) throw new Exception("错误，课程名不可为空！！");
if(id==null || id.equals("")) throw new Exception("错误，课程号不可为空！！");
flag=course.isLogin();
if(flag==false)
throw new Exception ("课程号有重复，新增失败!!!!!!");
String sql1="select dep from course where id='"+prepare+"' ";
ResultSet rs =sqlB.executeQuery(sql1);
 while(rs.next())
{
prepareDep=rs.getString("dep");}
out.println("预修课系别:  "+prepareDep+"<br>");

out.print("课程所在系:  "+dep+"<br>");
if(dep.equals(prepareDep) || dep.equals("public")||prepareDep.equals("null")) 
out.print("课程所在系与预修课所在系满足要求!!!"+"<br>");
else 
throw new Exception("课程所在系与预修课所在系不满足要求，新增失败！！！");
out.print("学分  ："+mark+"<br>");
String prepare1=prepare;
String sql2="insert into course(id,name,mark,prepare,dep) "+
 		  "VALUES('"+id+"','"+name+"','"+mark+"','"+prepare1+"','"+dep+"') ";
sqlB.executeInsert(sql2);           
//}catch(Exception e){
//out.print(e.toString());
//}
%>
</p>
<p>&nbsp; </p>
</div>
<meta http-equiv="refresh" content="2;url=addcourse.jsp">  
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -