JZTXT

5.31每日总结

发布时间 2023-05-31 22:04:09作者: 漏网鲨鱼
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查询考试成绩</title>
</head>
<body>
    <%
    response.setContentType("text/html;charset=UTF-8");
    String a = request.getParameter("routeMain");
    String URL = "jdbc:mysql://localhost:3306/SCORE";
    String USERNAME = "root";
    String PWD = "123456";

    //jsp就是在html中嵌套的java代码，因此java代码可以写在jsp中（《%%》）
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    Connection connection = null;

    try {

        // a.导入驱动，加载具体驱动类

        Class.forName("com.mysql.cj.jdbc.Driver");//注册// 加载具体的驱动类
        // b.与数据库建立链接
        connection = DriverManager.getConnection(URL, USERNAME, PWD);
        String sql = "select * from information where 编号 like ?";

        pstmt = connection.prepareStatement(sql);

        pstmt.setString(1, "%" + a + "%");

        rs = pstmt.executeQuery();// 反回值，增删改了几条数据增删改用update
        %>
        <table align="center" border="1px">
            <tr>
                <td align="center">学科1成绩</td>
                <td align="center">学科2成绩</td>
                <td align="center">学科3成绩</td>
            </tr>
            <%
        while (rs.next()) {

            String q = rs.getString("学科1");
            String w = rs.getString("学科2");
            String e = rs.getString("学科3");
        %>

        <tr>
            <td align="center">
                <%
                out.print(q);
                %>
            </td>
            <td align="center">
                <%
                out.print(w);
                %>
            </td>
            <td align="center">
                <%
                out.print(e);
                %>
            </td>
        </tr>
        <%
        }
        %>
        <tr align="center">
                <td colspan="3"><a href="student.jsp" style="text-decoration: none;">返回上一级</a></td>
            </tr>
    </table>


    <%
    } catch (ClassNotFoundException e) {
    e.printStackTrace();

    } catch (SQLException e) {
    e.printStackTrace();

    } catch (Exception e) {
    e.printStackTrace();

    }

    finally {
    // 关闭数据库
    try {//先开的后关
        if (rs != null)
            rs.close();
        if (pstmt != null)
            pstmt.close();// 对象.方法

        if (connection != null)
            connection.close();
    } catch (SQLException e) {
        e.printStackTrace();

    }

    }
    %>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>学生功能页</title>
</head>
<body>
<% String a = (String) request.getAttribute("routeMain");%>
<form align="middle">
    <table align="center">
        <tr>
            <td>
                <a href="change.jsp" style="text-decoration:none;">修改个人信息</a><br>
                <a href="show.jsp?routeMain=<%=a%>" style="text-decoration:none;">查询考试成绩</a><br>
                <a href="index.jsp" style="text-decoration:none;">退出系统</a>
            </td>
        </tr>
    </table>
</form>
</body>
</html>