neech
neech
Branch Unspecified
19 Jul 2011

Java Based - Airlines Reservation Management System

hi i am new to this forum....
I am currently taking software engineering and doing java
I have a project to do on Airlines reservation management system using java and implementing JDBC with sql..
Any ideas or samples or any kind of information will be highly appreciated..Thanks in advance
10 years ago
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

neech

Branch Unspecified
10 years ago
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

pinku.1kk

Branch Unspecified
10 years ago
hi,i am new in project.i am doing project in airline reservation in vb...so plz help me in source code...
10 years ago
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

remshad medappil

Aeronautical
9 years ago
Please post here the confused part of the code..
I hope CE members can clear it
zama

zama

Branch Unspecified
8 years ago
Im also doing the same project Airline reservation Management system based in java using JDBC/SQL......
allwynjk

allwynjk

Branch Unspecified
7 years ago
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

allwynjk

Branch Unspecified
7 years ago
😁 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;
}

}

Share this content on your social channels -

Only logged in users can reply.