weiyong
/
201906G105


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254
							<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="java.sql.*"%>
<!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>

		<script type="text/javascript">

			function del() {

				if(!confirm("确认要删除？")) {

					window.event.returnValue = false;

				}

			}

		</script>

    
    <title></title>

    	<style type="text/css">

			body {

				/*background-color: #eee;*/

			}

			
			form h1 {

				display: inline-block;

				width: 820px;

			}

			
			.check {

				padding: 30px 30px;

			}

			
			form {

				display: inline;

			}

			
			.contain {

				width: 1000px;

				border-radius: 10px;

				border: 1px #bbb solid;

				background-color: #f0f8ff;

				padding-top: 20px;

			}

			
			button {

				margin-left: 10px;

			}

			
			.search {

				display: inline-block;

				margin-left: 500px;

			}

			
			.add {

				float: right;

				margin-right: 50px;

			}
		</style>
  </head>
  <body>
	<div class="contain pull-left">

			<form action="search.jsp" class="form-inline ">

				<h2>查询结果</h2>

				<div class="form-group search">

					<input type="text" name="check" class="form-control" placeholder="请输入查询姓名或学号" />

					<input type="submit" name="submit" class="btn" value="搜索" />


				</div>

			</form>

			<a href="Add.jsp" target="_self"><button class="btn btn-primary add">添加学生资料</button></a>

			<div class="pull-left">

				<table class="table">

					<thead>

						<tr>

							<th>学号</th>

							<th>姓名</th>

							<th>班级</th>

							<th>性别</th>

							<th>项目</th>

							<th>比赛成绩</th>

							<th>排名</th>

							<th>操作</th>

						</tr>

					</thead>

					<tbody>

	<%

	//查询功能

	
	request.setCharacterEncoding("UTF-8");

	String search = request.getParameter("check");

	String sqlQuery;

	if(search.matches("[0-9]+")){

		sqlQuery = "SELECT * FROM ydh.grade where num='"+search+"'";

	}else{

		sqlQuery = "SELECT * FROM ydh.grade where name='"+search+"'";

	}

	
	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(sqlQuery);

		while(rs.next()){

			out.print("<tr>");

			out.print("<td>"+rs.getString(1)+"</td>");

			out.print("<td>"+rs.getString(2)+"</td>");

			out.print("<td>"+rs.getString(3)+"</td>");

			out.print("<td>"+rs.getString(4)+"</td>");

			out.print("<td>"+rs.getString(5)+"</td>");

			out.print("<td>"+rs.getString(6)+"</td>");

			out.print("<td>"+rs.getString(7)+"</td>");

			out.print("<td><a href='Revise.jsp?num="+rs.getString(1)+"'><button class='btn btn-primary'>修改</button></a><a href='Delete.jsp?num="+rs.getString(1)+"' onclick='javascript:return del();'><button class='btn btn-danger'>删除</button></a></td>");

			out.print("</tr>");

		}

		con.close();

	}catch(SQLException e){

		e.printStackTrace();

	}

%>


					</tbody>

				</table>

			</div>


		</div>
  </body>
</html>