lihong 20080424 1609.sql

使用java弄的,实现铁路售票的各种功能,供大家学习使用

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.27-community-nt


/*!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 utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema trainticket
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ trainticket;
USE trainticket;

--
-- Table structure for table `trainticket`.`railway`
--

DROP TABLE IF EXISTS `railway`;
CREATE TABLE `railway` (
  `trainno` char(10) NOT NULL default '',
  `railwayno` int(10) unsigned NOT NULL default '0',
  `railwaytype` char(10) NOT NULL default '',
  `seatcount` int(10) unsigned NOT NULL default '0',
  `useable` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`trainno`,`railwayno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `trainticket`.`railway`
--

/*!40000 ALTER TABLE `railway` DISABLE KEYS */;
INSERT INTO `railway` (`trainno`,`railwayno`,`railwaytype`,`seatcount`,`useable`) VALUES 
 ('5566',1,'超光速传送',356,120),
 ('A21',2,'硬座普快',123,122),
 ('B21',3,'硬座特快',321,321),
 ('C21',4,'硬座特快',564,540),
 ('D21',5,'硬座特快',678,321),
 ('E21',6,'硬座特快',678,321),
 ('F21',7,'硬座特快',678,121),
 ('G21',8,'硬座特快',345,111),
 ('H21',25,'软座普快',2008,2008),
 ('I21',26,'软座普快',2008,2007),
 ('J21',27,'软座普快',2008,2008),
 ('k10',9,'硬座特快',102,30),
 ('k11',25,'软座普快',2008,2008),
 ('k12',10,'软座普快',600,19),
 ('k13',11,'软座普快',2008,794),
 ('K21',28,'硬座特快',2008,2008),
 ('L21',25,'软座普快',2008,2007),
 ('M20',12,'软座普快',500,280),
 ('M21',25,'软座普快',2008,2008),
 ('N21',26,'软座普快',2008,2008),
 ('O21',13,'软座普快',677,600),
 ('P21',14,'软座普快',800,600),
 ('Q21',15,'软座普快',800,600),
 ('R21',16,'软座普快',800,600),
 ('S21',17,'软座普快',2008,1981),
 ('T21',18,'软座普快',2008,1992);
INSERT INTO `railway` (`trainno`,`railwayno`,`railwaytype`,`seatcount`,`useable`) VALUES 
 ('U21',19,'硬座特快',2008,2008),
 ('V21',20,'硬座特快',2008,1975),
 ('W21',21,'软座普快',2008,2008),
 ('X21',22,'硬座特快',2008,2008),
 ('Y21',23,'硬座特快',2008,2008),
 ('Z21',24,'软座普快',2008,1997);
/*!40000 ALTER TABLE `railway` ENABLE KEYS */;


--
-- Table structure for table `trainticket`.`salereturnticket`
--

