Advertisement
Guest User

Untitled

a guest
Sep 27th, 2016
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.12 KB | None | 0 0
  1.     public List<Car> getAllCars() throws SQLException {
  2.         Connection conn = null;
  3.         Statement stm = null;
  4.         String getAllCarsQuery = "SELECT * FROM CARS";
  5.  
  6.         List<Car> cars = null;
  7.  
  8.         try {
  9.             conn = DBConnection.getConnection();
  10.             stm = conn.createStatement();
  11.  
  12.             ResultSet rs = stm.executeQuery(getAllCarsQuery);
  13.             cars = new ArrayList<>();
  14.  
  15.             while(rs.next()) {
  16.                 Car car = new Car();
  17.                 car.setId(rs.getInt("ID"));
  18.                 car.setBrand(rs.getString("BRAND"));
  19.                 car.setModel(rs.getString("MODEL"));
  20.                 car.setYear(rs.getInt("YEAR"));
  21.                 car.setCarNumber(rs.getString("CAR_NUMBER"));
  22.                 car.setColor(rs.getString("COLOR"));
  23.  
  24.                 cars.add(car);
  25.             }
  26.  
  27.         } catch (SQLException e) {
  28.             e.printStackTrace();
  29.         } finally {
  30.             if(stm != null) {
  31.                 stm.close();
  32.             }
  33.             if(conn != null) {
  34.                 conn.close();
  35.             }
  36.         }
  37.         return cars;
  38.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement