courseeditsave.jsp

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

<%@page contentType="text/html; charset=gb2312" 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 = "update course set courseName = '" + request.getParameter("courseName") + "',courseCredit="+request.getParameter("courseCredit") +" where courseid="  + request.getParameter("courseID");
    System.out.println(sql);
    if (stmt.executeUpdate(sql) > 0) {
      response.sendRedirect("courseList.jsp"); //response对象
    }
  } catch (Exception e) {
   %>
   <script language = javascript>
   alert("非法操作！");
   window.history.go(-1);
   </script>
   <%
  }
%>