mysql - 如何更新sql中的日期

Question

所以基本上我正在尝试通过 jdbc 驱动程序更新表中的记录，jdbc 驱动程序不允许我更新任何记录，它不断抛出此错误消息

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'set brand ='Nissan', set type='Compactor Vehicle',set model='zx1000x',set dateAq' at line 1

我已经检查了所有值，它们的格式似乎与 sql 的格式相同。我怀疑是日期记录没有成功。

下面是我正在使用的sql语法

update vehicles set capacity = "+capacity+",set brand ='"+brand+"', set type='"+type+"',set model='"+model+"',set dateAqcuire ="+date+" where registrationPlate ='"+registrationNumber+"'

public void updateVehicle(){
database db = new database();
String registrationNumber = RegistrationPlate.getText();
int vehicleCapacity = Integer.parseInt(capacity.getText());
String brandz= brand.getText();
String vehicletype = vehicleType.getValue();
String vehicleModel = Model.getText();
LocalDate localDate= dateAccquire.getValue();
java.sql.Date date = java.sql.Date.valueOf(localDate);
db.UpdateVehicle(registrationNumber, vehicleCapacity, brandz, vehicletype, vehicleModel, date);
vehicleAlerts("updated");
}

下面是方法签名

public void UpdateVehicle(String registrationNumber,int capacity,String brand,String type,String model,java.sql.Date date){//code to update records}

Answer 1

您只需设置一个关键字:

update vehicles set capacity = "+capacity+",brand ='"+brand+"', type='"+type+" ..

了解准备语句以防止 SQL 注入(inject)