jsp在线留言管理源代码

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/message_db";
    String username = "root";
    String password = "password";
    Connection conn = DriverManager.getConnection(url, username, password);
%>

<form action="submit_message.jsp" method="post">
    姓名：<input type="text" name="name"><br>
    邮箱：<input type="text" name="email"><br>
    留言：<textarea name="message"></textarea><br>
    <input type="submit" value="提交">
</form>

<jsp:useBean id="dbConn" scope="page" class="DBConnection" />
<%
    String name = request.getParameter("name");
    String email = request.getParameter("email");
    String message = request.getParameter("message");
    
    PreparedStatement pstmt = dbConn.conn.prepareStatement("INSERT INTO messages (name, email, message) VALUES (?, ?, ?)");
    pstmt.setString(1, name);
    pstmt.setString(2, email);
    pstmt.setString(3, message);
    pstmt.executeUpdate();
    
    response.sendRedirect("index.jsp");
%>

<table border="1">
    <tr>
        <th>姓名</th>
        <th>邮箱</th>
        <th>留言</th>
    </tr>
    <%
        Statement stmt = dbConn.conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM messages");
        while(rs.next()) {
            out.println("<tr>");
            out.println("<td>" + rs.getString("name") + "</td>");
            out.println("<td>" + rs.getString("email") + "</td>");
            out.println("<td>" + rs.getString("message") + "</td>");
            out.println("</tr>");
        }
        rs.close();
        stmt.close();
    %>
</table>