Jsp/Servlet

Development Platform:
Java

MajorCourseAdd.jsp：Code Content
							<%@ 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="MajorCourseAddSave.jsp">
  <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="";
ResultSet rs = null;
Statement stmt=null;
 %>
<%
String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; //驱动程序，见第十四章
String url="jdbc:odbc:stud";//数据库连接语句，见第十四章
String userID="sa",pwd="",sql="";
try{
  Class.forName(driver);//调入JDBC-ODBC桥的驱动程序
  Connection conn = DriverManager.getConnection(url,userID,pwd);//建立与数据的连接
  //request对象见第四章
  sql = "select * from Major";
  stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
  rs  = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
  while(rs.next()){
    MajorID = rs.getString("MajorID");
    MajorName=rs.getString("MajorName");
%>
<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");
%>
        <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>

						