程序执行到PreparedStatement.executeUpdate();出错原因

package dao; import model.Vehicle; import model.VehicleType; import java.sql.*; import java.util.ArrayList; import java.util.List; import java.util.logging.Level; import java.util.logging.Logger; import javax.net.ssl.*; import java.security.Security; public class VehicleDAO { public static final Logger logger = Logger.getLogger(VehicleDAO.class.getName()); // 定义SQL语句 private static final String INSERT_VEHICLE_SQL = "INSERT INTO vehicles (plate_number, color, type, arrival_time, departure_time, is_in_parking_lot) VALUES (?, ?, ?, ?, ?, ?)"; private static final String SELECT_VEHICLE_BY_PLATE = "SELECT * FROM vehicles WHERE plate_number = ?"; private static final String SELECT_ALL_VEHICLES = "SELECT * FROM vehicles"; private static final String SELECT_VEHICLES_IN_PARKING_LOT = "SELECT * FROM vehicles WHERE is_in_parking_lot = true"; private static final String UPDATE_VEHICLE = "UPDATE vehicles SET color = ?, type = ?, arrival_time = ?, departure_time = ?, is_in_parking_lot = ? WHERE plate_number = ?"; private static final String DELETE_VEHICLE = "DELETE FROM vehicles WHERE plate_number = ?"; private static final String COUNT_VEHICLES_IN_PARKING_LOT = "SELECT COUNT(*) FROM vehicles WHERE is_in_parking_lot = true"; // 在获取连接前添加以下代码 static { try { // 允许TLS1.0协议（仅作为临时解决方案） Security.setProperty("jdk.tls.client.protocols", "TLSv1.2"); // 配置信任所有证书 TrustManager[] trustAllCerts = new TrustManager[]{ new X509TrustManager() { @Override public java.security.cert.X509Certificate[] getAcceptedIssuers() { return null; } @Override public void checkClientTrusted(java.security.cert.X509Certificate[] certs, String authType) { } @Override public void checkServerTrusted(java.security.cert.X509Certificate[] certs, String authType) { } } }; SSLContext sslContext = SSLContext.getInstance("TLS"); sslContext.init(null, trustAllCerts, new java.security.SecureRandom()); HttpsURLConnection.setDefaultSSLSocketFactory(sslContext.getSocketFactory()); } catch (Exception e) { e.printStackTrace(); } } // 数据库连接URL private final String jdbcURL = "jdbc:sqlserver:// 10.13.74.3:1433;databaseName=parking_system;" + "user=sa;password=123456;encrypt=false;trustServerCertificate=true;enableTLS1.2=true"; // integratedSecurity=true 启用 Windows 身份验证 public VehicleDAO() { // 检查驱动是否可用 try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); logger.info("SQL Server JDBC驱动加载成功"); } catch (ClassNotFoundException e) { logger.log(Level.SEVERE, "未找到SQL Server JDBC驱动，请确保已添加依赖", e); } } // 获取数据库连接 protected Connection getConnection() { Connection connection = null; try { logger.info("尝试连接到数据库: " + jdbcURL); connection = DriverManager.getConnection(jdbcURL); logger.info("数据库连接成功"); } catch (SQLException e) { logger.log(Level.SEVERE, "数据库连接失败", e); } return connection; } /** * 插入车辆 */ public boolean insertVehicle(Vehicle vehicle) throws SQLException { boolean rowInserted; try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(INSERT_VEHICLE_SQL)) { preparedStatement.setString(1, vehicle.getPlateNumber()); preparedStatement.setString(2, vehicle.getColor()); preparedStatement.setString(3, vehicle.getType().getDescription()); preparedStatement.setTimestamp(4, Timestamp.valueOf(vehicle.getArrivalTime())); if (vehicle.getDepartureTime() != null) { preparedStatement.setTimestamp(5, Timestamp.valueOf(vehicle.getDepartureTime())); } else { preparedStatement.setNull(5, Types.TIMESTAMP); } preparedStatement.setBoolean(6, vehicle.isInParkingLot()); rowInserted = preparedStatement.executeUpdate() > 0; } return rowInserted; } /** * 根据车牌号查询车辆 */ public Vehicle selectVehicle(String plateNumber) throws SQLException { Vehicle vehicle = null; try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(SELECT_VEHICLE_BY_PLATE)) { preparedStatement.setString(1, plateNumber); ResultSet rs = preparedStatement.executeQuery(); while (rs.next()) { String color = rs.getString("color"); String typeDesc = rs.getString("type"); Timestamp arrivalTime = rs.getTimestamp("arrival_time"); Timestamp departureTime = rs.getTimestamp("departure_time"); boolean isInParkingLot = rs.getBoolean("is_in_parking_lot"); VehicleType type = VehicleType.fromDescription(typeDesc); vehicle = new Vehicle(plateNumber, color, type); vehicle.setArrivalTime(arrivalTime.toLocalDateTime()); if (departureTime != null) { vehicle.setDepartureTime(departureTime.toLocalDateTime()); } vehicle.setInParkingLot(isInParkingLot); } } return vehicle; } /** * 查询所有车辆 */ public List<Vehicle> selectAllVehicles() throws SQLException { List<Vehicle> vehicles = new ArrayList<>(); try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(SELECT_ALL_VEHICLES)) { ResultSet rs = preparedStatement.executeQuery(); while (rs.next()) { String plateNumber = rs.getString("plate_number"); String color = rs.getString("color"); String typeDesc = rs.getString("type"); Timestamp arrivalTime = rs.getTimestamp("arrival_time"); Timestamp departureTime = rs.getTimestamp("departure_time"); boolean isInParkingLot = rs.getBoolean("is_in_parking_lot"); VehicleType type = VehicleType.fromDescription(typeDesc); Vehicle vehicle = new Vehicle(plateNumber, color, type); vehicle.setArrivalTime(arrivalTime.toLocalDateTime()); if (departureTime != null) { vehicle.setDepartureTime(departureTime.toLocalDateTime()); } vehicle.setInParkingLot(isInParkingLot); vehicles.add(vehicle); } } return vehicles; } /** * 查询在场车辆 */ public List<Vehicle> selectVehiclesInParkingLot() throws SQLException { List<Vehicle> vehicles = new ArrayList<>(); try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(SELECT_VEHICLES_IN_PARKING_LOT)) { ResultSet rs = preparedStatement.executeQuery(); while (rs.next()) { String plateNumber = rs.getString("plate_number"); String color = rs.getString("color"); String typeDesc = rs.getString("type"); Timestamp arrivalTime = rs.getTimestamp("arrival_time"); Timestamp departureTime = rs.getTimestamp("departure_time"); boolean isInParkingLot = rs.getBoolean("is_in_parking_lot"); VehicleType type = VehicleType.fromDescription(typeDesc); Vehicle vehicle = new Vehicle(plateNumber, color, type); vehicle.setArrivalTime(arrivalTime.toLocalDateTime()); if (departureTime != null) { vehicle.setDepartureTime(departureTime.toLocalDateTime()); } vehicle.setInParkingLot(isInParkingLot); vehicles.add(vehicle); } } return vehicles; } /** * 更新车辆信息 */ public boolean updateVehicle(Vehicle vehicle) throws SQLException { boolean rowUpdated; try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(UPDATE_VEHICLE)) { preparedStatement.setString(1, vehicle.getColor()); preparedStatement.setString(2, vehicle.getType().getDescription()); preparedStatement.setTimestamp(3, Timestamp.valueOf(vehicle.getArrivalTime())); if (vehicle.getDepartureTime() != null) { preparedStatement.setTimestamp(4, Timestamp.valueOf(vehicle.getDepartureTime())); } else { preparedStatement.setNull(4, Types.TIMESTAMP); } preparedStatement.setBoolean(5, vehicle.isInParkingLot()); preparedStatement.setString(6, vehicle.getPlateNumber()); rowUpdated = preparedStatement.executeUpdate() > 0; } return rowUpdated; } /** * 删除车辆 */ public boolean deleteVehicle(String plateNumber) throws SQLException { boolean rowDeleted; try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(DELETE_VEHICLE)) { preparedStatement.setString(1, plateNumber); rowDeleted = preparedStatement.executeUpdate() > 0; } return rowDeleted; } /** * 统计在场车辆数量 */ public int countVehiclesInParkingLot() throws SQLException { int count = 0; try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(COUNT_VEHICLES_IN_PARKING_LOT)) { ResultSet rs = preparedStatement.executeQuery(); if (rs.next()) { count = rs.getInt(1); } } return count; } /** * 根据车型查询车辆 */ public List<Vehicle> selectVehiclesByType(VehicleType type) throws SQLException { List<Vehicle> vehicles = new ArrayList<>(); String sql = "SELECT * FROM vehicles WHERE type = ?"; try (Connection connection = getConnection(); PreparedStatement preparedStatement = connection.prepareStatement(sql)) { preparedStatement.setString(1, type.getDescription()); ResultSet rs = preparedStatement.executeQuery(); while (rs.next()) { String plateNumber = rs.getString("plate_number"); String color = rs.getString("color"); Timestamp arrivalTime = rs.getTimestamp("arrival_time"); Timestamp departureTime = rs.getTimestamp("departure_time"); boolean isInParkingLot = rs.getBoolean("is_in_parking_lot"); Vehicle vehicle = new Vehicle(plateNumber, color, type); vehicle.setArrivalTime(arrivalTime.toLocalDateTime()); if (departureTime != null) { vehicle.setDepartureTime(departureTime.toLocalDateTime()); } vehicle.setInParkingLot(isInParkingLot); vehicles.add(vehicle); } } return vehicles; } } 修改代码使其连接navicat数据库并给出完整代码

conn.setAutoCommit(false); i = pstm.executeUpdate(); conn.commit();

怎么连接idea的java程序和mysql的.sql文件，并且.sql文件放在哪里，放前端里还是后端里