DROP TABLE IF EXISTS `salereturnticket`;
CREATE TABLE `salereturnticket` (
  `ticketno` char(10) NOT NULL default '',
  `trainno` char(10) NOT NULL default '',
  `railwayno` int(10) unsigned NOT NULL default '0',
  `seatno` int(10) unsigned NOT NULL default '0',
  `salestage` varchar(45) NOT NULL default '',
  `startstage` varchar(45) NOT NULL default '',
  `arrivestage` varchar(45) NOT NULL default '',
  `changetrain` varchar(45) NOT NULL default '',
  `tickettype` varchar(20) NOT NULL default '',
  `starttime` time default NULL,
  `saletime` date NOT NULL default '0000-00-00',
  `ticketprice` float(20,2) NOT NULL default '0.00',
  PRIMARY KEY  (`trainno`,`railwayno`,`seatno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `trainticket`.`salereturnticket`
--

/*!40000 ALTER TABLE `salereturnticket` DISABLE KEYS */;
INSERT INTO `salereturnticket` (`ticketno`,`trainno`,`railwayno`,`seatno`,`salestage`,`startstage`,`arrivestage`,`changetrain`,`tickettype`,`starttime`,`saletime`,`ticketprice`) VALUES 
 ('5566','5566',5566,5566,'人间','人间','天堂','大气','卧票','00:00:00','2008-05-01',100000000376832.00),
 ('202','A21',867,500,'南昌','南昌','北京','石家庄','卧票','18:00:00','2008-05-01',521.00),
 ('203','B21',6789,500,'南昌','南昌','九江','阳新','卧票','08:00:00','2008-05-01',132.00),
 ('204','C21',456,500,'香港','香港','台北','九龙','卧票','09:00:00','2008-05-01',451.00),
 ('999','D21',767,500,'澳门','澳门','武汉','长沙','卧票','10:00:00','2008-05-01',123.00),
 ('2008','E21',567,500,'台北','台北','武汉','长沙','卧票','11:00:00','2008-05-01',251.00),
 ('6788','F21',778,500,'九江','九江','香港','深圳','卧票','12:00:00','2008-05-01',231.00),
 ('646','G21',789,500,'阳新','阳新','香港','杭州','坐票','13:00:00','2008-05-01',211.00),
 ('205','H21',205,205,'上海','上海','北京','石家庄','坐票','11:00:00','2008-05-01',200.00);
INSERT INTO `salereturnticket` (`ticketno`,`trainno`,`railwayno`,`seatno`,`salestage`,`startstage`,`arrivestage`,`changetrain`,`tickettype`,`starttime`,`saletime`,`ticketprice`) VALUES 
 ('206','I21',206,206,'上海','上海','北京','石家庄','坐票','08:12:00','2008-05-01',200.00),
 ('207','J21',207,207,'上海','上海','北京','石家庄','坐票','11:00:00','2008-05-01',200.00),
 ('100','K10',100,100,'武汉','武汉','北京','石家庄','坐票','12:00:00','2008-05-01',122.00),
 ('101','k11',101,101,'武汉','武汉','阳新','九江','坐票','10:00:00','2008-05-01',30.00),
 ('102','k12',102,102,'武汉','武汉','北京','石家庄','坐票','10:00:00','2008-05-01',108.00),
 ('103','k13',103,103,'武汉','武汉','北京','石家庄','坐票','08:12:00','2008-05-01',30.00),
 ('208','K21',208,208,'上海','上海','北京','石家庄','坐票','08:12:00','2008-05-01',108.00),
 ('209','L21',209,209,'上海','上海','香港','九龙','坐票','12:00:00','2008-05-01',108.00),
 ('201','M20',123,156,'南昌','南昌','阳新','九江','坐票','12:00:00','2008-05-01',20.00);
INSERT INTO `salereturnticket` (`ticketno`,`trainno`,`railwayno`,`seatno`,`salestage`,`startstage`,`arrivestage`,`changetrain`,`tickettype`,`starttime`,`saletime`,`ticketprice`) VALUES 
 ('210','M21',210,210,'上海','上海','香港','九龙','坐票','11:00:00','2008-05-01',108.00),
 ('211','N21',211,211,'上海','上海','香港','九龙','坐票','10:00:00','2008-05-01',30.00),
 ('212','O21',212,212,'上海','上海','香港','九龙','坐票','10:00:00','2008-05-01',30.00),
 ('213','P21',213,213,'上海','上海','香港','九龙','坐票','11:00:00','2008-05-01',108.00),
 ('214','Q21',214,214,'武汉','武汉','香港','深圳','坐票','12:00:00','2008-05-01',30.00),
 ('215','R21',215,215,'武汉','武汉','香港','深圳','坐票','12:00:00','2008-05-01',122.00),
 ('216','S21',216,216,'武汉','武汉','台北','深圳','坐票','11:00:00','2008-05-01',238.00),
 ('217','T21',217,217,'武汉','武汉','台北','深圳','卧票','18:00:00','2008-05-01',30.00),
 ('218','U21',218,218,'武汉','武汉','台北','深圳','卧票','11:00:00','2008-05-01',321.00),
 ('219','V21',219,219,'武汉','武汉','台北','深圳','卧票','18:00:00','2008-05-01',30.00);
INSERT INTO `salereturnticket` (`ticketno`,`trainno`,`railwayno`,`seatno`,`salestage`,`startstage`,`arrivestage`,`changetrain`,`tickettype`,`starttime`,`saletime`,`ticketprice`) VALUES 
 ('220','W21',220,220,'武汉','武汉','石家庄','郑州','卧票','18:00:00','2008-05-01',30.00),
 ('221','X21',221,221,'石家庄','石家庄','武汉','郑州','卧票','19:00:00','2008-05-01',162.00),
 ('222','Y21',222,222,'阳新','阳新','北京','合肥','卧票','20:00:00','2008-05-01',188.00),
 ('223','Z21',223,223,'阳新','阳新','上海','合肥','坐票','01:00:00','2008-05-01',199.00);
/*!40000 ALTER TABLE `salereturnticket` ENABLE KEYS */;


--
-- Table structure for table `trainticket`.`surrogatesaleticket`
--

DROP TABLE IF EXISTS `surrogatesaleticket`;
CREATE TABLE `surrogatesaleticket` (
  `surrogateno` char(10) NOT NULL default '',
  `surrogatename` char(10) NOT NULL default '',
  PRIMARY KEY  (`surrogateno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `trainticket`.`surrogatesaleticket`
--

/*!40000 ALTER TABLE `surrogatesaleticket` DISABLE KEYS */;
/*!40000 ALTER TABLE `surrogatesaleticket` ENABLE KEYS */;


--
-- Table structure for table `trainticket`.`tickettable`
--

DROP TABLE IF EXISTS `tickettable`;
CREATE TABLE `tickettable` (
  `typeno` int(10) unsigned NOT NULL auto_increment,
  `tickettype` char(10) NOT NULL default '',
  `charge` float(8,2) NOT NULL default '0.00',
  PRIMARY KEY  (`typeno`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `trainticket`.`tickettable`
--

/*!40000 ALTER TABLE `tickettable` DISABLE KEYS */;
INSERT INTO `tickettable` (`typeno`,`tickettype`,`charge`) VALUES 
 (1,'半票',0.00),
 (2,'半票',0.00),
 (3,'半票',0.00),
 (4,'半票',0.00),
 (5,'半票',0.00),
 (6,'半票',0.00),
 (7,'半票',0.00),
 (8,'全票',0.00),
 (9,'全票',0.00),
 (10,'全票',0.00),
 (11,'全票',0.00),
 (12,'全票',0.00),
 (13,'全票',0.00),
 (14,'全票',0.00),
 (15,'全票',0.00),
 (16,'全票',0.00),
 (17,'全票',0.00),
 (18,'全票',0.00),
 (19,'全票',0.00),
 (20,'全票',0.00),
 (21,'全票',0.00),
 (22,'全票',0.00),
 (23,'全票',0.00),
 (24,'全票',0.00);
/*!40000 ALTER TABLE `tickettable` ENABLE KEYS */;


--
-- Table structure for table `trainticket`.`trainstage`
--

DROP TABLE IF EXISTS `trainstage`;
CREATE TABLE `trainstage` (
  `stagename` varchar(50) NOT NULL default '',
  `stagenameindex` char(10) NOT NULL default '',
  PRIMARY KEY  (`stagenameindex`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `trainticket`.`trainstage`
--

/*!40000 ALTER TABLE `trainstage` DISABLE KEYS */;
INSERT INTO `trainstage` (`stagename`,`stagenameindex`) VALUES 
 ('富池','a'),
 ('北京','b'),
 ('阳新','c'),
 ('石家庄','d'),
 ('武汉','e'),
 ('上海','f'),
 ('深圳','g'),
 ('香港','h'),
 ('澳门','i'),
 ('台北','j'),
 ('武昌','k'),
 ('九江','l');
/*!40000 ALTER TABLE `trainstage` ENABLE KEYS */;


--
-- Table structure for table `trainticket`.`trainstation`