<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.sql.*,javax.sql.*,javax.naming.*,java.util.*"%> <% 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()) { %> <% } } catch (Exception e) { out.print(e.getMessage()); } %>

项目	成绩
<%=rst.getString("project")%>	<%=rst.getString("grade")%>