weiyong
/
201906G105


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
							<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title></title>
  </head>
  <body>
   <%
	 //修改学生资料
	request.setCharacterEncoding("UTF-8");
  	String id = request.getParameter("id");
	String sourceId = request.getParameter("sourceId");
	sourceId = sourceId.substring(1, sourceId.length()-1);//由于传值过来会被''括住，需要去除
	String name = request.getParameter("name");
	String _class = request.getParameter("_class");
	String sex = request.getParameter("sex");
	String project = request.getParameter("project");
	String grade  = request.getParameter("grade");
	String ranking = request.getParameter("ranking");
	String sqlQuery = "UPDATE `ydh`.`grade` SET `num` = ?, `name` = ?, `class` = ?, `sex` = ?, `project` = ?, `grade` = ?, `ranking` = ? WHERE (`num` = ?)";
	String sqlid = "SELECT * FROM ydh.grade where num='"+id+"'";
	Connection con = null;
	Statement stat = null;
	ResultSet rs = null;
	PreparedStatement ps = null;
	boolean flag = true;
	  try{
		Class.forName("com.mysql.cj.jdbc.Driver");
		con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ydh?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf8","root","123456");
		stat = con.createStatement();
		rs = stat.executeQuery(sqlid);
		
		if(sourceId.equals(id)){
			flag = false;
		}
		/*//out.print(flag);
		out.print("<br/>"+sourceId);
		out.print("<br/>"+id);*/
		if(rs.next() && flag){
			out.print("<script type='text/javascript'>alert('学号重复!请重新输入!');window.location.href = document.referrer;</script>");
	 	}else{
	  		ps = con.prepareStatement(sqlQuery);
			ps.setString(1, id);
			ps.setString(2,name);
			ps.setString(3,_class);
			ps.setString(4,sex);
			ps.setString(5,project);
			ps.setString(6,grade);
			ps.setString(7,ranking);
			ps.setString(8,sourceId);
			ps.executeUpdate();
			out.print("<script type='text/javascript'>alert('更改学生信息成功!');window.location.href='contain.jsp?pages=1';</script>");
			ps.close();
		}
		rs.close();
		stat.close();
		con.close();
	}catch (Exception e){
			e.printStackTrace();
		}
  %> 
  </body>
</html>