6.13

　　今天完成了web课程的实验四作业，实现一个学生信息的增删改查。部分代码

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <style>
        .center {
            display: flex;
            justify-content: center;
            align-items: center;
            height: 100vh;
        }
        table {
            margin-bottom: 20px;
        }
    </style>
</head>
<body>
<div class="center">
    <%
        Statement stmt = null;
        ResultSet rs = null;
        Connection conn = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/web?characterEncoding=utf-8";
            // 数据库用户名
            String user = "root";
            // 数据库密码
            String pass ="123456";
            conn= DriverManager.getConnection(url,user,pass); //创建连接
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM student");
    %>
    <table>
        <% while(rs.next()) { %>
        <tr>
            <td><%= rs.getInt("id") %></td>
            <td><%= rs.getString("name") %></td>
            <td><%= rs.getString("sex") %></td>
            <td><%= rs.getString("birth") %></td>
            <td>
                <a href="edit.jsp?id=<%= rs.getInt("id") %>">编辑</a>
                <a href="del.jsp?id=<%= rs.getInt("id") %>">删除</a>
            </td>
        </tr>
        <% } %>
    </table>
    <a href="add.jsp">新增</a>
    <%
        } catch(Exception e) {
            response.sendRedirect("error.jsp");
        } finally {
            if(rs != null) rs.close();
            if(stmt != null) stmt.close();
            if(conn != null) conn.close();
        }
    %>
</div>
</body>
</html>

 

1) Add.jsp文件代码

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <style>
        .center {
            display: flex;
            justify-content: center;
            align-items: center;
            height: 100vh;
        }
    </style>
</head>
<body>
<div class="center">
    <form action="addsave.jsp" method="post">
        <label>学号:
            <input type="text" name="id"  required>
        </label>
        <label>姓名:
            <input type="text" name="name" required>
        </label>
        <label>性别:
            <input type="text" name="sex" required>
        </label>
        <label>生日:
            <input type="text" name="birth" required>
        </label>
        <input type="submit" value="提交">
    </form>
</div>
</body>
</html>

 

2) Addsave.jsp文件代码

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%

    Connection conn = null;
    PreparedStatement stmt = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver" );
        String url = "jdbc:mysql://localhost:3306/web";
        // 数据库用户名
        String user = "root";
        // 数据库密码
        String pass ="123456";
        conn= DriverManager.getConnection(url,user,pass); //创建连接
        stmt = conn.prepareStatement("INSERT INTO student (id,name,sex,birth) VALUES (?,?,?,?)");
        stmt.setString(1, request.getParameter("id"));
        stmt.setString(2, request.getParameter("name"));
        stmt.setString(3, request.getParameter("sex"));
        stmt.setString(4, request.getParameter("birth"));
        int rowsAffected = stmt.executeUpdate();
        if(rowsAffected > 0) {
            response.sendRedirect("index.jsp");
        } else {
            out.println("Failed to add record.");
        }
    } catch(Exception e) {
        response.sendRedirect("error.jsp");
        e.printStackTrace();
    } finally {
        if(stmt != null) stmt.close();
        if(conn != null) conn.close();
    }
%>

posted @ 2024-06-13 22:40  ZzHhyao  阅读(6)  评论(0)    收藏  举报