📄 updatecour_confirm.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");}
String id=(String )session.getAttribute("id");
boolean flag=true;
String prepareDep="null";
int mark=0;
try{
String name=new String(request.getParameter("name").getBytes("iso8859_1"),"gbk");
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("错误，课程名不可为空！！");
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 sql2="update course "+
" set name='"+name+"',prepare='"+prepare+"',"+
"dep='"+dep+"',mark='"+mark+"' "+
" where id='"+id+"' ";
sqlB.executeInsert(sql2);
}catch(Exception e){
out.print(e.toString());
}
%>
</p>
<p> </p>
</div>
<p><a href="getcourse.jsp"><<Back </a></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -