weiyong
/
201906G105


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127
							<%@page import="java.sql.DriverManager"%>

<%@page import="java.sql.PreparedStatement"%>

<%@page import="java.sql.ResultSet"%>

<%@page import="java.sql.Connection"%>

<%@page import="java.sql.Statement"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

  
    <title>My JSP 'AddHandle.jsp' starting page</title>


    </head>

  
  <body>

    <% 

    request.setCharacterEncoding("UTF-8");

	String id = request.getParameter("id");

	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 = "INSERT INTO `ydh`.`grade` (`num`, `name`, `class`, `sex`, `project`, `grade`, `ranking`) VALUES (?, ?, ?, ?, ?,?,?)";

	String sqlid = "SELECT * FROM ydh.grade where num='"+id+"'";

	Connection con = null;

	Statement stat = null;

	ResultSet rs = null;

	PreparedStatement ps = null;

	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(rs.next()){

			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.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>