coursesave.jsp

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

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*" import = "java.lang.*" %>
<%!Statement stmt=null;
ResultSet rs=null;
%>
<%
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.setCharacterEncoding("gb2312"); 
  stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
  sql = "select * from course where courseName='" + request.getParameter("courseName") + "'"; //检查用户名是否存在
  rs  = stmt.executeQuery(sql); //把查询结果放入ResultSet对象
  if(rs.next()){//判断该课程是否存在
	  rs.close();
%>
<script language="javascript">
alert("该课程已经存在！");
window.history.go(-1);
</script>
<%

  }
  else//不存在该课程的时候
  {
	  float credit = Float.parseFloat(request.getParameter("courseCredit"));
	  if(credit<=0.0f){
		  %>
			<script language="javascript">
			alert("课程的学分不能小于等于0.0");
			window.history.go(-1);
			</script>
			<% 
	  }
    sql = "insert course (courseName,courseCredit) values('" + request.getParameter("courseName") + "','";
    sql = sql  + request.getParameter("courseCredit")+"')";
    if(stmt.executeUpdate(sql)>0){
      response.sendRedirect("courseList.jsp");
    }
  }
}catch(Exception e){
	%>
	<script language="javascript">
	alert("非法操作！");
	window.history.go(-1);
	</script>
	<%
	
}


%>