jsp存储时间到mysql

CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_time DATETIME NOT NULL
);

<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date" %>
<%@ page import="java.text.SimpleDateFormat" %>

<%
    // 获取当前时间
    Date now = new Date();
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    String formattedDate = sdf.format(now);

    // 数据库连接信息
    String url = "jdbc:mysql://localhost:3306/your_database";
    String username = "your_username";
    String password = "your_password";

    // 连接数据库并插入数据
    try (Connection conn = DriverManager.getConnection(url, username, password);
         PreparedStatement pstmt = conn.prepareStatement("INSERT INTO example_table (event_time) VALUES (?)")) {
        pstmt.setString(1, formattedDate);
        pstmt.executeUpdate();
    } catch (SQLException e) {
        e.printStackTrace();
    }
%>