Scribd
Upload
3 views37 pages

Program Code

The document outlines the design and implementation of a bus reservation system called 'Saarthi Bus Reservation'. It includes various frames for user interaction such as login, account creation, ticket booking, and cancellation, all connected to a MySQL database for data management. The project was developed by Akshay N Nambiar as part of an Informatics Practices course and includes acknowledgments and a certificate of completion.

Uploaded by

akshay
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views37 pages

Program Code

The document outlines the design and implementation of a bus reservation system called 'Saarthi Bus Reservation'. It includes various frames for user interaction such as login, account creation, ticket booking, and cancellation, all connected to a MySQL database for data management. The project was developed by Akshay N Nambiar as part of an Informatics Practices course and includes acknowledgments and a certificate of completion.

Uploaded by

akshay
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

FRAME 1-WELCOME

PROGRAM CODE

FRAME 1- WELCOME

private void jButton1ActionPerformed([Link] evt)


{

dispose();

new page_2().setVisible(true);

private void jButton2ActionPerformed([Link] evt)


{

dispose();

new page_3().setVisible(true);

}
FRAME 2 - LOGIN
PROGRAM CODE

FRAME 2 - LOGIN
import [Link].*;

import [Link].*;
private void jButton1ActionPerformed([Link] evt)
{

String p="",r="";

String a=[Link]();

String sql="select password from login where


username='"+(a)+"'";

try {

[Link]("[Link]");

Connection
con=[Link]("jdbc:mysql

://localhost:3306/travels","root","");

Statement s=[Link]();

ResultSet rs=[Link](sql);

while([Link]())

String s_password=[Link](1);

[Link](""+s_password.toString());

p=s_password;

[Link]();

[Link]();

[Link]();
} catch(Exception e) {

r=[Link]();

String q=[Link]();

if([Link](r))

dispose();

new page_4().setVisible(true);

} else

[Link](this,"Please give correct


username and password!");

private void jButton2ActionPerformed([Link]


evt){

dispose();

new Page_1().setVisible(true);

FRAME 3 - CREATE A NEW ACCOUNT


PROGRAM CODE
FRAME 3 - CREATE A NEW ACCOUNT

import [Link].*;

import [Link].*;

private void jButton2ActionPerformed([Link] evt) {

dispose();

new Page_1().setVisible(true);
private void jButton1ActionPerformed([Link] evt) {

try {

[Link]("[Link]");

Connection con=[Link]("jdbc:mysql://

localhost:3306/travels","root","");

Statement s=[Link]();

String n=[Link]();

int u=[Link]([Link]());

String m=[Link]();

String r=[Link]();

String o=[Link]();

String p=[Link]();

String sql="insert into login values ('"+(n)+"',"+(u)+",'"+(m)+ "' ,

'"+(r)+"','"+(o)+"','"+(p)+"')";

[Link](sql);
[Link](this, "Welcome to [Link]");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]();

[Link]();

catch(Exception e)

[Link](this,[Link]());

dispose();

new page_4().setVisible(true);

FRAME 4 - MAIN PAGE


PROGRAM CODE

FRAME 4 - MAIN PAGE


private void jButton1ActionPerformed([Link] evt)
{

dispose();

new e().setVisible(true);

private void jButton2ActionPerformed([Link] evt)


{

dispose();

new h().setVisible(true);

private void jButton3ActionPerformed([Link] evt)


{

dispose();

new f().setVisible(true);

PROGRAM CODE
FRAME 5- TICKET BOOKING
import [Link].*;

import [Link].*;

import [Link].*;

private void jButton3ActionPerformed([Link] evt) {

DefaultListModel lb=(DefaultListModel)[Link]();

String sql="select distinct boarding from journey";

try {

[Link]("[Link]");

Connection con=[Link]("jdbc:mysql:

//localhost:3306/travels","root","");

Statement s=[Link]();

ResultSet rs=[Link](sql);

while([Link]()) {

String s_boarding=[Link](1);

[Link](s_boarding);

[Link](lb);

[Link]();

[Link]();

[Link]();

}catch(Exception e) {

[Link](this,[Link]());
}

private void jButton4ActionPerformed([Link] evt) {

[Link](false);

[Link](false);

[Link](false);

}
private void jButton5ActionPerformed([Link] evt) {

dispose();

new page_4().setVisible(true);

private void lb1ValueChanged([Link] evt) {

String h=[Link]().toString();

DefaultListModel lb=(DefaultListModel)[Link]();

String sql="select distinct boarding from journey where boarding

!='"+(h)+"'";

try {

[Link]("[Link]");

Connection con=[Link]("jdbc:mysql:

//localhost:3306/travels","root","");

Statement s=[Link]();

while([Link]()) {

String s_boarding=[Link](1);
[Link](s_boarding);

[Link](lb);

[Link]();

[Link]();

[Link]();

} catch(Exception e) {

[Link](this,"go to Destination");

private void jButton1ActionPerformed([Link] evt) {

[Link](true);

[Link](true);

[Link](true);

DefaultTableModel tb=(DefaultTableModel)[Link]();

[Link](0);

String sql="select * from journey";

try {

[Link]("[Link]");

Connection con=[Link]("jdbc:mysql:

//localhost:3306/travels","root","");
Statement s=[Link]();

ResultSet rs=[Link](sql);

while([Link]()) {

int s_busno=[Link](1);
String s_boarding=[Link](2);

String s_destination=[Link](3);

String s_departure=[Link](4);

String s_arrival=[Link](5);

[Link](new Object[]{s_busno, s_boarding, s_destination,

s_departure,s_arrival});

[Link](tb);

[Link]();

[Link]();

[Link]();

} catch(Exception e) {

[Link](this,[Link]());

private void jButton2ActionPerformed([Link] evt) {

dispose();

new page_6().setVisible(true);

}
FRAME 5 - TICKET BOOKING
FRAME 6 - SEATS AVAILABLE

PROGRAM CODE
FRAME 6 - SEATS AVAILABLE

import [Link].*;

import [Link].*;

import [Link].*;

private void jButton1ActionPerformed([Link] evt) {

String a=page_5.[Link]().toString();

[Link](""+a);

DefaultTableModel tb=(DefaultTableModel)[Link]();

[Link](0);

String h=[Link]();

String sql="select * from "+h;

try {

[Link]("[Link]");

Connection con=[Link]("jdbc:mysql:

//localhost:3306/travels","root","");

Statement s=[Link]();

ResultSet rs=[Link](sql);

while([Link]()) {

int s_seat=[Link](1);

[Link](new Object[]{s_seat});
[Link](tb);

[Link]();

[Link]();

[Link]();

catch(Exception e) {

[Link](this,[Link]());

[Link](a);

private void jButton2ActionPerformed([Link] evt) {

dispose();

new page_7().setVisible(true);

private void jButton5ActionPerformed([Link] evt) {

dispose();

new page_5().setVisible(true);

}
FRAME 7 - PASSENGER INFORMATION
PROGRAM CODE

FRAME 7 - PASSENGER INFORMATION

import [Link].*;

import [Link].*;

private void jButton1ActionPerformed([Link] evt) {

try {

[Link]("[Link]");

Connection Con=[Link]("jdbc:mysql:

//localhost:3306/travels","root","");

Statement s=[Link]();

String n=[Link]();

int u=[Link]([Link]());

String m=[Link]();

String r=[Link]();

String o=[Link]();

String p=[Link]();

String q=[Link]();

String sql="insert into details values('"+(n)+"',"+(u)+",

'"+(m)+"','"+(r)+"','"+(o)+"','"+(p)+"','"+(q)+"')";

[Link](sql);
[Link](this, "Ticket Booked \n name"+n+"\n
no of seats:"+u);

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]("");

[Link]();

[Link]();

} catch(Exception e) {

[Link](this,[Link]());

String q=[Link]();

int i=1,t=0,k=0;

for(i=0;i<[Link]()-1;i++)

switch([Link](i))

case ',':

t=i;

int j=[Link]([Link](k,t));

k=i ;
String v=[Link]();

try {

[Link]("[Link]");

Connection con1=DriverManager .getConnection("jdbc:mysql://


localhost:3306/travels","root","");

Statement w=[Link]();

String sql1="delete from '"+(v)+"' where seat_available="+j;

[Link](sql1);

[Link]();

[Link]();

} catch(Exception e) {

break;

default :

break;

dispose();

new page_4().setVisible(false);

private void jButton5ActionPerformed([Link] evt) {

dispose();

new page_6().setVisible(true);

}
FRAME 8 - TICKET CANCELLATION
PROGRAM CODE

FRAME 8-TICKET CANCELLATION

import [Link];

import [Link];

import [Link];

import [Link];

private void jButton1ActionPerformed([Link] evt) {

dispose();

new page_4().setVisible(true);

private void r4ActionPerformed([Link] evt) {

[Link]("50%");

private void r3ActionPerformed([Link] evt) {

[Link]("20%");

private void b1ActionPerformed([Link] evt) {


String seat_no=[Link]();

String j=[Link]();

String a=[Link]();

int totalamt=[Link]([Link]());

if(seat_no.isEmpty()) {

[Link](this,"Please fill in the details");

else if([Link]()) {

[Link](this,"Please fill in the details");

else if(totalamt==0) {

[Link](this,"Please fill in the details");

else {

try {

[Link]("[Link]");

Connection con=(Connection)DriverManager .getConnection

("jdbc :mysql://localhost:3306/travels","root","");

Statement s=(Statement)[Link]();

int r=[Link]([Link]());

String sql="delete from details where name_of_Passenger='"+(a)+"'";

[Link](sql);

[Link](this,"booking cancelled");
[Link]("");

[Link]("");

[Link]();

[Link]();

catch(Exception e) {

[Link](this,[Link]());

dispose();

new page_4().setVisible(true);

private void b2ActionPerformed([Link] evt) {

int totalamt,cutoff,amtremitted = 0,amtdeducted;

totalamt=[Link]([Link]());

if([Link]()) {

cutoff=5;

amtdeducted=(cutoff*totalamt)/100;

amtremitted=totalamt-amtdeducted;

else if([Link]())

cutoff=10;
amtdeducted=(cutoff*totalamt)/100;

amtremitted=totalamt-amtdeducted;

else if([Link]())

cutoff=20;

amtdeducted=(cutoff*totalamt)/100;

amtremitted=totalamt-amtdeducted;

else

cutoff=50;

amtdeducted=(cutoff*totalamt)/100;

amtremitted=totalamt-amtdeducted;

[Link](""+amtremitted);

private void r1ActionPerformed([Link] evt) {

[Link]("5%");

private void r2ActionPerformed([Link] evt) {

[Link]("10%");

}
BIBLIOGRAPHY
●​Informatics Practices Textbook

Informatics Practices -

SAARTHI BUS RESERVATION

●​Java Programming System


(Tata Mc Graw Hill)
A project in Informatics practices submitted to CBSE in partial
fulfilment of the requirement of AISSCE
2014-2015

SUBMITTED BY :
AKSHAY N NAMBIAR
XII - ‘A’
CERTIFICATE
THIS IS TO CERTIFY THAT AKSHAY N NAMBIAR OF
CLASS XII A OF ARMY PUBLIC SCHOOL, BANGALORE
HAS SUCCESSFULLY DONE HIS PROJECT ON Bus
Reservation System UNDER THE GUIDANCE OF MR .
AJITH IN THE YEAR 2014-2015

..................................... ...................................................

(Signature of HOD) (Signature of examiner)

Date:
ACKNOWLEDGEMENT
I express my heartiest gratitude and sincerest thanks
to Mr. Ajith, my respected informatics practices
teacher. This project could not have been visualised
without the valuable guidance and support of my
teacher. I am indebted to all my teachers for having
taught me how to use the theoretical knowledge gained
into useful practical applications. I would also like to
thank my parents who have extended a helping hand
for fulfilling my requirements by the way of helping
me to gather all the technical information required in
making this project a success.
CONTENTS

​
SYNOPSIS

SAARTHI BUS RESERVATION

Is a software prototype of software used by agencies and

organisations for booking bus ticket. It is able to view

buses available as well as book tickets by providing full

information about date cost etc. With proper use of


interface and efficient coding with less data transfer via

database, it helps manage bus reservation better.

DATABASE TABLES USED


Database name –Travels
Tables used:
●​ Login

Create table login(Name varchar(15), age int(2), date_of_birth


varchar(10), ph_no varchar(10), username varchar(20) Primary
Key,Password varchar(10));

●​ Journey

Create table journey(Busno varchar(15), Boarding varchar(15),


Departure varchar(15), arrival varchar(15));

●​ Details

Create table details(Name_of_Passenger varchar(15), no_of_seats


int(15), Date_of_journey varchar(15), Seat_nos varchar(15),
Boarding varchar(15), Destination varchar(15));​

INFORMATION SYSTEM
TREE

Front End
NetBeans IDE 6.7

Middleware
MySQL JDBC Driver

Back End
MySQL 5.5

You might also like