package com; public class Flight { int flightID; String flightName; int passengerID; public Flight(int flightID, String flightName, int passengerID) { super(); this.flightID = flightID; this.flightName = flightName; this.passengerID = passengerID; } public int getFlightID() { return flightID; } public void setFlightID(int flightID) { this.flightID = flightID; } public String getFlightName() { return flightName; } public void setFlightName(String flightName) { this.flightName = flightName; } public int getPassengerID() { return passengerID; } public void setPassengerID(int passengerID) { this.passengerID = passengerID; } } package com; import java.util.ArrayList; public class FlightManagement { /** * @param args */ public static void main(String[] args) { FlightPassengerDAO demo = new FlightPassengerDAO(); Flight f1 = new Flight(104, "fhsdfgs", 2); Passenger p1 = new Passenger(3, "jape", "MUMBAI"); //System.out.println(demo.addFlight(f1)); //System.out.println(demo.addPassenger(p1)); System.out.println(demo.getPassengerCountByCity(p1)); ArrayList<Passenger> passengerList = demo.viewPassengerDetails(); for(Passenger obj : passengerList) { System.out.println(obj.getPassengerID()); System.out.println(obj.getPassengerName()); System.out.println(obj.getPassengerCity()); } } } package com; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; public class FlightPassengerDAO { public int addFlight(Flight f) { Connection con=null; ResultSet rs=null; String driver="oracle.jdbc.driver.OracleDriver"; String url="jdbc:oracle:thin:@172.26.132.40:1521:ORCLILP"; String username="ja112core"; String password="ja112core"; int number=0; try { Class.forName(driver); con = DriverManager.getConnection(url,username,password); PreparedStatement pst = con.prepareStatement("Insert into Flight_844789 Values(?,?,?)"); pst.setInt(1, f.getFlightID()); pst.setString(2, f.getFlightName()); pst.setInt(3, f.getPassengerID()); number=pst.executeUpdate(); con.commit(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ if(con != null) try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } if(rs != null) try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return number; } public int addPassenger(Passenger p) { Connection con=null; ResultSet rs=null; String driver="oracle.jdbc.driver.OracleDriver"; String url="jdbc:oracle:thin:@172.26.132.40:1521:ORCLILP"; String username="ja112core"; String password="ja112core"; int number=0; try { Class.forName(driver); con = DriverManager.getConnection(url,username,password); PreparedStatement pst = con.prepareStatement("Insert into Passenger_844789 Values(?,?,?)"); pst.setInt(1, p.getPassengerID()); pst.setString(2, p.getPassengerName()); pst.setString(3, p.getPassengerCity()); number=pst.executeUpdate(); con.commit(); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally{ if(con != null) try { con.close(); } catch (SQLException e) { // | 0 |