majorcourseaddsave.jsp

学生管理系统 对学生成绩的操作

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%
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对象
    request.setCharacterEncoding("gb2312"); //乱码转换成中文
    Statement stmt = conn.createStatement(); //建立Statement的实例，相当于创建一个查询分析器的运行环境
    sql = "select * from majorcourse where MajorID=" + request.getParameter("MajorID") + " and CourseID=" + request.getParameter("CourseID") ;
    ResultSet rs = stmt.executeQuery(sql);
    if (!rs.next()) {
      rs.close();
      sql = "insert majorcourse (majorId,courseId) values('" + request.getParameter("MajorID") + "','";
      sql = sql + request.getParameter("CourseID") + "')";
      if (stmt.executeUpdate(sql) > 0) {
        response.sendRedirect("MajorCourseList.jsp"); //response对象
      }
    }
    else {
    %>
    <script language="javascript">
    alert("该专业的该门课程已经存在，请选择其它课程");
    window.history.go(-1);
    </script>
  <%
    }
  }
  catch (Exception e) {
	  %>
	    <script language="javascript">
	    alert("非法操作！");
	    window.history.go(-1);
	    </script>
	  <%
	  
  }
%>