Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static int createReservation(Rezerwacja rez) {
- Connection connect;
- Statement statement;
- ResultSet resultSet;
- boolean b=true;
- int id = 0;
- int id2 = 5;
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/kino?user=root");
- statement=connect.createStatement();
- b=statement.execute("INSERT INTO `rezerwacje`(`tytul`, `godzina`, `miejscaZar`, `nazwisko`) VALUES ('"+rez.getTitle()+"', '"+rez.getTime()+"', '"+rez.getTakenSeats()+"', '"+rez.getSurname()+"' );");
- if (statement != null) {
- statement.close();
- }
- if (connect != null) {
- connect.close();
- }
- } catch(Exception e) {
- e.printStackTrace();
- }
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connect = DriverManager.getConnection("jdbc:mysql://localhost/kino?user=root");
- statement=connect.createStatement();
- resultSet = statement.executeQuery("select 'id' from rezerwacje where tytul = '"+rez.getTitle()+"' AND godzina = '"+rez.getTime()+"' AND miejscaZar = '"+rez.getTakenSeats()+"' AND nazwisko = '"+rez.getSurname()+"'");
- while (resultSet.next()) {
- id2 = resultSet.getInt(1);
- System.out.println(id2);
- }
- if (resultSet != null) {
- resultSet.close();
- }
- if (statement != null) {
- statement.close();
- }
- if (connect != null) {
- connect.close();
- }
- } catch (Exception e) {
- e.printStackTrace();
- }
- return id2;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement