weiyong
/
201906G105


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136
							<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ 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">
		<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
		<!-- Bootstrap CSS -->
		<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
		<!-- Optional JavaScript -->
		<!-- jQuery first, then Popper.js, then Bootstrap JS -->
		<script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
		<script src="https://cdn.bootcss.com/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
		<script src="https://cdn.bootcss.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>

    <title>Revise</title>
    <style type="text/css">
			.form-control {
				width: 300px;
				height: 30px;
				float: right;
			}
			
			select {
				width: 210px;
				height: 30px;
			}
			
			.submit {
				margin-left: 100px;
				margin-right: 30px;
			}
			
			.contain {
				width: 1000px;
				border: 1px #bbb solid;
				background-color: #eee;
				padding-top: 20px;
				border-radius: 10px;
			}
			
			label {
				display: inline-block;
				width: 100px;
				margin-right: 10px;
			}
			
			form {
				margin-left: 300px;
			}
		</style>

  </head>
  
  <body>
 <%!
		String id;
		String sourceId;
		String name;
		String _class;
		String sex;
		String project;
		String grade;
		String ranking;
	%>
	<%
		request.setCharacterEncoding("UTF-8");
		id = request.getParameter("num");
		String sqlid = "SELECT * FROM ydh.grade where num='"+id+"'";
		sourceId = id;
		try{
			Class.forName("com.mysql.cj.jdbc.Driver");
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ydh?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf8","root","123456");
			Statement sql = con.createStatement();
			ResultSet rs = sql.executeQuery(sqlid);
			if(rs.next()){
				name = rs.getString(2);
				_class = rs.getString(3);
				sex = rs.getString(4);
				project = rs.getString(5);
				grade = rs.getString(6);
				ranking = rs.getString(7);
			}
			rs.close();
			sql.close();
			con.close();
		}catch(Exception e){
			e.printStackTrace();
		}
	%>
		<div class="contain">
			<form action="ReviseHandle.jsp?sourceId='<%=sourceId %>'" method="post">
				<div class="form-group form-inline">
					<label for="id">学号:</label>
				<input type="text" class="form-control" id="id" name="id" value='<%=id %>' required="required">
				</div>
			<div class="form-group form-inline">
				<label for="name">姓名:</label>
					<input type="text" class="form-control" id="name" name="name" maxlength="15" value='<%=name %>' required="required">
				</div>
					<div class="form-group form-inline">
				<label for="name">班级:</label>
					<input type="text" class="form-control" id="_class" name="_class" maxlength="15" value='<%=_class %>' required="required">
				</div>
				<div class="form-group form-inline">
					<label for="sex">性别:</label>
					<select name="sex" id="sex">
						<option value='男'selected='selected'>男</option>
						<option value='女'>女</option>
					</select>
				</div>
				<div class="form-group form-inline">
					<label for="birthday">报名项目:</label>
					<input type="text" class="form-control" id="project" name="project" value='<%=project %>' required="required">
				</div>
				<div class="form-group form-inline">
					<label for="birthday">项目成绩:</label>
					<input type="text" class="form-control" id="grade" name="grade" value='<%=grade %>' required="required">
				</div>
				<div class="form-group form-inline">
					<label for="schoolday">成绩排名:</label>
					<input type="text" class="form-control" id="ranking" name="ranking" value='<%=ranking %>' required="required">
				</div>
				
				</div>
				<div class="form-group form-inline">
					<input type="submit" id="" name="" class="btn btn-primary submit" value='修改' /><input type="reset" class="btn btn-warning" value="重置" />
				</div>
			</form>
		</div>
  </body>
</html>