Advertisement
Guest User

Untitled

a guest
Jul 8th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.99 KB | None | 0 0
  1. public class DataBase {
  2.     Connection connection;
  3.     Statement statement;
  4.     PreparedStatement preparedStatement;
  5.     ResultSet result;
  6.  
  7.  
  8.     public DataBase() throws SQLException {
  9.         connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/rentalcar?autoReconnect=true&serverTimezone=" + TimeZone.getDefault().getID(), "...", "...");
  10.         statement = connection.createStatement();
  11.     }
  12.  
  13.    ...
  14.  
  15.     public void insertNewCar(String brand, String productionYear, String engineCapacity, int dayPrice, String avaible) throws SQLException {
  16.         String sql = "insert into car" + "(brand, productionYear, engineCapacity,dayPrice,avaible)" + "values(?,?,?,?,?)";
  17.         preparedStatement.setString(1, brand);
  18.         preparedStatement.setString(2, productionYear);
  19.         preparedStatement.setString(3, engineCapacity);
  20.         preparedStatement.setInt(4, dayPrice);
  21.         preparedStatement.setString(5, avaible);
  22.         preparedStatement.executeUpdate(sql);
  23.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement