Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void loadFlightFromDB()
- {
- try
- {
- Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
- Connection conn = DriverManager.getConnection("jdbc:ucanaccess://H:\\YEAR 2\\OO PROGRAMMING (JAMES)\\ScotiaAirlines\\Airline.accdb");
- Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery("SELECT * FROM Flight");
- while(rs.next())
- {
- String flightNumber = rs.getString(1);
- String departure = rs.getString(2);
- String arrival = rs.getString(3);
- int rows = rs.getInt(4);
- int columns = rs.getString(5).charAt(0);
- Flight loadedFlight = new Flight(columns, rows);
- AddFlight(loadedFlight);
- }
- }
- catch(Exception ex)
- {
- String massage = ex.getMessage();
- }
- }
- public void saveFlightsToDB()
- {
- try
- {
- Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
- Connection conn = DriverManager.getConnection("jdbc:ucanaccess://H:\\YEAR 2\\OO PROGRAMMING (JAMES)\\ScotiaAirlines\\Airline.accdb");
- Statement stmt = conn.createStatement();
- for(Map.Entry<String,Flight> f : people.entrySet())
- {
- Flight actualFlight = f.getValue();
- stmt.executeUpdate("INSERT INTO People VALUES ('" + actualFlight.getFlightNumber() + "','" + actualFlight.getDeparture() + "','"
- + actualFlight.getArrival() + "','" + actualFlight.getRows() + "','" + actualFlight.getColumns() + "')");
- }
- }
- catch(Exception ex)
- {
- String message = ex.getMessage();
- }
- }
- public void clearFlightsFromDB()
- {
- try
- {
- Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
- Connection conn = DriverManager.getConnection("jdbc:ucanaccess://H:\\YEAR 2\\OO PROGRAMMING (JAMES)\\ScotiaAirlines\\Airline.accdb");
- Statement stmt = conn.createStatement();
- stmt.executeUpdate("DELETE * FROM Flights");
- }
- catch(Exception ex)
- {
- String message = ex.getMessage();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement