coursedel.jsp

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

<%@ page contentType="text/html; charset=GBK" 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对象
  Statement stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
  sql = "select * from course where courseId="+ request.getParameter("courseId") ;
  if(stmt.executeQuery(sql).next()){
	sql = "delete course where courseid=" + request.getParameter("courseId");
  	stmt.executeUpdate(sql);
  	response.sendRedirect("courseList.jsp");
  }
}catch(Exception e){
	%>
    <script language="javascript">
	alert("还有专业在开设这门课程，不能删除！");
	window.history.go(-1);
	</script>
    <%
  System.out.println(e.getMessage());
}

%>