View Feed
group-icon
Java Developers
Community of Java Developers: Get Java Programming Help from fellow Java Developers across the world.
562 Members
Join this group to post and comment.
neech
neech • Sep 11, 2008

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
Kaustubh Katdare
Kaustubh Katdare • Sep 11, 2008
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 • Sep 24, 2008
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 • Dec 1, 2008
hi,i am new in project.i am doing project in airline reservation in vb...so plz help me in source code...
Kaustubh Katdare
Kaustubh Katdare • Dec 1, 2008
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?
Please post here the confused part of the code..
I hope CE members can clear it
zama
zama • Aug 24, 2010
Im also doing the same project Airline reservation Management system based in java using JDBC/SQL......
allwynjk
allwynjk • Jun 27, 2011
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 • Jul 19, 2011
😁 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 -