<%@page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<%
  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對象見第四章
    request.setCharacterEncoding("gb2312"); //亂碼轉換成中文
    Statement stmt = conn.createStatement(); //建立Statement的實例，相當于創建一個查詢分析器的運行環境
    sql = "select * from studinfo where studid='" + request.getParameter("studID") + "'";
    ResultSet rs = stmt.executeQuery(sql);
    if(rs.next())
    {
%>
<script language="javascript">
alert("學生編號已存在，請選擇其它編號");
window.history.go(-1);
</script>
<%
    }
    rs.close();
    sql = "insert studinfo values('" + request.getParameter("studID") + "','";
    sql = sql  + request.getParameter("studName") + "','";
    sql = sql  + request.getParameter("classID") + "','";
    sql = sql  + request.getParameter("sex") + "','";
    sql = sql  + request.getParameter("age") + "')";
    if (stmt.executeUpdate(sql) > 0) {
      response.sendRedirect("StudList.jsp"); //response對象見第四章,連接到memCenter.jsp頁面
    }
  } catch (Exception e) {
    System.out.println(e.getMessage());
  }
%>