Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private int luoVaraus(String varaajanId, String alkupaiva, String loppupaiva) {
- Connection connection = null;
- try {
- connection = DriverManager.getConnection("jdbc:h2:./hotelliketju", "sa", "");
- PreparedStatement stmt;
- stmt = connection.prepareStatement("INSERT INTO Varaus"
- + " (varaaja_id, alkupvm, loppupvm)"
- + " VALUES (?, ?, ?)",
- Statement.RETURN_GENERATED_KEYS);
- stmt.setString(1, varaajanId);
- stmt.setString(2, alkupaiva);
- stmt.setString(3, loppupaiva);
- // varaaja lisätään tietokantaan
- stmt.executeUpdate();
- int id = -1;
- ResultSet generatedKeys = stmt.getGeneratedKeys();
- // haetaan id vain mikäli tulostaulussa on rivi
- if (generatedKeys.next()) {
- id = generatedKeys.getInt(1);
- }
- return id;
- } catch (SQLException ex) {
- Logger.getLogger(Tekstikayttoliittyma.class.getName()).log(Level.SEVERE, null, ex);
- }
- return -1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement