I am writing a database manager. There are method for adding an car into database and removing car.
public class DBManager {
public static void addCar(Car car) {
...
}
public static void deleteCar(Car car) {
try {
Statement statement = connection.createStatement();
statement.executeUpdate("DELETE FROM cars WHERE id = '" + car.getId() + "'");
} catch (SQLException e) {
System.out.println(e);
}
}
}
Next I have class Car:
public class Car {
private int id;
private String name;
public User(String name) {
this.name = name;
}
public int getId(){
return this.id;}
}
I create and save car in method main. When I want delete car, car is deleted from database but I have object car in a programme and I can work with it. How I can delete carA inside method deleteCar?
public class Main {
public static void main(String[] args) {
Car carA = new Car("Opel");
DBManager.addCar(carA);
DBManager.deleteCar(carA);
}
}