INFORMATICS PRACTICES
PROJECT ON TOPIC
RAILWAY RESERVATION
SYSTEM
SUBMITTED TO
Mr. Sahil Monga
TABLE OF CONTENT
1. ACKNOWLEDGEMENT
2. CERTIFICATE
3. WORKING DESCRIPTION OF
PROJECT
4. HEADER FILES
5. OUTPUT AND CODING FOR JAVA
6. OUTPUT AND CODING FOR MYSQL
ACKNOWLEDGEMENT
It would be my utmost pleasure to express
my sincere thanks to my computer teacher
Mr. Sahil Monga in providing a helping
hand in this project.
His unflagging patience,creativity and
immense knowledge that he shared with
me have proved highly beneficial to me and
have made my project both possible and
successful.
+2 non_medical
Roll no. :-
CERTIFICATE
This is to certify that of class 12 has
completed this project titled “ RAILWAY
RESERVATION SYSTEM” under my
guidance and this project may be
considered as the part of the practical
examination of AISSCE conducted by
CBSE.
Mr. Sahil Monga
INFORMATIC PRACTICES
D.C MODEL INTERNATIONAL SCHOOL
WORKING DESCRIPTION OF
PROJECT
This project deals with a working model of a
software which can be used for various
purposes like :
1. Booking Railway Ticket
2. Display Train Details
3. Check Reservation Status
HEADER FILES
1. import [Link];
2. import [Link].*;
3. import [Link];
import [Link]
LOGIN PAGE
CODING FOR LOGIN PAGE :-
package project_sr;
import [Link];
import [Link].*
private void
jButton1ActionPerformed([Link] evt) {
String n = new String([Link]());
String m = [Link]();
if([Link]("sr")&&[Link]("1"))
{
DETAILS s = new DETAILS();
[Link](true);
}
else
{[Link](null,"INCORRECT
USERNAME OR PASSWORD");
}
}
private void
jButton2ActionPerformed([Link] evt) {
[Link]("");
[Link]("");// TODO add your handling code here:
}
private void
jButton3ActionPerformed([Link] evt) {
[Link](0); }
HOMEPAGE
CODING FOR HOMEPAGE :-
private void jButton1ActionPerformed([Link]
evt) {
bookticket m = new bookticket();
[Link](true);// TODO add your handling code here:
}
private void
jButton3ActionPerformed([Link] evt) {
traindetails n = new traindetails();
[Link](true);// TODO add your handling code here:
}
private void
jButton5ActionPerformed([Link] evt) {
[Link](0); // TODO add your handling code here:
}
private void
jButton4ActionPerformed([Link] evt) {
reservation o = new reservation();
[Link](true);
BOOK TICKET
CODING FOR BOOK TICKET :-
[Link] TICKET
private void jButton1ActionPerformed([Link]
evt) {
try{
String tr_no = (String)[Link]();
String tr_name = [Link]();
String tr_from = (String)[Link]();
String tr_to = (String)[Link]();
String m1=[Link]();
String m2=[Link]();
String m3=[Link]();
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/S
R","root","root");
Statement stmt=[Link]();
String m="select * from booking;";
ResultSet rs=[Link](m);
int ti=0;
while([Link]())
{
ti=[Link](3);
}
ti=ti+1;
String s="insert into booking
values("+tr_no+",'"+tr_name+"',"+ti+",'"+tr_from+"','"+tr_to+"',"+me
m+",'"+m1+"','"+m2+"','"+m3+"',"+rent+");";
[Link](s);
[Link](null,"Ticket Confirmed");
}catch(Exception e)
{
[Link](null,[Link]());
}
2. RADIO BUTTON CODING :-
private void
jRadioButton1ItemStateChanged([Link] evt) {
if([Link]())
{
[Link](true);
[Link](""+rent);
mem=1;
}
else
{
[Link](false);
}
}
private void
jRadioButton2ItemStateChanged([Link] evt) {
if([Link]())
{
[Link](true);
[Link](true);
[Link](""+(2*rent));
mem=2;
}
else
{
[Link](false);
[Link](false);
}
}
private void
jRadioButton3ItemStateChanged([Link] evt) {
if ([Link]())
{ [Link](true);
[Link](true);
[Link](true);
[Link](""+(3*rent));
mem=3;
}
else
{
[Link](false);
[Link](false);
[Link](false);
}
}
3. COMBO BOX CODING:-
private void
jComboBox2ItemStateChanged([Link] evt)
{
int a=[Link]();
int b=[Link]();
if(a==1 && b==1)
{
rent=200;
}
if(a==1 && b==2)
{
rent=400;
}
if(a==1 && b==3)
{
rent=600;
}
if(a==2 && b==2)
{
rent=250;
}
if(a==2 && b==3)
{
rent=450;
}
if(a==3 && b==3)
{
rent=300;
}
}
private void
jComboBox3ItemStateChanged([Link] evt)
{
{
int c = [Link]();
if (c==1)
{
[Link]("Punjab Mail");
}
if(c==2)
{
[Link]("Janta Express");
}
if(c==3)
{[Link]("Intercity Express");
}
}
}
4. CODING FOR RESET BUTTON :-
private void
jButton2ActionPerformed([Link] evt) {
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link](0);
[Link](0);
[Link](0);
[Link]();
[Link] FOR CLOSE BUTTON :-
private void
jButton3ActionPerformed([Link] evt) {
DETAILS d=new DETAILS();
[Link](true);
dispose();
TRAIN DETAILS
[Link] FOR SHOW RENT
BUTTON :-
private void
jButton1ActionPerformed([Link] evt) {
int a=[Link]();
int b=[Link]();
if(a==1 && b==1)
{
rent=200; }
if(a==1 && b==2)
{
rent=400; }
if(a==1 && b==3)
{
rent=600; }
if(a==2 && b==2)
{
rent=250; }
if(a==2 && b==3)
{
rent=450; }
if(a==3 && b==3)
{
rent=300;}
[Link](""+ rent);
}
private void
jComboBox1ItemStateChanged([Link] evt) {
try{
int c = [Link]();
if (c==1)
{
[Link]("Punjab Mail");
}
if(c==2)
{
[Link]("Janta Express"); }
if(c==3)
{[Link]("Intercity Express");
} }catch (Exception e){
[Link](null,[Link]());
}
}
private void
jComboBox2ItemStateChanged([Link] evt) {
}
[Link] FOR CLOSE BUTTON :-
private void
jButton2ActionPerformed([Link] evt) {
DETAILS d=new DETAILS();
[Link](true);
dispose();
RESERVATION STATUS
[Link] FOR SUBMIT BUTTON :-
private void jButton1ActionPerformed([Link]
evt) {
DefaultTableModel m=(DefaultTableModel)[Link]();
try{
[Link](0);
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/SR"
,"root","root");
Statement stmt=[Link]();
int c = [Link]();
int no=[Link]([Link]());
String s="";
if (c==1)
{
s="select * from booking where ticket_no="+no+";";
}
if(c==2)
{
s="select * from booking where Tr_no="+no+";";
}
ResultSet rs=[Link](s);
while([Link]())
{
int tr_no=[Link](1);
String nm=[Link](2);
int ti_no=[Link](3);
String fr=[Link](4);
String to=[Link](5);
double re=[Link](10);
[Link](new Object[]{tr_no,nm,ti_no,fr,to,re});
}
[Link]();
[Link]();
[Link]();
} catch (Exception e)
{
[Link](null,[Link]());
}
}
[Link] FOR CLOSE BUTTON :-
private void
jButton2ActionPerformed([Link] evt) {
DETAILS d=new DETAILS();
[Link](true); dispose();
MYSQL SCREENSHOT
-- MySQL dump 10.13 Distrib 5.5.27, for Win32 (x86)
--
-- Host: localhost Database: sr
-- ------------------------------------------------------
-- Server version 5.5.27
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_C
LIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET
_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNE
CTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET
@OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS,
UNIQUE_CHECKS=0 */;
/*!40014 SET
@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECK
S, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES,
SQL_NOTES=0 */;
--
-- Table structure for table `booking`
--
DROP TABLE IF EXISTS `booking`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `booking` (
`tr_no` int(10) DEFAULT NULL,
`tr_name` varchar(30) DEFAULT NULL,
`ticket_no` int(10) DEFAULT NULL,
`tr_from` varchar(30) DEFAULT NULL,
`tr_to` varchar(30) DEFAULT NULL,
`no_members` varchar(30) DEFAULT NULL,
`1member` varchar(30) DEFAULT NULL,
`2member` varchar(30) DEFAULT NULL,
`3member` varchar(40) DEFAULT NULL,
`tr_rent` double(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `booking`
--
LOCK TABLES `booking` WRITE;
/*!40000 ALTER TABLE `booking` DISABLE KEYS */;
INSERT INTO `booking` VALUES (1001,'Punja
Mail',1001,'Ferozepur','Agra','2','Ajay','Vijay','',400.00),(1001,'Punj
ab
Mail',1002,'Ferozepur','Bhopal','1','ABC','','',600.00),(1001,'Punjab
Mail',1003,'Ferozepur','Bhopal','1','ABC','','',600.00),(1002,'Janta
Express',1004,'Ferozepur','Bhopal','2','e65t','ryry','',600.00),(1002,'
Janta
Express',1005,'Agra','Bhopal','1','i9o','','',300.00),(1002,'Janta
Express',1006,'New Delhi','Bhopal','2','','','',450.00),(1002,'Janta
Express',1007,'New Delhi','Bhopal','3','','','',450.00),(1001,'Punjab
Mail',1008,'Ferozepur','Agra','2','','','',400.00),(1001,'Punjab
Mail',1009,'Ferozepur','New Delhi','1','aj','','',200.00),(1001,'Punjab
Mail',1010,'Ferozepur','New
Delhi','3','AJAY','VIJAY','JAY',200.00),(1001,'Punjab
Mail',1011,'Ferozepur','New Delhi','3','AJAY','VIJAY','JAY',200.00);
/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIE
NT */;
/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RE
SULTS */;
/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTI
ON */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2019-02-07 11:03:35