public boolean getPassenger (String searchID)
  //
  // getPassenger loads the passenger from the file that has passengerID equal to searchID
  // Returns true if the passenger was found and loaded
  //
  {
	  try
	  {
    	//create mysql connection
		 String myDriver = "org.gjt.mm.mysql.Driver";
		 String myUrl = "jdbc:mysql://localhost/se4453";
		 Class.forName(myDriver);
		 Connection conn = DriverManager.getConnection(myUrl, "root", "123456");

		 String query = "SELECT passengerID FROM CPassenger WHERE passengerID =" + "searchID ";

		 Statement stmt = conn.createStatement();
		 ResultSet res = stmt.executeQuery(query);

		 if (!res.next() ) {
			 conn.close();
			 return false;
			}
		 else
		 {
			  conn.close();
		 }
	  }
	  catch (Exception e)
	  {
		  System.err.println("Got an exception!");
	      System.err.println(e.getMessage());
	  }
	  return true;