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 |
