无法在JDBC中插入日期

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.SQLException;

// 假设已经建立了数据库连接
Connection connection = ...;

// 假设要插入的日期是2022-01-01
Date date = Date.valueOf("2022-01-01");

String sql = "INSERT INTO table_name (date_column) VALUES (?)";
try (PreparedStatement statement = connection.prepareStatement(sql)) {
    statement.setDate(1, date);
    statement.executeUpdate();
} catch (SQLException e) {
    e.printStackTrace();
}

import java.sql.Connection;
import java.sql.Timestamp;
import java.sql.PreparedStatement;
import java.sql.SQLException;

// 假设已经建立了数据库连接
Connection connection = ...;

// 假设要插入的日期和时间是2022-01-01 12:34:56
Timestamp timestamp = Timestamp.valueOf("2022-01-01 12:34:56");

String sql = "INSERT INTO table_name (timestamp_column) VALUES (?)";
try (PreparedStatement statement = connection.prepareStatement(sql)) {
    statement.setTimestamp(1, timestamp);
    statement.executeUpdate();
} catch (SQLException e) {
    e.printStackTrace();
}