Java Based - Airlines Reservation Management System

Replies

• 

  Kaustubh Katdare

  Hi Neech,
  
  Couple of things to start with. What are the features of your airline reservation management system? What's your progress so far?
  
  Please do not expect ready-made solutions here.
• 

  neech

  sorry for late response...i was away...Well i have list the tables and its columns...The following are the 6 tables with their respective columns that i have designed...Any help on them will be appreciated.Thanks
  
  1.Flight Details
  -Airline Code
  -Filght code
  -Flight name
  -Type
  -Source
  -Destination
  -Travel Days
  -Total Capacity
  -Category
  
  2.Passenger Details
  -PNR no
  -Flight code
  -Date of birth
  -Address
  -Nationality
  -Name
  -Gender
  -Phone no
  -Email id
  -Meal pref
  -Service
  -Status
  -Passport no
  
  3.Reservation Details
  -PNR no
  -Flight Code
  -Journey Date
  -Journey Time
  -Class code
  -Source
  -Destination
  -Name
  -Phone no
  -Address
  -Email id
  
  4.Cancellation
  -PNR no
  -Name
  -Phone no
  -Address
  -Travel date
  -Travel time
  -Cancellation no
  -Cancellation date
  -Refund money
  
  5.Sector
  -Flight Code
  -Class code
  -Class name
  -Fare
  -Total class seats
  -source
  -destination
  -total seats
  
  6.Payment
  -PNR no
  -Name
  -Phone no
  -Address
  -Flight Code
  -Class code
  -Travel date
  -Travel time
  -Payment type
  -Check no
  -Credit card no
  -Paid amount
  -Payment date
• 

  pinku.1kk

  hi,i am new in project.i am doing project in airline reservation in vb...so plz help me in source code...
• 

  Kaustubh Katdare

  pinku.1kk

  hi,i am new in project.i am doing project in airline reservation in vb...so plz help me in source code...

  How'd we know what problems are you facing with the vB code?
• 

  remshad medappil

  Please post here the confused #-Link-Snipped-#..
  I hope CE members can clear it
• 

  zama

  Im also doing the same project Airline reservation Management system based in java using JDBC/SQL......
• 

  allwynjk

  Hi! I'm not an engineer, but just a student of class 12. I chose the same topic for my holiday homework. In one of the forms, i check the validity of the date selected (via comboboxes) and display the day too. I wrote the coding but I'm having a runtime error. Somebody please help me out! Thanks in advance!!
  
  click event of the button:
  private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
  final int dd = (Integer)ddcb.getSelectedItem();
  final int mm = (Integer)mmcb.getSelectedItem();
  final int yyyy = (Integer)yyyycb.getSelectedItem();
  class CompareDate{
  public void main(String args[]){
  Calendar cal = Calendar.getInstance();
  Calendar currentcal = Calendar.getInstance();
  cal.set(yyyy, mm, dd);
  currentcal.set(currentcal.get(Calendar.YEAR),
  currentcal.get(Calendar.MONTH), currentcal.get(Calendar.DAY_OF_MONTH));
  if(cal.before(currentcal))
  invalidlbl.setText("Entered date is before today's date");
  }
  }
  if((dd >30) && ((mm==3)||(mm==8)||(mm==5)||(mm==10)))
  invalidlbl.setText("The month selected has only 30 days");
  else if((dd > 28) && (mm == 1) && (yyyy != 2012))
  invalidlbl.setText("The month selected has only 28 days");
  else if((dd > 29) && (mm == 1) && (yyyy == 2012))
  invalidlbl.setText("The month selected has only 29 days");
  else
  invalidlbl.setText("The date is valid");
  class calplay{
  public void main(String []args){
  Calendar c = Calendar.getInstance();
  int d = c.get(Calendar.DAY_OF_WEEK);
  switch(d){
  case 1 :dayTF.setText("Sunday");
  break;
  case 2 :dayTF.setText("Monday");
  break;
  case 3 :dayTF.setText("Tueday");
  break;
  case 4 :dayTF.setText("Wedday");
  break;
  case 5 :dayTF.setText("Thursday");
  break;
  case 6 :dayTF.setText("Friday");
  break;
  case 7 :dayTF.setText("Saturday");
  break;
  
  }
  }
  }
  }
• 

  allwynjk

  😁 Yea, I got it myself!
  int dd = Integer.parseInt((String)ddcb.getSelectedItem());
  int mm = mmcb.getSelectedIndex();
  int yyyy = Integer.parseInt((String)yyyycb.getSelectedItem());
  
  Calendar cal = Calendar.getInstance();
  Calendar currentcal = Calendar.getInstance();
  cal.set(yyyy, mm, dd);
  currentcal.set(currentcal.get(Calendar.YEAR),
  currentcal.get(Calendar.MONTH), currentcal.get(Calendar.DAY_OF_MONTH));
  
  
  if(cal.before(currentcal))
  {
  
  invalidlbl.setText("Entered date is before today's date");
  
  }
  if(cal.equals(currentcal))
  {
  
  invalidlbl.setText("Tickets cannot be reserved for the same day ");
  
  }
  
  
  if(cal.after(currentcal))
  
  {
  
  
  if((dd >30) && ((mm==3)||(mm==8)||(mm==5)||(mm==10)))
  invalidlbl.setText("The month selected has only 30 days");
  else if((dd > 28) && (mm == 1) && (yyyy != 2012))
  invalidlbl.setText("The month selected has only 28 days");
  else if((dd > 29) && (mm == 1) && (yyyy == 2012))
  invalidlbl.setText("The month selected has only 29 days");
  else
  invalidlbl.setText("The date is valid");
  
  
  
  
  
  
  
  int dayofweek = cal.get(Calendar.DAY_OF_WEEK);
  switch(dayofweek){
  case 1 :dayTF.setText("Sunday");
  break;
  case 2 :dayTF.setText("Monday");
  break;
  case 3 :dayTF.setText("Tuesday");
  break;
  case 4 :dayTF.setText("Wednesday");
  break;
  case 5 :dayTF.setText("Thursday");
  break;
  case 6 :dayTF.setText("Friday");
  break;
  case 7 :dayTF.setText("Saturday");
  break;
  }
  
  }