jsp调查问卷

<%@ page import="java.sql.*" %>
<%
    String url = "jdbc:mysql://localhost:3306/survey_db";
    String username = "root";
    String password = "password";
    Connection conn = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
        out.println("数据库连接成功！");
    } catch (Exception e) {
        out.println("数据库连接失败：" + e.getMessage());
    } finally {
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
%>

<form action="submit_survey.jsp" method="post">
    <label for="question1">问题1:</label>
    <input type="text" id="question1" name="question1"><br>
    <label for="question2">问题2:</label>
    <input type="text" id="question2" name="question2"><br>
    <input type="submit" value="提交">
</form>

<%@ page import="java.sql.*" %>
<%
    String question1 = request.getParameter("question1");
    String question2 = request.getParameter("question2");
    // 将数据存储到数据库
    String url = "jdbc:mysql://localhost:3306/survey_db";
    String username = "root";
    String password = "password";
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(url, username, password);
        String sql = "INSERT INTO survey_responses (question1, question2) VALUES (?, ?)";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, question1);
        pstmt.setString(2, question2);
        pstmt.executeUpdate();
        out.println("数据提交成功！");
    } catch (Exception e) {
        out.println("数据提交失败：" + e.getMessage());
    } finally {
        if (pstmt != null) {
            try {
                pstmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
%>