public void insertTour(Tour tour) throws Exception {
try {
Statement statement = connection.createStatement();
statement.executeUpdate(
String.format(
"INSERT INTO tour (location_id, start_date, count_days, price) "
+ "VALUES(%s, '%s', %s, %s)",
tour.getLocationId(),
tour.getStartDate().toString(),
tour.getCountDays(),
tour.getPrice()));
} finally {
closeConnention();
}
}
public void updateTour(Tour tour, String id) throws SQLException {
try {
Statement statement = connection.createStatement();
statement.executeUpdate(
String.format(
"UPDATE tour SET location_id=%s AND start_date='%s' "
+ "AND count_days=%s AND price=%s WHERE id=%s",
tour.getLocationId(),
tour.getStartDate().toString(),
tour.getCountDays(),
tour.getPrice(),
id));
} finally {
closeConnention();
}
}
