Advertisement
Guest User

Untitled

a guest
May 21st, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. public ArrayList<Hotel> getHotelsByStars(int sterren) {
  2. ArrayList<Hotel> hotels = new ArrayList<>();
  3. try (
  4. Connection connection = DriverManager.getConnection(url, login, password);
  5. PreparedStatement statement = connection.prepareStatement("SELECT * FROM hotel where aantalsterren = ?");) {
  6. statement.setInt(1, sterren);
  7. ResultSet resultSet = statement.executeQuery();
  8.  
  9. hotels.add(constructHotel(resultSet));
  10. } catch (Exception e) {
  11. e.printStackTrace();
  12. }
  13. return hotels;
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement