scoresave.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="";
int score;
try{
  Class.forName(driver);//调入JDBC-ODBC桥的驱动程序
  Connection conn = DriverManager.getConnection(url,userID,pwd);//建立与数据的连接
  request.setCharacterEncoding("gb2312"); 
  stmt = conn.createStatement();//建立Statement的实例，相当于创建一个查询分析器的运行环境
  score = Integer.parseInt(request.getParameter("score"));
  if(score<0||score>100){
	  %>
	  <script language="javascript">
		alert("学生的成绩登记有误！");
		window.history.go(-1);
		</script>
		<% 
  }
  sql = "update choice set score ="+request.getParameter("score");
  sql = sql +" where studId = '"+request.getParameter("studId");
  sql = sql +"' and courseId = "+request.getParameter("courseId");
  if(stmt.executeUpdate(sql)>0){
	  %>
	  <script language="javascript">
		alert("操作已成功，请继续!");
		window.history.go(-1);
		</script>
		<% 
	  }
  else{
	  %>
	  <script language="javascript">
		alert("该学生没有选修该门课程！");
		window.history.go(-1);
		</script>
		<%
  }
}catch(Exception e){
	System.out.println(e.getMessage());
	%>
	<script language="javascript">
	alert("非法操作！");
	window.history.go(-1);
	</script>
<%	
}
%>