📄 modifycourse.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.net.*" %>
<html>
<head>
<title>学生选课系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
background-image: url(images/0866.jpg);
}
-->
</style></head>
<%
String ss=getClass().getResource("/").getPath();
String ss1=ss.substring(1).replace("%20"," ");
URL str=getClass().getResource("/");
String s=str.toString();
String url0=s.substring(6);
String url=url0.replace("%20"," ");
String constr="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};"+
"DBQ="+url+"/data/system";
if(request.getParameter("input1")!=null)
{
byte []b;
Object CID=session.getAttribute("C_ID");
String C_ID=(String)CID;
String C_Name=(String)session.getAttribute("C_Name");
String score=request.getParameter("score");
String period=request.getParameter("period");
String teacher=request.getParameter("teacher");
b=teacher.getBytes("ISO-8859-1");
teacher=new String(b);
String specialty=request.getParameter("specialty");
b=specialty.getBytes("ISO-8859-1");
specialty=new String(b);
String Maxpeople=request.getParameter("Maxpeople");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(constr);
Statement smt = con.createStatement();
String sql="update Course set teacher='"+teacher+"',score="+score+",period="+period+",specialty='"+specialty+"',Max_people="+Maxpeople+" where C_ID="+C_ID+" and C_Name='"+C_Name+"' and semester='2007年秋'";
smt.executeUpdate(sql);
int i=smt.getUpdateCount();
if(i>0)
out.println("<script>alert('修改成功');</script>");
else
out.println("<script>alert('修改失败');</script>");
}
%>
<body>
<table align="center" border="0">
<form action="modifyCourse.jsp" method="post">
<%
Object CID=session.getAttribute("C_ID");
String C_ID=(String)CID;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection(constr);
Statement smt = con.createStatement();
String sql="select * from Course where C_ID="+C_ID+" and semester='2007年秋'";
ResultSet result=smt.executeQuery(sql);
while(result.next())
{
String C_Name=result.getString(2);
session.setAttribute("C_Name",C_Name);
%>
<tr>
<td>课程号:</td>
<td><%= result.getInt(1)%></td>
</tr>
<tr>
<td>课程名:</td>
<td><%= C_Name%></td>
</tr>
<tr>
<td>任课老师:</td>
<td><input type="text" name="teacher" value="<%= result.getString(5)%>"/></td>
</tr>
<tr>
<td>学分:</td>
<td><input type="text" name="score" value="<%= result.getFloat(3)%>"></td>
</tr>
<tr>
<td>学时:</td>
<td><input type="text" name="period" value="<%= result.getInt(4)%>"></td>
</tr>
<tr>
<td>适应专业:</td>
<td><input type="text" name="specialty" value="<%= result.getString(7)%>"></td>
</tr>
<tr>
<td>最大人数:</td>
<td><input type="text" name="Maxpeople" value="<%= result.getInt(8)%>"></td>
</tr>
<tr align="center"><td><input type="submit" name="input1" value="提交"></td></tr>
</form>
<tr align="center"><td>
<form action="ManagerCourse.jsp" method="post" >
<input type="submit" name="cancle" value="退出"></form></td></tr>
</table>
<%
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -