Java Programming

Database : IndianRailway.sql

  -- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jun 02, 2022 at 02:54 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.2.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `indianrailway`
--
CREATE DATABASE IF NOT EXISTS `indianrailway` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `indianrailway`;

-- --------------------------------------------------------

--
-- Table structure for table `eticketing`
--

CREATE TABLE `eticketing` (
  `ID` int(11) NOT NULL,
  `TicketNumber` int(11) NOT NULL,
  `UserID` int(11) NOT NULL,
  `TrainID` int(11) NOT NULL,
  `JourneyDate` varchar(100) NOT NULL,
  `Passengers` int(5) NOT NULL,
  `TrainClass` varchar(50) NOT NULL,
  `TicketType` varchar(50) NOT NULL,
  `TicketPrize` int(5) NOT NULL,
  `BookingDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `eticketing`
--

INSERT INTO `eticketing` (`ID`, `TicketNumber`, `UserID`, `TrainID`, `JourneyDate`, `Passengers`, `TrainClass`, `TicketType`, `TicketPrize`, `BookingDate`) VALUES
(1, 1001, 1, 1, 'Fri Jun 03 16:26:11 IST 2022', 1, 'First Class', 'Return', 480, '2022-06-02 11:00:01');

-- --------------------------------------------------------

--
-- Table structure for table `statecodes`
--

CREATE TABLE `statecodes` (
  `StateCode` int(20) NOT NULL,
  `StateName` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `statecodes`
--

INSERT INTO `statecodes` (`StateCode`, `StateName`) VALUES
(1, 'Andhra Pradesh'),
(2, 'Arunachal Pradesh'),
(3, 'Assam'),
(4, 'Bihar'),
(5, 'Chandigarh'),
(6, 'Chhattisgarh'),
(7, 'DADRA AND NAGAR HAVELI'),
(8, 'DAMAN AND DIU'),
(9, 'Delhi'),
(10, 'Goa'),
(11, 'Gujarat'),
(12, 'Haryana'),
(13, 'Himachal Pradesh'),
(14, 'JAMMU AND KASHMIR'),
(15, 'Jharkhand'),
(16, 'Karnataka'),
(17, 'Kerala'),
(18, 'LAKSHADWEEP'),
(19, 'Madhya Pradesh'),
(20, 'Maharashtra'),
(21, 'Manipur'),
(22, 'Meghalaya'),
(23, 'Mizoram'),
(24, 'Nagaland'),
(25, 'Odisha'),
(26, 'PUDUCHERRY'),
(27, 'Punjab'),
(28, 'Rajasthan'),
(29, 'Sikkim'),
(30, 'Tamil Nadu'),
(31, 'Telangana'),
(32, 'Tripura'),
(33, 'Uttar Pradesh'),
(34, 'Uttarakhand'),
(35, 'West Bengal');

-- --------------------------------------------------------

--
-- Table structure for table `trains`
--

CREATE TABLE `trains` (
  `TrainID` double DEFAULT NULL,
  `TrainNo` double DEFAULT NULL,
  `TrainName` varchar(100) DEFAULT NULL,
  `Source` varchar(100) DEFAULT NULL,
  `DepTime` varchar(100) DEFAULT NULL,
  `Destination` varchar(100) DEFAULT NULL,
  `ArrTime` varchar(100) DEFAULT NULL,
  `KiloMeter` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `trains`
--

INSERT INTO `trains` (`TrainID`, `TrainNo`, `TrainName`, `Source`, `DepTime`, `Destination`, `ArrTime`, `KiloMeter`) VALUES
(1, 103, 'Mandovi Express', 'Mumbai Cst', '6:55', 'Madgaon', '18:30', 30),
(2, 104, 'Mandovi Express', 'Madgaon', '10:00', 'Mumbai Cst', '21:45', 40),
(3, 1048, 'Ubl Vsg Link Exp', 'Hubli Jn', '23:00', 'Vasco Da Gama', '6:30', 50),
(4, 1066, 'Dbg Ltt Express', 'Darbhanga Jn', '13:10', 'Lokmanyatilak T', '3:45', 60),
(5, 111, 'Konkan Kanya Exp', 'Mumbai Cst', '23:00', 'Madgaon', '10:45', 70),
(6, 112, 'Konkan Kanya Exp', 'Madgaon', '18:00', 'Mumbai Cst', '5:50', 80),
(7, 201, 'Ypr Guwahati Exp', 'Yesvantpur Jn', '23:55', 'Guwahati', '7:55', 100),
(8, 2779, 'Vsg Ubl Link Exp', 'Vasco Da Gama', '15:10', 'Hubli Jn', '22:25', 30),
(9, 3154, 'Gour Exp', 'Balurghat', '17:20', 'Sealdah', '6:15', 40),
(10, 340, 'Link Secbad Exp', 'Manuguru', '20:30', 'Secunderabad Jn', '4:45', 50),
(11, 4017, 'Sadbhavna Exp', 'Muzaffarpur Jn', '4:15', 'Delhi', '4:40', 60),
(12, 4523, 'Mfp Umb Exp', 'Muzaffarpur Jn', '7:25', 'Ambala Cant Jn', '8:15', 70),
(13, 4649, 'Saryuyamuna Exp', 'Darbhanga Jn', '9:25', 'Amritsar Jn', '20:55', 80),
(14, 4673, 'Shaheed Express', 'Darbhanga Jn', '9:25', 'Amritsar Jn', '20:55', 100),
(15, 5001, 'Mfp Ddn Exp', 'Muzaffarpur Jn', '14:00', 'Dehradun', '14:00', 30),
(16, 5097, 'Amarnath Exp', 'Barauni Jn', '5:00', 'Jammu Tawi', '12:45', 40),
(17, 5228, 'Mfp Ypr Exp', 'Muzaffarpur Jn', '7:30', 'Yesvantpur Jn', '11:25', 50),
(18, 611, 'Nagercoil Exp', 'Chennai Egmore', '23:15', 'Nagarcoil Jn', '14:15', 60),
(19, 612, 'Chennai Exp', 'Nagarcoil Jn', '13:30', 'Chennai Egmore', '4:30', 70),
(20, 6317, 'Mdu Jammu Exp', 'Madurai Jn', '19:15', 'Jammu Tawi', '14:10', 80),
(21, 641, 'Bangalore Exp', 'Eranakulam Jn', '17:00', 'Bangalore Cy Jn', '4:20', 100),
(22, 642, 'Ernakulam Exp', 'Bangalore Cy Jn', '17:15', 'Eranakulam Jn', '4:30', 30),
(23, 6687, 'Mdu Jammu Exp', 'Madurai Jn', '19:15', 'Jammu Tawi', '14:10', 40),
(24, 674, 'Jodhpur Express', 'Yesvantpur Jn', '17:35', 'Jodhpur Jn', '17:00', 50),
(25, 683, 'Bangalore Exp', 'Chennai Central', '23:30', 'Bangalore Cy Jn', '5:55', 60),
(26, 684, 'Chennai Exp', 'Bangalore Cy Jn', '23:00', 'Chennai Central', '5:15', 70),
(27, 7058, 'Devagiri Exp', 'Secunderabad Jn', '13:45', 'Mumbai Cst', '7:25', 80),
(28, 9040, 'Avadh Express', 'Muzaffarpur Jn', '6:25', 'Bandra Terminus', '4:45', 100),
(29, 1005, 'Latur Express', 'Mumbai Cst', '23:50', 'Latur', '14:10', 30),
(30, 1006, 'Latur Express', 'Latur', '17:00', 'Mumbai Cst', '7:45', 40),
(31, 1007, 'Deccan Express', 'Mumbai Cst', '7:10', 'Pune Jn', '11:10', 50),
(32, 1008, 'Deccan Express', 'Pune Jn', '15:30', 'Mumbai Cst', '19:40', 60),
(33, 1009, 'Sinhagad Exp', 'Mumbai Cst', '14:30', 'Pune Jn', '18:40', 70),
(34, 1010, 'Sinhagad Exp', 'Pune Jn', '6:05', 'Mumbai Cst', '10:05', 80),
(35, 1011, 'Mahalaxmi Exp', 'Mumbai Cst', '20:20', 'C Shahumharaj T', '7:20', 100),
(36, 1012, 'Mahalaxmi Exp', 'C Shahumharaj T', '19:35', 'Mumbai Cst', '6:15', 30),
(37, 1013, 'Coimbatore Exp', 'Lokmanyatilak T', '22:30', 'Coimbatore Jn', '6:30', 40),
(38, 1014, 'Lokmanya Tt Exp', 'Coimbatore Jn', '8:00', 'Lokmanyatilak T', '14:30', 50),
(39, 1015, 'Kushinagar Exp', 'Lokmanyatilak T', '22:55', 'Gorakhpur Jn', '7:25', 60),
(40, 1016, 'Kushinagar Exp', 'Gorakhpur Jn', '19:00', 'Lokmanyatilak T', '4:15', 70),
(41, 1017, 'Chalukya Express', 'Dadar', '21:30', 'Yesvantpur Jn', '20:40', 80),
(42, 1018, 'Chalukya Exp', 'Yesvantpur Jn', '7:20', 'Dadar', '7:20', 100),
(43, 1019, 'Konark Express', 'Mumbai Cst', '15:10', 'Bhubaneswar', '4:35', 30),
(44, 1020, 'Konark Express', 'Bhubaneswar', '15:15', 'Mumbai Cst', '3:55', 40),
(45, 1021, 'Indrayani Exp', 'Mumbai Cst', '5:40', 'Pune Jn', '9:08', 50),
(46, 1022, 'Indrayani Exp', 'Pune Jn', '18:35', 'Mumbai Cst', '22:00', 60),
(47, 1023, 'Sahyadri Expres', 'Mumbai Cst', '17:50', 'C Shahumharaj T', '6:05', 70),
(48, 1024, 'Sahyadri Exp', 'C Shahumharaj T', '22:50', 'Mumbai Cst', '12:20', 80),
(49, 1029, 'Koyna Express', 'Mumbai Cst', '9:00', 'C Shahumharaj T', '21:25', 100),
(50, 1030, 'Koyna Express', 'C Shahumharaj T', '7:55', 'Mumbai Cst', '20:30', 30),
(51, 1031, 'Gyan Ganga Exp', 'Pune Jn', '16:15', 'Manduadih', '20:10', 40),
(52, 1032, 'Gyan Ganga Exp', 'Manduadih', '4:45', 'Pune Jn', '8:00', 50),
(53, 1035, 'Sharavathi Exp', 'Dadar', '21:30', 'Mysore Jn', '21:10', 60),
(54, 1036, 'Sharavati Exp', 'Mysore Jn', '6:50', 'Dadar', '7:20', 70),
(55, 1039, 'Maharashtra Exp', 'C Shahumharaj T', '15:30', 'Gondia Jn', '20:15', 80),
(56, 0, 'Maharashtra Exp', 'Pune Jn', '23:20', 'Faizabad Jn', '10:10', 100),
(57, 1040, 'Maharashtra Exp', 'Gondia Jn', '8:20', 'C Shahumharaj T', '12:45', 30),
(58, 1043, 'Madurai Express', 'Lokmanyatilak T', '0:15', 'Madurai Jn', '11:45', 40),
(59, 1044, 'Lokamanya Tt Exp', 'Madurai Jn', '18:00', 'Lokmanyatilak T', '5:45', 50),
(60, 1047, 'Mrj Ubl Exp', 'Miraj Jn', '0:20', 'Hubli Jn', '7:20', 60),
(61, 1048, 'Ubl Mrj Express', 'Hubli Jn', '23:00', 'Miraj Jn', '5:15', 70),
(62, 1055, 'Godan Express', 'Lokmanyatilak T', '10:55', 'Gorakhpur Jn', '20:10', 80),
(63, 1056, 'Godan Express', 'Gorakhpur Jn', '6:30', 'Lokmanyatilak T', '16:05', 100),
(64, 1057, 'Amritsar Express', 'Dadar', '23:45', 'Amritsar Jn', '17:30', 30),
(65, 1058, 'Asr Dr Express', 'Amritsar Jn', '8:35', 'Dadar', '4:00', 40),
(66, 1059, 'Chhapra Express', 'Lokmanyatilak T', '10:55', 'Chhapra', '21:00', 50),
(67, 1060, 'Cpr Ltt Express', 'Chhapra', '5:30', 'Lokmanyatilak T', '16:05', 60),
(68, 1061, 'Muzaffarpur Exp', 'Lokmanyatilak T', '12:15', 'Muzaffarpur Jn', '22:35', 70),
(69, 1062, 'Mfp Ltt Express', 'Muzaffarpur Jn', '15:50', 'Lokmanyatilak T', '3:45', 80),
(70, 1065, 'Darbhanga Exp', 'Lokmanyatilak T', '12:15', 'Darbhanga Jn', '1:15', 100),
(71, 1066, 'Dikshabhumi Exp', 'Gaya Jn', '16:45', 'Nagpur', '16:50', 30),
(72, 1067, 'Saket Express', 'Lokmanyatilak T', '5:20', 'Faizabad Jn', '10:10', 40),
(73, 1068, 'Saket Express', 'Faizabad Jn', '15:35', 'Lokmanyatilak T', '22:00', 50),
(74, 0, 'Saket Link Exp', 'Rae Bareli Jn', '16:15', 'Lokmanyatilak T', '22:00', 60),
(75, 1069, 'Tulsi Express', 'Lokmanyatilak T', '5:20', 'Allahabad Jn', '10:15', 70),
(76, 1070, 'Tulsi Express', 'Allahabad Jn', '16:15', 'Lokmanyatilak T', '22:00', 80),
(77, 1071, 'Kamayani Express', 'Lokmanyatilak T', '12:40', 'Varanasi Jn', '19:15', 100),
(78, 1072, 'Kamayani Expres', 'Varanasi Jn', '15:50', 'Lokmanyatilak T', '23:05', 30),
(79, 1077, 'Jhelum Express', 'Pune Jn', '17:40', 'Jammu Tawi', '10:55', 40),
(80, 1078, 'Jhelum Express', 'Jammu Tawi', '21:45', 'Pune Jn', '14:35', 50),
(81, 1081, 'Kanyakumari Exp', 'Mumbai Cst', '15:45', 'Kanyakumari', '12:10', 60),
(82, 1082, 'Cape Mumbai Exp', 'Kanyakumari', '5:30', 'Mumbai Cst', '4:50', 70),
(83, 1089, 'Ju Pune Express', 'Jodhpur Jn', '5:30', 'Pune Jn', '4:45', 80),
(84, 1090, 'Pune Jodhpur Exp', 'Pune Jn', '19:50', 'Jodhpur Jn', '17:45', 100),
(85, 1091, 'Ahimsa Express', 'Bhuj', '7:35', 'Pune Jn', '4:45', 30),
(86, 1092, 'Pune Bhuj Exp', 'Pune Jn', '19:50', 'Bhuj', '16:45', 40),
(87, 1093, 'Mahanagari Exp', 'Mumbai Cst', '0:10', 'Varanasi Jn', '4:30', 50),
(88, 1094, 'Mahanagari Exp', 'Varanasi Jn', '11:30', 'Mumbai Cst', '14:30', 60),
(89, 1095, 'Ahimsa Express', 'Ahmedabad Jn', '16:00', 'Pune Jn', '4:45', 70),
(90, 1096, 'Ahimsa Express', 'Pune Jn', '19:50', 'Ahmedabad Jn', '8:30', 80),
(91, 1097, 'Eranakulam Exp', 'Pune Jn', '23:10', 'Eranakulam Jn', '4:20', 100),
(92, 1098, 'Poorna Express', 'Eranakulam Jn', '23:30', 'Pune Jn', '5:05', 30),
(93, 1103, 'Intercity Exp', 'Agra Cantt', '6:00', 'H Nizamuddin', '9:30', 40),
(94, 1104, 'Intercity Exp', 'H Nizamuddin', '18:10', 'Agra Cantt', '21:35', 50),
(95, 1107, 'Bundelkhand Exp', 'Gwalior', '19:50', 'Varanasi Jn', '10:15', 60),
(96, 1108, 'Bundelkhand Exp', 'Varanasi Jn', '14:30', 'Gwalior', '7:35', 70),
(97, 1123, 'Bju Gwl Mail', 'Barauni Jn', '14:55', 'Gwalior', '16:35', 80),
(98, 1124, 'Gwl Bju Mail', 'Gwalior', '11:25', 'Barauni Jn', '12:55', 100),
(99, 1271, 'Vindhyachal Exp', 'Itarsi Jn', '16:20', 'Bhopal Jn', '9:15', 30),
(100, 1272, 'Vindhyachal Exp', 'Bhopal Jn', '18:00', 'Itarsi Jn', '12:15', 40),
(101, 0, 'Dnr Grd Express', 'Danapur', '18:15', 'GirTrainIDih', '4:30', 50),
(102, 1396, 'Bpq Dr Pas Exp', 'Balharshah', '17:00', 'Dadar', '11:45', 60),
(103, 1405, 'Kakinada Express', 'Manmad Jn', '19:15', 'Kakinada Town', '20:10', 70),
(104, 1406, 'Cct Manmad Exp', 'Kakinada Town', '6:15', 'Manmad Jn', '7:10', 80),
(105, 1447, 'Shaktipunj Exp', 'Jabalpur', '23:40', 'Howrah Jn', '4:15', 100),
(106, 1448, 'Shaktipunj Exp', 'Howrah Jn', '14:30', 'Jabalpur', '16:15', 30),
(107, 1449, 'Jammutawi Exp', 'Jabalpur', '6:00', 'Jammu Tawi', '14:10', 40),
(108, 1450, 'Jat Jbp Express', 'Jammu Tawi', '23:30', 'Jabalpur', '8:15', 50),
(109, 1453, 'Prerana Express', 'Ahmedabad Jn', '16:25', 'Nagpur', '12:15', 60),
(110, 1454, 'Prerana Express', 'Nagpur', '8:30', 'Ahmedabad Jn', '4:00', 70),
(111, 1463, 'Vrl Jbp Express', 'Veraval', '10:05', 'Jabalpur', '15:10', 80),
(112, 1464, 'Veraval Express', 'Jabalpur', '12:00', 'Veraval', '17:10', 30),
(113, 1465, 'Vrl Jabalpur Exp', 'Veraval', '10:05', 'Jabalpur', '18:15', 40),
(114, 1466, 'Veraval Express', 'Jabalpur', '10:00', 'Veraval', '17:10', 50),
(115, 1471, 'Bpl Jabalpur Exp', 'Bhopal Jn', '23:00', 'Jabalpur', '5:40', 60),
(116, 1472, 'Jbp Bhopal Exp', 'Jabalpur', '23:00', 'Bhopal Jn', '6:15', 70),
(117, 1473, 'Bpl Jabalpur Exp', 'Bhopal Jn', '23:00', 'Jabalpur', '8:15', 80),
(118, 1474, 'Jbp Bhopal Exp', 'Jabalpur', '20:50', 'Bhopal Jn', '5:45', 100),
(119, 1616, 'Dhi Dr Pas Exp', 'Dhule', '19:20', 'Dadar', '4:00', 30),
(120, 163, 'Re Md Express', 'Rewari', '9:30', 'Madar', '18:50', 40),
(121, 2103, 'Pa Lucknow Exp', 'Pune Jn', '16:15', 'Lucknow', '17:25', 50),
(122, 2104, 'Ljn Pune Exp', 'Lucknow', '6:30', 'Pune Jn', '8:00', 60),
(123, 2105, 'VTrainIDarbha Express', 'Mumbai Cst', '19:40', 'Nagpur', '9:40', 70),
(124, 2106, 'VTrainIDarbha Express', 'Nagpur', '18:10', 'Mumbai Cst', '8:00', 80),
(125, 2107, 'Lucknow Sup Exp', 'Lokmanyatilak T', '16:25', 'Lucknow', '15:05', 100),
(126, 2108, 'Ljn Ltt Expresss', 'Lucknow', '22:35', 'Lokmanyatilak T', '22:45', 30),
(127, 2109, 'Panchavati Exp.', 'Mumbai Cst', '18:15', 'Manmad Jn', '22:50', 40),
(128, 2110, 'Panchavti Exp', 'Manmad Jn', '6:10', 'Mumbai Cst', '10:45', 50),
(129, 2115, 'STrainIDdheshwar Exp', 'Mumbai Cst', '22:35', 'Solapur Jn', '6:50', 60),
(130, 2116, 'STrainIDdheswar Exp', 'Solapur Jn', '22:30', 'Mumbai Cst', '6:45', 70),
(131, 2117, 'Ltt Mmr Exp', 'Lokmanyatilak T', '15:00', 'Manmad Jn', '19:25', 80),
(132, 2118, 'Mmr Ltt Exp', 'Manmad Jn', '8:35', 'Lokmanyatilak T', '13:00', 100),
(133, 2125, 'Pragati Express', 'Mumbai Cst', '16:25', 'Pune Jn', '19:53', 30),
(134, 2126, 'Pragati Express', 'Pune Jn', '7:50', 'Mumbai Cst', '11:15', 40),
(135, 2127, 'Intercity Exp', 'Mumbai Cst', '6:45', 'Pune Jn', '9:52', 50),
(136, 2128, 'Intercity Exp', 'Pune Jn', '17:55', 'Mumbai Cst', '21:00', 60),
(137, 2129, 'Azad Hind Exp', 'Pune Jn', '18:25', 'Howrah Jn', '4:00', 70),
(138, 2130, 'Azad Hind Exp', 'Howrah Jn', '22:15', 'Pune Jn', '6:50', 80),
(139, 2133, 'Darbhanga Exp', 'Pune Jn', '16:15', 'Darbhanga Jn', '6:45', 100),
(140, 2134, 'Dbg Pune Exp', 'Darbhanga Jn', '17:20', 'Pune Jn', '8:00', 30),
(141, 2135, 'Pune Nagpur Exp', 'Pune Jn', '17:20', 'Nagpur', '9:20', 40),
(142, 2136, 'Nagpur Pune Exp', 'Nagpur', '18:35', 'Pune Jn', '10:25', 50),
(143, 2137, 'Punjab Mail', 'Mumbai Cst', '19:10', 'Firozpur Cant', '5:20', 60),
(144, 2138, 'Punjab Mail', 'Firozpur Cant', '21:45', 'Mumbai Cst', '7:35', 70),
(145, 2139, 'Sewagram Exp.', 'Dadar', '15:10', 'Nagpur', '6:10', 80),
(146, 2140, 'Sewagram Exp.', 'Nagpur', '20:50', 'Dadar', '11:45', 100),
(147, 2141, 'Rajendra Ngr Exp', 'Lokmanyatilak T', '23:40', 'Rjndr Ngr Bihar', '5:30', 30),
(148, 2142, 'Rjpb Ltt Sup Exp', 'Rjndr Ngr Bihar', '10:45', 'Lokmanyatilak T', '15:15', 40),
(149, 2143, 'Dikshabhumi Exp', 'Nagpur', '10:00', 'Gaya Jn', '9:00', 50),
(150, 2144, 'Dikshabhumi Exp', 'Gaya Jn', '17:10', 'Nagpur', '16:00', 60),
(151, 2145, 'Bhubaneshwar Exp', 'Lokmanyatilak T', '20:35', 'Bhubaneswar', '4:20', 70),
(152, 2146, 'Bbs Ltt Sup Exp', 'Bhubaneswar', '23:00', 'Lokmanyatilak T', '7:30', 80),
(153, 2147, 'Nizamuddin Exp', 'C Shahumharaj T', '9:05', 'H Nizamuddin', '17:05', 100),
(154, 2148, 'Nzm Kop Exp', 'H Nizamuddin', '6:00', 'C Shahumharaj T', '16:20', 30),
(155, 2149, 'Pa Patna Sup Exp', 'Pune Jn', '20:55', 'Patna Jn', '4:00', 40),
(156, 2150, 'Pnbe Pune Exp', 'Patna Jn', '23:00', 'Pune Jn', '5:30', 50),
(157, 2151, 'Samarsata Exp', 'Lokmanyatilak T', '20:35', 'Howrah Jn', '8:30', 60),
(158, 2152, 'Samarsata Exp', 'Howrah Jn', '21:15', 'Lokmanyatilak T', '7:30', 70),
(159, 2153, 'Habibganj Expres', 'Lokmanyatilak T', '16:25', 'Habibganj', '5:30', 80),
(160, 2154, 'Hbj Ltt Sup Exp', 'Habibganj', '18:15', 'Lokmanyatilak T', '7:30', 100),
(161, 2155, 'Bhopal Express', 'Habibganj', '21:05', 'H Nizamuddin', '8:05', 30),
(162, 2156, 'Bhopal Express', 'H Nizamuddin', '21:00', 'Habibganj', '7:05', 40),
(163, 2157, 'Hutatma Express', 'Pune Jn', '18:00', 'Solapur Jn', '22:00', 50),
(164, 2158, 'Hutatma Express', 'Solapur Jn', '6:55', 'Pune Jn', '10:50', 60),
(165, 2159, 'Ngp Jbp Sup Exp', 'Nagpur', '21:25', 'Jabalpur', '6:40', 70),
(166, 2160, 'Nagpur Sup Exp', 'Jabalpur', '20:50', 'Nagpur', '6:25', 80),
(167, 2161, 'Lashkar Express', 'Lokmanyatilak T', '16:25', 'Agra Cantt', '12:45', 100),
(168, 2162, 'Lashkar Express', 'Agra Cantt', '23:20', 'Lokmanyatilak T', '22:45', 40),
(169, 2163, 'Chennai Express', 'Dadar', '20:30', 'Chennai Central', '19:35', 50),
(170, 2164, 'Chennai Exp', 'Chennai Central', '7:00', 'Dadar', '6:00', 60),
(171, 2165, 'Ltt Bsb Sup Exp', 'Lokmanyatilak T', '5:20', 'Varanasi Jn', '8:00', 70),
(172, 2166, 'Bsb Ltt Sup Exp', 'Varanasi Jn', '20:25', 'Lokmanyatilak T', '22:00', 80),
(173, 2173, 'Udyog Nagri Exp', 'Lokmanyatilak T', '16:25', 'Kanpur Central', '13:40', 100),
(174, 2174, 'Udyog Nagri Exp', 'Kanpur Central', '8:00', 'Lokmanyatilak T', '6:15', 30),
(175, 2175, 'Chambal Exp', 'Howrah Jn', '17:40', 'Gwalior', '17:25', 40),
(176, 2176, 'Chambal Express', 'Gwalior', '6:55', 'Howrah Jn', '6:30', 50),
(177, 2177, 'Chambal Exp', 'Howrah Jn', '17:40', 'Agra Cantt', '19:30', 60),
(178, 2178, 'Chambal Express', 'Agra Cantt', '5:10', 'Howrah Jn', '6:30', 70),
(179, 2181, 'Dayodaya Express', 'Jabalpur', '20:15', 'Jaipur', '12:30', 80),
(180, 2182, 'Dayodaya Exp', 'Jaipur', '17:25', 'Jabalpur', '9:15', 100),
(181, 2183, 'Bpl Lucknow Exp', 'Bhopal Jn', '19:00', 'Lucknow', '5:30', 30),
(182, 2184, 'Ljn Bpl Express', 'Lucknow', '22:35', 'Bhopal Jn', '9:00', 40),
(183, 2185, 'Rewanchal Exp', 'Bhopal Jn', '22:20', 'Rewa', '8:15', 50),
(184, 2186, 'Rewanchal Exp', 'Rewa', '19:50', 'Bhopal Jn', '5:45', 60),
(185, 2187, 'Rewanchal Exp', 'Bhopal Jn', '22:15', 'Rewa', '8:15', 70),
(186, 2188, 'Rewanchal Exp', 'Rewa', '19:50', 'Bhopal Jn', '6:15', 80),
(187, 2189, 'Mahakaushal Exp', 'Jabalpur', '18:05', 'H Nizamuddin', '11:30', 100),
(188, 2190, 'Mahakoshal Exp', 'H Nizamuddin', '16:10', 'Jabalpur', '9:50', 30),
(189, 0, 'Garib Rath Exp', 'Saharsa Jn', '15:00', 'Amritsar Jn', '20:20', 40),
(190, 2225, 'Kaifiyat Exp', 'Azamgarh', '16:30', 'Delhi', '6:45', 50),
(191, 2226, 'Kaifiyat Exp', 'Delhi', '19:25', 'Azamgarh', '9:30', 60),
(192, 2229, 'Lucknow Mail', 'Lucknow', '22:00', 'New Delhi', '7:00', 70),
(193, 2230, 'Lucknow Mail', 'New Delhi', '22:00', 'Lucknow', '6:50', 80),
(194, 2231, 'Lko Cdg Express', 'Lucknow', '22:30', 'Chandigarh', '9:55', 100),
(195, 2232, 'Cdg Lko Express', 'Chandigarh', '20:30', 'Lucknow', '8:35', 30),
(196, 2279, 'Taj Express', 'Jhansi Jn', '15:20', 'H Nizamuddin', '22:05', 40),
(197, 2280, 'Taj Express', 'H Nizamuddin', '7:15', 'Jhansi Jn', '13:35', 50),
(198, 2303, 'Poorva Express', 'Howrah Jn', '8:05', 'New Delhi', '7:05', 60),
(199, 2304, 'Poorva Express', 'New Delhi', '16:25', 'Howrah Jn', '16:45', 70),
(200, 2307, 'Hwh==Ju==Exp', 'Howrah Jn', '23:30', 'Jodhpur Jn', '7:20', 80),
(201, 2311, 'Hwh Dli Klk Mail', 'Howrah Jn', '19:40', 'Kalka', '4:55', 100),
(202, 2312, 'Kalka Mail', 'Kalka', '23:45', 'Howrah Jn', '7:10', 30),
(203, 2315, 'Annanya Express', 'Sealdah', '13:00', 'Ajmer Jn', '21:25', 40),
(204, 2316, 'Ananya Express', 'Ajmer Jn', '6:15', 'Sealdah', '15:15', 50),
(205, 2317, 'Akal Takht Exp', 'Sealdah', '7:40', 'Amritsar Jn', '17:10', 60),
(206, 2318, 'Asr Sealdah Exp', 'Amritsar Jn', '6:05', 'Sealdah', '15:15', 70),
(207, 2321, 'Hwh Mumbai Mail', 'Howrah Jn', '22:00', 'Mumbai Cst', '11:25', 80),
(208, 2322, 'Kolkata Mail', 'Mumbai Cst', '21:25', 'Howrah Jn', '11:40', 100),
(209, 2323, 'Hwh Ndls Express', 'Howrah Jn', '18:45', 'New Delhi', '17:00', 30),
(210, 2324, 'Ndls Hwh Express', 'New Delhi', '7:20', 'Howrah Jn', '6:00', 40),
(211, 2327, 'Upasana Express', 'Howrah Jn', '12:50', 'Dehradun', '18:05', 50),
(212, 2328, 'Upasana Express', 'Dehradun', '10:15', 'Howrah Jn', '15:05', 60),
(213, 2331, 'Himgiri Express', 'Howrah Jn', '23:45', 'Jammu Tawi', '12:45', 70),
(214, 2332, 'Himgiri Express', 'Jammu Tawi', '22:45', 'Howrah Jn', '11:30', 80),
(215, 2333, 'Vibhuti Express', 'Howrah Jn', '20:00', 'Varanasi Jn', '9:45', 100),
(216, 2334, 'Vibhuti Express', 'Varanasi Jn', '18:00', 'Howrah Jn', '7:55', 30),
(217, 2335, 'Bgp Ltt Express', 'Bhagalpur', '9:00', 'Lokmanyatilak T', '20:00', 40),
(218, 2336, 'Bhagalpur Exp', 'Lokmanyatilak T', '7:45', 'Bhagalpur', '18:30', 50),
(219, 2337, 'Santinikatanexp', 'Howrah Jn', '10:10', 'Bolpur S Niktn', '12:25', 60),
(220, 2338, 'Santiniketanexp', 'Bolpur S Niktn', '13:10', 'Howrah Jn', '15:40', 70),
(221, 2339, 'Coal Field Exp', 'Howrah Jn', '17:15', 'Dhanbad Jn', '21:40', 80),
(222, 2340, 'Coalfield Exp', 'Dhanbad Jn', '6:00', 'Howrah Jn', '10:25', 100),
(223, 2341, 'Agnibina Express', 'Howrah Jn', '18:20', 'Asansol Jn', '21:40', 30),
(224, 2342, 'Agnibina Express', 'Asansol Jn', '5:30', 'Howrah Jn', '8:45', 40),
(225, 2343, 'Darjeeling Mail', 'Sealdah', '22:05', 'New Jalpaiguri', '8:00', 50),
(226, 2344, 'Darjeeling Mail', 'Jalpaiguri', '17:25', 'Sealdah', '6:00', 60),
(227, 2345, 'Saraighat Exp', 'Howrah Jn', '16:00', 'Guwahati', '9:30', 70),
(228, 2346, 'Saraighatexpres', 'Guwahati', '19:00', 'Howrah Jn', '11:50', 80),
(229, 2351, 'Danapur Express', 'Howrah Jn', '21:35', 'Danapur', '7:40', 100),
(230, 2352, 'Danapur Exp', 'Danapur', '20:40', 'Howrah Jn', '6:45', 30),
(231, 2355, 'Archna Express', 'Rjndr Ngr Bihar', '7:05', 'Jammu Tawi', '9:30', 40),
(232, 2356, 'Archana Express', 'Jammu Tawi', '20:00', 'Rjndr Ngr Bihar', '23:05', 50),
(233, 2367, 'Vikramshila Exp', 'Bhagalpur', '11:30', 'New Delhi', '7:45', 60),
(234, 2368, 'Vikramshila Exp', 'New Delhi', '15:00', 'Bhagalpur', '12:40', 70),
(235, 2381, 'Poorva Express', 'Howrah Jn', '8:20', 'New Delhi', '7:05', 80),
(236, 2382, 'Poorva Express', 'New Delhi', '16:25', 'Howrah Jn', '16:45', 100),
(237, 2391, 'Shramjeevi Exp', 'Rajgir', '8:10', 'New Delhi', '5:20', 30),
(238, 2392, 'Shramjevi N Exp', 'New Delhi', '13:15', 'Rajgir', '10:00', 40),
(239, 2393, 'S Kranti Sup Exp', 'Rjndr Ngr Bihar', '17:35', 'New Delhi', '8:25', 50),
(240, 2394, 'Sampoorn K Exp', 'New Delhi', '18:15', 'Patna Jn', '8:15', 60),
(241, 2395, 'Ibadat Express', 'Rjndr Ngr Bihar', '18:55', 'Ajmer Jn', '15:48', 70),
(242, 2396, 'Ziyarat Express', 'Ajmer Jn', '23:30', 'Rjndr Ngr Bihar', '23:05', 80),
(243, 2397, 'Mahabodhi Exp', 'Gaya Jn', '14:30', 'New Delhi', '5:15', 100),
(244, 2398, 'Mahabodhi Exp', 'New Delhi', '14:05', 'Gaya Jn', '6:50', 30),
(245, 2401, 'Magadh Express', 'Islampur', '15:55', 'New Delhi', '11:05', 40),
(246, 2402, 'Magadh Express', 'New Delhi', '20:00', 'Islampur', '13:50', 50),
(247, 2405, 'Gondwana Express', 'Bhusaval Jn', '5:15', 'H Nizamuddin', '7:25', 60),
(248, 2406, 'Nzm Bsl Express', 'H Nizamuddin', '15:25', 'Bhusaval Jn', '15:50', 70),
(249, 2409, 'Gondwan Express', 'Bilaspur Jn', '6:00', 'H Nizamuddin', '7:25', 80),
(250, 2410, 'Gondwana Expres', 'H Nizamuddin', '15:25', 'Bilaspur Jn', '15:55', 100),
(251, 2411, 'Gondwana Express', 'Jabalpur', '15:55', 'H Nizamuddin', '7:25', 30),
(252, 2412, 'Gondwana Expres', 'H Nizamuddin', '15:25', 'Jabalpur', '7:15', 40),
(253, 2413, 'Jp Jat Exp', 'Jaipur', '16:35', 'Jammu Tawi', '8:10', 50),
(254, 0, 'Aii Jp Link Exp', 'Ajmer Jn', '13:55', 'Jaipur', '16:20', 60),
(255, 2414, 'Jammu Jp Exp', 'Jammu Tawi', '18:15', 'Jaipur', '10:10', 70),
(256, 0, 'Jp Aii Link Exp', 'Jaipur', '10:20', 'Ajmer Jn', '12:45', 80),
(257, 2415, 'Nizamuddin Exp', 'Indore Jn Bg', '16:20', 'H Nizamuddin', '5:40', 100),
(258, 2416, 'Intercity Exp', 'H Nizamuddin', '22:15', 'Indore Jn Bg', '11:40', 30),
(259, 2417, 'Prayag Raj Exp', 'Allahabad Jn', '21:30', 'New Delhi', '6:35', 40),
(260, 2418, 'Prayag Raj Exp', 'New Delhi', '21:30', 'Allahabad Jn', '6:45', 50),
(261, 2419, 'Gomti Exp', 'Lucknow', '5:30', 'New Delhi', '13:55', 60),
(262, 2420, 'Gomti Express', 'New Delhi', '14:20', 'Lucknow', '22:50', 70),
(263, 2428, 'Ndls Rewa Exp', 'New Delhi', '23:50', 'Rewa', '15:00', 80),
(264, 2449, 'Goa Smprk K Exp', 'Madgaon', '11:15', 'H Nizamuddin', '16:45', 100),
(265, 2450, 'Goa Smprk K Exp', 'H Nizamuddin', '7:30', 'Madgaon', '13:15', 30),
(266, 2451, 'Shram Shkti Exp', 'Kanpur Central', '23:35', 'New Delhi', '5:55', 40),
(267, 2452, 'Shram Shkti Exp', 'New Delhi', '23:35', 'Kanpur Central', '6:00', 50),
(268, 2459, 'Ndlsasr Express', 'New Delhi', '13:40', 'Amritsar Jn', '21:30', 60),
(269, 2460, 'Asr Ndls Exp', 'Amritsar Jn', '6:25', 'New Delhi', '14:10', 70),
(270, 2461, 'Mandor Express', 'Delhi', '20:45', 'Jodhpur Jn', '8:00', 80),
(271, 2462, 'Mandor Express', 'Jodhpur Jn', '19:30', 'Delhi', '6:25', 100),
(272, 2465, 'Intercity Exp', 'Sawai Madhopur', '15:05', 'Jodhpur Jn', '23:00', 30),
(273, 2466, 'Intercity Exp', 'Jodhpur Jn', '5:45', 'Sawai Madhopur', '13:00', 40),
(274, 2471, 'Swaraj Express', 'Bandra Terminus', '7:55', 'Jammu Tawi', '15:40', 50),
(275, 2472, 'Swaraj Express', 'Jammu Tawi', '11:15', 'Bandra Terminus', '18:05', 60),
(276, 2473, 'Sarvodaya Exp', 'Ahmedabad Jn', '11:35', 'Jammu Tawi', '15:40', 70),
(277, 2474, 'Sarvodaya Exp', 'Jammu Tawi', '11:15', 'Ahmedabad Jn', '14:00', 80),
(278, 2475, 'Hapa Jat Express', 'Hapa', '5:20', 'Jammu Tawi', '15:40', 30),
(279, 2476, 'Sarvodaya Exp', 'Jammu Tawi', '11:15', 'Hapa', '20:35', 40),
(280, 2477, 'Jam Jat Express', 'Jamnagar', '5:05', 'Jammu Tawi', '15:40', 50),
(281, 2478, 'Jat Jamnagr Exp', 'Jammu Tawi', '11:15', 'Jamnagar', '20:50', 60),
(282, 2479, 'Surya Nagri Exp', 'Jodhpur Jn', '18:45', 'Bandra Terminus', '11:45', 70),
(283, 2480, 'Suryanagari Exp', 'Bandra Terminus', '13:30', 'Jodhpur Jn', '6:30', 80),
(284, 2481, 'Intercity Exp', 'New Delhi', '13:10', 'Shri Ganganagar', '20:35', 100),
(285, 2482, 'Intercity Exp', 'Shri Ganganagar', '6:00', 'New Delhi', '13:40', 30),
(286, 2503, 'Sdah Njp Express', 'Sealdah', '9:05', 'New Jalpaiguri', '19:00', 40),
(287, 2504, 'Njp Sdah Express', 'New Jalpaiguri', '9:45', 'Sealdah', '19:55', 50),
(288, 2505, 'North East Exp', 'Guwahati', '9:20', 'New Delhi', '19:30', 60),
(289, 2506, 'North East Exp', 'New Delhi', '6:40', 'Guwahati', '16:40', 70),
(290, 2507, 'Guwahati Exp', 'Eranakulam Jn', '20:35', 'Guwahati', '7:55', 80),
(291, 2508, 'Ghy Ers Express', 'Guwahati', '6:30', 'Eranakulam Jn', '19:00', 100),
(292, 2509, 'Guwahati Exp', 'Bangalore Cy Jn', '23:30', 'Guwahati', '5:50', 30),
(293, 251, 'Kalka Simla Exp', 'Kalka', '6:00', 'Simla', '11:00', 40),
(294, 2510, 'Ghy-Sbc-Express', 'Guwahati', '6:30', 'Bangalore Cy Jn', '11:50', 50),
(295, 2511, 'Rapti Sagar Exp', 'Gorakhpur Jn', '6:30', 'Trivandrum Cntl', '17:55', 60),
(296, 2512, 'Raptisagar Exp', 'Trivandrum Cntl', '5:20', 'Gorakhpur Jn', '15:20', 70),
(297, 2513, 'Sc Ghy Exp', 'Secunderabad Jn', '7:30', 'Guwahati', '5:50', 80),
(298, 2514, 'Ghy Sc Express', 'Guwahati', '6:30', 'Secunderabad Jn', '4:20', 100),
(299, 2515, 'Guwahati Exp', 'Trivandrum Cntl', '12:45', 'Guwahati', '5:50', 30),
(300, 2516, 'Ghy-Tvc-Express', 'Guwahati', '6:30', 'Trivandrum Cntl', '23:30', 40),
(301, 252, 'Sml Klk Express', 'Simla', '18:15', 'Kalka', '23:15', 50),
(302, 2521, 'Rapti Sagar Exp', 'Barauni Jn', '23:00', 'Eranakulam Jn', '13:20', 60),
(303, 2522, 'Raptisagar Exp', 'Eranakulam Jn', '9:30', 'Barauni Jn', '22:50', 70),
(304, 2533, 'Pushpak Express', 'Mumbai Cst', '8:20', 'Lucknow', '8:20', 80),
(305, 2534, 'Pushpak Exp', 'Lucknow', '19:50', 'Mumbai Cst', '20:05', 100),
(306, 2553, 'Vaishali Exp', 'Barauni Jn', '9:30', 'New Delhi', '6:15', 30),
(307, 2554, 'Vaishali Exp', 'New Delhi', '19:50', 'Barauni Jn', '17:15', 40),
(308, 2555, 'Gorakdam Express', 'Gorakhpur Jn', '16:30', 'Bhiwani', '8:55', 50),
(309, 2556, 'Gorakdam Express', 'Bhiwani', '17:35', 'Gorakhpur Jn', '10:05', 60),
(310, 2557, 'Sapt Kranti Exp', 'Muzaffarpur Jn', '12:00', 'Delhi', '7:50', 70),
(311, 2558, 'Sapt Kranti Exp', 'Delhi', '16:45', 'Muzaffarpur Jn', '12:25', 80),
(312, 2559, 'Shiv Ganga Exp', 'Varanasi Jn', '19:15', 'New Delhi', '7:25', 100),
(313, 2560, 'Shiv Ganga Exp', 'New Delhi', '18:30', 'Varanasi Jn', '7:30', 30),
(314, 2561, 'Swatantrta S Exp', 'Darbhanga Jn', '15:30', 'New Delhi', '12:25', 40),
(315, 2562, 'Swatantrta S Exp', 'New Delhi', '20:40', 'Darbhanga Jn', '18:05', 50),
(316, 2587, 'Amar Nath Exp', 'Gorakhpur Jn', '14:05', 'Jammu Tawi', '12:45', 60),
(317, 2588, 'Jammu Gkp Exp', 'Jammu Tawi', '22:45', 'Gorakhpur Jn', '21:00', 70),
(318, 2589, 'Gkp Sc Express', 'Gorakhpur Jn', '6:30', 'Secunderabad Jn', '15:30', 80),
(319, 2590, 'Gorakhpur Exp', 'Secunderabad Jn', '8:10', 'Gorakhpur Jn', '15:20', 100),
(320, 2591, 'Gkp Sbc Express', 'Gorakhpur Jn', '6:30', 'Bangalore Cy Jn', '5:55', 30),
(321, 2592, 'Gorakhpur Exp', 'Bangalore Cy Jn', '16:40', 'Gorakhpur Jn', '15:20', 40),
(322, 2601, 'Mangalore Mail', 'Chennai Central', '20:15', 'Mangalore', '12:20', 50),
(323, 2602, 'Chennai Mail', 'Mangalore', '13:15', 'Chennai Central', '5:25', 60),
(324, 2603, 'Hwh Mas Mail', 'Howrah Jn', '23:30', 'Chennai Central', '3:50', 70),
(325, 2604, 'Howrah Mail', 'Chennai Central', '23:35', 'Howrah Jn', '4:05', 80),
(326, 2605, 'Pallavan Exp', 'Chennai Egmore', '15:30', 'Tiruchchirapali', '20:50', 100),
(327, 2606, 'Pallavan Exp', 'Tiruchchirapali', '6:30', 'Chennai Egmore', '12:00', 30),
(328, 2607, 'Lalbagh Express', 'Chennai Central', '15:30', 'Bangalore Cy Jn', '21:25', 40),
(329, 2608, 'Lalbagh Exp', 'Bangalore Cy Jn', '6:30', 'Chennai Central', '12:00', 50),
(330, 2609, 'Bangalore Exp', 'Chennai Central', '13:15', 'Bangalore Cy Jn', '19:45', 60),
(331, 2610, 'Chennai Express', 'Bangalore Cy Jn', '8:15', 'Chennai Central', '14:45', 70),
(332, 2613, 'Tippu Express', 'Mysore Jn', '11:00', 'Bangalore Cy Jn', '13:25', 80),
(333, 2614, 'Tippu Express', 'Bangalore Cy Jn', '14:15', 'Mysore Jn', '16:45', 100),
(334, 2615, 'Grand Trunk Exp', 'Chennai Central', '19:15', 'New Delhi', '6:20', 40),
(335, 2616, 'G T Express', 'New Delhi', '18:40', 'Chennai Central', '6:15', 50),
(336, 2618, 'Mngla Lksdp Exp', 'H Nizamuddin', '9:20', 'Eranakulam Jn', '10:00', 60),
(337, 2619, 'Matsyagandha Exp', 'Lokmanyatilak T', '14:05', 'Mangalore', '6:15', 70),
(338, 2620, 'Matsyaganda Exp', 'Mangalore', '14:40', 'Lokmanyatilak T', '6:35', 80),
(339, 2621, 'Tamil Nadu Exp', 'Chennai Central', '22:00', 'New Delhi', '7:05', 100),
(340, 2622, 'Tamil Nadu Exp', 'New Delhi', '22:30', 'Chennai Central', '7:10', 30),
(341, 2623, 'Trivandrum Mail', 'Chennai Central', '20:00', 'Trivandrum Cntl', '11:40', 40),
(342, 2624, 'Chennai Mail', 'Trivandrum Cntl', '14:30', 'Chennai Central', '7:00', 50),
(343, 2625, 'Kerala Express', 'Trivandrum Cntl', '11:30', 'New Delhi', '13:25', 60),
(344, 2626, 'Kerala Express', 'New Delhi', '11:30', 'Trivandrum Cntl', '14:20', 70),
(345, 2627, 'Karnataka Exp', 'Bangalore Cy Jn', '19:20', 'New Delhi', '10:35', 80),
(346, 2628, 'Karnataka Exp', 'New Delhi', '21:15', 'Bangalore Cy Jn', '13:40', 100),
(347, 2630, 'Ypr S Krnti Exp', 'H Nizamuddin', '8:55', 'Yesvantpur Jn', '6:40', 30),
(348, 2631, 'Nellai Express', 'Chennai Egmore', '21:00', 'Tirunelveli', '8:35', 40),
(349, 2632, 'Nellai Express', 'Tirunelveli', '18:30', 'Chennai Egmore', '6:10', 50),
(350, 2633, 'Kanyakumari Exp', 'Chennai Egmore', '17:25', 'Kanyakumari', '6:30', 60),
(351, 2634, 'Kanyakumari Exp', 'Kanyakumari', '17:15', 'Chennai Egmore', '6:45', 70),
(352, 2635, 'Vaigai Exp', 'Chennai Egmore', '12:25', 'Madurai Jn', '20:10', 80),
(353, 2636, 'Vaigai Exp', 'Madurai Jn', '6:45', 'Chennai Egmore', '14:40', 100),
(354, 2637, 'Pandian Exp', 'Chennai Egmore', '21:30', 'Madurai Jn', '6:15', 30),
(355, 2638, 'Pandian Exp', 'Madurai Jn', '20:45', 'Chennai Egmore', '5:45', 40),
(356, 2639, 'Brindavan Exp', 'Chennai Central', '7:15', 'Bangalore Cy Jn', '13:20', 50),
(357, 2640, 'Brindavan Exp', 'Bangalore Cy Jn', '14:30', 'Chennai Central', '20:15', 60),
(358, 2641, 'Tirukkural Exp', 'Kanyakumari', '19:15', 'H Nizamuddin', '18:00', 70),
(359, 2642, 'Thirukkural Exp', 'H Nizamuddin', '6:00', 'Kanyakumari', '8:40', 80),
(360, 2643, 'Nizamuddin Exp', 'Trivandrum Cntl', '14:15', 'H Nizamuddin', '17:05', 100),
(361, 2645, 'Nizamuddin Exp', 'Eranakulam Jn', '18:40', 'H Nizamuddin', '17:05', 30),
(362, 2646, 'Ers Millenum Exp', 'H Nizamuddin', '6:00', 'Eranakulam Jn', '6:00', 40),
(363, 2647, 'Kongu Express', 'Coimbatore Jn', '15:15', 'H Nizamuddin', '14:10', 50),
(364, 2648, 'Kongu Express', 'H Nizamuddin', '8:45', 'Coimbatore Jn', '9:30', 60),
(365, 2650, 'Ktk Smprk K Exp', 'H Nizamuddin', '6:45', 'Yesvantpur Jn', '19:10', 70),
(366, 2655, 'Navjeevan Exp', 'Ahmedabad Jn', '6:30', 'Chennai Central', '16:05', 80),
(367, 2656, 'Navajivan Exp', 'Chennai Central', '9:35', 'Ahmedabad Jn', '19:45', 100),
(368, 2657, 'Bangalore Mail', 'Chennai Central', '23:15', 'Bangalore Cy Jn', '5:30', 30),
(369, 2658, 'Chennai Mail', 'Bangalore Cy Jn', '22:45', 'Chennai Central', '4:40', 40),
(370, 2659, 'Gurudev Express', 'Nagarcoil Jn', '14:35', 'Howrah Jn', '13:55', 50),
(371, 2660, 'Gurudev Express', 'Howrah Jn', '23:15', 'Nagarcoil Jn', '22:15', 60),
(372, 2661, 'Tenkasi Express', 'Chennai Egmore', '20:00', 'Tenkasi Jn', '8:00', 70),
(373, 2662, 'Tsi Chennai Exp', 'Tenkasi Jn', '19:00', 'Chennai Egmore', '7:00', 80),
(374, 2663, 'Hwh Tpj Express', 'Howrah Jn', '16:05', 'Tiruchchirapali', '4:30', 100),
(375, 2664, 'Howrah Express', 'Tiruchchirapali', '16:00', 'Howrah Jn', '3:20', 30),
(376, 2665, 'Kannyakumari Exp', 'Howrah Jn', '16:05', 'Kanyakumari', '11:20', 40),
(377, 2666, 'Cape Howrah Exp', 'Kanyakumari', '7:50', 'Howrah Jn', '3:20', 50),
(378, 2667, 'Nagercoil Exp', 'Chennai Egmore', '19:00', 'Nagarcoil Jn', '8:10', 60),
(379, 2668, 'Chennai Exp', 'Nagarcoil Jn', '19:40', 'Chennai Egmore', '8:50', 70),
(380, 2669, 'Gangakaveri Exp', 'Chennai Central', '17:30', 'Chhapra', '12:00', 80),
(381, 2670, 'Gangakaveri Exp', 'Varanasi Jn', '20:25', 'Chennai Central', '9:50', 100),
(382, 2671, 'Nilagiri Exp', 'Chennai Central', '21:00', 'Metupalaiyam', '6:15', 30),
(383, 2672, 'Nilagiri Exp', 'Metupalaiyam', '19:45', 'Chennai Central', '5:10', 40),
(384, 2673, 'Cheran Express', 'Chennai Central', '22:10', 'Coimbatore Jn', '6:10', 50),
(385, 2674, 'Cheran Express', 'Coimbatore Jn', '22:15', 'Chennai Central', '6:35', 60),
(386, 2675, 'Kovai Express', 'Chennai Central', '6:15', 'Coimbatore Jn', '13:55', 70),
(387, 2676, 'Kovai Exp', 'Coimbatore Jn', '13:40', 'Chennai Central', '21:20', 80),
(388, 2677, 'Coimbatore Exp', 'Bangalore Cy Jn', '6:15', 'Coimbatore Jn', '13:10', 100),
(389, 2678, 'Bangalore Exp', 'Coimbatore Jn', '14:25', 'Bangalore Cy Jn', '21:10', 30),
(390, 2679, 'Coimbatore Exp', 'Chennai Central', '14:30', 'Coimbatore Jn', '22:15', 40),
(391, 2680, 'Chennai Express', 'Coimbatore Jn', '6:30', 'Chennai Central', '14:00', 50),
(392, 2681, 'Coimbatore Exp', 'Chennai Central', '22:20', 'Coimbatore Jn', '7:15', 60),
(393, 2682, 'Chennai Exp', 'Coimbatore Jn', '23:30', 'Chennai Central', '8:00', 70),
(394, 2683, 'Bangalore Sf Exp', 'Eranakulam Jn', '17:00', 'Bangalore Cy Jn', '4:20', 80),
(395, 2684, 'Ernakulam Sf Exp', 'Bangalore Cy Jn', '17:15', 'Eranakulam Jn', '4:20', 100),
(396, 2685, 'Mangalore Exp', 'Chennai Central', '17:00', 'Mangalore', '9:10', 30),
(397, 2686, 'Chennai Exp', 'Mangalore', '16:00', 'Chennai Central', '8:00', 40),
(398, 2687, 'Dehradun Exp', 'Chennai Central', '9:10', 'Dehradun', '5:00', 50),
(399, 2688, 'Ddn Mas Exp', 'Dehradun', '7:15', 'Chennai Central', '3:15', 60),
(400, 0, 'Ddn Cdg Mas Exp', 'Chandigarh', '7:35', 'Chennai Central', '3:15', 70),
(401, 2689, 'Nagercoil Exp', 'Chennai Central', '18:05', 'Nagarcoil Jn', '10:50', 80),
(402, 2690, 'Ncj Chennai Exp', 'Nagarcoil Jn', '19:40', 'Chennai Central', '12:15', 100),
(403, 2691, 'Bangalore Exp', 'Chennai Central', '23:30', 'Bangalore Cy Jn', '5:55', 30),
(404, 2692, 'Chennai Express', 'Bangalore Cy Jn', '23:00', 'Chennai Central', '5:15', 40),
(405, 2693, 'Pearl City Exp', 'Chennai Egmore', '18:30', 'Tuticorin', '6:15', 50),
(406, 2694, 'Pearl City Exp', 'Tuticorin', '19:45', 'Chennai Egmore', '7:40', 60),
(407, 2695, 'Trivandrum Exp', 'Chennai Central', '16:15', 'Trivandrum Cntl', '7:30', 70),
(408, 2696, 'Tvc Chennai Exp', 'Trivandrum Cntl', '17:15', 'Chennai Central', '9:30', 80),
(409, 2697, 'Trivandrum Exp', 'Chennai Central', '16:00', 'Trivandrum Cntl', '7:00', 100),
(410, 2698, 'Tvc Chennai Exp', 'Trivandrum Cntl', '20:00', 'Chennai Central', '12:15', 30),
(411, 2701, 'Husainsagar Exp', 'Mumbai Cst', '21:50', 'Hyderabad Decan', '12:10', 40),
(412, 2702, 'Hussainsagar Exp', 'Hyderabad Decan', '14:45', 'Mumbai Cst', '5:05', 50),
(413, 2703, 'Falaknuma Exp', 'Howrah Jn', '7:20', 'Secunderabad Jn', '9:35', 60),
(414, 2704, 'Falaknuma Exp', 'Secunderabad Jn', '16:00', 'Howrah Jn', '17:55', 70),
(415, 2705, 'Bza Sc Exp', 'Vijayawada Jn', '16:00', 'Secunderabad Jn', '21:50', 80),
(416, 2706, 'Sc Bza Exp', 'Secunderabad Jn', '7:40', 'Vijayawada Jn', '13:30', 100),
(417, 2709, 'Simhapuri Exp', 'Gudur Jn', '21:00', 'Secunderabad Jn', '7:45', 30),
(418, 2710, 'Simhapuri Exp', 'Secunderabad Jn', '21:30', 'Gudur Jn', '8:25', 40),
(419, 2711, 'Pinakini Exp', 'Vijayawada Jn', '6:00', 'Chennai Central', '13:00', 50),
(420, 2712, 'Pinakini Exp', 'Chennai Central', '14:00', 'Vijayawada Jn', '21:10', 60),
(421, 2713, 'Satavahana Exp', 'Vijayawada Jn', '6:10', 'Secunderabad Jn', '11:45', 70),
(422, 2714, 'Satavahana Exp', 'Secunderabad Jn', '16:15', 'Vijayawada Jn', '21:50', 80),
(423, 2715, 'Sachkhand Exp', 'Nanded', '9:30', 'Amritsar Jn', '20:15', 100),
(424, 2716, 'Asr Ned Express', 'Amritsar Jn', '5:35', 'Nanded', '15:40', 30),
(425, 2717, 'Ratnachalam Exp', 'Vishakapatnam', '12:30', 'Vijayawada Jn', '18:35', 40),
(426, 2718, 'Ratnachal Exp', 'Vijayawada Jn', '6:05', 'Vishakapatnam', '12:05', 50),
(427, 2720, 'Nagarjuna Exp', 'Secunderabad Jn', '6:40', 'Tenali Jn', '12:10', 60),
(428, 2721, 'Nizamuddin Exp', 'Hyderabad Decan', '22:55', 'H Nizamuddin', '4:05', 70),
(429, 2722, 'Dakshin Express', 'H Nizamuddin', '22:50', 'Hyderabad Decan', '5:00', 80),
(430, 2723, 'A P Exp', 'Hyderabad Decan', '6:25', 'New Delhi', '9:00', 100),
(431, 2724, 'A P Express', 'New Delhi', '17:45', 'Hyderabad Decan', '19:50', 30),
(432, 2725, 'Hubli Express', 'Bangalore Cy Jn', '14:30', 'Hubli Jn', '22:15', 40),
(433, 2726, 'Intercity Exp', 'Hubli Jn', '6:20', 'Bangalore Cy Jn', '13:50', 50),
(434, 2727, 'Godavari Exp', 'Vishakapatnam', '17:25', 'Hyderabad Decan', '6:15', 60),
(435, 2728, 'Godavari Exp', 'Hyderabad Decan', '17:15', 'Vishakapatnam', '6:05', 70),
(436, 2729, 'Pune Nanded Exp', 'Pune Jn', '22:00', 'Nanded', '10:00', 80),
(437, 2730, 'Pune Express', 'Nanded', '21:20', 'Pune Jn', '9:20', 100),
(438, 2733, 'Narayanadri Exp', 'Tirupati', '18:25', 'Secunderabad Jn', '6:25', 30),
(439, 2734, 'Narayanadri Exp', 'Secunderabad Jn', '18:05', 'Tirupati', '6:05', 40),
(440, 2737, 'Goutami Exp', 'Kakinada Port', '20:20', 'Secunderabad Jn', '6:35', 50),
(441, 2738, 'Goutami Exp', 'Secunderabad Jn', '21:15', 'Kakinada Port', '7:30', 60),
(442, 2747, 'Palnadu Exp', 'Guntur Jn', '5:45', 'Vikarabad Jn', '12:10', 70),
(443, 2748, 'Palnadu Exp', 'Vikarabad Jn', '13:45', 'Guntur Jn', '20:00', 80),
(444, 2753, 'Hyderabad Exp', 'Chennai Central', '16:45', 'Hyderabad Decan', '5:45', 30),
(445, 2754, 'Chennai Exp', 'Hyderabad Decan', '16:55', 'Chennai Central', '5:55', 40),
(446, 2759, 'Charminar Exp', 'Chennai Central', '18:10', 'Hyderabad Decan', '8:00', 50),
(447, 2760, 'Charminar Exp', 'Hyderabad Decan', '18:30', 'Chennai Central', '8:15', 60),
(448, 2763, 'Padmavathi Exp', 'Tirupati', '17:05', 'Secunderabad Jn', '5:50', 70),
(449, 2764, 'Padmavati Exp', 'Secunderabad Jn', '18:30', 'Tirupati', '7:00', 80),
(450, 2779, 'Goa Express', 'Vasco Da Gama', '15:10', 'H Nizamuddin', '6:30', 100),
(451, 2780, 'Goa Express', 'H Nizamuddin', '15:00', 'Vasco Da Gama', '6:30', 30),
(452, 2785, 'Bangalore Exp', 'Kacheguda', '19:05', 'Bangalore Cy Jn', '6:25', 40),
(453, 2786, 'Kacheguda Exp', 'Bangalore Cy Jn', '18:20', 'Kacheguda', '5:40', 50),
(454, 2797, 'Venkatadri Exp', 'Kacheguda', '20:05', 'Chittor', '8:55', 60),
(455, 2798, 'Venkatadri Exp', 'Chittor', '17:30', 'Kacheguda', '6:20', 70),
(456, 2801, 'Purushottam Exp', 'Puri', '21:45', 'New Delhi', '4:55', 80),
(457, 2802, 'Purshottam Exp', 'New Delhi', '22:25', 'Puri', '5:30', 100),
(458, 2804, 'Vskp Swrn J Exp', 'H Nizamuddin', '6:00', 'Vishakapatnam', '18:30', 30),
(459, 2805, 'Janmabhoomi Exp', 'Vishakapatnam', '6:00', 'Tenali Jn', '12:40', 40),
(460, 2806, 'Janmabhoomi Exp', 'Tenali Jn', '13:10', 'Vishakapatnam', '20:05', 50),
(461, 2807, 'Samta-Express', 'Vishakapatnam', '6:20', 'H Nizamuddin', '16:50', 60),
(462, 2808, 'Samta Express', 'H Nizamuddin', '8:45', 'Vishakapatnam', '18:30', 70),
(463, 2809, 'Howrah Mail', 'Mumbai Cst', '20:35', 'Howrah Jn', '5:40', 80),
(464, 2810, 'Hwh Mumbai Mail', 'Howrah Jn', '20:15', 'Mumbai Cst', '5:15', 100),
(465, 2811, 'Hatia Express', 'Lokmanyatilak T', '0:15', 'Hatia', '4:00', 30),
(466, 2813, 'Steel Express', 'Howrah Jn', '17:30', 'Tatanagar Jn', '21:30', 40),
(467, 2814, 'Steel Exp', 'Tatanagar Jn', '6:15', 'Howrah Jn', '10:25', 50),
(468, 2815, 'Puri Ndls Exp', 'Puri', '10:50', 'New Delhi', '17:00', 60),
(469, 2816, 'Puri Express', 'New Delhi', '6:30', 'Puri', '13:15', 70),
(470, 2817, 'Jharkhands/Jexp', 'Hatia', '14:45', 'Delhi', '13:55', 80),
(471, 2818, 'Jharkhand Expres', 'Delhi', '19:45', 'Hatia', '16:40', 100),
(472, 2821, 'Dhauli Exp', 'Howrah Jn', '6:00', 'Bhubaneswar', '12:45', 30),
(473, 2822, 'Dhauli Exp', 'Bhubaneswar', '13:15', 'Howrah Jn', '20:20', 40),
(474, 2827, 'Hwh Prr Exp', 'Howrah Jn', '16:45', 'Purulia Jn', '22:20', 50),
(475, 2828, 'Prr Hwh Exp', 'Purulia Jn', '5:30', 'Howrah Jn', '11:20', 60),
(476, 2829, 'Bhubaneswar Exp', 'Chennai Central', '21:10', 'Bhubaneswar', '17:30', 70),
(477, 2830, 'Bbs Chennai Exp', 'Bhubaneswar', '11:45', 'Chennai Central', '8:55', 80),
(478, 2833, 'Howrah Express', 'Ahmedabad Jn', '23:55', 'Howrah Jn', '13:45', 100),
(479, 2834, 'Hwh Adi Express', 'Howrah Jn', '23:55', 'Ahmedabad Jn', '13:40', 30),
(480, 2835, 'Hte Ypr Express', 'Hatia', '18:30', 'Yesvantpur Jn', '5:00', 40),
(481, 2836, 'Ypr Hatia Exp', 'Yesvantpur Jn', '8:30', 'Hatia', '19:15', 50),
(482, 2837, 'Hwh Puri Exp', 'Howrah Jn', '22:35', 'Puri', '7:20', 60),
(483, 2838, 'Puri Hwh Exp', 'Puri', '20:05', 'Howrah Jn', '4:55', 70),
(484, 2841, 'Coromandal Exp', 'Howrah Jn', '14:50', 'Chennai Central', '17:15', 80),
(485, 2842, 'Coromandel Exp', 'Chennai Central', '9:00', 'Howrah Jn', '12:00', 100),
(486, 2843, 'Puri=Adi Exp', 'Puri', '17:25', 'Ahmedabad Jn', '7:25', 30),
(487, 2844, 'Adi Puri Exp', 'Ahmedabad Jn', '18:00', 'Puri', '8:45', 40),
(488, 2845, 'Bbs Ypr Sup Exp', 'Bhubaneswar', '7:30', 'Yesvantpur Jn', '11:10', 50),
(489, 2846, 'Bhubaneshwar Exp', 'Yesvantpur Jn', '7:45', 'Bhubaneswar', '11:30', 60),
(490, 2847, 'Amaravathi Exp', 'Howrah Jn', '23:45', 'Vasco Da Gama', '14:20', 70),
(491, 2848, 'Vsg Howrah Exp', 'Vasco Da Gama', '7:50', 'Howrah Jn', '22:30', 80),
(492, 2851, 'Bsp Mas Exp', 'Bilaspur Jn', '8:45', 'Chennai Central', '8:55', 100),
(493, 2852, 'Bilaspur Express', 'Chennai Central', '21:10', 'Bilaspur Jn', '20:05', 30),
(494, 2853, 'Amarkantak Exp', 'Durg', '18:20', 'Bhopal Jn', '10:30', 40),
(495, 2854, 'Amarkantak Exp', 'Bhopal Jn', '15:45', 'Durg', '7:55', 50),
(496, 2859, 'Gitanjali Exp.', 'Mumbai Cst', '6:00', 'Howrah Jn', '12:15', 60),
(497, 2860, 'Gitanjali Exp', 'Howrah Jn', '14:05', 'Mumbai Cst', '21:30', 70),
(498, 2861, 'Link-Daksin Exp', 'Vishakapatnam', '15:10', 'H Nizamuddin', '4:05', 80),
(499, 2863, 'Hwh Ypr Express', 'Howrah Jn', '20:35', 'Yesvantpur Jn', '8:10', 100),
(500, 2864, 'Ypr Howrah Exp', 'Yesvantpur Jn', '19:30', 'Howrah Jn', '6:15', 40),
(501, 2867, 'Shm Digha Exp', 'Shalimar', '8:00', 'Digha Flag Stn', '11:20', 50),
(502, 0, 'Hwh Dgha Exp', 'Howrah Jn', '7:55', 'Digha Flag Stn', '11:20', 60),
(503, 2868, 'Digha Src Exp', 'Digha Flag Stn', '13:35', 'Santragachi Jn', '16:40', 70),
(504, 0, 'Dgha Hwh Exp', 'Digha Flag Stn', '13:35', 'Howrah Jn', '17:00', 80),
(505, 2869, 'Howrah Sup Exp', 'Mumbai Cst', '11:05', 'Howrah Jn', '19:15', 100),
(506, 2870, 'Hwh Cstm Express', 'Howrah Jn', '14:25', 'Mumbai Cst', '23:45', 30),
(507, 2871, 'Ispat Express', 'Howrah Jn', '6:50', 'Sambalpur', '16:50', 40),
(508, 2872, 'Ispat Express', 'Sambalpur', '8:40', 'Howrah Jn', '18:50', 50),
(509, 2874, 'Jharkhand Exp', 'Delhi', '19:45', 'Hatia', '19:55', 60),
(510, 2875, 'Neelachal Exp', 'Puri', '10:50', 'New Delhi', '21:10', 70),
(511, 2876, 'Neelachal Exp', 'New Delhi', '6:30', 'Puri', '17:10', 80),
(512, 2883, 'Rupasibangla Exp', 'Howrah Jn', '6:00', 'Purulia Jn', '11:50', 100),
(513, 2884, 'Rupasibangla Exp', 'Purulia Jn', '15:35', 'Howrah Jn', '21:25', 30),
(514, 2887, 'Hwh Puri Express', 'Howrah Jn', '21:35', 'Puri', '6:35', 40),
(515, 2888, 'Puri Hwh Express', 'Puri', '22:00', 'Howrah Jn', '7:00', 50),
(516, 2889, 'Tata Ypr Exp', 'Tatanagar Jn', '18:50', 'Yesvantpur Jn', '5:00', 60),
(517, 2890, 'Ypr Tata Exp', 'Yesvantpur Jn', '8:30', 'Tatanagar Jn', '18:55', 70),
(518, 2895, 'Hwh Puri Express', 'Howrah Jn', '21:35', 'Puri', '6:35', 80),
(519, 2896, 'Puri Hwh Express', 'Puri', '22:00', 'Howrah Jn', '7:00', 100),
(520, 2897, 'Pdy Bbs Express', 'Pondicherry', '18:15', 'Bhubaneswar', '19:25', 30),
(521, 2898, 'Bbs Pdy Express', 'Bhubaneswar', '11:45', 'Pondicherry', '13:35', 40),
(522, 2901, 'Gujarat Mail', 'Mumbai Central', '21:50', 'Ahmedabad Jn', '6:20', 50),
(523, 2902, 'Gujarat Mail', 'Ahmedabad Jn', '22:05', 'Mumbai Central', '6:40', 60),
(524, 2905, 'Pbr Howrah Exp', 'Porbandar', '6:40', 'Howrah Jn', '3:45', 70),
(525, 2906, 'Hwh Pbr Express', 'Howrah Jn', '22:55', 'Porbandar', '18:15', 80),
(526, 2907, 'Bdts Smprk K Exp', 'Bandra Terminus', '16:50', 'H Nizamuddin', '13:40', 100),
(527, 2913, 'Trishatabdi Exp', 'Indore Jn Bg', '20:45', 'Nagpur', '8:25', 30),
(528, 2914, 'Trishatabdi Exp', 'Nagpur', '19:15', 'Indore Jn Bg', '6:55', 40),
(529, 2915, 'Ashram Express', 'Ahmedabad Jn', '17:45', 'Delhi', '10:25', 50),
(530, 2916, 'Ashram Express', 'Delhi', '15:05', 'Ahmedabad Jn', '7:40', 60),
(531, 2919, 'Malwa Express', 'Indore Jn Bg', '12:25', 'Jammu Tawi', '16:15', 70),
(532, 2920, 'Malwa Express', 'Jammu Tawi', '9:00', 'Indore Jn Bg', '12:50', 80),
(533, 2923, 'Indb Nagpur Exp', 'Indore Jn Bg', '21:35', 'Nagpur', '8:25', 100),
(534, 2924, 'Ngp Indore Exp', 'Nagpur', '19:15', 'Indore Jn Bg', '5:50', 30),
(535, 2925, 'Paschim Express', 'Bandra Terminus', '11:35', 'Amritsar Jn', '19:05', 40),
(536, 2926, 'Paschim Express', 'Amritsar Jn', '8:15', 'Bandra Terminus', '15:15', 50),
(537, 0, 'Paschim Express', 'Kalka', '10:10', 'Bandra Terminus', '15:15', 60),
(538, 2927, 'Vadodara Exp', 'Mumbai Central', '23:35', 'Vadodara Jn', '6:15', 70),
(539, 2928, 'Vadodara Exp', 'Vadodara Jn', '22:40', 'Mumbai Central', '5:00', 80),
(540, 2933, 'Karnavati Exp', 'Mumbai Central', '13:40', 'Ahmedabad Jn', '21:20', 100),
(541, 2934, 'Karnavati Exp', 'Ahmedabad Jn', '4:55', 'Mumbai Central', '12:35', 30),
(542, 2935, 'Bdts Surat Exp', 'Bandra Terminus', '6:50', 'Surat', '11:15', 40),
(543, 2936, 'Surat Bdts Exp', 'Surat', '15:55', 'Bandra Terminus', '20:25', 50),
(544, 2941, 'Adi Asansol Exp', 'Ahmedabad Jn', '23:35', 'Asansol Jn', '10:10', 60),
(545, 2942, 'Asn Adi Sup Exp', 'Asansol Jn', '19:35', 'Ahmedabad Jn', '5:50', 70),
(546, 2943, 'Udyogkarmi Exp', 'Valsad', '19:40', 'Kanpur Central', '19:20', 80),
(547, 2944, 'Udhyogkarmi Exp', 'Kanpur Central', '8:00', 'Valsad', '7:35', 100),
(548, 2945, 'Tapti Ganga Exp', 'Surat', '9:35', 'Varanasi Jn', '10:40', 30),
(549, 2946, 'Tapti Ganga Exp', 'Varanasi Jn', '17:35', 'Surat', '18:30', 40),
(550, 2947, 'Azimabad Express', 'Ahmedabad Jn', '21:25', 'Patna Jn', '4:35', 50),
(551, 2948, 'Azimabad Express', 'Patna Jn', '23:00', 'Ahmedabad Jn', '5:50', 60),
(552, 2955, 'Bct Jp Express', 'Mumbai Central', '18:50', 'Jaipur', '12:55', 70),
(553, 2961, 'Avantika Exp', 'Mumbai Central', '19:05', 'Indore Jn Bg', '9:20', 80),
(554, 2962, 'Avantika Exp', 'Indore Jn Bg', '15:50', 'Mumbai Central', '6:30', 100),
(555, 2963, 'Mewar Express', 'H Nizamuddin', '19:00', 'Udaipur City', '7:00', 30),
(556, 2964, 'Mewar Express', 'Udaipur City', '18:35', 'H Nizamuddin', '6:15', 40),
(557, 2965, 'Jp Udz Sup Exp', 'Jaipur', '22:25', 'Udaipur City', '7:45', 50),
(558, 2966, 'Udz Jp Sup Exp', 'Udaipur City', '21:40', 'Jaipur', '7:10', 60),
(559, 2967, 'Jaipur Exp', 'Chennai Central', '17:30', 'Jaipur', '6:20', 70),
(560, 2968, 'Jp Madras Expres', 'Jaipur', '19:40', 'Chennai Central', '10:35', 80),
(561, 2969, 'Cbe Jaipur Exp', 'Coimbatore Jn', '9:15', 'Jaipur', '6:20', 100),
(562, 2970, 'Jp Cbe Sup Exp', 'Jaipur', '19:40', 'Coimbatore Jn', '19:15', 30),
(563, 2971, 'Bhavnagar Exp', 'Bandra Terminus', '21:25', 'Bhavnagar Trmus', '11:30', 40),
(564, 2972, 'Bvc Bdts Express', 'Bhavnagar Trmus', '20:45', 'Bandra Terminus', '10:30', 50),
(565, 2973, 'Jaipur Express', 'Indore Jn Bg', '22:30', 'Jaipur', '8:30', 60),
(566, 2974, 'Jp Indb Express', 'Jaipur', '21:15', 'Indore Jn Bg', '6:55', 70),
(567, 2975, 'Jaipur Express', 'Mysore Jn', '10:15', 'Jaipur', '6:05', 80),
(568, 2976, 'Jp Mysore Exp', 'Jaipur', '19:40', 'Mysore Jn', '16:10', 100),
(569, 2977, 'Maru Sagar Exp', 'Eranakulam Jn', '19:55', 'Jaipur', '14:05', 30),
(570, 2978, 'Maru Sagar Exp', 'Jaipur', '10:05', 'Eranakulam Jn', '4:30', 40),
(571, 2980, 'Jp Bdts Sup Exp', 'Jaipur', '20:40', 'Bandra Terminus', '14:25', 50),
(572, 2985, 'Sdah Jp Express', 'Sealdah', '22:50', 'Jaipur', '23:30', 60),
(573, 2986, 'Jp Sdah Express', 'Jaipur', '11:35', 'Sealdah', '13:05', 70),
(574, 2989, 'Ajmer Express', 'Mumbai Central', '14:20', 'Ajmer Jn', '8:15', 80),
(575, 2990, 'Aii Bct Express', 'Ajmer Jn', '19:30', 'Mumbai Central', '13:05', 100),
(576, 3005, 'Amritsar Mail', 'Howrah Jn', '19:10', 'Amritsar Jn', '8:10', 30),
(577, 3006, 'Asr Hwh Mail', 'Amritsar Jn', '18:45', 'Howrah Jn', '7:30', 40),
(578, 3007, 'U/Abhatoofanexp', 'Howrah Jn', '9:40', 'Shri Ganganagar', '7:50', 50),
(579, 3008, 'U A Toofan Exp', 'Shri Ganganagar', '20:45', 'Howrah Jn', '19:20', 60),
(580, 3009, 'Doon Express', 'Howrah Jn', '20:35', 'Dehradun', '6:45', 70),
(581, 3010, 'Doon Express', 'Dehradun', '20:25', 'Howrah Jn', '7:00', 80),
(582, 3011, 'Hwh Mldt Int Exp', 'Howrah Jn', '15:25', 'Malda Town', '22:50', 100),
(583, 3012, 'Mldt Hwh Int Exp', 'Malda Town', '4:30', 'Howrah Jn', '11:25', 30),
(584, 3017, 'Ganadevta Exp', 'Howrah Jn', '6:05', 'Azimganj Jn', '13:05', 40),
(585, 3018, 'Ganadevta Exp', 'Rampur Hat', '17:20', 'Howrah Jn', '21:45', 50),
(586, 3019, 'Bagh Express', 'Howrah Jn', '21:45', 'Kathgodam', '9:30', 60),
(587, 3020, 'Bagh Express', 'Kathgodam', '21:55', 'Howrah Jn', '12:40', 70),
(588, 3021, 'Mithila Express', 'Howrah Jn', '15:45', 'Raxual Jn', '8:25', 80),
(589, 3022, 'Mithila Express', 'Raxual Jn', '10:05', 'Howrah Jn', '4:00', 100),
(590, 3023, 'Hwh Gaya Express', 'Howrah Jn', '19:50', 'Gaya Jn', '11:05', 30),
(591, 3024, 'Gaya Hwh Express', 'Gaya Jn', '12:20', 'Howrah Jn', '3:45', 40),
(592, 3025, 'Hwh Bpl Express', 'Howrah Jn', '12:50', 'Bhopal Jn', '18:30', 50),
(593, 3026, 'Bpl Howrah Exp', 'Bhopal Jn', '7:35', 'Howrah Jn', '15:05', 60),
(594, 3039, 'Janta Express', 'Howrah Jn', '20:20', 'Rajgir', '12:15', 70),
(595, 3049, 'Amritsar Exp', 'Howrah Jn', '14:00', 'Amritsar Jn', '10:05', 80),
(596, 3050, 'Asr Hwh Express', 'Amritsar Jn', '17:40', 'Howrah Jn', '16:00', 100),
(597, 3071, 'Hwh Jmp Express', 'Howrah Jn', '21:45', 'Jamalpur Jn', '7:25', 30),
(598, 3072, 'Jmp Hwh Exp', 'Jamalpur Jn', '17:55', 'Howrah Jn', '4:40', 40),
(599, 3103, 'Bhagirathi Exp', 'Sealdah', '18:25', 'Lalgola', '23:20', 50),
(600, 3104, 'Bhagirathi Exp', 'Lalgola', '5:30', 'Sealdah', '10:25', 60),
(601, 3105, 'Sdah Bui Express', 'Sealdah', '13:15', 'Ballia', '6:15', 70),
(602, 3106, 'Bui Sdah Exp', 'Ballia', '9:10', 'Sealdah', '3:30', 80),
(603, 3111, 'Lal Quila Exp', 'Kolkata', '20:10', 'Delhi', '3:20', 100),
(604, 3112, 'Lal Quila Exp', 'Delhi', '20:55', 'Kolkata', '7:15', 30),
(605, 3133, 'Sdah Bsb Exp', 'Sealdah', '20:40', 'Varanasi Jn', '22:20', 40),
(606, 3134, 'Bsb Sdah Express', 'Varanasi Jn', '9:25', 'Sealdah', '11:00', 50),
(607, 3141, 'Testa Torsa Exp', 'Sealdah', '13:35', 'New Alipurdaur', '7:15', 60),
(608, 3142, 'Testa Torsa Exp', 'New Alipurdaur', '11:45', 'Sealdah', '5:00', 70),
(609, 0, 'Teesta Torsa Exp', 'Jalpaiguri', '13:45', 'Sealdah', '5:00', 80),
(610, 3145, 'Radhikapur Exp', 'Kolkata', '19:30', 'Radhikapur', '7:45', 30),
(611, 3146, 'Rdp Kokata Exp', 'Kaliyanganj', '18:06', 'Kolkata', '5:45', 40),
(612, 3147, 'Uttar Banga Exp', 'Sealdah', '19:35', 'New Cooch Behar', '9:20', 50),
(613, 3148, 'Uttar Banga Exp', 'New Cooch Behar', '17:15', 'Sealdah', '8:15', 60),
(614, 3149, 'Kanchankanya Exp', 'Sealdah', '19:35', 'Alipur Duar Jn', '11:10', 70),
(615, 3150, 'Kanchankanya Exp', 'Alipur Duar Jn', '16:45', 'Sealdah', '8:15', 80),
(616, 3151, 'Jammu Tawi Exp', 'Kolkata', '11:45', 'Jammu Tawi', '8:50', 100),
(617, 3152, 'Sealdah Express', 'Jammu Tawi', '19:15', 'Kolkata', '15:50', 30),
(618, 3153, 'Gour Express', 'Sealdah', '22:15', 'Malda Town', '6:15', 40),
(619, 3154, 'Gour Exp', 'Malda Town', '21:35', 'Sealdah', '6:15', 50),
(620, 3155, 'Mithilanchal Exp', 'Kolkata', '20:55', 'Darbhanga Jn', '9:20', 60),
(621, 3156, 'Mithilanchal Exp', 'Darbhanga Jn', '14:45', 'Kolkata', '3:45', 70),
(622, 3157, 'Tirhut Express', 'Kolkata', '20:55', 'Muzaffarpur Jn', '9:15', 80),
(623, 3158, 'Tirhut Express', 'Muzaffarpur Jn', '14:50', 'Kolkata', '3:45', 100),
(624, 3163, 'Hate Bazare Exp', 'Sealdah', '20:00', 'Saharsa Jn', '12:15', 30),
(625, 3164, 'Hate Bazare Exp', 'Saharsa Jn', '14:20', 'Sealdah', '8:05', 40),
(626, 3185, 'Gangasagar Exp', 'Sealdah', '15:40', 'Darbhanga Jn', '5:25', 50),
(627, 3186, 'Dbg Sdah Exp', 'Darbhanga Jn', '18:55', 'Sealdah', '6:55', 60),
(628, 3201, 'Rjpb(T)-Ltt Exp', 'Rjndr Ngr Bihar', '22:40', 'Lokmanyatilak T', '11:30', 70),
(629, 3202, 'Ltt Rjpb Exp', 'Lokmanyatilak T', '22:10', 'Rjndr Ngr Bihar', '9:45', 80),
(630, 3225, 'Intercity Expres', 'Darbhanga Jn', '14:05', 'Danapur', '20:15', 100),
(631, 0, 'Shc Dnr Link Exp', 'Saharsa Jn', '12:50', 'Danapur', '20:15', 30);
INSERT INTO `trains` (`TrainID`, `TrainNo`, `TrainName`, `Source`, `DepTime`, `Destination`, `ArrTime`, `KiloMeter`) VALUES
(632, 3226, 'Intercity Expres', 'Danapur', '6:50', 'Darbhanga Jn', '12:20', 40),
(633, 0, 'Dnr Shc Link Exp', 'Danapur', '6:50', 'Saharsa Jn', '13:20', 50),
(634, 3233, 'Rajgriha Express', 'Rajgir', '15:00', 'Danapur', '18:20', 60),
(635, 3234, 'Rajgriha Express', 'Danapur', '8:50', 'Rajgir', '12:35', 70),
(636, 3235, 'Intercity Exp', 'Sahibganj Jn', '14:30', 'Danapur', '22:35', 80),
(637, 3236, 'Intercity Exp', 'Danapur', '5:05', 'Sahibganj Jn', '12:30', 100),
(638, 3241, 'Banka Dnr Exp', 'Banka Road Oa', '7:45', 'Danapur', '15:35', 30),
(639, 3242, 'Dnr Banka Exp', 'Danapur', '22:40', 'Banka Road Oa', '6:45', 40),
(640, 3245, 'Capital Express', 'New Jalpaiguri', '14:30', 'Danapur', '4:15', 50),
(641, 3246, 'Capital Exp', 'Danapur', '22:15', 'New Jalpaiguri', '11:40', 60),
(642, 3287, 'South Bihar Exp', 'Durg', '7:00', 'Danapur', '7:00', 70),
(643, 3288, 'South Bihar Exp', 'Danapur', '20:00', 'Durg', '20:40', 80),
(644, 3301, 'Subarnarekha Exp', 'Dhanbad Jn', '5:35', 'Tatanagar Jn', '11:15', 100),
(645, 3302, 'Subarnarekha Exp', 'Tatanagar Jn', '13:30', 'Dhanbad Jn', '19:10', 30),
(646, 3303, 'Dhn Hte Int Exp', 'Dhanbad Jn', '5:40', 'Hatia', '10:25', 40),
(647, 3304, 'Hte Dhn Int Exp', 'Hatia', '17:50', 'Dhanbad Jn', '22:25', 50),
(648, 3307, 'Gangasutlej Exp', 'Dhanbad Jn', '21:30', 'Firozpur Cant', '9:25', 60),
(649, 3308, 'Gangasatluj Exp', 'Firozpur Cant', '18:25', 'Dhanbad Jn', '4:55', 70),
(650, 3317, 'Blackdiamond Exp', 'Howrah Jn', '6:15', 'Dhanbad Jn', '11:10', 80),
(651, 3318, 'Blackdiamond Exp', 'Dhanbad Jn', '16:30', 'Howrah Jn', '21:25', 100),
(652, 3329, 'Gangadamodarexp', 'Dhanbad Jn', '23:10', 'Rjndr Ngr Bihar', '5:50', 30),
(653, 3330, 'Gangadamodarexp', 'Rjndr Ngr Bihar', '23:10', 'Dhanbad Jn', '5:20', 40),
(654, 3347, 'Palamou Express', 'Barka Kana', '18:00', 'Rjndr Ngr Bihar', '6:35', 50),
(655, 0, 'Sgrl Ghdlink Exp', 'Singrauli', '16:10', 'Rjndr Ngr Bihar', '6:35', 60),
(656, 3348, 'Palamau Exp', 'Rjndr Ngr Bihar', '21:35', 'Barka Kana', '10:05', 70),
(657, 3351, 'Dhn Allp Express', 'Dhanbad Jn', '11:00', 'Alleppey', '20:05', 80),
(658, 3352, 'Dhanbad Express', 'Alleppey', '6:00', 'Dhanbad Jn', '13:10', 100),
(659, 3401, 'Intercity Exp', 'Bhagalpur', '5:30', 'Danapur', '12:00', 30),
(660, 3402, 'Intercity Exp', 'Danapur', '16:15', 'Bhagalpur', '22:40', 40),
(661, 3403, 'Vananchal Exp', 'Ranchi', '14:50', 'Bhagalpur', '5:15', 50),
(662, 3404, 'Vananchal Exp', 'Bhagalpur', '15:00', 'Ranchi', '5:15', 60),
(663, 3405, 'Vananchal Exp', 'Ranchi', '14:50', 'Bhagalpur', '4:00', 70),
(664, 3406, 'Vananchal Exp', 'Bhagalpur', '16:55', 'Ranchi', '5:15', 80),
(665, 3409, 'Mldt Bgp Int Exp', 'Malda Town', '5:40', 'Bhagalpur', '10:20', 100),
(666, 3410, 'Bgp Mldt Int Exp', 'Bhagalpur', '16:30', 'Malda Town', '21:00', 40),
(667, 3413, 'Farakka Express', 'Malda Town', '19:10', 'Delhi', '4:30', 50),
(668, 3414, 'Farkka Express', 'Delhi', '21:45', 'Malda Town', '7:30', 60),
(669, 3419, 'Janasewa Express', 'Bhagalpur', '14:10', 'Muzaffarpur Jn', '20:20', 70),
(670, 3420, 'Jansewa Express', 'Muzaffarpur Jn', '23:00', 'Bhagalpur', '5:55', 80),
(671, 3483, 'Farakka Express', 'Malda Town', '19:10', 'Delhi', '4:30', 100),
(672, 3484, 'Farakka Express', 'Delhi', '21:45', 'Malda Town', '7:30', 30),
(673, 3503, 'Intercity Exp', 'Sealdah', '16:40', 'Asansol Jn', '20:55', 40),
(674, 3504, 'Intercity Exp', 'Asansol Jn', '6:40', 'Sealdah', '10:45', 50),
(675, 4001, 'Dli Attari Exp', 'Delhi', '22:40', 'Atari', '6:20', 60),
(676, 4002, 'Attari Dli Exp', 'Atari', '20:35', 'Delhi', '3:20', 70),
(677, 4005, 'Lichchavi Exp', 'Samastipur Jn', '5:15', 'New Delhi', '4:35', 80),
(678, 4006, 'Lichchavi Exp', 'New Delhi', '15:45', 'Samastipur Jn', '18:55', 100),
(679, 4007, 'Sadbhawna Exp', 'Muzaffarpur Jn', '4:15', 'Delhi', '4:40', 30),
(680, 4008, 'Sadhbhawna Exp', 'Delhi', '16:35', 'Muzaffarpur Jn', '18:05', 40),
(681, 4013, 'Sln Dli Exp', 'Sultanpur', '15:30', 'Delhi', '4:40', 50),
(682, 4014, 'Sultanpur Exp', 'Delhi', '16:35', 'Sultanpur', '6:15', 60),
(683, 4015, 'Sadbhawana Exp', 'Raxual Jn', '0:35', 'Delhi', '4:40', 70),
(684, 4016, 'Sadhbhawna Exp', 'Delhi', '16:35', 'Raxual Jn', '21:30', 80),
(685, 4018, 'Sadbhavna Exp', 'Delhi', '16:35', 'Muzaffarpur Jn', '18:05', 100),
(686, 4033, 'Jammu Mail', 'Delhi', '21:15', 'Jammu Tawi', '10:30', 30),
(687, 0, 'Jammu Mail', 'Delhi', '21:15', 'Hoshiarpur', '6:25', 40),
(688, 4034, 'Jammu Mail', 'Jammu Tawi', '15:45', 'Delhi', '5:00', 50),
(689, 0, 'Jammu Mail', 'Hoshiarpur', '19:15', 'Delhi', '5:00', 60),
(690, 4035, 'Dauladhar Exp', 'Delhi', '21:50', 'Pathankot', '7:55', 70),
(691, 4036, 'Dauladhar Exp', 'Pathankot', '21:35', 'Delhi', '7:40', 80),
(692, 4041, 'Mussoorie Exp', 'Delhi S Rohilla', '21:10', 'Dehradun', '8:00', 100),
(693, 4042, 'Mussoorie Exp', 'Dehradun', '21:30', 'Delhi S Rohilla', '8:10', 30),
(694, 0, 'Mussoorie Exp', 'Kotdwara', '22:00', 'Delhi S Rohilla', '8:10', 40),
(695, 4043, 'Garhwal Express', 'Kotdwara', '16:00', 'Delhi', '22:55', 50),
(696, 4044, 'Garhwal Express', 'Delhi', '7:00', 'Kotdwara', '14:20', 60),
(697, 4055, 'Brahmputra Mail', 'Dibrugarh Town', '22:45', 'Delhi', '5:25', 70),
(698, 4056, 'Brahmputra Mail', 'Delhi', '23:40', 'Dibrugarh Town', '4:00', 80),
(699, 4059, 'Dli Jsm Express', 'Delhi', '17:45', 'Jaisalmer', '13:00', 100),
(700, 4060, 'Jsm Dli Express', 'Jaisalmer', '16:00', 'Delhi', '11:05', 30),
(701, 0, 'Malani Exp', 'Barmer', '18:30', 'Delhi', '11:05', 40),
(702, 4083, 'Mahananda Exp', 'Alipur Duar Jn', '7:30', 'Delhi', '18:05', 50),
(703, 4084, 'Mahananda Exp', 'Delhi', '6:40', 'Alipur Duar Jn', '17:20', 60),
(704, 4114, 'Link Express', 'Dehradun', '13:20', 'Allahabad Jn', '8:30', 70),
(705, 4115, 'Ald Hw Exp', 'Allahabad Jn', '23:40', 'HarTrainIDwar Jn', '14:30', 80),
(706, 4116, 'Hw Ald Exp', 'HarTrainIDwar Jn', '16:20', 'Allahabad Jn', '7:45', 100),
(707, 4119, 'Kgm Ddn Express', 'Kathgodam', '19:40', 'Dehradun', '4:05', 30),
(708, 4120, 'Ddn Kgm Express', 'Dehradun', '22:30', 'Kathgodam', '7:15', 40),
(709, 4163, 'Sangam Express', 'Allahabad Jn', '17:30', 'Meerut City', '7:10', 50),
(710, 4164, 'Sangam Exp', 'Meerut City', '19:00', 'Allahabad Jn', '8:30', 60),
(711, 4201, 'Lko Mtj Express', 'Lucknow', '23:30', 'Mathura Jn', '8:20', 70),
(712, 4202, 'Mtj Lko Express', 'Mathura Jn', '22:00', 'Lucknow', '6:05', 80),
(713, 4205, 'Fd Dli Exp', 'Faizabad Jn', '17:35', 'Delhi', '6:40', 100),
(714, 4206, 'Dli Fd Exp', 'Delhi', '19:55', 'Faizabad Jn', '7:30', 30),
(715, 4207, 'Rbl Dli Express', 'Rae Bareli Jn', '19:15', 'Delhi', '6:40', 40),
(716, 4208, 'Dli Rbl Exp', 'Delhi', '19:55', 'Rae Bareli Jn', '6:00', 50),
(717, 4215, 'Ganga Gomti Exp', 'Allahabad Jn', '6:00', 'Lucknow', '10:10', 60),
(718, 4216, 'Ganga Gomti Exp', 'Lucknow', '18:35', 'Allahabad Jn', '22:45', 70),
(719, 4227, 'Varuna Express', 'Varanasi Jn', '4:55', 'Lucknow', '10:20', 80),
(720, 4228, 'Varuna Exp', 'Lucknow', '18:00', 'Varanasi Jn', '23:30', 100),
(721, 0, 'Lko Sre Express', 'Lucknow', '22:30', 'Saharanpur', '9:55', 30),
(722, 0, 'Sre Lko Express', 'Saharanpur', '20:40', 'Lucknow', '8:35', 40),
(723, 4257, 'K V Exp', 'Varanasi Jn', '13:45', 'New Delhi', '6:25', 50),
(724, 4258, 'Kashi V Express', 'New Delhi', '13:30', 'Varanasi Jn', '5:50', 60),
(725, 4265, 'Bsb Ddn Exp', 'Varanasi Jn', '8:30', 'Dehradun', '9:40', 70),
(726, 4266, 'Ddn Bsb Express', 'Dehradun', '18:15', 'Varanasi Jn', '18:30', 80),
(727, 4307, 'Mgs Be Pass Exp', 'Mughal Sarai Jn', '16:30', 'Bareilly', '10:45', 100),
(728, 4309, 'Ujjaini Express', 'Ujjain Jn', '15:00', 'Dehradun', '19:00', 30),
(729, 4310, 'Ujjaiyani Exp', 'Dehradun', '6:00', 'Ujjain Jn', '9:25', 40),
(730, 4311, 'Ala Hazrat Exp', 'Bareilly', '6:10', 'Bhuj', '14:50', 50),
(731, 4312, 'Ala Hazrat Exp', 'Bhuj', '11:05', 'Bareilly', '20:05', 60),
(732, 4313, 'Bareilly Exp', 'Lokmanyatilak T', '7:45', 'Bareilly', '15:55', 70),
(733, 4314, 'Be Ltt Express', 'Bareilly', '10:45', 'Lokmanyatilak T', '20:00', 80),
(734, 4315, 'Intercity Exp', 'Bareilly', '4:55', 'New Delhi', '10:10', 100),
(735, 4316, 'Intercity Exp', 'New Delhi', '16:25', 'Bareilly', '21:35', 30),
(736, 4317, 'Ind Ddn Express', 'Indore Jn Bg', '16:05', 'Dehradun', '19:00', 40),
(737, 4318, 'Ddn Indb Exp', 'Dehradun', '6:00', 'Indore Jn Bg', '8:00', 50),
(738, 4321, 'Be Bhuj Exp', 'Bareilly', '6:10', 'Bhuj', '10:15', 60),
(739, 4322, 'Bareilly Express', 'Bhuj', '15:40', 'Bareilly', '20:05', 70),
(740, 4369, 'Tribeni Express', 'Singrauli', '18:25', 'Bareilly', '14:10', 80),
(741, 0, 'Tribeni Express', 'Shakti Nagar', '17:55', 'Bareilly', '14:10', 100),
(742, 0, 'Tribeni Express', 'Daltonganj', '15:59', 'Bareilly', '14:10', 30),
(743, 4370, 'Triveni Exp', 'Bareilly', '12:00', 'Singrauli', '7:40', 40),
(744, 0, 'Triveni Exp', 'Bareilly', '12:00', 'Shakti Nagar', '8:10', 50),
(745, 4511, 'Nauchandi Exp', 'Allahabad Jn', '17:30', 'Saharanpur', '11:35', 60),
(746, 4512, 'Nauchandi Exp', 'Saharanpur', '17:00', 'Allahabad Jn', '9:55', 70),
(747, 0, 'Krj Ald Link Exp', 'Bulandshahr', '18:15', 'Allahabad Jn', '9:55', 80),
(748, 4517, 'Unchahar Exp', 'Allahabad Jn', '14:15', 'Ambala Cant Jn', '8:55', 100),
(749, 4518, 'Unchahar Exp', 'Ambala Cant Jn', '17:25', 'Allahabad Jn', '11:20', 30),
(750, 4519, 'Kisan Express', 'Delhi', '15:00', 'Bhatinda Jn', '22:20', 40),
(751, 4520, 'Kisan Express', 'Bhatinda Jn', '6:55', 'Delhi', '14:15', 50),
(752, 4524, 'Umb Mfp Express', 'Ambala Cant Jn', '22:15', 'Muzaffarpur Jn', '23:35', 60),
(753, 4553, 'Himachal Exp', 'Delhi', '23:20', 'Una Himachal', '7:50', 70),
(754, 4554, 'Himachal Express', 'Una Himachal', '20:50', 'Delhi', '5:35', 80),
(755, 4556, 'Bareilly Exp', 'Delhi', '6:10', 'Bareilly', '13:05', 100),
(756, 4601, 'Mour Dhwaj Exp', 'Sonpur Jn', '8:20', 'Jammu Tawi', '12:10', 30),
(757, 4602, 'Maur Dhawaj Exp', 'Jammu Tawi', '20:00', 'Sonpur Jn', '23:35', 40),
(758, 4609, 'Hemkunt Exp', 'Rishikesh', '16:20', 'Jammu Tawi', '4:20', 50),
(759, 4610, 'Hemkunt Exp', 'Jammu Tawi', '18:45', 'Rishikesh', '8:00', 60),
(760, 462, 'Rmr Bsb Express', 'Ramnagar', '20:25', 'Varanasi Jn', '18:40', 70),
(761, 4629, 'Satluj Express', 'Ludhiana Jn', '7:00', 'Firozpur Cant', '9:55', 80),
(762, 4630, 'Satluj Express', 'Firozpur Cant', '17:15', 'Ludhiana Jn', '19:45', 100),
(763, 4645, 'Shalimar Exp', 'New Delhi', '16:00', 'Jammu Tawi', '5:35', 30),
(764, 4646, 'Shalimar Exp', 'Jammu Tawi', '21:00', 'New Delhi', '10:45', 40),
(765, 4650, 'Saryuyamuna Exp', 'Amritsar Jn', '11:55', 'Darbhanga Jn', '22:45', 50),
(766, 4674, 'Shaheed Exp', 'Amritsar Jn', '11:55', 'Darbhanga Jn', '22:45', 60),
(767, 4681, 'Ndls Juc Expres', 'New Delhi', '14:45', 'Jalandhar City', '23:25', 70),
(768, 4682, 'Juc Ndls Expres', 'Jalandhar City', '4:20', 'New Delhi', '12:50', 80),
(769, 4707, 'Ranakpur Expres', 'Bikaner Jn', '9:45', 'Bandra Terminus', '11:30', 100),
(770, 4708, 'Ranakpur Expres', 'Bandra Terminus', '15:00', 'Bikaner Jn', '16:00', 30),
(771, 4710, 'Link Express', 'Bikaner Jn', '17:50', 'Rewari', '3:40', 40),
(772, 4711, 'Hw Sgnr Express', 'HarTrainIDwar Jn', '14:05', 'Shri Ganganagar', '23:45', 50),
(773, 4712, 'Sgnr Hw Express', 'Shri Ganganagar', '4:15', 'HarTrainIDwar Jn', '13:35', 60),
(774, 4715, 'Chetak Express', 'Rewari', '13:55', 'Chittaurgarh', '23:40', 70),
(775, 4723, 'Kalindi Express', 'Kanpur Central', '17:05', 'Bhiwani', '10:15', 80),
(776, 4724, 'Kalindi Express', 'Bhiwani', '18:15', 'Kanpur Central', '11:10', 30),
(777, 4731, 'Ndls Bti Exp', 'New Delhi', '14:15', 'Bhatinda Jn', '21:55', 40),
(778, 4732, 'Bti Ndls Expres', 'Bhatinda Jn', '5:00', 'New Delhi', '12:30', 50),
(779, 4737, 'Jp Bikaner Exp', 'Jaipur', '22:10', 'Bikaner Jn', '6:55', 60),
(780, 4738, 'Bkn Jaipur Exp', 'Bikaner Jn', '21:20', 'Jaipur', '5:45', 70),
(781, 4743, 'Re Md Express', 'Rewari', '23:05', 'Madar', '7:25', 80),
(782, 0, 'Aii Re Express', 'Ajmer Jn', '22:00', 'Rewari', '5:35', 100),
(783, 4789, 'Bikaner Express', 'Rewari', '10:50', 'Bikaner Jn', '19:15', 30),
(784, 4790, 'Bikaner Express', 'Bikaner Jn', '8:35', 'Rewari', '16:50', 40),
(785, 4791, 'Bikaner Mail', 'Rewari', '23:30', 'Bikaner Jn', '8:05', 50),
(786, 4792, 'Bikaner Mail', 'Bikaner Jn', '19:55', 'Rewari', '4:25', 60),
(787, 0, 'Bikaner Mail', 'Hanumangarh Jn', '18:00', 'Rewari', '4:25', 70),
(788, 4809, 'Jsm Ju Express', 'Jaisalmer', '23:15', 'Jodhpur Jn', '5:20', 80),
(789, 4810, 'Ju Jsm Express', 'Jodhpur Jn', '23:30', 'Jaisalmer', '5:20', 100),
(790, 4853, 'Marudhar Express', 'Varanasi Jn', '17:20', 'Jodhpur Jn', '18:20', 30),
(791, 4854, 'Marudhar Expres', 'Jodhpur Jn', '9:15', 'Varanasi Jn', '9:30', 40),
(792, 4863, 'Marudhar Expres', 'Varanasi Jn', '18:15', 'Jodhpur Jn', '18:20', 50),
(793, 4864, 'Marudhar Expres', 'Jodhpur Jn', '9:15', 'Varanasi Jn', '8:15', 60),
(794, 4887, 'Klk Bme Express', 'Kalka', '21:45', 'Barmer', '20:50', 70),
(795, 0, 'Hw Bme Link Exp', 'HarTrainIDwar Jn', '19:05', 'Barmer', '20:50', 80),
(796, 4888, 'Barmer Klk Exp', 'Barmer', '6:40', 'Kalka', '7:00', 100),
(797, 0, 'Bme Hw Link Exp', 'Barmer', '6:40', 'HarTrainIDwar Jn', '9:30', 30),
(798, 4889, 'Ju Mbf Link Exp', 'Jodhpur Jn', '1:00', 'Munabao', '7:00', 40),
(799, 5002, 'Ddn Mfp Exp', 'Dehradun', '15:35', 'Muzaffarpur Jn', '15:55', 50),
(800, 5003, 'Chaurichauraexp', 'Kanpur Anwrganj', '16:45', 'Gorakhpur Jn', '6:05', 60),
(801, 5004, 'Chaurichauraexp', 'Gorakhpur Jn', '22:45', 'Kanpur Anwrganj', '12:00', 70),
(802, 5005, 'Gkp Ddn Express', 'Gorakhpur Jn', '21:00', 'Dehradun', '14:00', 80),
(803, 5006, 'Ddn Gkp Exp', 'Dehradun', '15:35', 'Gorakhpur Jn', '7:50', 100),
(804, 5007, 'Muv Ljn Express', 'Manduadih', '16:40', 'Lucknow', '6:00', 30),
(805, 5008, 'Ljn Muv Exp', 'Lucknow', '23:00', 'Manduadih', '13:00', 40),
(806, 5009, 'Chitrakut Exp', 'Jabalpur', '19:15', 'Lucknow', '9:40', 50),
(807, 5010, 'Chitrakut Exp', 'Lucknow', '17:30', 'Jabalpur', '7:55', 60),
(808, 5013, 'Ranikhet Exp', 'Delhi S Rohilla', '21:55', 'Kathgodam', '5:45', 70),
(809, 5014, 'Ranikhet Exp', 'Kathgodam', '20:40', 'Delhi S Rohilla', '5:10', 80),
(810, 5017, 'Gorakhpur Exp', 'Lokmanyatilak T', '6:35', 'Gorakhpur Jn', '19:10', 100),
(811, 5018, 'Gkp Ltt Exp', 'Gorakhpur Jn', '5:20', 'Lokmanyatilak T', '18:40', 30),
(812, 5027, 'Maurya Exp', 'Hatia', '17:20', 'Gorakhpur Jn', '16:50', 40),
(813, 5028, 'Maurya Express', 'Gorakhpur Jn', '7:20', 'Hatia', '8:30', 50),
(814, 5035, 'Utr Samprk K Exp', 'Delhi', '16:05', 'Kathgodam', '22:35', 60),
(815, 5036, 'Utr Samprk K Exp', 'Kathgodam', '8:50', 'Delhi', '15:00', 70),
(816, 5045, 'Gorakhpur Exp', 'Okha', '18:45', 'Gorakhpur Jn', '20:25', 80),
(817, 5046, 'Gkp Okha Expres', 'Gorakhpur Jn', '4:05', 'Okha', '5:50', 100),
(818, 5047, 'Purbanchal Exp', 'Kolkata', '14:30', 'Gorakhpur Jn', '7:45', 30),
(819, 5048, 'Purvanchal Exp', 'Gorakhpur Jn', '11:30', 'Kolkata', '4:15', 40),
(820, 5049, 'Cp Gkp Exp', 'Kolkata', '14:30', 'Gorakhpur Jn', '9:45', 50),
(821, 5050, 'Gkp Kolkata Exp', 'Gorakhpur Jn', '8:10', 'Kolkata', '4:15', 60),
(822, 5051, 'Cp Gkp Exp', 'Kolkata', '14:30', 'Gorakhpur Jn', '8:15', 70),
(823, 5052, 'Gkp Kolkata Exp', 'Gorakhpur Jn', '10:10', 'Kolkata', '4:15', 80),
(824, 5098, 'Amarnath Exp', 'Jammu Tawi', '22:45', 'Barauni Jn', '5:45', 100),
(825, 5107, 'Chapra Ljn Exp', 'Chhapra', '19:05', 'Lucknow', '7:15', 30),
(826, 5108, 'Ljn Chapra Exp', 'Lucknow', '19:00', 'Chhapra', '8:25', 40),
(827, 5109, 'Budh Purnima Exp', 'Rajgir', '22:30', 'Sarnath', '9:20', 50),
(828, 5110, 'Budhpurnima Exp', 'Varanasi Jn', '20:40', 'Rajgir', '5:35', 60),
(829, 5159, 'Sarnath Express', 'Durg', '20:30', 'Chhapra', '21:45', 70),
(830, 5160, 'Sarnath Express', 'Chhapra', '7:20', 'Durg', '7:30', 80),
(831, 5204, 'Ljn Bju Exp', 'Lucknow', '15:15', 'Barauni Jn', '8:15', 100),
(832, 5227, 'Muzaffarpur Exp', 'Yesvantpur Jn', '23:55', 'Muzaffarpur Jn', '4:00', 40),
(833, 5273, 'Satyagrah Exp', 'Raxual Jn', '9:40', 'Delhi', '9:10', 50),
(834, 5274, 'Satyagrah Exp', 'Delhi', '17:15', 'Raxual Jn', '16:00', 60),
(835, 5277, 'Bagmati Express', 'Darbhanga Jn', '10:05', 'Bangalore Cy Jn', '16:50', 70),
(836, 5278, 'Bagmati Express', 'Bangalore Cy Jn', '6:45', 'Darbhanga Jn', '14:35', 80),
(837, 5279, 'Poorbiya Exp', 'Saharsa Jn', '10:35', 'Adrsh Ngr Delhi', '13:00', 100),
(838, 5280, 'Poorabiya Exp', 'Adrsh Ngr Delhi', '15:35', 'Saharsa Jn', '18:50', 30),
(839, 5281, 'Koshi Exp', 'Saharsa Jn', '5:30', 'Patna Jn', '10:15', 40),
(840, 5282, 'Koshi Exp', 'Patna Jn', '17:05', 'Saharsa Jn', '22:15', 50),
(841, 5307, 'Nainital Exp', 'Lal Kuan', '20:45', 'Aishbagh', '6:30', 60),
(842, 5308, 'Nainital Exp', 'Aishbagh', '21:00', 'Lal Kuan', '6:10', 70),
(843, 5311, 'Kumaon Express', 'Mathura Jn', '23:15', 'Lal Kuan', '8:25', 80),
(844, 5312, 'Kumaun Express', 'Lal Kuan', '19:05', 'Mathura Jn', '4:30', 100),
(845, 5313, 'Ash Mathura Exp', 'Aishbagh', '18:10', 'Mathura Jn', '8:50', 30),
(846, 5314, 'Mathura Ash Exp', 'Mathura Jn', '19:25', 'Aishbagh', '10:20', 40),
(847, 5315, 'Gokul Exp', 'Gonda Jn', '20:20', 'Mathura Jn', '12:20', 50),
(848, 5316, 'Gokul Express', 'Mathura Jn', '14:30', 'Gonda Jn', '7:05', 60),
(849, 5603, 'Inter City Exp', 'Guwahati', '20:30', 'Ledo', '10:15', 70),
(850, 5604, 'Intercity Exp', 'Tinsukia Jn', '16:35', 'Guwahati', '4:30', 80),
(851, 5609, 'Abadh Assam Exp', 'Guwahati', '21:30', 'Bikaner Jn', '5:46', 100),
(852, 5610, 'Avadh Assam Exp', 'Lalgarh Jn', '19:40', 'Guwahati', '4:00', 30),
(853, 5629, 'Guwahati Express', 'Chennai Egmore', '22:30', 'Guwahati', '4:55', 40),
(854, 5630, 'Guwahati Ms Exp', 'Guwahati', '15:00', 'Chennai Egmore', '20:30', 50),
(855, 5631, 'Bme Ghy Express', 'Barmer', '21:00', 'Guwahati', '23:15', 60),
(856, 0, 'Bkn Ghy Express', 'Bikaner Jn', '23:30', 'Guwahati', '23:15', 70),
(857, 5632, 'Ghy Bme Bkn Exp', 'Guwahati', '10:45', 'Barmer', '13:30', 80),
(858, 5635, 'Guwahati Express', 'Okha', '11:15', 'Guwahati', '7:30', 100),
(859, 5636, 'Dwarka Express', 'Guwahati', '10:45', 'Okha', '5:50', 30),
(860, 5639, 'Puri Ghy Express', 'Puri', '14:00', 'Guwahati', '22:00', 40),
(861, 5640, 'Ghy Puri Express', 'Guwahati', '18:45', 'Puri', '3:30', 50),
(862, 5641, 'Jhajha Ghy Exp', 'Jhajha', '22:00', 'Guwahati', '22:00', 60),
(863, 5642, 'Ghy Jhajha Exp', 'Guwahati', '18:30', 'Jhajha', '18:00', 70),
(864, 5645, 'Guwahati Express', 'Lokmanyatilak T', '7:45', 'Guwahati', '11:30', 80),
(865, 5646, 'Ghy Ltt Exp', 'Guwahati', '16:45', 'Lokmanyatilak T', '20:00', 100),
(866, 5647, 'Guwahati Express', 'Lokmanyatilak T', '7:45', 'Guwahati', '13:00', 30),
(867, 5648, 'Ghy Ltt Express', 'Guwahati', '15:00', 'Lokmanyatilak T', '20:00', 40),
(868, 5651, 'Kamrup Express', 'Guwahati', '13:15', 'Jammu Tawi', '12:45', 50),
(869, 5652, 'Lohit Express', 'Jammu Tawi', '22:45', 'Guwahati', '22:45', 60),
(870, 5653, 'Amarnath Express', 'Guwahati', '13:15', 'Jammu Tawi', '12:45', 70),
(871, 5654, 'Amarnath Express', 'Jammu Tawi', '22:45', 'Guwahati', '22:45', 80),
(872, 5657, 'Kanchanjanga Exp', 'Sealdah', '6:45', 'Guwahati', '4:30', 100),
(873, 5658, 'Kanchanjungaexp', 'Guwahati', '22:30', 'Sealdah', '19:25', 30),
(874, 5665, 'B G Express', 'Guwahati', '14:00', 'Dimapur', '19:30', 40),
(875, 5666, 'B G Express', 'Dimapur', '21:00', 'Guwahati', '3:45', 50),
(876, 5691, 'Cachar Express', 'Lumding Jn', '21:00', 'Silchar', '8:15', 60),
(877, 5692, 'Cachar Express', 'Silchar', '18:15', 'Lumding Jn', '5:30', 70),
(878, 5693, 'Barak Valley Exp', 'Lumding Jn', '6:15', 'Silchar', '19:00', 80),
(879, 5694, 'Barak Valley Exp', 'Silchar', '8:25', 'Lumding Jn', '20:45', 100),
(880, 5707, 'Kir Asr Express', 'Katihar Jn', '23:30', 'Amritsar Jn', '11:50', 30),
(881, 5708, 'Asr Kir Express', 'Amritsar Jn', '7:15', 'Katihar Jn', '20:10', 40),
(882, 5713, 'Intercity Exp', 'Katihar Jn', '6:30', 'Patna Jn', '13:05', 50),
(883, 5714, 'Intercity Exp', 'Patna Jn', '14:15', 'Katihar Jn', '21:20', 60),
(884, 5715, 'Garib Nawaj Exp', 'Kishanganj', '5:40', 'Ajmer Jn', '22:05', 70),
(885, 5716, 'Garib Nawaj Exp', 'Ajmer Jn', '10:45', 'Kishanganj', '5:25', 80),
(886, 5761, 'Rnc Apdj Express', 'Ranchi', '20:40', 'Alipur Duar Jn', '16:40', 100),
(887, 5762, 'Apdj Rnc Express', 'Alipur Duar Jn', '18:00', 'Ranchi', '14:20', 30),
(888, 5813, 'Arunachal Exp', 'Rangiya Jn', '19:15', 'Murkeongselek', '10:45', 40),
(889, 5814, 'Arunachal Exp', 'North Lakhimpur', '18:55', 'Rangiya Jn', '5:10', 50),
(890, 5929, 'Dibrugarh Exp', 'Chennai Egmore', '22:30', 'Dibrugarh Town', '20:55', 60),
(891, 5930, 'Dbrt Ms Express', 'Dibrugarh Town', '23:45', 'Chennai Egmore', '20:30', 70),
(892, 5933, 'Dbrt Asr Express', 'Dibrugarh Town', '6:45', 'Amritsar Jn', '21:15', 80),
(893, 5934, 'Asr Dbrt Express', 'Amritsar Jn', '16:00', 'Dibrugarh Town', '5:45', 100),
(894, 5959, 'Kamrup Express', 'Howrah Jn', '17:35', 'Dibrugarh Town', '6:30', 30),
(895, 5960, 'Kamrup Express', 'Dibrugarh Town', '18:00', 'Howrah Jn', '6:25', 40),
(896, 6009, 'Chennai Mail', 'Mumbai Cst', '23:35', 'Chennai Central', '5:00', 50),
(897, 6010, 'Mumbai Mail', 'Chennai Central', '22:50', 'Mumbai Cst', '3:45', 60),
(898, 0, 'Mas Mumbai Exp', 'Solapur Jn', '18:15', 'Gondia Jn', '21:10', 70),
(899, 6011, 'Cstm Chennai Exp', 'Mumbai Cst', '14:00', 'Chennai Central', '16:45', 80),
(900, 6012, 'Mumbai Express', 'Chennai Central', '11:45', 'Mumbai Cst', '13:45', 100),
(901, 6031, 'Andaman Express', 'Chennai Central', '5:15', 'Jammu Tawi', '14:10', 30),
(902, 6032, 'Andaman Express', 'Jammu Tawi', '23:30', 'Chennai Central', '10:15', 40),
(903, 6041, 'Alleppey Exp', 'Chennai Central', '21:15', 'Alleppey', '10:50', 50),
(904, 6042, 'Chennai Express', 'Alleppey', '16:10', 'Chennai Central', '6:05', 60),
(905, 6043, 'Circar Exp', 'Chennai Central', '17:45', 'Kakinada Port', '9:40', 70),
(906, 6044, 'Circar Exp', 'Kakinada Port', '14:40', 'Chennai Central', '6:30', 80),
(907, 6053, 'Tirupathi Exp', 'Chennai Central', '13:50', 'Tirupati', '17:00', 100),
(908, 6054, 'Madras Express', 'Tirupati', '10:05', 'Chennai Central', '13:20', 30),
(909, 6057, 'Sapthagiri Exp', 'Chennai Central', '6:25', 'Tirupati', '9:30', 40),
(910, 6058, 'Saptagiri Exp', 'Tirupati', '17:20', 'Chennai Central', '20:35', 50),
(911, 6093, 'Lucknow Exp', 'Chennai Central', '5:15', 'Lucknow', '20:55', 60),
(912, 6094, 'Ljn Mas Exp', 'Lucknow', '16:25', 'Chennai Central', '10:15', 70),
(913, 6123, 'Anantapuri Exp', 'Chennai Egmore', '19:30', 'Trivandrum Cntl', '11:35', 80),
(914, 6124, 'Anantapuri Exp', 'Trivandrum Cntl', '16:20', 'Chennai Egmore', '8:40', 100),
(915, 6125, 'Ms Jodhpur Exp', 'Chennai Egmore', '15:15', 'Jodhpur Jn', '11:15', 30),
(916, 6126, 'Ju Ms Express', 'Jodhpur Jn', '21:00', 'Chennai Egmore', '17:30', 40),
(917, 6127, 'Ms Guruvayur Exp', 'Chennai Egmore', '7:25', 'Guruvayur', '6:10', 50),
(918, 6128, 'Guv Chennai Exp', 'Guruvayur', '21:00', 'Chennai Egmore', '20:10', 60),
(919, 6177, 'Rock Fort Exp', 'Chennai Egmore', '22:30', 'Kumbakonam', '7:30', 70),
(920, 6178, 'Rockfort Express', 'Kumbakonam', '19:30', 'Chennai Egmore', '5:15', 80),
(921, 6201, 'Mys Dharwad Exp', 'Mysore Jn', '20:40', 'Dharwar', '5:55', 100),
(922, 0, 'Mys Shimoga Exp', 'Mysore Jn', '20:40', 'Shimoga Town', '4:55', 30),
(923, 6202, 'Dwr Mysore Exp', 'Dharwar', '20:20', 'Mysore Jn', '6:00', 40),
(924, 6203, 'Tirupathy Exp', 'Chennai Central', '16:35', 'Tirupati', '20:05', 50),
(925, 6215, 'Chamundi Exp', 'Mysore Jn', '6:45', 'Bangalore Cy Jn', '9:50', 60),
(926, 6216, 'Chamundi Expres', 'Bangalore Cy Jn', '18:15', 'Mysore Jn', '21:15', 70),
(927, 6221, 'Chennai Express', 'Mysore Jn', '20:05', 'Chennai Central', '7:20', 80),
(928, 6222, 'Mysore Express', 'Chennai Central', '21:30', 'Mysore Jn', '8:05', 100),
(929, 6227, 'Shimoga Express', 'Bangalore Cy Jn', '23:10', 'Shimoga Town', '4:55', 30),
(930, 6228, 'Bangalore Exp', 'Shimoga Town', '22:00', 'Bangalore Cy Jn', '5:00', 40),
(931, 0, 'Smet Mysore Exp', 'Shimoga Town', '22:00', 'Mysore Jn', '4:55', 50),
(932, 6231, 'Mysore Express', 'Mayiladuturai J', '17:30', 'Mysore Jn', '9:30', 60),
(933, 6232, 'Mailaduturai Ex', 'Mysore Jn', '15:45', 'Mayiladuturai J', '7:25', 70),
(934, 6301, 'Venad Express', 'Shoranur Jn', '14:30', 'Trivandrum Cntl', '22:10', 80),
(935, 6302, 'Venad Express', 'Trivandrum Cntl', '5:00', 'Shoranur Jn', '12:45', 100),
(936, 6303, 'Vanchinad Exp', 'Eranakulam Jn', '6:05', 'Trivandrum Cntl', '10:35', 30),
(937, 6304, 'Vanchinad Exp', 'Trivandrum Cntl', '17:30', 'Eranakulam Jn', '22:05', 40),
(938, 6305, 'Cannanore Exp', 'Eranakulam Jn', '6:45', 'Kannur', '12:50', 50),
(939, 6306, 'Ernakulam Exp', 'Kannur', '14:30', 'Eranakulam Jn', '20:25', 60),
(940, 6307, 'Cannanore Exp', 'Alleppey', '15:00', 'Kannur', '23:15', 70),
(941, 0, 'Cannanore Exp', 'Eranakulam Jn', '16:20', 'Kannur', '23:15', 80),
(942, 6308, 'Alleppey Exp', 'Kannur', '5:00', 'Alleppey', '12:55', 30),
(943, 0, 'Ernakulam Exp', 'Kannur', '5:00', 'Eranakulam Jn', '11:25', 40),
(944, 6309, 'Patna Express', 'Eranakulam Jn', '17:10', 'Patna Jn', '20:20', 50),
(945, 6310, 'Pnbe-Ers Express', 'Patna Jn', '14:00', 'Eranakulam Jn', '18:10', 60),
(946, 6311, 'Bkn Tvc Express', 'Bikaner Jn', '19:10', 'Trivandrum Cntl', '3:10', 70),
(947, 6312, 'Bikaner Express', 'Trivandrum Cntl', '15:15', 'Bikaner Jn', '22:00', 80),
(948, 6315, 'Kochuveli Exp', 'Bangalore Cy Jn', '18:55', 'Kochuveli', '11:10', 100),
(949, 6316, 'Bangalore Exp', 'Kochuveli', '14:15', 'Bangalore Cy Jn', '7:15', 30),
(950, 6317, 'Himsagar Exp', 'Kanyakumari', '14:05', 'Jammu Tawi', '14:10', 40),
(951, 6318, 'Himsagar Exp', 'Jammu Tawi', '23:30', 'Kanyakumari', '22:45', 50),
(952, 6321, 'Trivandrum Exp', 'Bangalore Cy Jn', '18:55', 'Trivandrum Cntl', '12:00', 60),
(953, 6322, 'Bangalore Exp', 'Trivandrum Cntl', '16:05', 'Bangalore Cy Jn', '9:45', 70),
(954, 6323, 'Howrah Exp', 'Trivandrum Cntl', '16:05', 'Howrah Jn', '13:55', 80),
(955, 6324, 'Hwh=Tvc Express', 'Howrah Jn', '23:15', 'Trivandrum Cntl', '23:30', 100),
(956, 6327, 'Krba Tvc Express', 'Korba', '19:50', 'Trivandrum Cntl', '17:55', 30),
(957, 6328, 'Korba Express', 'Trivandrum Cntl', '4:30', 'Korba', '4:15', 40),
(958, 6329, 'Malabar Exp', 'Trivandrum Cntl', '18:30', 'Mangalore', '10:10', 50),
(959, 0, 'Malabar Exp', 'Kottayam', '22:05', 'Mangalore', '10:10', 60),
(960, 6330, 'Malabar Express', 'Mangalore', '18:00', 'Trivandrum Cntl', '9:05', 70),
(961, 6331, 'Trivandram Exp', 'Mumbai Cst', '12:05', 'Trivandrum Cntl', '4:00', 80),
(962, 6332, 'Mumbai Exp', 'Trivandrum Cntl', '3:45', 'Mumbai Cst', '21:10', 100),
(963, 6333, 'Vrl Tvc Express', 'Veraval', '3:00', 'Trivandrum Cntl', '3:10', 30),
(964, 6334, 'Veraval Express', 'Trivandrum Cntl', '15:15', 'Veraval', '16:20', 40),
(965, 6335, 'Nagercoil Exp', 'GandhTrainIDham Bg', '5:00', 'Nagarcoil Jn', '4:40', 50),
(966, 6336, 'GandhTrainIDham Exp', 'Nagarcoil Jn', '13:30', 'GandhTrainIDham Jn.', '14:10', 60),
(967, 6337, 'Okha Ers Express', 'Okha', '1:45', 'Eranakulam Jn', '22:50', 70),
(968, 6338, 'Okha Express', 'Eranakulam Jn', '19:55', 'Okha', '17:30', 80),
(969, 6339, 'Nagarcoil Exp', 'Mumbai Cst', '12:05', 'Nagarcoil Jn', '3:00', 100),
(970, 6340, 'Mumbai Express', 'Nagarcoil Jn', '7:00', 'Mumbai Cst', '21:10', 30),
(971, 6341, 'Trivandrum Exp', 'Eranakulam Jn', '5:50', 'Trivandrum Cntl', '10:10', 40),
(972, 6342, 'Ernakulam Exp', 'Trivandrum Cntl', '17:00', 'Eranakulam Jn', '21:20', 50),
(973, 6343, 'Amritha Express', 'Trivandrum Cntl', '23:00', 'Palghat Town', '8:00', 60),
(974, 6344, 'Amritha Express', 'Palghat Town', '22:15', 'Trivandrum Cntl', '6:30', 70),
(975, 6345, 'Netravati Exp', 'Lokmanyatilak T', '11:40', 'Trivandrum Cntl', '18:40', 80),
(976, 6346, 'Netravathi Exp', 'Trivandrum Cntl', '10:00', 'Lokmanyatilak T', '16:40', 100),
(977, 6347, 'Mangalore Exp', 'Trivandrum Cntl', '20:45', 'Mangalore', '11:15', 30),
(978, 6348, 'Trivandrum Exp', 'Mangalore', '14:30', 'Trivandrum Cntl', '5:05', 40),
(979, 6349, 'Parasuram Exp', 'Trivandrum Cntl', '6:35', 'Mangalore', '20:20', 50),
(980, 6350, 'Parasuram Exp', 'Mangalore', '4:15', 'Trivandrum Cntl', '18:25', 60),
(981, 6351, 'Nagarcoil Exp', 'Mumbai Cst', '12:05', 'Nagarcoil Jn', '5:30', 70),
(982, 6352, 'Ncj Mumbai Exp', 'Nagarcoil Jn', '4:50', 'Mumbai Cst', '21:10', 80),
(983, 6359, 'Ers Patna Exp', 'Eranakulam Jn', '22:45', 'Patna Jn', '9:50', 100),
(984, 6360, 'Rjpb Ers Express', 'Patna Jn', '16:30', 'Eranakulam Jn', '4:00', 30),
(985, 6501, 'Adi Sbc Express', 'Ahmedabad Jn', '18:00', 'Bangalore Cy Jn', '4:45', 40),
(986, 6502, 'Ahmadabad Exp', 'Bangalore Cy Jn', '13:30', 'Ahmedabad Jn', '4:00', 50),
(987, 6505, 'Gimb Sbc Express', 'GandhTrainIDham Bg', '8:20', 'Bangalore Cy Jn', '4:00', 60),
(988, 6506, 'GandhTrainIDham Exp', 'Bangalore Cy Jn', '21:45', 'GandhTrainIDham Jn.', '14:10', 70),
(989, 6507, 'Ju Banglore Exp', 'Jodhpur Jn', '5:30', 'Bangalore Cy Jn', '4:00', 80),
(990, 6508, 'Jodhpur Express', 'Bangalore Cy Jn', '21:45', 'Jodhpur Jn', '17:00', 100),
(991, 6509, 'Aii Sbc Express', 'Ajmer Jn', '5:50', 'Bangalore Cy Jn', '4:00', 30),
(992, 6510, 'Ajmer Express', 'Bangalore Cy Jn', '21:45', 'Ajmer Jn', '17:10', 40),
(993, 6511, 'Ypr Bsp Express', 'Yesvantpur Jn', '23:40', 'Bilaspur Jn', '4:15', 50),
(994, 6512, 'Bsp Ypr Express', 'Bilaspur Jn', '21:10', 'Yesvantpur Jn', '4:00', 60),
(995, 6513, 'Basava Express', 'Yesvantpur Jn', '16:45', 'Bagalkot', '12:30', 70),
(996, 6514, 'Basava Express', 'Bagalkot', '13:35', 'Yesvantpur Jn', '10:00', 80),
(997, 6525, 'Bangalore Exp', 'Kanyakumari', '10:30', 'Bangalore Cy Jn', '7:00', 100),
(998, 6526, 'Kanyakumari Exp', 'Bangalore Cy Jn', '21:45', 'Kanyakumari', '18:00', 40),
(999, 6528, 'Yesvantpur Exp', 'Kannur', '17:45', 'Yesvantpur Jn', '7:25', 50),
(1000, 6529, 'Udyan Express', 'Mumbai Cst', '8:05', 'Bangalore Cy Jn', '8:50', 60),
(1001, 6530, 'Udyan Exp', 'Bangalore Cy Jn', '20:05', 'Mumbai Cst', '19:55', 70),
(1002, 6532, 'Garib Nawaz Exp', 'Yesvantpur Jn', '17:35', 'Ajmer Jn', '17:10', 80),
(1003, 6590, 'Ranichennama Exp', 'C Shahumharaj T', '14:05', 'Bangalore Cy Jn', '7:25', 100),
(1004, 6591, 'Hampi Express', 'Hubli Jn', '17:00', 'Bangalore Cy Jn', '5:55', 30),
(1005, 6592, 'Hampi Exp', 'Bangalore Cy Jn', '22:20', 'Hubli Jn', '11:00', 40),
(1006, 6593, 'Hampi Link Exp', 'Nanded', '6:00', 'Bangalore Cy Jn', '5:55', 50),
(1007, 6595, 'Sanghamitra Exp', 'Bangalore Cy Jn', '6:45', 'Patna Jn', '9:50', 60),
(1008, 6596, 'Sangha Mitra Exp', 'Patna Jn', '14:45', 'Bangalore Cy Jn', '16:50', 70),
(1009, 6603, 'Maveli Express', 'Mangalore', '23:00', 'Trivandrum Cntl', '12:30', 80),
(1010, 6604, 'Maveli Express', 'Trivandrum Cntl', '19:25', 'Mangalore', '8:50', 100),
(1011, 6607, 'Ms Mangalore Exp', 'Chennai Egmore', '22:00', 'Mangalore', '22:00', 30),
(1012, 6608, 'Maq Chennai Exp', 'Mangalore', '6:40', 'Chennai Egmore', '5:30', 40),
(1013, 6613, 'Coimbatore Exp', 'Rajkot Jn', '5:00', 'Coimbatore Jn', '3:00', 50),
(1014, 6614, 'Rajkot Express', 'Coimbatore Jn', '23:30', 'Rajkot Jn', '19:55', 60),
(1015, 6627, 'West Coast Exp', 'Chennai Central', '11:30', 'Mangalore', '5:00', 70),
(1016, 6628, 'West Coast Exp', 'Mangalore', '21:30', 'Chennai Central', '15:15', 80),
(1017, 6669, 'Yercaud Express', 'Chennai Central', '22:30', 'Erode Jn', '6:35', 100),
(1018, 6670, 'Yercaud Exp', 'Erode Jn', '21:00', 'Chennai Central', '4:30', 30),
(1019, 6687, 'Navyug Exp', 'Mangalore', '16:20', 'Jammu Tawi', '14:10', 40),
(1020, 6688, 'Navyug Express', 'Jammu Tawi', '23:30', 'Mangalore', '19:00', 50),
(1021, 6713, 'Sethu Express', 'Tambaram', '13:00', 'Rameswaram', '6:30', 60),
(1022, 6714, 'Sethu Express', 'Rameswaram', '15:10', 'Tambaram', '9:20', 70),
(1023, 6715, 'Madurai Express', 'Coimbatore Jn', '22:45', 'Madurai Jn', '5:00', 80),
(1024, 6716, 'Coimbatore Exp', 'Madurai Jn', '22:50', 'Coimbatore Jn', '4:30', 100),
(1025, 6731, 'Mysore Exp', 'Tuticorin', '17:00', 'Mysore Jn', '10:00', 30),
(1026, 6732, 'Tuticorin Exp', 'Mysore Jn', '18:00', 'Tuticorin', '10:30', 40),
(1027, 6733, 'Mdu Mmr Express', 'Madurai Jn', '23:45', 'Manmad Jn', '12:40', 50),
(1028, 6734, 'Mmr Madurai Exp', 'Manmad Jn', '21:40', 'Madurai Jn', '9:00', 60),
(1029, 6865, 'Ernakulam Exp', 'Tiruchchirapali', '19:50', 'Eranakulam Jn', '5:40', 70),
(1030, 6866, 'Tiruchchi Exp', 'Eranakulam Jn', '22:15', 'Tiruchchirapali', '7:50', 80),
(1031, 7015, 'Visakha Express', 'Bhubaneswar', '8:25', 'Secunderabad Jn', '7:30', 100),
(1032, 7016, 'Visakha Exp', 'Secunderabad Jn', '17:00', 'Bhubaneswar', '15:10', 30),
(1033, 7017, 'Rjt Sc Express', 'Rajkot Jn', '5:00', 'Secunderabad Jn', '10:30', 40),
(1034, 7018, 'Rajkot Express', 'Secunderabad Jn', '14:50', 'Rajkot Jn', '19:55', 50),
(1035, 7031, 'Hyderabad Exp', 'Mumbai Cst', '12:45', 'Hyderabad Decan', '5:55', 60),
(1036, 7032, 'Mumbai Exp', 'Hyderabad Decan', '20:40', 'Mumbai Cst', '13:05', 70),
(1037, 7037, 'Sc Bkn Exp', 'Secunderabad Jn', '23:00', 'Bikaner Jn', '17:10', 80),
(1038, 7038, 'Bkn Sc Exp', 'Bikaner Jn', '15:00', 'Secunderabad Jn', '8:50', 100),
(1039, 7039, 'Sc Ned Express', 'Secunderabad Jn', '7:20', 'Nanded', '13:35', 30),
(1040, 7040, 'Ned Sc Express', 'Nanded', '14:40', 'Secunderabad Jn', '20:30', 40),
(1041, 7049, 'Mtm Sc Exp', 'Machelipatnam', '19:45', 'Secunderabad Jn', '4:45', 50),
(1042, 7050, 'Machiliptnm Exp', 'Secunderabad Jn', '22:45', 'Machelipatnam', '7:15', 60),
(1043, 7057, 'Devagiri Exp', 'Mumbai Cst', '21:05', 'Secunderabad Jn', '14:15', 70),
(1044, 7058, 'Devagiri Exp', 'Secunderabad Jn', '13:45', 'Mumbai Cst', '7:25', 80),
(1045, 7063, 'Ajanta Express', 'Manmad Jn', '17:30', 'Secunderabad Jn', '9:00', 100),
(1046, 7064, 'Ajanta Exp', 'Secunderabad Jn', '17:45', 'Manmad Jn', '8:10', 30),
(1047, 7091, 'Sc Pnbe Express', 'Secunderabad Jn', '22:00', 'Patna Jn', '9:50', 40),
(1048, 7092, 'Rjpb Sc Express', 'Patna Jn', '16:30', 'Secunderabad Jn', '2:30', 50),
(1049, 7201, 'Golconda Exp', 'Guntur Jn', '5:45', 'Secunderabad Jn', '13:45', 60),
(1050, 7202, 'Golconda Exp', 'Secunderabad Jn', '13:05', 'Guntur Jn', '21:20', 70),
(1051, 7203, 'Bvc Kakinada Exp', 'Bhavnagar Trmus', '4:05', 'Kakinada Town', '21:15', 80),
(1052, 7204, 'Cct Bvc Express', 'Kakinada Town', '4:00', 'Bhavnagar Trmus', '20:40', 100),
(1053, 7209, 'Seshadri Express', 'Bangalore Cy Jn', '13:15', 'Kakinada Town', '8:45', 30),
(1054, 7210, 'Sheshadri Exp', 'Kakinada Town', '17:35', 'Bangalore Cy Jn', '12:35', 40),
(1055, 7225, 'Amaravathi Exp', 'Vijayawada Jn', '18:55', 'Hubli Jn', '10:00', 50),
(1056, 7226, 'Amaravati Exp', 'Hubli Jn', '11:30', 'Vijayawada Jn', '2:50', 60),
(1057, 7228, 'Vsg Bza Express', 'Vasco Da Gama', '6:50', 'Vijayawada Jn', '5:45', 70),
(1058, 7229, 'Sabari Express', 'Trivandrum Cntl', '7:10', 'Hyderabad Decan', '13:40', 80),
(1059, 7230, 'Sabari Exp', 'Hyderabad Decan', '12:00', 'Trivandrum Cntl', '18:55', 100),
(1060, 7233, 'Bhagyanagar Exp', 'Secunderabad Jn', '15:25', 'Sirpur Kagazngr', '21:40', 30),
(1061, 7234, 'Bhagyanagar Exp', 'Sirpur Kagazngr', '4:00', 'Secunderabad Jn', '10:20', 40),
(1062, 7239, 'Simhadri Exp', 'Guntur Jn', '8:00', 'Vishakapatnam', '17:50', 50),
(1063, 7240, 'Simhadri Express', 'Vishakapatnam', '7:10', 'Guntur Jn', '15:35', 60),
(1064, 7255, 'Ns Hydrabad Exp', 'Narasapur', '18:45', 'Hyderabad Decan', '5:25', 70),
(1065, 7256, 'Narasapur Exp', 'Hyderabad Decan', '21:45', 'Narasapur', '8:35', 80),
(1066, 7305, 'Nzm Link Exp', 'Hubli Jn', '16:20', 'H Nizamuddin', '6:30', 100),
(1067, 7309, 'Ypr Vasco Exp', 'Yesvantpur Jn', '15:15', 'Vasco Da Gama', '6:00', 30),
(1068, 7310, 'Ypr Biweekly Exp', 'Vasco Da Gama', '20:45', 'Yesvantpur Jn', '11:00', 40),
(1069, 7311, 'Mas Vasco Exp', 'Chennai Central', '14:00', 'Vasco Da Gama', '12:40', 50),
(1070, 7312, 'Vsg Chennai Exp', 'Vasco Da Gama', '14:30', 'Chennai Central', '13:10', 60),
(1071, 7313, 'Mas Hubli Exp', 'Chennai Central', '14:00', 'Hubli Jn', '6:15', 70),
(1072, 7314, 'Ubl Chennai Exp', 'Hubli Jn', '20:25', 'Chennai Central', '13:10', 80),
(1073, 7405, 'Krishna Express', 'Tirupati', '5:25', 'Nizamabad', '0:15', 100),
(1074, 7406, 'Krishna Exp', 'Nizamabad', '2:25', 'Tirupati', '21:15', 30),
(1075, 7416, 'Haripriya Exp', 'C Shahumharaj T', '11:35', 'Tirupati', '8:45', 40),
(1076, 7429, 'Rayalaseema Exp', 'Hyderabad Decan', '17:25', 'Tirupati', '8:45', 50),
(1077, 7430, 'Rayalaseema Exp', 'Tirupati', '19:15', 'Hyderabad Decan', '10:30', 60),
(1078, 7479, 'Puri Tpty Exp', 'Puri', '12:15', 'Tirupati', '16:05', 70),
(1079, 7480, 'Tpty Puri Exp', 'Tirupati', '10:35', 'Puri', '15:20', 80),
(1080, 7481, 'Bsp Tpty Express', 'Bilaspur Jn', '9:50', 'Tirupati', '16:05', 100),
(1081, 7482, 'Tpty Bsp Exp', 'Tirupati', '10:35', 'Bilaspur Jn', '18:15', 30),
(1082, 7487, 'Tirumala Exp', 'Tirupati', '19:50', 'Vishakapatnam', '10:55', 40),
(1083, 7488, 'Tirumala Exp', 'Vishakapatnam', '13:50', 'Tirupati', '5:00', 50),
(1084, 7603, 'Kcg Ypr Exp', 'Kacheguda', '21:15', 'Yesvantpur Jn', '10:30', 60),
(1085, 7604, 'Kacheguda Exp', 'Yesvantpur Jn', '16:10', 'Kacheguda', '5:00', 70),
(1086, 7605, 'Nandigram Exp', 'Mumbai Cst', '16:35', 'Nagpur', '18:10', 80),
(1087, 7606, 'Nandigram Exp', 'Nanded', '17:30', 'Mumbai Cst', '5:30', 100),
(1088, 7607, 'Tungabhadra Exp', 'Secunderabad Jn', '7:45', 'Kurnool Town', '12:20', 30),
(1089, 7608, 'Tungabhadra Exp', 'Kurnool Town', '15:10', 'Secunderabad Jn', '19:55', 40),
(1090, 7609, 'Pnbe Ned Pau Exp', 'Patna Jn', '23:00', 'Purna Jn', '7:15', 50),
(1091, 7610, 'Pau Pnbe Exp', 'Purna Jn', '18:10', 'Patna Jn', '4:10', 60),
(1092, 7617, 'Tapovan Express', 'Mumbai Cst', '6:10', 'Nanded', '18:05', 70),
(1093, 7618, 'Tapovan Exp', 'Nanded', '10:30', 'Mumbai Cst', '22:10', 80),
(1094, 7651, 'Kacheguda Exp', 'Chennai Egmore', '17:00', 'Kacheguda', '7:30', 100),
(1095, 7652, 'Kcg Ms Exp', 'Kacheguda', '15:20', 'Chennai Egmore', '6:40', 30),
(1096, 7688, 'Marathwada Exp', 'Mudkhed', '4:59', 'Manmad Jn', '13:05', 40),
(1097, 8005, 'Hwh Koraput Exp', 'Howrah Jn', '20:55', 'Koraput', '20:30', 50),
(1098, 8006, 'Koraput Hwh Exp', 'Koraput', '7:45', 'Howrah Jn', '7:30', 60),
(1099, 8029, 'Ltt Shalimar Exp', 'Lokmanyatilak T', '21:50', 'Shalimar', '12:15', 70),
(1100, 8030, 'Shm Ltt Express', 'Shalimar', '15:00', 'Lokmanyatilak T', '4:50', 80),
(1101, 8101, 'Tata Jat Exp', 'Tatanagar Jn', '14:50', 'Jammu Tawi', '11:45', 100),
(1102, 8102, 'Muri Express', 'Jammu Tawi', '14:30', 'Hatia', '10:05', 30),
(1103, 8103, 'Jalianwala B Exp', 'Tatanagar Jn', '13:50', 'Amritsar Jn', '23:35', 40),
(1104, 8104, 'Jalianwala B Exp', 'Amritsar Jn', '12:45', 'Tatanagar Jn', '21:35', 50),
(1105, 8181, 'Tata-Cpr Exp', 'Tatanagar Jn', '21:25', 'Chhapra', '16:20', 60),
(1106, 8182, 'Cpr Tata Exp', 'Chhapra', '12:45', 'Tatanagar Jn', '6:15', 70),
(1107, 8183, 'Tata Pnbe Exp', 'Tatanagar Jn', '8:00', 'Danapur', '19:25', 80),
(1108, 8184, 'Dnr-Tata===Exp', 'Danapur', '6:15', 'Tatanagar Jn', '17:10', 30),
(1109, 8189, 'Tata Allp Exp', 'Tatanagar Jn', '16:00', 'Alleppey', '20:05', 40),
(1110, 8201, 'Durg Gkp Express', 'Durg', '19:45', 'Gorakhpur Jn', '20:30', 50),
(1111, 8202, 'Gkp Durg Exp', 'Gorakhpur Jn', '13:30', 'Durg', '15:05', 60),
(1112, 8203, 'Durg Cnb Express', 'Durg', '19:45', 'Kanpur Central', '14:45', 70),
(1113, 8204, 'Betwa Express', 'Kanpur Central', '17:00', 'Durg', '13:05', 80),
(1114, 8205, 'Durg Gkp Exp', 'Durg', '19:45', 'Gorakhpur Jn', '21:00', 100),
(1115, 8206, 'Gkp Durg Exp', 'Gorakhpur Jn', '10:30', 'Durg', '13:05', 30),
(1116, 8233, 'Narmada Express', 'Indore Jn Bg', '17:00', 'Bilaspur Jn', '18:00', 40),
(1117, 8234, 'Narmada Pas/Exp', 'Bilaspur Jn', '9:40', 'Indore Jn Bg', '10:35', 50),
(1118, 8237, 'Chattisgarh Exp', 'Bilaspur Jn', '14:10', 'Amritsar Jn', '8:55', 60),
(1119, 8238, 'Chhatisgarh Exp', 'Amritsar Jn', '16:15', 'Bilaspur Jn', '11:50', 70),
(1120, 8239, 'Gad Ngp Exp', 'Gevra Road', '17:30', 'Nagpur', '5:55', 80),
(1121, 8240, 'Ngp Bilaspur Exp', 'Nagpur', '23:20', 'Bilaspur Jn', '7:05', 100),
(1122, 8301, 'Sbp Rgda Express', 'Sambalpur', '6:30', 'Rayagada', '13:35', 30),
(1123, 8302, 'Rgda Sbp Express', 'Rayagada', '14:15', 'Sambalpur', '21:00', 40),
(1124, 8303, 'Sbp Puri Int Exp', 'Sambalpur', '6:15', 'Puri', '13:30', 50),
(1125, 8304, 'Puri Sbp Int Exp', 'Puri', '16:30', 'Sambalpur', '22:45', 60),
(1126, 8401, 'Puri-Okha-Exp', 'Puri', '8:45', 'Okha', '15:05', 70),
(1127, 8402, 'Okha Puri Exp', 'Okha', '7:10', 'Puri', '12:40', 80),
(1128, 8405, 'Puri Adi Exp', 'Puri', '18:20', 'Ahmedabad Jn', '7:25', 100),
(1129, 8406, 'Adi Puri Exp', 'Ahmedabad Jn', '18:00', 'Puri', '9:15', 30),
(1130, 8409, 'Srijagannathexp', 'Howrah Jn', '19:00', 'Puri', '4:30', 40),
(1131, 8410, 'Srijagannathexp', 'Puri', '22:30', 'Howrah Jn', '8:15', 50),
(1132, 8411, 'Inter City Exp', 'Bhubaneswar', '5:25', 'Vishakapatnam', '14:10', 60),
(1133, 8412, 'Inter City Exp', 'Vishakapatnam', '14:35', 'Bhubaneswar', '22:50', 70),
(1134, 8425, 'Bbs R Express', 'Bhubaneswar', '19:15', 'Raipur Jn', '9:05', 80),
(1135, 8426, 'R Bbs Exp', 'Raipur Jn', '17:00', 'Bhubaneswar', '7:45', 100),
(1136, 8447, 'Hirakhand Exp', 'Bhubaneswar', '20:00', 'Koraput', '10:15', 30),
(1137, 8448, 'Hirakhand Exp', 'Koraput', '18:25', 'Bhubaneswar', '8:30', 40),
(1138, 8449, 'B Nath Dham Exp', 'Puri', '14:10', 'Patna Jn', '10:00', 50),
(1139, 8450, 'B Nath Dham Exp', 'Patna Jn', '9:00', 'Puri', '3:30', 60),
(1140, 8451, 'Tapaswini Expres', 'Hatia', '16:15', 'Puri', '8:00', 70),
(1141, 8452, 'Tapaswini Exp', 'Puri', '20:45', 'Hatia', '11:40', 80),
(1142, 8473, 'Puri Ju Express', 'Puri', '14:30', 'Jodhpur Jn', '13:20', 100),
(1143, 8474, 'Ju Puri Express', 'Jodhpur Jn', '12:20', 'Puri', '12:10', 30),
(1144, 8477, 'Utkal Express', 'Puri', '21:10', 'HarTrainIDwar Jn', '20:30', 40),
(1145, 8478, 'Kalingautkalexp', 'HarTrainIDwar Jn', '6:00', 'Puri', '6:20', 50),
(1146, 8507, 'Vskp Nzm Hkg Exp', 'Vishakapatnam', '0:20', 'Amritsar Jn', '22:10', 60),
(1147, 8508, 'Hirakund Exp', 'H Nizamuddin', '8:45', 'Vishakapatnam', '23:50', 70),
(1148, 0, 'Hirakund Exp', 'Amritsar Jn', '23:55', 'H Nizamuddin', '8:25', 80),
(1149, 8509, 'Vskp Nzb Express', 'Vishakapatnam', '19:30', 'Nizamabad', '12:00', 100),
(1150, 8510, 'Nzb Vskp Express', 'Nizamabad', '18:00', 'Vishakapatnam', '10:25', 30),
(1151, 8517, 'Krba Vskp Exp', 'Korba', '16:30', 'Vishakapatnam', '8:10', 40),
(1152, 8518, 'Vskp Krba Exp', 'Vishakapatnam', '18:50', 'Korba', '11:10', 50),
(1153, 8563, 'Prasanthi Exp', 'Vishakapatnam', '11:30', 'Bangalore Cy Jn', '10:00', 60),
(1154, 0, 'Prasanthi Exp', 'Bhubaneswar', '4:15', 'Bangalore Cy Jn', '10:00', 70),
(1155, 8564, 'Prasanthi Exp', 'Bangalore Cy Jn', '14:00', 'Bhubaneswar', '20:55', 80),
(1156, 8601, 'Hte Jat Exp', 'Hatia', '15:05', 'Jammu Tawi', '11:45', 100),
(1157, 8609, 'Rnc Ltt Express', 'Ranchi', '21:05', 'Lokmanyatilak T', '13:45', 30),
(1158, 8610, 'Ranchi Express', 'Lokmanyatilak T', '15:50', 'Ranchi', '8:15', 40),
(1159, 8611, 'Rnc Bsb Express', 'Ranchi', '20:20', 'Varanasi Jn', '8:55', 50),
(1160, 8612, 'Bsb Rnc Express', 'Varanasi Jn', '14:55', 'Ranchi', '4:30', 60),
(1161, 8615, 'Hwh Hatia Exp', 'Howrah Jn', '21:55', 'Hatia', '6:40', 70),
(1162, 8616, 'Hte Rnc Hwh Exp', 'Hatia', '21:20', 'Howrah Jn', '6:35', 80),
(1163, 8621, 'Patliputra Exp', 'Patna Jn', '15:30', 'Hatia', '5:05', 100),
(1164, 8622, 'Patliputra Exp', 'Hatia', '22:00', 'Patna Jn', '12:10', 30),
(1165, 8623, 'Rjpb Hatia Exp', 'Rjndr Ngr Bihar', '21:00', 'Hatia', '8:00', 40),
(1166, 8624, 'Hte Rjpb Exp', 'Hatia', '19:05', 'Rjndr Ngr Bihar', '6:55', 50),
(1167, 0, 'Hatia Patna Exp', 'Barka Kana', '16:23', 'Patna Jn', '6:30', 60),
(1168, 8625, 'Rjpb Hte Express', 'Rjndr Ngr Bihar', '11:05', 'Hatia', '21:05', 70),
(1169, 8626, 'Hte-Rjpb-Exp', 'Hatia', '5:55', 'Rjndr Ngr Bihar', '16:15', 80),
(1170, 8645, 'East Coast Exp', 'Howrah Jn', '11:45', 'Hyderabad Decan', '18:30', 100),
(1171, 8646, 'East Coast Exp', 'Hyderabad Decan', '10:00', 'Howrah Jn', '16:15', 30),
(1172, 9005, 'Saurashtra Mail', 'Mumbai Central', '20:25', 'Okha', '16:00', 40),
(1173, 9006, 'Saurashtra Mail', 'Okha', '12:30', 'Mumbai Central', '7:10', 50),
(1174, 9011, 'Gujarat Express', 'Mumbai Central', '5:45', 'Ahmedabad Jn', '15:00', 60),
(1175, 9012, 'Gujarat Express', 'Ahmedabad Jn', '7:00', 'Mumbai Central', '16:25', 70),
(1176, 9017, 'Sau Janata Exp', 'Bandra Terminus', '17:35', 'Jamnagar', '9:35', 80),
(1177, 9018, 'Sau Janata Exp', 'Jamnagar', '13:35', 'Bandra Terminus', '5:30', 100),
(1178, 9019, 'Dehradun Exp', 'Bandra Terminus', '22:25', 'Dehradun', '17:35', 30),
(1179, 0, 'Nmh Kota Exp', 'Nimach', '13:40', 'Delhi', '6:00', 40),
(1180, 9020, 'Dehradun Exp', 'Dehradun', '10:35', 'Bandra Terminus', '4:30', 50),
(1181, 0, 'Dehradun Express', 'Delhi', '21:45', 'Nimach', '13:15', 60),
(1182, 9023, 'Fzr Janata Exp', 'Mumbai Central', '7:25', 'Firozpur Cant', '22:25', 70),
(1183, 9031, 'Kutch Express', 'Mumbai Central', '17:10', 'Bhuj', '9:00', 80),
(1184, 9032, 'Kutch Express', 'Bhuj', '20:00', 'Mumbai Central', '11:45', 100),
(1185, 9037, 'Avadh Express', 'Bandra Terminus', '22:40', 'Gorakhpur Jn', '13:40', 30),
(1186, 9038, 'Avadh Express', 'Gorakhpur Jn', '13:30', 'Bandra Terminus', '4:45', 40),
(1187, 9039, 'Avadh Express', 'Bandra Terminus', '22:40', 'Muzaffarpur Jn', '21:50', 50),
(1188, 9047, 'St Bhagalpur Exp', 'Surat', '9:35', 'Bhagalpur', '19:20', 60),
(1189, 9048, 'Bgp Surat Exp', 'Bhagalpur', '9:15', 'Surat', '18:30', 70),
(1190, 9049, 'Bdts Patna Exp', 'Bandra Terminus', '16:10', 'Patna Jn', '4:10', 80),
(1191, 9050, 'Pnbe Bdts Exp', 'Patna Jn', '23:00', 'Bandra Terminus', '10:45', 100),
(1192, 9051, 'Shramik Express', 'Valsad', '19:40', 'Sonpur Jn', '6:40', 30),
(1193, 9052, 'Bl Shramik Exp', 'Sonpur Jn', '20:45', 'Valsad', '5:30', 40),
(1194, 9105, 'HarTrainIDwar Mail', 'Ahmedabad Jn', '9:50', 'HarTrainIDwar Jn', '12:30', 50),
(1195, 9106, 'Hw Adi Mail', 'HarTrainIDwar Jn', '15:25', 'Ahmedabad Jn', '17:35', 60),
(1196, 9115, 'Sayajinagari Exp', 'Bandra Terminus', '14:50', 'Bhuj', '7:30', 70),
(1197, 9116, 'Bhuj Bdts Exp', 'Bhuj', '20:30', 'Bandra Terminus', '13:55', 80),
(1198, 9143, 'Lok Shakti Exp', 'Bandra Terminus', '19:40', 'Ahmedabad Jn', '4:50', 100),
(1199, 9144, 'Lok Shakti Exp', 'Ahmedabad Jn', '21:05', 'Bandra Terminus', '6:05', 30),
(1200, 9163, 'Sabarmati Exp', 'Ahmedabad Jn', '20:30', 'Faizabad Jn', '4:20', 40),
(1201, 9164, 'Sabarmati Exp', 'Faizabad Jn', '19:25', 'Ahmedabad Jn', '4:25', 50),
(1202, 9165, 'Sabarmati Exp', 'Ahmedabad Jn', '20:30', 'Darbhanga Jn', '19:20', 60),
(1203, 9166, 'Sabarmati Exp', 'Darbhanga Jn', '4:35', 'Ahmedabad Jn', '4:25', 70),
(1204, 9167, 'Sabarmati Exp', 'Ahmedabad Jn', '20:30', 'Varanasi Jn', '9:50', 80),
(1205, 9168, 'Sabarmati Exp', 'Varanasi Jn', '13:55', 'Ahmedabad Jn', '4:25', 100),
(1206, 9215, 'Saurashtra Exp', 'Mumbai Central', '7:55', 'Porbandar', '6:05', 30),
(1207, 9216, 'Saurashtra Exp', 'Porbandar', '20:10', 'Mumbai Central', '19:10', 40),
(1208, 9221, 'Somnath Express', 'Ahmedabad Jn', '21:45', 'Veraval', '6:15', 50),
(1209, 9222, 'Somnath Express', 'Veraval', '19:30', 'Ahmedabad Jn', '4:00', 60),
(1210, 9223, 'Adi Jat Express', 'Ahmedabad Jn', '11:10', 'Jammu Tawi', '19:55', 70),
(1211, 9224, 'Jat Adi Express', 'Jammu Tawi', '7:00', 'Ahmedabad Jn', '16:30', 80),
(1212, 9225, 'Bti Jat Exp', 'Bhatinda Jn', '16:45', 'Jammu Tawi', '4:55', 100),
(1213, 9226, 'Jat Bti Exp', 'Jammu Tawi', '22:05', 'Bhatinda Jn', '10:25', 30),
(1214, 9263, 'Delhi Sr Express', 'Porbandar', '15:05', 'Delhi S Rohilla', '19:55', 40),
(1215, 9264, 'Dee Porbndr Exp', 'Delhi S Rohilla', '8:40', 'Porbandar', '13:05', 50),
(1216, 9265, 'Uttaranchal Exp', 'Okha', '5:55', 'Dehradun', '19:00', 60),
(1217, 9266, 'Uttaranchal Exp', 'Dehradun', '6:00', 'Okha', '17:40', 70),
(1218, 9267, 'Pbr Okha Express', 'Porbandar', '22:50', 'Okha', '4:05', 80),
(1219, 9268, 'Porbandar Exp', 'Okha', '20:30', 'Porbandar', '1:30', 100),
(1220, 9269, 'Pbr Motihari Exp', 'Porbandar', '15:05', 'Motihari', '17:15', 30),
(1221, 9270, 'Mki Pbr Express', 'Motihari', '16:30', 'Porbandar', '17:10', 40),
(1222, 9303, 'Intercity Exp', 'Ratlam Jn', '6:00', 'Bhopal Jn', '11:10', 50),
(1223, 9305, 'Shipra Express', 'Indore Jn Bg', '23:00', 'Howrah Jn', '6:30', 60),
(1224, 9306, 'Shipra Exp', 'Howrah Jn', '17:40', 'Indore Jn Bg', '3:30', 70),
(1225, 9309, 'Gnc Indore Exp', 'Gandhinagar Cap', '18:25', 'Indore Jn Bg', '5:35', 80),
(1226, 9310, 'Indore Gnc Exp', 'Indore Jn Bg', '22:00', 'Gandhinagar Cap', '10:15', 100),
(1227, 9311, 'Pune Indore Exp', 'Pune Jn', '15:20', 'Indore Jn Bg', '9:50', 30),
(1228, 9312, 'Ind Pune Express', 'Indore Jn Bg', '14:00', 'Pune Jn', '8:05', 40),
(1229, 9313, 'Indb Patna Exp', 'Indore Jn Bg', '14:00', 'Patna Jn', '15:50', 50),
(1230, 9314, 'Rjpb Indb Expres', 'Rjndr Ngr Bihar', '11:00', 'Indore Jn Bg', '15:00', 60),
(1231, 9319, 'Indore Bhind Exp', 'Indore Jn Bg', '20:45', 'Bhind', '11:30', 70),
(1232, 9320, 'Bix Indb Exp', 'Bhind', '17:00', 'Indore Jn Bg', '8:00', 80),
(1233, 9321, 'Indb Rjpb Exp', 'Indore Jn Bg', '14:00', 'Rjndr Ngr Bihar', '16:15', 100),
(1234, 9322, 'Rjpb Indb Expres', 'Rjndr Ngr Bihar', '11:00', 'Indore Jn Bg', '15:00', 30),
(1235, 9323, 'Intercity Exp', 'Indore Jn Bg', '7:00', 'Bhopal Jn', '10:35', 40),
(1236, 9569, 'Okha Bsb Express', 'Okha', '13:30', 'Varanasi Jn', '4:45', 50),
(1237, 9570, 'Bsb Okha Exp', 'Varanasi Jn', '22:00', 'Okha', '13:40', 60),
(1238, 9658, 'Mhow Cor Express', 'Mhow', '11:50', 'Chittaurgarh', '21:30', 70),
(1239, 9707, 'Aravali Express', 'Bandra Terminus', '21:00', 'Jaipur', '18:45', 80),
(1240, 9708, 'Aravali Express', 'Jaipur', '8:45', 'Bandra Terminus', '6:45', 100),
(1241, 9711, 'Jp Sgnr Exp', 'Jaipur', '20:40', 'Shri Ganganagar', '8:15', 30),
(1242, 9712, 'Sgnr Jp Express', 'Shri Ganganagar', '20:00', 'Jaipur', '7:55', 40),
(1243, 9733, 'Shekhawati Exp', 'Rewari', '1:05', 'Jaipur', '10:20', 50),
(1244, 9734, 'Shekhawati Exp', 'Jaipur', '18:05', 'Rewari', '3:30', 60),
(1245, 9771, 'Jaipur Asr Exp', 'Jaipur', '19:20', 'Amritsar Jn', '13:45', 70),
(1246, 9772, 'Asr Jaipur Exp', 'Amritsar Jn', '14:30', 'Jaipur', '9:25', 80),
(1247, 9781, 'Jp Asr Express', 'Jaipur', '19:20', 'Amritsar Jn', '10:25', 100),
(1248, 9782, 'Asr Jp Express', 'Amritsar Jn', '18:00', 'Jaipur', '9:35', 30),
(1249, 9943, 'Udz Adi Express', 'Udaipur City', '19:45', 'Ahmedabad Jn', '4:20', 40),
(1250, 9944, 'Adi Udz Express', 'Ahmedabad Jn', '23:15', 'Udaipur City', '7:40', 50),
(1251, 0, 'Grd Dnr Exp', 'GirTrainIDih', '22:45', 'Danapur', '7:10', 60),
(1252, 0, 'Grd Cp Express', 'GirTrainIDih', '22:45', 'Kolkata', '7:15', 70);

-- --------------------------------------------------------

--
-- Table structure for table `userlogin`
--

CREATE TABLE `userlogin` (
  `UserID` int(11) NOT NULL,
  `UserName` varchar(50) NOT NULL,
  `UserPassword` varchar(50) NOT NULL,
  `FullName` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `StateCode` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `LoginSession` int(2) NOT NULL DEFAULT 0,
  `DistrictCode` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `RegDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userlogin`
--

INSERT INTO `userlogin` (`UserID`, `UserName`, `UserPassword`, `FullName`, `StateCode`, `LoginSession`, `DistrictCode`, `RegDate`) VALUES
(1, '12345678', '12345678', 'Jaspinder Kaur', 'Punjab', 1, 'Sri Muktsar Sahib', '2022-06-02 10:52:26');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `eticketing`
--
ALTER TABLE `eticketing`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `UserID` (`UserID`),
  ADD KEY `TrainID` (`TrainID`);

--
-- Indexes for table `statecodes`
--
ALTER TABLE `statecodes`
  ADD PRIMARY KEY (`StateCode`);

--
-- Indexes for table `userlogin`
--
ALTER TABLE `userlogin`
  ADD PRIMARY KEY (`UserID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `eticketing`
--
ALTER TABLE `eticketing`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `statecodes`
--
ALTER TABLE `statecodes`
  MODIFY `StateCode` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `userlogin`
--
ALTER TABLE `userlogin`
  MODIFY `UserID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

IndianRailway.java

import java.awt.*;
import javax.swing.border.EmptyBorder;
import java.awt.*;
import javax.swing.*;
import javax.swing.event.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.table.DefaultTableModel;
import javax.swing.border.*;

import java.io.*;
import java.sql.*;
import java.awt.print.*;
import java.awt.geom.*;

import javax.swing.text.html.*;
import javax.swing.text.html.HTMLDocument;

import java.text.SimpleDateFormat;
import java.util.Calendar;

import com.toedter.calendar.JCalendar;
import com.toedter.calendar.JDateChooser;

import java.text.DateFormat;
import java.text.NumberFormat;
import java.util.Date.*;

import java.time.Month;
import java.time.LocalDate;
import java.time.*;
import java.util.Formatter.*;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

import java.util.*;
import java.time.format.*;
import java.time.temporal.*;
import java.text.DateFormat.*; 

import java.text.*;
import java.util.concurrent.TimeUnit;

public class IndianRailway extends JFrame implements ActionListener,ItemListener, MenuListener, HyperlinkListener
{

	Connection conn;
	Statement stmt;
	ResultSet rs;
	int sessionOut, flag;
	
	int nrows,reply,response,stmtval;
		
	private JPanel contentPane;
	
	Icon imgIcon 			= new ImageIcon("Images/rail.gif");
	JLabel lblIcon 			= new JLabel("", imgIcon, SwingConstants.RIGHT);
	
	Image titleIcon 		= Toolkit.getDefaultToolkit().getImage("Images/rail.gif");    
	   

	Button btnLogin 		= new Button("Login");

	// Create Labels
	JLabel lblLoginSystem 	= new JLabel("Indian Railway");
	JLabel lbl_lifeline		= new JLabel("Lifeline to the nation");
	
	JLabel lblUserName 		= new JLabel("User Name:");
	JLabel lblPassword 		= new JLabel("Password:");

	JLabel lblProgrammer 	= new JLabel("Developed by: Jaspinder Kaur, MCA");

	// Create Text Items
	JTextField txtUserName 		= new JTextField("",20);
	JPasswordField txtPassword 	= new JPasswordField("",20);
	
	
	JTextField txtuname;
	String uname="";
	String UserID="0";
	
	
	JFrame frameHomePage	= new JFrame("Indian Railway");
	JFrame frameLogin 		= new JFrame("Login - Indian Railway");
	JFrame frameRegister 	= new JFrame("User Registration - Indian Railway");
	JFrame frameDashboard 	= new JFrame();
	JFrame frameFindTrain	= new JFrame();	
	JFrame frameHelp		= new JFrame("Help - Indian Railway");
	JFrame frameETicketing	= new JFrame();	
	JFrame frameMyTickets	= new JFrame();
	
			
	Font font1 = new Font("Verdana", Font.BOLD, 14);
	Font font2 = new Font("Verdana", Font.BOLD, 26);
	
	Color c1 = new Color(0, 0, 204);  
	
	
	JLabel lblResults = new JLabel();
	
	//Variables For RegisterFunction
	JLabel lblUserFullName, lblUserMobName,lblUserState, lblUserCity;
	JLabel label_txtUserFullName, label_txtUserMobName;
	JTextField txtUserFullName, txtUserMobName, txtCity;
	JTextField txtStateID;
	
	JLabel labelMSG_txtUserMobName;
	
	JComboBox cmbState;
	Button btnSignUp,btnCleanSignUp;
	
	String valStateName, valCity, valStateCode, strcls;
	//Variables For RegisterFunction
	
	
	//Variables for FindTrainFunction
	JPanel panelTable;
	
	JLabel findTrainNo, findTrainName,findTrainSource, findDepTime, findTrainDes, findArrTime;
	JLabel lblfindTrainType, lblfindTrainName, lblfindTrainNumber;
	JLabel errtxtfindTrainName, queryfindTrainNo;
	
	JTextField txtfindTrainName, txtfindTrainNumber;
	Button btnfindTrainSearch,btnfindTrainClean;
	
	String chkFromTrain, chkDesTrain;
	
	// Closed Variables for FindTrainFunction
	
	
	//e-Ticketing Funtion	
	JLabel lblFromTrain, lblToTrain, lblDesTrain;
	JComboBox cmbFromTrain, cmbDesTrain;
	JTextField txtcmbFromTrain, txtcmbDesTrain;
	
	JTextField txtSelectedDate,txtCurrentDate;
	JTextField txtETikcetTrainClass, txtETikcetTrainType;
			        
	JLabel lbldateChooserTrain;
	JDateChooser currdateChooserTrain, dateChooserTrain;
				
	JLabel lblETicketClass, lblETikcetTrainType, lblETicketUser;
	
	JLabel lblETicketPrize;
	JTextField txtETicketPrize;
	
	JComboBox cmbETicketClass, cmbETicketTrainType, cmbETicketPassenger;
	JTextField txtETicketPassenger;
	
	Button btnETicketTotalPayment, btnETicketReset, btnETicketSave;
	
	int valTicketNumber;
	int valDesTrainID;
	JTextField txtvalDesTrainID, txtUserID;
	
			
	//Closed e-Ticketing Function
	
	//MyTicketing Function
	JTable tableMyTickets;
	JScrollPane scrollPane;
	
	// Closed MyTicketing Function
	
	/**
	 * Create the frame.
	 */
	 
	public IndianRailway() 
	{
		
		frameHomePage.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		frameHomePage.getContentPane().setLayout(null);
		frameHomePage.setResizable(false);
		
		lblIcon.setBounds(363, 158, 100, 75);
		frameHomePage.getContentPane().add(lblIcon);
		
		//frameHomePage.getContentPane().setBackground(Color.white);
		
		frameHomePage.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(325, 253, 269, 50);
		lbl_lifeline.setBounds(353, 303, 153, 25);
		lblProgrammer.setBounds(300, 403, 296, 35);
		
		
		frameHomePage.getContentPane().add(lblLoginSystem);			
		frameHomePage.getContentPane().add(lbl_lifeline);
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
		
		
		lblProgrammer.setFont(new Font("Verdana", Font.BOLD, 13));
		lblProgrammer.setForeground(Color.black);
				
		frameHomePage.getContentPane().add(lblProgrammer);
		
		JLabel lblProgrammer_1 = new JLabel("P.U. Regional Centre - Sri Muktsar Sahib");
		lblProgrammer_1.setForeground(Color.red);
		lblProgrammer_1.setFont(new Font("Verdana", Font.BOLD, 15));
		lblProgrammer_1.setBounds(270, 477, 357, 35);
		frameHomePage.getContentPane().add(lblProgrammer_1);
		
		
		enableEvents(AWTEvent.WINDOW_EVENT_MASK);
		
		frameHomePage.setBounds(200,10,900,700);

		frameHomePage.setVisible(true);
		frameHomePage.setJMenuBar(loginMenuBar());
													       
	}
	
	
	/* 
	 	===================================================================	
		loginMenuBar() JMenu only without Authentication
		===================================================================	
	*/
	public JMenuBar loginMenuBar() 
	{
		JMenuBar menuBar = new JMenuBar();
		
		//First Menu Dashboard		
		JMenu homeLoginMenu  = new JMenu("Home");
		menuBar.add(homeLoginMenu);
				        
		JMenuItem indianRailwayItem = new JMenuItem("Indian Railway");
		homeLoginMenu.add(indianRailwayItem);
				        		       
		// Add ActionListener on HomeItem        
		indianRailwayItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();
			frameRegister.dispose();
			frameHomePage.dispose();
			IndianRailway obj_IndianRailwaySystem	=	new IndianRailway();
			//frameHomePage.setVisible(true);	            	            		            	               
			}
		});
				// Closed Add ActionListener on HomeItem
				// Closed First Menu Dashboard
				
		//Start Trains Menu        
		JMenu trains  = new JMenu ("Login Area");
		menuBar.add(trains);
		        
		JMenuItem loginItem = new JMenuItem("User Login");
		trains.add(loginItem);
		        
		// Add ActionListener on addTrainItem
		loginItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameRegister.dispose();      						
			frameDashboard.dispose();			        	
			frameHomePage.dispose();
			frameLogin.setVisible(true);
        	
        	FrameLoginFunction();
		    					            	            		            	               	
		    }
		});
	    // Closed ActionListener on addTrainItem
		        				        								        		                		     
		//Closed Trains Menu
		        
		        
		JMenu registrationMenu  = new JMenu ("Registration");
		menuBar.add(registrationMenu);
		
		JMenuItem registrationItem	=	new JMenuItem("User Registration");
		registrationMenu.add(registrationItem);
		        
				        
		//Add ActionListener on addTrainItem
		registrationItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();    			
			frameDashboard.dispose();
			frameHomePage.dispose();
        	frameRegister.setVisible(true);
        	RegisterFunction();
		    }
		});
		// Closed ActionListener on addTrainItem
		        
		       
		                
		menuBar.add (Box.createHorizontalGlue ());
		        
		JMenu helpMenu  = new JMenu ("Help");
		menuBar.add(helpMenu);
		
		JMenuItem helpItem	=	new JMenuItem("About Project");
		helpMenu.add(helpItem);
		        
				        
		//Add ActionListener on helpItem
		helpItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();    			
			frameDashboard.dispose();
			frameHomePage.dispose();
        	frameRegister.dispose();
        	
        	frameHelp.setVisible(true);
        	
        	FrameHelpFunction();
        	
		    }
		});
		// Closed ActionListener on helpItem
		
		                                                             
        return menuBar;
	}
	
	/* 
 		===================================================================	
		Closed loginMenuBar() JMenu only without Authentication
		===================================================================	
	*/
	
	
		
	/* 
 	===================================================================	
	dashboardMenuBar() JMenu only with Authentication
	===================================================================	
	 */
	public JMenuBar dashboardMenuBar(String uname, String UserID) 
	{
		JMenuBar menuBar = new JMenuBar ();
				
		//First Menu Dashboard		
		JMenu homeMenu  = new JMenu ("Home");
		menuBar.add(homeMenu);
		        
		JMenuItem dashboardItem = new JMenuItem("Dashboard");
		homeMenu.add(dashboardItem);
		        		       
		// Add ActionListener on HomeItem        
		dashboardItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();
			frameRegister.dispose();			
			frameFindTrain.dispose();
			frameETicketing.dispose();
	    	frameDashboard.setVisible(true);
	    	DashboardFunction(uname,UserID);
		    }
		});
		// Closed Add ActionListener on HomeItem
		// Closed First Menu Dashboard
		        		       
		JMenu trainsMenu  = new JMenu ("Trains");
		menuBar.add(trainsMenu);
								       
		JMenuItem findTrainItem	= new JMenuItem("Train Schedule",new ImageIcon("images/find.jpg"));
		trainsMenu.add(findTrainItem);
		
		// Add ActionListener on HomeItem        
		findTrainItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();
			frameRegister.dispose();			
	    	frameDashboard.dispose();
	    	frameETicketing.dispose();
	    	frameFindTrain.setVisible(true);
	    	
	    	//Call FindTrainFunction
	    	FindTrainFunction(uname,UserID);
		    }
		});
		// Closed Add ActionListener on HomeItem

						       
		JMenu bookingMenu  = new JMenu ("Booking");
		menuBar.add(bookingMenu);
		
		JMenuItem eTicketingItem	= new JMenuItem("e-Ticketing",new ImageIcon("images/find.jpg"));
		bookingMenu.add(eTicketingItem);
		
		// Add ActionListener on eTicketingItem        
		eTicketingItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();
			frameRegister.dispose();			
	    	frameDashboard.dispose();	            	            		            	               
	    	frameFindTrain.dispose();
			frameHomePage.dispose();
			frameMyTickets.dispose();
			frameETicketing.setVisible(true);
			        	
        	FrameETicketingFunction(uname,UserID);
        		    
		    }
		});
		// Closed Add ActionListener on HomeItem
		
		JMenuItem MyeTicketingItem	= new JMenuItem("My Tickets",new ImageIcon("images/find.jpg"));
		bookingMenu.add(MyeTicketingItem);
		
		// Add ActionListener on eTicketingItem        
		MyeTicketingItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();
			frameRegister.dispose();			
	    	frameDashboard.dispose();	            	            		            	               
	    	frameFindTrain.dispose();
			frameHomePage.dispose();
			frameETicketing.dispose();
			
			frameMyTickets.setVisible(true);
			        	
        	FrameMyTicketsFunction(uname,UserID);
        		    
		    }
		});
		// Closed Add ActionListener on HomeItem

		
		
			
		
		menuBar.add (Box.createHorizontalGlue ());
		        
		JMenu profileMenu  = new JMenu ("Profile");
		menuBar.add(profileMenu);
		
		JMenuItem userNameItem	= new JMenuItem(uname,new ImageIcon("images/find.jpg"));
		userNameItem.setComponentOrientation(ComponentOrientation.LEFT_TO_RIGHT);
		profileMenu.add(userNameItem);
		
		profileMenu.addSeparator();
		
		JMenuItem logOutItem	= new JMenuItem("Logout",new ImageIcon("images/find.jpg"));
		
		// Add ActionListener on logOutItem        
		logOutItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			
			frameRegister.dispose();			
	    	frameDashboard.dispose();	            	            		            	               
	    	frameFindTrain.dispose();
			frameHomePage.dispose();
			frameLogin.setVisible(true);
        	
        	FrameLoginFunction();
        		    
		    }
		});
		// Closed Add ActionListener on HomeItem

		
		profileMenu.add(logOutItem);
				
		JMenu helpMenu  = new JMenu ("Help");
		menuBar.add(helpMenu);
		
		JMenuItem helpItem	=	new JMenuItem("About Project");
		helpMenu.add(helpItem);
		        
				        
		//Add ActionListener on helpItem
		helpItem.addActionListener(new ActionListener() {
		public void actionPerformed(ActionEvent ev) {
			frameLogin.dispose();    			
			frameDashboard.dispose();
			frameHomePage.dispose();
        	frameRegister.dispose();        	
        	frameHelp.dispose();
        	
        	frameETicketing.setVisible(true);
        	
        	FrameHelpFunction();
		    }
		});
		// Closed ActionListener on helpItem
		
		
	    return menuBar;
	}
	
	/* 
		===================================================================	
		Closed dashboardMenuBar() JMenu only with Authentication
		===================================================================	
	*/
	
	
	public void FrameETicketingFunction(String uname, String UserID)
	{
		frameETicketing.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		frameETicketing.getContentPane().setLayout(null);
		frameETicketing.setBounds(200,10,900,700);
		frameETicketing.setResizable(false);
		
		txtuname	= new JTextField(uname);
		
		txtuname.setBounds(100,10,100,20);
		frameETicketing.getContentPane().add(txtuname);
		txtuname.setVisible(false);
		
		txtUserID	=	new JTextField(UserID);
		txtUserID.setBounds(10,10,100,20);
		frameETicketing.getContentPane().add(txtUserID);
		txtUserID.setVisible(false);
		
		frameETicketing.setTitle("e-Ticketing - Indian Railway");

		lblIcon.setBounds(250, 35, 100, 75);
		frameETicketing.getContentPane().add(lblIcon);
		frameETicketing.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(381, 30, 269, 50);			
		lbl_lifeline.setBounds(448, 73, 150, 25);			
		
		frameETicketing.getContentPane().add(lblLoginSystem);			
		frameETicketing.getContentPane().add(lbl_lifeline);
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
				
		lblFromTrain	=	new JLabel("From");
		lblToTrain		=	new JLabel("To");
		lblDesTrain		=	new JLabel("Destination");
		
		cmbFromTrain	=	new JComboBox();
		cmbDesTrain		=	new JComboBox();
		
		txtcmbFromTrain	= 	new JTextField(20);
		txtcmbDesTrain	= 	new JTextField(20);
		
		txtSelectedDate	= 	new JTextField(20);
		txtCurrentDate	= 	new JTextField(20);
		
		txtcmbFromTrain.setBounds(10,200,100,20);
		txtcmbDesTrain.setBounds(150,200,100,20);
		
		txtSelectedDate.setBounds(350,200,100,20);
		txtCurrentDate.setBounds(480,200,100,20);
		
		frameETicketing.getContentPane().add(txtSelectedDate);
		frameETicketing.getContentPane().add(txtCurrentDate);
		
		txtSelectedDate.setVisible(false);
		txtCurrentDate.setVisible(false);
		txtcmbFromTrain.setVisible(false);
		txtcmbDesTrain.setVisible(false);
		
		frameETicketing.getContentPane().add(txtcmbFromTrain);
		frameETicketing.getContentPane().add(txtcmbDesTrain);
						
		cmbFromTrain.setBounds(100, 150, 150, 25);
		cmbFromTrain.addItemListener(this);
			
		lblToTrain.setBounds(280, 150, 50, 25);		
		frameETicketing.getContentPane().add(lblToTrain);
		
		cmbDesTrain.setBounds(330, 150, 150, 25);
					
		cmbDesTrain.addItemListener(new ItemListener(){
			
			@Override
		     public void itemStateChanged(ItemEvent e) {
				//System.out.println(e.getItem() + " " + e.getStateChange() );
		         		             		            
		        String valDesTrain =(String)cmbDesTrain.getSelectedItem();
		            		         		       
		        txtcmbDesTrain.setText(valDesTrain);
		         
		        try
		        {
		        	DatabaseConncetion();
		        	ResultSet rsDesTrain4;
		        	rsDesTrain4=stmt.executeQuery("select * from Trains where Destination ='" + valDesTrain + "'");
		    		
		        	while(rsDesTrain4.next()) 
		        	{	
		        		valDesTrainID			=	rsDesTrain4.getInt("TrainID");
            			String valDesTrainName	=	rsDesTrain4.getString("Destination");
            			            		
		        		int valDesTrainKM		=	rsDesTrain4.getInt("KiloMeter");
		    			
		        		txtvalDesTrainID.setText(String.valueOf(valDesTrainID));
		        		//txtETicketPrize.setText(String.valueOf(valDesTrainKM));
		        	}		            
		        }
				catch(Exception ex)
		        {
		    		System.out.println(ex.getMessage());
		        }
		         		         
		     }
				           
        });
		
			
		lbldateChooserTrain	= new JLabel("Journey Date");
		lbldateChooserTrain.setBounds(500,150,100,20);
		frameETicketing.getContentPane().add(lbldateChooserTrain);
		
		dateChooserTrain 		= new JDateChooser();
		dateChooserTrain.setBounds(590,150,150,25);
				
		dateChooserTrain.addPropertyChangeListener("date", new PropertyChangeListener() {
		    //@Override
		    public void propertyChange(PropertyChangeEvent evt) {
		    	
		    	//get Selected Date from JDateChooser then getNewValue of selected date
		    	//selected date will be in String Format for example : Thu May 26 18:29:11 IST 2022
		    	//then String Date Convert to Date format for example : 26/05/2022
		    	
		    	//System.out.println(evt.getNewValue().toString());
		    	
		    	
		    	txtSelectedDate.setText((String) evt.getNewValue().toString());
		    	String sel_Date = txtSelectedDate.getText();
		    	
		    	Date curr_Date = new Date();
		    			    	 		    
		    	 
		    	txtCurrentDate.setText((String) curr_Date.toString());
		    	String sel_DateStr = txtCurrentDate.getText();		    		    	
		    			    			    	    		    
		    	//String input = "Mon Jun 18 00:00:00 IST 2012";
		    	DateTimeFormatter f = DateTimeFormatter.ofPattern( "E MMM dd HH:mm:ss z uuuu" ).withLocale( Locale.US );
		    	 
		    	ZonedDateTime zdt = ZonedDateTime.parse( sel_Date , f );		    	
		    	LocalDate ld = zdt.toLocalDate();
		    	DateTimeFormatter fLocalDate = DateTimeFormatter.ofPattern( "dd/MM/uuuu" );
		    	String output = ld.format( fLocalDate) ;
		    	 
//		    	System.out.println( "input: " + sel_Date );
//		    	System.out.println( "zdt: " + zdt );
//		    	System.out.println( "ld: " + ld );
//		    	System.out.println( "output: " + output );
		    			    			    
		    			    			    			    			    		    			    	  		    			 
		    	//System.out.println( "Curr_Date: " + curr_Date );
		    	
		    	DateTimeFormatter f2 = DateTimeFormatter.ofPattern( "E MMM dd HH:mm:ss z uuuu" ).withLocale( Locale.US );
		    	
		    	ZonedDateTime zdt2 = ZonedDateTime.parse( sel_DateStr , f2 );
		    	System.out.println("-----------------------"); 
		    	LocalDate ld2 = zdt2.toLocalDate();
		    	DateTimeFormatter fLocalDate2 = DateTimeFormatter.ofPattern( "dd/MM/uuuu" );
		    	String output2 = ld2.format( fLocalDate2) ;
		    	 
//		    	System.out.println( "input2: " + sel_DateStr );
//		    	System.out.println( "zdt2: " + zdt2 );
//		    	System.out.println( "ld2: " + ld2 );
//		    	System.out.println( "output2: " + output2 );

		    	
					try {
				      //define date format to take input
				      SimpleDateFormat dateF = new SimpleDateFormat("dd/MM/yyyy");
				  
				      //convert input date string into Date
				      Date dt1 = dateF.parse(output);
				      Date dt2 = dateF.parse(output2);

				      //System.out.println("First Date is: " + dt1.toString());
				      //System.out.println("Second Date is: " + dt2.toString());
				      				    
				      long diff = dt1.getTime() - dt2.getTime();
				      
				      //System.out.println ("Days: " + TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS));
				      				     
					  int ageInDays = (int) TimeUnit.DAYS.convert(diff, TimeUnit.MILLISECONDS);
					  
					  //System.out.println ("Days: " + ageInDays);
		
				      if (ageInDays > 15 )
				      {
				    	  JOptionPane.showMessageDialog(null, "You Can't select more than 15 days for e-Ticketing !!! \n\n Total "+ ageInDays +" Days between \nCurrent Date "+ dt2 +" \nSelection Date "+dt1+"  ", "Invalid Date!", JOptionPane.ERROR_MESSAGE);
				    	    cmbETicketPassenger.setEnabled(false);
				    	    cmbETicketTrainType.setVisible(false);
				  			txtETicketPrize.setVisible(false);
				  			btnETicketTotalPayment.setEnabled(false);
				  			lblETicketClass.setVisible(false);
				  			lblETikcetTrainType.setVisible(false);
				  			
	                      return;
				      }
				      else if(ageInDays < 0 )
				      {
				    	  JOptionPane.showMessageDialog(null, "You Can't select back date for e-Ticketing !!! \n\n Selection Date "+ dt1 +" ", "Invalid Date!", JOptionPane.ERROR_MESSAGE);
				    	    cmbETicketPassenger.setEnabled(false);
				    	  	cmbETicketClass.setVisible(false);
				  			cmbETicketTrainType.setVisible(false);
				  			txtETicketPrize.setVisible(false);
				  			btnETicketTotalPayment.setEnabled(false);
				  			
				  			lblETicketClass.setVisible(false);
				  			lblETikcetTrainType.setVisible(false);
				  			
				  			return;
				      }
				      
				      else
				      {
				    	  ImageIcon icon = new ImageIcon("images/rail.gif");
				          JOptionPane.showMessageDialog(null, "Selection Date "+dt1+" \nis valid for e-Ticketing", "Valid Days", JOptionPane.INFORMATION_MESSAGE, icon);
				            cmbETicketPassenger.setEnabled(true);
				          	cmbETicketClass.setVisible(true);
				  			cmbETicketTrainType.setVisible(true);
				  			txtETicketPrize.setVisible(true);
				  			btnETicketTotalPayment.setEnabled(true);
				  			
				  			lblETicketClass.setVisible(true);
				  			lblETikcetTrainType.setVisible(true);
				  			cmbETicketPassenger.setVisible(true);
				  			
				  			
				  			return;
				      }
				    } 
					catch (Exception e) 
					{
				      System.out.println("Exception is: " + e.toString());
				    }
		    			        
		    	//closed JDateChooser
		        
		    }
		});
		//dateChooserTrain.setDate(new Date());
		
				
												
		lblETicketClass			= new JLabel("Class");
		lblETikcetTrainType		= new JLabel("Train Type");
							
		lblETicketClass.setBounds(100,250,150,25);
		lblETikcetTrainType.setBounds(100,300,150,25);
		
				
		frameETicketing.getContentPane().add(lblETicketClass);
		frameETicketing.getContentPane().add(lblETikcetTrainType);
		
		JLabel lblETicketPassenger			= new JLabel("Passenger");
		lblETicketPassenger.setBounds(100,200,150,25);
		
		frameETicketing.getContentPane().add(lblETicketPassenger);
		
		txtETicketPassenger	= new JTextField("1",10);
		
		txtETicketPassenger.setBounds(350,200,150,25);
		
		frameETicketing.getContentPane().add(txtETicketPassenger);
		txtETicketPassenger.setVisible(false);
		
		
		
		cmbETicketPassenger		= new JComboBox();
		
		cmbETicketPassenger.addItem("1");
		cmbETicketPassenger.addItem("2");
		cmbETicketPassenger.addItem("3");
		cmbETicketPassenger.addItem("4");
		cmbETicketPassenger.addItem("5");
		
		cmbETicketPassenger.setBounds(250,200,150,25);
		
		frameETicketing.getContentPane().add(cmbETicketPassenger);
		cmbETicketPassenger.setVisible(false);
		
		cmbETicketPassenger.addItemListener(new ItemListener(){
			
			@Override
		     public void itemStateChanged(ItemEvent e) {
				//System.out.println(e.getItem() + " " + e.getStateChange() );
		         		             		            
		        String valTicketPassenger =(String)cmbETicketPassenger.getSelectedItem();
		            		         		       
		        txtETicketPassenger.setText(valTicketPassenger);
			}
});
		
		
		cmbETicketClass			= new JComboBox();
		cmbETicketTrainType		= new JComboBox();
							
		cmbETicketClass.addItem("Standard");							
		cmbETicketClass.addItem("Economy");
		cmbETicketClass.addItem("First Class");
		
				
		cmbETicketTrainType.addItem("Single");
		cmbETicketTrainType.addItem("Return");
		
		cmbETicketTrainType.addItemListener(this);
		cmbETicketTrainType.addItemListener(this);
		
		cmbETicketClass.setBounds(250,250,150,25);
		cmbETicketTrainType.setBounds(250,300,150,25);
				
		frameETicketing.getContentPane().add(cmbETicketClass);
		frameETicketing.getContentPane().add(cmbETicketTrainType);
		
		txtETikcetTrainClass	= new JTextField("Standard",10);
		txtETikcetTrainClass.setBounds(450,250,100,20);
		txtETikcetTrainClass.setVisible(false);
		frameETicketing.getContentPane().add(txtETikcetTrainClass);
		
		txtETikcetTrainType	= new JTextField("Single",10);
		txtETikcetTrainType.setBounds(450,300,100,20);
		frameETicketing.getContentPane().add(txtETikcetTrainType);
		txtETikcetTrainType.setVisible(false);
		
		cmbETicketClass.setVisible(false);
		cmbETicketTrainType.setVisible(false);
					
		cmbETicketClass.addItemListener(new ItemListener(){
			
			@Override
		     public void itemStateChanged(ItemEvent e) {
				System.out.println(e.getItem() + " " + e.getStateChange() );
		         if(e.getSource() == cmbETicketClass){
		             		             
		            strcls=(String)cmbETicketClass.getSelectedItem();
		          	
		            txtETikcetTrainClass.setText(strcls);
		            		                    
		         }
		         if(e.getStateChange() == ItemEvent.DESELECTED){
		             System.out.println("Deselected");
		         } 
		     }
				           
        });
		
		cmbETicketTrainType.addItemListener(new ItemListener(){
			
			@Override
		     public void itemStateChanged(ItemEvent e) {
				System.out.println(e.getItem() + " " + e.getStateChange() );
		         if(e.getSource() == cmbETicketTrainType){
		             		             
		            strcls=(String)cmbETicketTrainType.getSelectedItem();
		          	
		            txtETikcetTrainType.setText(strcls);
		            
		                    
		         }
		         if(e.getStateChange() == ItemEvent.DESELECTED){
		             System.out.println("Deselected");
		         } 
		     }
				           
        });
		           
		    				
		lblETicketPrize	= new JLabel("Ticket Prize");;
		txtETicketPrize	= new JTextField(10);
		
		txtvalDesTrainID= new JTextField(10);
		
		lblETicketPrize.setBounds(100,350,150,25);		
		txtETicketPrize.setBounds(250,350,150,25);				
		txtETicketPrize.setVisible(false);
		txtETicketPrize.setEditable(false);
		
		txtvalDesTrainID.setVisible(false);
		
		txtvalDesTrainID.setBounds(450,350,150,25);
		
		frameETicketing.getContentPane().add(lblETicketPrize);		
		frameETicketing.getContentPane().add(txtETicketPrize);			
		frameETicketing.getContentPane().add(txtvalDesTrainID);
				
		
		btnETicketTotalPayment	= new Button("Total"); 
		btnETicketReset			= new Button("Reset");
		btnETicketSave			= new Button("Save Ticket");
		
		btnETicketTotalPayment.setBackground(Color.orange); 
		btnETicketReset.setBackground(Color.orange);
		btnETicketSave.setBackground(Color.orange);
						
		btnETicketTotalPayment.setBounds(250,450,100,25); 		
		btnETicketSave.setBounds(360,450,100,25);
		btnETicketReset.setBounds(470,450,100,25);
		
		btnETicketTotalPayment.addActionListener(this);
		btnETicketReset.addActionListener(this);
		btnETicketSave.addActionListener(this);
		
		btnETicketTotalPayment.setEnabled(false); 		
		btnETicketSave.setEnabled(false);
		
		frameETicketing.getContentPane().add(btnETicketTotalPayment); 
		frameETicketing.getContentPane().add(btnETicketReset);
		frameETicketing.getContentPane().add(btnETicketSave);
				
		frameETicketing.getContentPane().add(dateChooserTrain);        
        

		try 
		{
			//Call DatabaseConnection
			DatabaseConncetion();				    			
			rs=stmt.executeQuery("select * from Trains");
						
			cmbFromTrain.addItem("From Train");
			cmbDesTrain.addItem("Destination");
											
			while (rs.next()) {
										
				String valSourceName 		= rs.getString("Source");
				String valDestinationName 	= rs.getString("Destination");
				
				String valSourceID			= rs.getString("TrainID");
				String valDesID				= rs.getString("TrainID");
				
				cmbFromTrain.addItem(valSourceName);			
											
//				cmbDesTrain.addItem(valDestinationName);
//				frameETicketing.getContentPane().add(cmbDesTrain);
														
			} 
													           
		}
		catch(Exception e)
        {
			System.out.println(e.getMessage());
        }
		
		Button btnFromTrainSearch;
		
		frameETicketing.getContentPane().add(cmbFromTrain);			
		frameETicketing.getContentPane().add(cmbDesTrain);
		frameETicketing.setJMenuBar(dashboardMenuBar(uname,UserID));
	}
	
	public void itemStateChanged(ItemEvent it)
    {		
//	    if (it.getSource().equals(cmbETicketTrainType)) {
//	        System.out.println("Single");
//	    }
//		    
//	    else if (it.getSource().equals(cmbETicketTrainType)) {
//	        System.out.println("Return");
//	    }
		
		
		if(it.getSource()==cmbFromTrain)                        
        {                        
			chkFromTrain=(String)it.getItem();
			//chkFromTrain==(String)it.getSelectedItem();
			
            txtcmbFromTrain.setText(chkFromTrain);
            
            String Train1 = txtcmbFromTrain.getText();
            
            cmbDesTrain.removeAllItems(); // <- Clear comboboxB
            
            try
            {
            	DatabaseConncetion();	
            	ResultSet r2;
            	r2=stmt.executeQuery("select * from Trains where Source ='" + Train1 + "'");
            	
            	if (r2.next()) {
            		
            		int valTrainID		=	r2.getInt("TrainID");
            		String valTrainName	=	r2.getString("TrainName");
            		            		            		
            		            		
//            		System.out.print("\n Train No :" +valTrainID);
//            		System.out.print("\n Train Name :" +valTrainName);            		            		
            		            		            
            		String getSourceTrain = txtcmbFromTrain.getText();
            		
            		
            		ResultSet rsDesTrain;
            		rsDesTrain=stmt.executeQuery("select * from Trains where Source ='" + getSourceTrain + "'");
            		
            		while(rsDesTrain.next()) {
            			            			
            			String valDesTrainName	=	rsDesTrain.getString("Destination");
            			            			
            			cmbDesTrain.addItem(valDesTrainName);
            			            			            		            			        			
            		}
            	}
            	
            }
            catch(Exception ex)
            {
    			System.out.println(ex.getMessage());
            }
        }
		
//		if(it.getSource()==cmbDesTrain)                        
//        {   
//			chkDesTrain=(String)it.getItem();
//            txtcmbDesTrain.setText(chkDesTrain);				                                 
//            		
//            
//        }

//		}
		
//		if (Train1.equals(Train2))
//		{
//			System.out.print("Both are equals");
//		}
//		else
//		{
//			System.out.print("Both are not equals");
//		}
				                                          
    }
	
	
	
	public void FrameMyTicketsFunction(String uname, String UserID)
	{
		frameMyTickets.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		frameMyTickets.invalidate();
		frameMyTickets.validate();
		frameMyTickets.repaint();
		
		frameMyTickets.getContentPane().setLayout(null);
		frameMyTickets.setBounds(200,10,900,700);
		frameMyTickets.setResizable(false);
		
		txtuname	= new JTextField(uname);
		
		txtuname.setBounds(100,10,100,20);
		frameMyTickets.getContentPane().add(txtuname);
		txtuname.setVisible(false);
		
		txtUserID	=	new JTextField(UserID);
		txtUserID.setBounds(10,10,100,20);
		frameMyTickets.getContentPane().add(txtUserID);
		txtUserID.setVisible(false);
		
		frameMyTickets.setTitle("My Tickets - Indian Railway");

		lblIcon.setBounds(250, 35, 100, 75);
		frameMyTickets.getContentPane().add(lblIcon);
		frameMyTickets.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(381, 30, 269, 50);			
		lbl_lifeline.setBounds(448, 73, 150, 25);			
		
		frameMyTickets.getContentPane().add(lblLoginSystem);			
		frameMyTickets.getContentPane().add(lbl_lifeline);
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
										
			
		frameMyTickets.setLayout(new FlowLayout());
		
		//Retrive User's ID
		String valUserID		=	txtUserID.getText();
		int valIntUserID		=	Integer.parseInt(valUserID);
			
	    Statement stmt, stmt_train;
	    String query, query_train;
	    ResultSet rs, rs_train;
	 
	    // 2 dimension array to hold table contents
	    // it holds temp values for now
	    Object rowData[][] = {{"#", "Ticket Number","Train Number", "Train Name", "From","Destination", "Class","Ticket Type","Journey Date","Passengers"}};
	    
	    // array to hold column names
	    Object columnNames[] = { "#", "Ticket Number","Train Number", "Train Name", "From","Destination", "Class","Ticket Type","Journey Date","Passengers"};
	    
	    	 
	    // create a table model and table based on it
	    
	    DefaultTableModel mTableModel = new DefaultTableModel(rowData, columnNames);
	    JTable table = new JTable(mTableModel);
	    
	    ((DefaultTableModel)table.getModel()).fireTableDataChanged();
	 
	    // try and connect to the database
	    try 
	    {
	    	DatabaseConncetion();
			stmt=conn.createStatement();
			stmt_train=conn.createStatement();
	    	
		    query = "select * from eTicketing where UserID =" + valIntUserID + " order by ID desc";		    		   
		    rs = stmt.executeQuery(query);
		            		        		       
    		table.setPreferredScrollableViewportSize(new Dimension(850, 450) );
    		table.setFillsViewportHeight(true);    		    		    	
		    JScrollPane scrollPane = new JScrollPane(table);
		    frameMyTickets.add(scrollPane, BorderLayout.CENTER);
		    		 
		    // remove the temp row
		    mTableModel.removeRow(0);
		    
		    int i=1;
		    // create a temporary object array to hold the result for each row
		    Object[] rows;
		    // for each row returned
		    while (rs.next()) {
		      // add the values to the temporary row
		    	
		    	int valTicketNumber		=	rs.getInt("TicketNumber");        		
        		int valTrainID			=	rs.getInt("TrainID");        		
        		String valJourneyDate	=	rs.getString("JourneyDate");        		
        		String valTrainClass	=	rs.getString("TrainClass");
        		String valTrainType		=	rs.getString("TicketType");        		        		
        		int valPassengers		=	rs.getInt("Passengers");
        		
        		query_train = "select * from Trains where TrainID =" + valTrainID;		    		   
    		    rs_train = stmt_train.executeQuery(query_train);
    		    
    		    while (rs_train.next()) 
    		    {
    		    	String valTrainName			=	rs_train.getString("TrainName");
        			String valTrainSource		=	rs_train.getString("Source");
        			String valTrainDestination	=	rs_train.getString("Destination");
    		    	    		    
    		    	rows = new Object[] { i, valTicketNumber, valTrainID,valTrainName, valTrainSource, valTrainDestination, valTrainClass ,valTrainType,valJourneyDate,valPassengers };
        		
    		    	//rows = new Object[]{rs.getString(1), rs.getString(2), rs.getString(3)};
        			// add the temp row to the table
        			mTableModel.addRow(rows);
        			mTableModel.fireTableDataChanged();
    		    }
    		    i++;
		    }
		 
		    
	    } 
	    catch (Exception e) 
	    {
	      System.err.println("Exception: " + e.getMessage());
	    }

				
		
		frameMyTickets.setJMenuBar(dashboardMenuBar(uname,UserID));
	}

	
	
	public void FrameHelpFunction() 
	{		
		frameHelp.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		frameHelp.getContentPane().setLayout(null);
		frameHelp.setResizable(false);

		lblIcon.setBounds(236, 50, 100, 75);
		frameHelp.getContentPane().add(lblIcon);
		frameHelp.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(381, 50, 269, 50);
		frameHelp.getContentPane().add(lblLoginSystem);
		
		lbl_lifeline.setBounds(448, 93, 150, 25);
		frameHelp.getContentPane().add(lbl_lifeline);
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
		
		//frameHelp.setLayout(new FlowLayout());
		
		frameHelp.setLayout(new BorderLayout());
		
		   
		
		JTextArea area=new JTextArea(
				"\n How can a user Registration ?"+
				"\n => Click on Registration Menu, user will register in this page with own Mobile Number as a UserName."+
								
				"\n\n How can a User Login ?"+
				"\n => After Registration a user can login with own Mobile Number and password will be same Mobile No. under Login Area Menu"	+
								
				"\n\n How to book a Train Ticket ?"+
				"\n => In the e-Ticketing Page.... first of all a User will select a Train from 'From Train' ComboBox."+
				"\n => After From Train selection - Destination Trains will be load...now user can select a Destination Train"+
				"\n => Now! it's time for date when a user wants to travel,"+
				"\n\n => Travel Date Selection's Conditions...."+
				"\n 1) Traveler cannot travel on a previous date. "+
				"\n 2) Passengers cannot book tickets for more than 15 days. "+
				"\n\n  If the above condition is correct then passenger, class type, train time and ticket price options will be displayed."+
				
				
				")"
				);  
		area.setBounds(20,150,840,350);		
		area.setEditable(false); // set textArea non-editable
		JScrollPane scroll = new JScrollPane(area);
		scroll.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);

		//Add Textarea in to middle panel
		   
		    
		frameHelp.add(area);
		
		
		
		frameHelp.getContentPane().setLayout(null);
		
		lblProgrammer.setBounds(300, 550, 296, 35);
		frameHelp.getContentPane().add(lblProgrammer);
		
		JLabel lblProgrammer_1 = new JLabel("P.U. Regional Centre - Sri Muktsar Sahib");
		lblProgrammer_1.setForeground(Color.red);
		lblProgrammer_1.setFont(new Font("Verdana", Font.BOLD, 15));
		lblProgrammer_1.setBounds(270, 580, 357, 35);
		frameHelp.getContentPane().add(lblProgrammer_1);
			
		frameHelp.getContentPane().add(lblProgrammer);

		// Add listeners for the buttons
		btnLogin.addActionListener(this);

		enableEvents(AWTEvent.WINDOW_EVENT_MASK);
		
		frameHelp.setBounds(200,10,900,700);
		//frameHelp.setSize(800,600);
		//frameHelp.setVisible(true);
		frameHelp.setJMenuBar(loginMenuBar());
		
		
		
				       
	}

	
	
	public void FrameLoginFunction() 
	{
		frameLogin.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		
		frameLogin.getContentPane().setLayout(null);
		frameLogin.setResizable(false);

		lblIcon.setBounds(236, 50, 100, 75);
		frameLogin.getContentPane().add(lblIcon);
		frameLogin.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(381, 50, 269, 50);
		frameLogin.getContentPane().add(lblLoginSystem);
		
		lbl_lifeline.setBounds(448, 93, 150, 25);
		frameLogin.getContentPane().add(lbl_lifeline);
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
		
		
		lblUserName.setBounds(300, 180, 75, 25);		
		frameLogin.getContentPane().add(lblUserName);
		
		txtUserName.setBounds(409, 180, 181, 25);		
		frameLogin.getContentPane().add(txtUserName);
		
		lblPassword.setBounds(300, 220, 75, 25);
		
		frameLogin.getContentPane().add(lblPassword);
		txtPassword.setBounds(409, 220, 181, 25);
		
		frameLogin.getContentPane().add(txtPassword);
		btnLogin.setBounds(509, 269, 75, 25);
		
		btnLogin.setBackground(Color.orange);
		frameLogin.getContentPane().add(btnLogin);
		
		lblResults.setBounds(310, 350, 322, 50);
		lblResults.setFont(font1);
		
		frameLogin.getContentPane().add(lblResults);
		lblProgrammer.setBounds(300, 380, 296, 35);
		
							
		JLabel lblProgrammer_1 = new JLabel("P.U. Regional Centre - Sri Muktsar Sahib");
		lblProgrammer_1.setForeground(Color.red);
		lblProgrammer_1.setFont(new Font("Verdana", Font.BOLD, 15));
		lblProgrammer_1.setBounds(270, 477, 357, 35);
		frameLogin.getContentPane().add(lblProgrammer_1);
			
		frameLogin.getContentPane().add(lblProgrammer);

		// Add listeners for the buttons
		btnLogin.addActionListener(this);

		enableEvents(AWTEvent.WINDOW_EVENT_MASK);
		
		frameLogin.setBounds(200,10,900,700);
		//frameLogin.setSize(800,600);
		//frameLogin.setVisible(true);
		frameLogin.setJMenuBar(loginMenuBar());
				       
	}

	
	
	public void checkLogin()
	{
		try 
		{
			DatabaseConncetion();
			
	    	String valUserName2	=	txtUserName.getText();
			String valPassword2	=	String.valueOf(txtPassword.getPassword());
			
			
			rs=stmt.executeQuery("select * from UserLogin where UserName ='" + valUserName2 + "' and UserPassword= '" + valPassword2 + "'");
			
			if (rs.next()) {
				
				sessionOut = 1;
				
				
				String UserID 		= rs.getString("UserID");
				String User_name 	= rs.getString("FullName");
				
				PreparedStatement pre_sess=conn.prepareStatement("UPDATE UserLogin SET LoginSession='"+1+"' WHERE UserID="+UserID);
                pre_sess.executeUpdate();
				

				lblResults.setForeground(Color.BLACK);
				lblResults.setText("Welcome : " + User_name);
				ImageIcon icon = new ImageIcon("images/rail.gif");
		        
				JOptionPane.showMessageDialog(null, "Welcome "+User_name+" ", "Authentication", JOptionPane.INFORMATION_MESSAGE, icon);
		          
								
				frameLogin.dispose();
				
				DashboardFunction(User_name,UserID);

			} else {
				sessionOut = 0;
				
				//lblResults.setForeground(Color.RED);
				//lblResults.setText("Wrong Authentication");
				JOptionPane.showMessageDialog(null, "Wrong Authentication !!!", "Wrong Authentication!", JOptionPane.ERROR_MESSAGE);
	    	  		  		
				return;
				
			}
            stmt.close();
            conn.close();
		}
		catch(Exception e)
        {
			System.out.println(e.getMessage());
        }	
	}
	
	
		
	
	public void RegisterFunction()
	{
							
		frameRegister.getContentPane().setLayout(null);
		frameRegister.setResizable(false);
		frameRegister.setBounds(200,10,900,700);

		lblIcon.setBounds(236, 50, 100, 75);
		frameRegister.getContentPane().add(lblIcon);
		frameRegister.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(381, 50, 269, 50);
		frameRegister.getContentPane().add(lblLoginSystem);
		
		lbl_lifeline.setBounds(448, 93, 153, 25);
		frameRegister.getContentPane().add(lbl_lifeline);
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
			
		lblUserFullName	=	new JLabel("Name : ");
		lblUserMobName	=	new JLabel("MobileNo/User Name : ");
		lblUserState	=	new JLabel("State : ");
		lblUserCity		=	new JLabel("District : ");
		
				
		lblUserFullName.setBounds(52, 200, 100, 25);
		lblUserMobName.setBounds(52, 250, 150, 25);
		lblUserState.setBounds(52, 300, 100, 25);
		lblUserCity.setBounds(52, 350, 100, 25);
		
		
		frameRegister.getContentPane().add(lblUserFullName);
		frameRegister.getContentPane().add(lblUserMobName);
		frameRegister.getContentPane().add(lblUserState);
		frameRegister.getContentPane().add(lblUserCity);
		
		
		label_txtUserFullName	=	new JLabel();
		label_txtUserMobName	=	new JLabel();
		
		labelMSG_txtUserMobName	=	new JLabel("Mobile No. will be your UserName & Password");
		labelMSG_txtUserMobName.setBounds(470,250,400,25);
		labelMSG_txtUserMobName.setForeground(Color.red);
		frameRegister.getContentPane().add(labelMSG_txtUserMobName);
		
		label_txtUserMobName.setForeground(Color.red);
		label_txtUserMobName.setBounds(480,250,180,25);
		
		label_txtUserFullName.setForeground(Color.red);
		label_txtUserFullName.setBounds(480,200,180,25);
		
		frameRegister.getContentPane().add(label_txtUserFullName);
		frameRegister.getContentPane().add(label_txtUserMobName);
		
		txtUserFullName	=	new JTextField(40);
		
		txtUserMobName	=	new JTextField(10);
		
		txtUserFullName.setBounds(250, 200, 200, 25);
		txtUserMobName.setBounds(250, 250, 200, 25);
		
		frameRegister.getContentPane().add(txtUserFullName);
		frameRegister.getContentPane().add(txtUserMobName);
		
		
		txtUserFullName.addKeyListener(new KeyAdapter() {
	        public void keyPressed(KeyEvent ke) {
	           String value = txtUserMobName.getText();
	           int l = value.length();
	           if (ke.getKeyChar() >= '0' && ke.getKeyChar() <= '9') {
	        	   txtUserFullName.setEditable(false);
	        	   JOptionPane.showMessageDialog(null, "Enter only numeric digits(0-9) \n\n"+ value +" ", "Invalid!", JOptionPane.ERROR_MESSAGE);		  			
		  		   return;
	           } else {
	        	   txtUserFullName.setEditable(true);
	        	   label_txtUserFullName.setText("");
	        	   
	           }
	        }
	     });
		
		
		txtUserMobName.addKeyListener(new KeyAdapter() {
	        public void keyPressed(KeyEvent ke) {
	           String value = txtUserMobName.getText();
	           int l = value.length();
	           if (ke.getKeyChar() >= '0' && ke.getKeyChar() <= '9') {
	        	   txtUserMobName.setEditable(true);
	        	   label_txtUserMobName.setText("");
	           } else {
	        	   txtUserMobName.setEditable(false);
	        	   JOptionPane.showMessageDialog(null, "Enter only numeric digits(0-9) \n\n"+ value +" ", "Invalid!", JOptionPane.ERROR_MESSAGE);
		    	    		  			
		  		   return;
	               
	           }
	        }
	     });
		
		
		cmbState		= new JComboBox();
		cmbState.setBounds(250, 300, 200, 25);
		
		try 
		{
			//Call DatabaseConnection
			DatabaseConncetion();				    			
			rs=stmt.executeQuery("select * from StateCodes");
			
			cmbState.addItem("Select-State");
			while (rs.next()) {
				
				sessionOut = 1;
				
				valStateName = rs.getString("StateName");
				
				cmbState.addItem(valStateName);
								
				frameRegister.getContentPane().add(cmbState);			
								
			} 
            
		}
		catch(Exception e)
        {
			System.out.println(e.getMessage());
        }
		
		txtStateID	=	new JTextField(10);
		//txtStateID.setBounds(500, 300, 200, 25);
		frameRegister.getContentPane().add(txtStateID);
		
		
		txtCity		=	new JTextField(20);
			
		txtCity.setBounds(250, 350, 200, 25);			
		frameRegister.getContentPane().add(txtCity);
		
		
		cmbState.addItemListener(new ItemListener(){
						    			
			@Override
		     public void itemStateChanged(ItemEvent e) {
				System.out.println(e.getItem() + " " + e.getStateChange() );
		         if(e.getSource() == cmbState){
		             		             
		             strcls=(String)cmbState.getSelectedItem();
		          		             
		             System.out.println("Selected" + strcls);
		             try
		                {
		                	DatabaseConncetion();	
		                	ResultSet r1;
		                	r1=stmt.executeQuery("select * from StateCodes where StateName ='" + strcls + "'");
		                	
		                	if (r1.next()) {
		                		
		                		valStateCode	=	r1.getString("StateCode");
		                		
		                		txtStateID.setText(valStateCode);		                				                				                   
		                	}
		                }
		                catch(Exception ex)
		                {
		        			System.out.println(ex.getMessage());
		                }		             		               
		         }
		         if(e.getStateChange() == ItemEvent.DESELECTED){
		             System.out.println("Deselected");
		         } 
		     }
				           
        });
		
						
		btnSignUp = new Button("Save");		
		btnSignUp.setBounds(250,516,100,25);		
		btnSignUp.setBackground(Color.orange);
		
		// Add listeners for the buttons
		btnSignUp.addActionListener(this);
					
		frameRegister.getContentPane().add(btnSignUp);
				
		btnCleanSignUp = new Button("Clear Form");		
		btnCleanSignUp.setBounds(350,516,100,25);		
		btnCleanSignUp.setBackground(Color.orange);
		
		// Add listeners for the buttons
		btnCleanSignUp.addActionListener(this);			
		frameRegister.getContentPane().add(btnCleanSignUp);
		
		//frameRegister.setSize(900,750);
		frameRegister.setJMenuBar(loginMenuBar());
		
							
	}
	
	// To trap events for each buttons
	public void actionPerformed(ActionEvent actEvt)
	{
		if(actEvt.getSource() == btnETicketSave)
		{
			int TicketNumber	=	1001;
			
			String valUserName		= txtuname.getText();
			String valTrainPass		= txtETicketPassenger.getText();
			int intvalTrainPass 	= Integer.parseInt(valTrainPass);
								
			String valUserID		= 	txtUserID.getText();
			int valIntUserID 		= 	Integer.parseInt(valUserID);
			
			String valTrainClass	= 	txtETikcetTrainClass.getText();
			String valTrainType		= 	txtETikcetTrainType.getText();
								
			String valTicketPrize	= 	txtETicketPrize.getText();
			String valTrainID		= 	txtvalDesTrainID.getText();
						
			String valSelectedDate	=	txtSelectedDate.getText();
			String valCurrentDate	=	txtCurrentDate.getText();
						
			
			String s1_Single 	= new String("Single");
            String s2_Return 	= new String("Return");
            
            String s3_Standard	= new String("Standard");
            String s4_Economy	= new String("Economy");
            String s5_FirstClass= new String("First Class");
            
						
//			System.out.print("\n UserID =" + valUserID);			
//			System.out.print("\n TrainID =" + valTrainID);
//			System.out.print("\n Train Class =" + valTrainClass);
//			System.out.print("\n Train Type =" + valTrainType);								
//			System.out.print("\n Ticket Prize =" + valTicketPrize);
			
			try
            {
            	DatabaseConncetion();	
            	ResultSet r1;
            	r1=stmt.executeQuery("select * from eTicketing ORDER BY ID Desc Limit 1");
            	            	            	
            	if (r1.next()) {
            		
            		valTicketNumber		=	r1.getInt("TicketNumber");            		           
            		valTicketNumber		=	valTicketNumber + 1;
            		            		
            		flag=1;
					            		                        					
    				if(flag==1)
    	            {
    					String sql_reg="Insert into eTicketing"+"(TicketNumber,UserID,TrainID,JourneyDate,Passengers,TrainClass,TicketType,TicketPrize)"+"Values"+ ""+ "("+valTicketNumber+",'"+valIntUserID+"',"+valTrainID+",'"+valSelectedDate+"',"+intvalTrainPass+",'"+valTrainClass+"','"+valTrainType+"',"+valTicketPrize+")";
    					reply=JOptionPane.showConfirmDialog(null,"Do you Want Generate this Ticket Number "+ valTicketNumber +" ?");
    	                if(reply==JOptionPane.YES_OPTION)
    	                {
    	                	nrows=stmt.executeUpdate(sql_reg);                                                                             
    	                    JOptionPane.showMessageDialog(null,"Please Note Your Ticket Number "+ valTicketNumber +" ");
    	                    
    	                    //FrameMyTicketsFunction(String uname, String UserID)
    	                    
    	                    frameETicketing.dispose();
    	                    DashboardFunction(valUserName, UserID);    	                        	                   
    	                    frameDashboard.setVisible(true);
    	                }                                       
    	                if(reply==JOptionPane.NO_OPTION)
    	                {                                               
    	                	return;
    	                }       
    	            }                            					    			    		
            	}
            	else
            	{
            		flag=1;
            		valTicketNumber	=	TicketNumber;
            		    								
    				if(flag==1)
    	            {
    					String sql_reg="Insert into eTicketing"+"(TicketNumber,UserID,TrainID,JourneyDate,Passengers,TrainClass,TicketType,TicketPrize)"+"Values"+ ""+ "("+valTicketNumber+",'"+valUserID+"',"+valIntUserID+",'"+valSelectedDate+"',"+intvalTrainPass+",'"+valTrainClass+"','"+valTrainType+"',"+valTicketPrize+")";
    					reply=JOptionPane.showConfirmDialog(null,"Do you Want Generate this Ticket Number "+ valTicketNumber +" ?");
    	                if(reply==JOptionPane.YES_OPTION)
    	                {
    	                	nrows=stmt.executeUpdate(sql_reg);                                                                             
    	                    JOptionPane.showMessageDialog(null,"Please Note Your Ticket Number "+ valTicketNumber +" ");
    	                    
    	                    frameETicketing.dispose();
    	                    DashboardFunction(valUserName, UserID);    	                    
    	                    frameDashboard.setVisible(true);
    	                    
    	                }                                       
    	                if(reply==JOptionPane.NO_OPTION)
    	                {                                               
    	                	return;
    	                }       
    	            }
            	}
            }
            catch(Exception ex)
            {
    			System.out.println(ex.getMessage());
            }
			
			//SELECT ID FROM YourTable ORDER BY ID Desc Limit 1
						
						
						
		}
		if(actEvt.getSource() == btnETicketReset)
		{
			cmbETicketPassenger.setEnabled(true);
	        cmbFromTrain.setEnabled(true);
	        cmbDesTrain.setEnabled(true);	        
	        cmbETicketClass.setEnabled(true);
			cmbETicketTrainType.setEnabled(true);			
			btnETicketSave.setEnabled(false);			
			dateChooserTrain.setEnabled(true);
		}
		
		if(actEvt.getSource() == btnETicketTotalPayment)
		{
			String valTrainPass		= txtETicketPassenger.getText();
			int intvalTrainPass 	= Integer.parseInt(valTrainPass);
            
			
			
			String valTrainClass	= txtETikcetTrainClass.getText();
			
			System.out.print("Train Class=" + valTrainClass);
			String valTrainType		= txtETikcetTrainType.getText();
				          
            String getDesTrainID	= txtvalDesTrainID.getText();		            
            int intgetDesTrainID 	= Integer.parseInt(getDesTrainID);
            
                        
            String s1_Single 	= new String("Single");
            String s2_Return 	= new String("Return");
            
            String s3_Standard	= new String("Standard");
            String s4_Economy	= new String("Economy");
            String s5_FirstClass= new String("First Class");
            
            cmbETicketPassenger.setEnabled(false);
            cmbFromTrain.setEnabled(false);
            cmbDesTrain.setEnabled(false);
            
            cmbETicketClass.setEnabled(false);
    		cmbETicketTrainType.setEnabled(false);
    		
    		btnETicketSave.setEnabled(true);
    		
    		dateChooserTrain.setEnabled(false);
    		    	
                        
            try
	        {
	        	DatabaseConncetion();
	        	ResultSet rsDesTrain5;
	        	
	        	System.out.print("entr try");
	        	rsDesTrain5=stmt.executeQuery("select * from Trains where TrainID =" + intgetDesTrainID);
	    			        		        
	        	while(rsDesTrain5.next()) 
	        	{				        			            				            			            	
	        		int valDesTrainKM2		=	rsDesTrain5.getInt("KiloMeter");
	        		
	        		
	        		if (valTrainClass.equals(s3_Standard))
	        		{
	        			if (valTrainType.equals(s1_Single))
			            {		            			    	    			    					    					    				            	
			            	int TotalKMPrize = valDesTrainKM2 * intvalTrainPass;				            			            	
			            	txtETicketPrize.setText(String.valueOf(TotalKMPrize));
			            									    		
			            }
			            else
			            {
			            	int TotalKMPrize = valDesTrainKM2 * 2 * intvalTrainPass;				            	
			            	txtETicketPrize.setText(String.valueOf(TotalKMPrize));
			            }
	        			
	        		}
	        		else if (valTrainClass.equals(s4_Economy))
	        		{
	        			if (valTrainType.equals(s1_Single))
			            {		            			    	    			    					    					    				            	
			            	int TotalKMPrize = valDesTrainKM2 * 2  * intvalTrainPass;				            			            	
			            	txtETicketPrize.setText(String.valueOf(TotalKMPrize));
			            									    		
			            }
			            else
			            {
			            	int TotalKMPrize = valDesTrainKM2 * 4 * intvalTrainPass;				            	
			            	txtETicketPrize.setText(String.valueOf(TotalKMPrize));
			            }
	        		}
	        		else
	        		{
	        			if (valTrainType.equals(s1_Single))
			            {		            			    	    			    					    					    				            	
			            	int TotalKMPrize = valDesTrainKM2 * 3  * intvalTrainPass;				            			            	
			            	txtETicketPrize.setText(String.valueOf(TotalKMPrize));
			            									    		
			            }
			            else
			            {
			            	int TotalKMPrize = valDesTrainKM2 * 6 * intvalTrainPass;				            	
			            	txtETicketPrize.setText(String.valueOf(TotalKMPrize));
			            }
	        		}
	        			        			        				            			        
	        	}		            
	        }
			catch(Exception ex)
	        {
	    		System.out.println(ex.getMessage());
	        }
            
            
    
		}
		if (actEvt.getSource() == btnfindTrainSearch) 
		{
			findTrainFunction();
		}
		
		if (actEvt.getSource() == btnfindTrainClean) 
		{
			txtfindTrainName.setText("");
		}
		
		if (actEvt.getSource() == btnLogin) 
		{
			checkLogin();			
		}
		
		if (actEvt.getSource() == btnCleanSignUp) 
		{
			txtUserFullName.setText("");
			txtUserMobName.setText("");
			txtCity.setText("");			
		}
		
		if (actEvt.getSource() == btnSignUp)
		{
			if (txtUserFullName.getText().isEmpty()) {
				txtUserFullName.setEditable(true);
	            label_txtUserFullName.setText("* Name Can't be Blank!");
	            		          		           
			}
			else {
				txtUserFullName.setEditable(true);
	        	label_txtUserFullName.setText("");
	        	
	            //Save the Record
	            String valUserFullName	=	txtUserFullName.getText();
				String valUserMobName	=	txtUserMobName.getText();
				String valUserCity		=	txtCity.getText();
				
				flag=1;
										
				try 
				{																	
					String sql_reg="Insert into UserLogin"+"(UserName,UserPassword,FullName,StateCode,DistrictCode)"+"Values('"+valUserMobName+"','"+valUserMobName+"','"+valUserFullName+"','"+strcls+"','"+valUserCity+"')";					
					if(flag==1)
	                {
	                        reply=JOptionPane.showConfirmDialog(null,"Do you Want Register this "+ valUserMobName +" ?");
	                        if(reply==JOptionPane.YES_OPTION)
	                        {
	                        	nrows=stmt.executeUpdate(sql_reg);                                                                             
	                        	JOptionPane.showMessageDialog(null,"User Name/Mobile No "+ valUserMobName +" Successfully Registered!!!");
	                        	
	                        	frameRegister.dispose();      			
	                			frameDashboard.dispose();			        	
	                			frameHomePage.dispose();
	                			frameLogin.setVisible(true);
	                        	
	                        	FrameLoginFunction();
	                        		                           
	                        }                                       
	                        if(reply==JOptionPane.NO_OPTION)
	                        {                                               
	                                return;
	                        }       
	                }                        
					
				}
				catch(Exception e)
		        {
					System.out.println(e.getMessage());
		        }	
	            //Closed Save the Record

			}									           	        		          

	    }
			
	} // End of actionPerformed() method

	
			
	//DashboardFunction - After Successfully Authentication
		public void DashboardFunction(String uname, String UserID)
		{		
			frameDashboard.setTitle( uname + " - Dashboard - Indian Railway");
			frameDashboard.setVisible(true);			
			frameDashboard.getContentPane().setLayout(null);
			frameDashboard.setResizable(false);
			
			frameDashboard.setBounds(200,10,900,700);
			
			lblIcon.setBounds(363, 158, 100, 75);			
			frameDashboard.getContentPane().add(lblIcon);
			frameDashboard.setIconImage(titleIcon);
			
			
			lblLoginSystem.setBounds(325, 253, 269, 50);
			lbl_lifeline.setBounds(353, 303, 153, 25);
			lblProgrammer.setBounds(300, 403, 296, 35);
			
			
			frameDashboard.getContentPane().add(lblLoginSystem);			
			frameDashboard.getContentPane().add(lbl_lifeline);
			
			lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
			lblLoginSystem.setForeground(Color.blue);
			
			lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
			lbl_lifeline.setForeground(Color.darkGray);
			
			
			lblProgrammer.setFont(new Font("Verdana", Font.BOLD, 13));
			lblProgrammer.setForeground(Color.black);
					
			frameDashboard.getContentPane().add(lblProgrammer);
			
			JLabel lblProgrammer_1 = new JLabel("P.U. Regional Centre - Sri Muktsar Sahib");
			lblProgrammer_1.setForeground(Color.red);
			lblProgrammer_1.setFont(new Font("Verdana", Font.BOLD, 15));
			lblProgrammer_1.setBounds(270, 477, 357, 35);
			frameDashboard.getContentPane().add(lblProgrammer_1);

			enableEvents(AWTEvent.WINDOW_EVENT_MASK);
						
			frameDashboard.setJMenuBar(dashboardMenuBar(uname,UserID));			
			
		}
		//Closed DashboardFunction - After Successfully Authentication

	
	//##########################################################################################
	//	Find Train Function
	
	public void FindTrainFunction(String uname, String UserID)
	{
		frameFindTrain.setTitle( uname + " - Find Train - Indian Railway");
		frameFindTrain.setVisible(true);
		frameFindTrain.setResizable(false);
		
		frameFindTrain.getContentPane().setLayout(null);
		frameFindTrain.setBounds(200,10,900,700);

		lblIcon.setBounds(236, 30, 100, 75);
		frameFindTrain.getContentPane().add(lblIcon);
		frameFindTrain.setIconImage(titleIcon);
		
		lblLoginSystem.setBounds(381, 30, 269, 50);
		frameFindTrain.getContentPane().add(lblLoginSystem);
		
		lbl_lifeline.setBounds(448, 73, 150, 25);
		frameFindTrain.getContentPane().add(lbl_lifeline);
		
		
		lblLoginSystem.setFont(new Font("Verdana", Font.BOLD, 24));
		lblLoginSystem.setForeground(Color.blue);
		
		lbl_lifeline.setFont(new Font("Verdana", Font.BOLD, 12));
		lbl_lifeline.setForeground(Color.darkGray);
		
		frameFindTrain.setJMenuBar(dashboardMenuBar(uname,UserID));
		
	
		findTrainNo	=	new JLabel("Train No. :");
		findTrainNo.setBounds(286, 150, 100, 25);		
		frameFindTrain.getContentPane().add(findTrainNo);
		
		errtxtfindTrainName	=	new JLabel();
		errtxtfindTrainName.setForeground(Color.red);
		errtxtfindTrainName.setBounds(409,180,180,25);
		frameFindTrain.getContentPane().add(errtxtfindTrainName);
							
				
		txtfindTrainName	= new JTextField(10);
		txtfindTrainName.setBounds(350, 150, 181, 25);
		frameFindTrain.getContentPane().add(txtfindTrainName);
		
		txtfindTrainName.addKeyListener(new KeyAdapter() {
	        public void keyPressed(KeyEvent ke) {
	           String value = txtfindTrainName.getText();
	           int l = value.length();
	           if (ke.getKeyChar() >= '0' && ke.getKeyChar() <= '9') {
	        	   txtfindTrainName.setEditable(true);
	        	   errtxtfindTrainName.setText("");
	           } else {
	        	   txtfindTrainName.setEditable(false);
	               errtxtfindTrainName.setText("* Enter only numeric digits(0-9)");
	           }
	        }
	     });
		
		//txtfindTrainNumber;
		
				
		btnfindTrainSearch = new Button("Search");		
		btnfindTrainSearch.setBounds(550,150,100,25);		
		btnfindTrainSearch.setBackground(Color.orange);
		
		// Add listeners for the buttons
		btnfindTrainSearch.addActionListener(this);
		frameFindTrain.getContentPane().add(btnfindTrainSearch);
			
		
		btnfindTrainClean = new Button("Clear");
		btnfindTrainClean.setBackground(Color.orange);
		btnfindTrainClean.setBounds(655,150,100,25);
		
		// Add listeners for the buttons
		btnfindTrainClean.addActionListener(this);
		frameFindTrain.getContentPane().add(btnfindTrainClean);
		
		queryfindTrainNo=	new JLabel();
		
		findTrainNo		=	new JLabel();
		findTrainName	=	new JLabel();
		findTrainSource	=	new JLabel();
		findDepTime		=	new JLabel();
		findTrainDes	=	new JLabel();
		findArrTime		=	new JLabel();
		
		queryfindTrainNo.setBounds(50,200,600,50);
		queryfindTrainNo.setFont(new Font("Verdana", Font.BOLD, 20));
		btnfindTrainClean.setForeground(Color.black);
		frameFindTrain.getContentPane().add(queryfindTrainNo);
		
		findTrainNo.setBounds(50,250,400,50);
		findTrainName.setBounds(50,300,400,50);
		findTrainSource.setBounds(50,350,400,50);
		findDepTime.setBounds(50,400,400,50);
		findTrainDes.setBounds(50,450,400,50);
		findArrTime.setBounds(50,500,400,50);
		
		frameFindTrain.getContentPane().add(findTrainNo);
		frameFindTrain.getContentPane().add(findTrainName);
		frameFindTrain.getContentPane().add(findTrainSource);
		frameFindTrain.getContentPane().add(findDepTime);
		frameFindTrain.getContentPane().add(findTrainDes);
		frameFindTrain.getContentPane().add(findArrTime);
		
											
	}
	
	
	public void findTrainFunction()
	{
		String valtxtfindTrainName	=	txtfindTrainName.getText();
				
		if(valtxtfindTrainName.isEmpty()) {
			txtfindTrainName.setEditable(false);
			errtxtfindTrainName.setText("* Can't blank!!!");
                       
		}
		else {
			txtfindTrainName.setEditable(true);
			errtxtfindTrainName.setText("");			
			try 
			{				
								   
			    DatabaseConncetion();
			    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/IndianRailway","root","");																																	
				String query = "select * from Trains where TrainNo ='" + valtxtfindTrainName + "'";
				
				rs = stmt.executeQuery(query);
																													
				if (rs.next()) {
					String train_TrainNo 	= rs.getString("TrainNo");
					String train_TrainName	= rs.getString("TrainName");
					String train_Source		= rs.getString("Source");
					String train_DepTime	= rs.getString("DepTime");
					String train_Destination= rs.getString("Destination");
					String train_ArrTime	= rs.getString("ArrTime");
					
					queryfindTrainNo.setText("Your Query for : " + train_TrainNo);
					
					findTrainNo.setText("Train No. : " + train_TrainNo);
					findTrainName.setText("Train Nname. : " + train_TrainName);
					findTrainSource.setText("Source. : " + train_Source);
					findDepTime.setText("Departure Time. : " + train_DepTime);
					findTrainDes.setText("Destination : " + train_Destination);
					findArrTime.setText("Arrival Time : " + train_ArrTime);
											     
			     

				} else {
//					errtxtfindTrainName.setForeground(Color.RED);					
//					errtxtfindTrainName.setText("Train Number " + valtxtfindTrainName + " is not available");
					
					queryfindTrainNo.setText("Train Number " + valtxtfindTrainName + " is not available");
					queryfindTrainNo.setForeground(Color.RED);
					
					findTrainNo.setText("");
					findTrainName.setText("");
					findTrainSource.setText("");
					findDepTime.setText("");
					findTrainDes.setText("");
					findArrTime.setText("");
									
				}
	            stmt.close();
	            conn.close();
	            		
			}
			catch(Exception e)
	        {
				System.out.println(e.getMessage());
	        }
			
		}
    
	
	}
	// Closed Find Train Function
	//##########################################################################################
	
	//DatabaseConnection Function for one Time Database Connection with phpmyadmin (SQL Tool)
	public void DatabaseConncetion()
	{
		try 
		{			
			Class.forName("com.mysql.cj.jdbc.Driver");					
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/IndianRailway","root","");
			stmt=conn.createStatement();													            	
		}
		catch(Exception e)
        {
			System.out.println(e.getMessage());
        }				
	}
	//Closed DatabaseConnection Function for one Time Database Connection with phpmyadmin (SQL Tool)
	
	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					
					
					IndianRailway objIndianRailwaySystem = new IndianRailway();
					
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}
}

To connect java application with the mysql database, mysqlconnector.jar & jcalendar-1.4 file is required to be loaded.

download the jar file mysql-connector.jar

Two ways to load the jar file:

1) Paste the mysqlconnector.jar file in jre/lib/ext folder
2) Set classpath

	Section 1
	Home
	Introduction To Java
	Java Evolution
	Overview of Java
	Constants, Variables & Data Types
	Java Operators
	Branching Statements
	Looping Statements
	Section 2
	Classes, Objects & Methods
	Inheritance
	Array, String & Vectors
	Java Interfaces
	Java Packages
	Java Applet Programming
	Java Graphics Programming
Advance Java Programming
	Section 1
	Java AWT
	Java Event Handling
	Java File Handling
	Java MultiThreading
	Java Swing-I
	Java Swing-II
	Java Exception Handling
	Section 2
	Java Socket Programming
	Java Database Connectivity
	Java RMI
	Java Servlets
	Java Beans

Railway Reservation Project with MySQL | eclipse IDE | phpmyadmin | Advanced Java Programming

Useful Links

Visitors

Java Tutorials

Follow by Email

Follow Advanced Java Programming on Facebook

Popular Programs

Follow Advanced Java Programming on Twitter