<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
//修改学生资料
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("
"+sourceId);
out.print("
"+id);*/
if(rs.next() && flag){
out.print("");
}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("");
ps.close();
}
rs.close();
stat.close();
con.close();
}catch (Exception e){
e.printStackTrace();
}
%>