weiyong
/
201906G105


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
							<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ page import="java.sql.*,javax.sql.*,javax.naming.*,java.util.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询成绩</title>
<style type="text/css">
html {
 background: linear-gradient(to top right, white 0%, skyblue 98%, blue 100%);
 font-family: "宋体";
 background-repeat: no-repeat;
 width: 100%;
 height: 100%;
}
table{
 margin: 80px 0 0 300px;
}
</style>
</head>
<body>
	<table border="1" cellspacing="0" width="700">
		<tr>
			<td>项目</td>
			<td>成绩</td>
		</tr>
		<%
			Connection connection;
			String num = (String) session.getAttribute("user");
			try {
				InitialContext ctx = new InitialContext();
				DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/ydh");
				connection = ds.getConnection();
				Statement stmt = connection.createStatement();;
				ResultSet rst = stmt.executeQuery("select project,grade from grade where num='"+num+"'");
					while (rst.next()) {
		%>
		<tr>
			<td><%=rst.getString("project")%></td>
			<td><%=rst.getString("grade")%></td>
		</tr>
		<%
				} 
			} catch (Exception e) {
				out.print(e.getMessage());
			}
		%>
	</table>

</body>
</html>