📄 majorcourseedit.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">
</head>
<body>
<%
if (session.getAttribute("userid") == null || session.getAttribute("userid").equals("")) {
response.sendRedirect("index.jsp");
}
%>
<jsp:include flush="true" page="head.jsp"/>
<br/>
<br/>
<br/>
<br/>
<form name="form1" method="post" action="MajorCourseEditSave.jsp">
<input type="hidden" name="recID" value="<%=request.getParameter("recId")%>">
<table width="500" height="104" border="1" align="center" cellpadding="3" cellspacing="1">
<caption>修改专业课程 </caption>
<tr>
<td height="50">
<div align="right">专业名称：</div>
</td>
<td>
<select name="MajorID" id="MajorID" style="width:133px">
<%!
String MajorName = "", MajorID = "", CourseName = "", CourseID = "", tempmajorid = "", tempcourseid = "";
ResultSet rs = null;
Statement stmt = null;
%>
<%
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //驱动程序
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=stuManager";//数据库连接语句
String userID="sa",pwd="sa",sql="";
try {
Class.forName(driver); //调入JDBC-ODBC桥的驱动程序
Connection conn = DriverManager.getConnection(url, userID, pwd); //建立与数据的连接
//request对象见第四章
stmt = conn.createStatement(); //建立Statement的实例，相当于创建一个查询分析器的运行环境
sql = "select * from majorcourse where recid=" + request.getParameter("recId");
rs = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
rs.next();
tempmajorid = rs.getString("MajorID");
tempcourseid = rs.getString("CourseID");
rs.close();
sql = "select * from Major";
rs = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
while (rs.next()) {
MajorID = rs.getString("MajorID");
MajorName = rs.getString("MajorName");
if (MajorID.equals(tempmajorid)) {
%>
<option value="<%=MajorID%>" selected="selected"><%=MajorName%> </option>
<%
} else {
%>
<option value="<%=MajorID%>"><%=MajorName%> </option>
<%
}
}
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
</select>
</td>
</tr>
<tr>
<td width="301" height="50">
<div align="right">课程名称：</div>
</td>
<td width="446">
<select name="CourseID" id="CourseID" style="width:133px">
<%
try {
rs.close();
sql = "select * from Course";
rs = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
while (rs.next()) {
CourseID = rs.getString("CourseID");
CourseName = rs.getString("CourseName");
if(CourseID.equals(tempcourseid)){
%>
<option value="<%=CourseID%>" selected="selected"><%=CourseName%> </option>
<%
}else{
%>
<option value="<%=CourseID%>"><%=CourseName%> </option>
<%
}}
} catch (Exception e) {
System.out.println(e.getMessage());
}
finally {
rs.close();
}
%>
</select>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="submit" name="Submit" value=" 保 存 ">
</div>
</td>
</tr>
</table>
</form>
<jsp:include flush="true" page="bottom.jsp"/>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -