📄 modify.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<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>
<%
if(request.getParameter("Submit")!=null)
{
String name=request.getParameter("Submit");
byte c[]=name.getBytes("ISO-8859-1");
name=new String(c);
String semester="2007年秋";
if(name.equals("删除"))
{
String C_ID=request.getParameter("CID");
%>
<jsp:useBean id="decourse" class="student.DeCourse" scope="request"/>
<jsp:setProperty name="decourse" property="semester" value="<%= semester %>" />
<jsp:setProperty name="decourse" property="CID" value="<%= C_ID %>" />
<%
int i=decourse.getResult();
decourse.Close();
if(i>0)
out.println("<script>alert('删除成功');</script>");
else
out.println("<script>alert('删除失败');</script>");
out.println("<script> history.go(-1);</script>");
}
if(name.equals("修改"))
{
String C_ID=request.getParameter("CID");
session.setAttribute("C_ID",C_ID);
}
%>
<%
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("jdbc:odbc:system");
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="modify.jsp" method="post">
<%
Object CID=session.getAttribute("C_ID");
String C_ID=(String)CID;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:system");
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 + -