trainticketmanager.sql

Java火车站售票管理系统

/*
MySQL Data Transfer
Source Host: localhost
Source Database: trainticketmanager
Target Host: localhost
Target Database: trainticketmanager
Date: 2008-9-2 21:02:18
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for admin
-- ----------------------------
CREATE TABLE `admin` (
  `id` int(11) NOT NULL auto_increment,
  `number` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for carriage
-- ----------------------------
CREATE TABLE `carriage` (
  `id` int(11) NOT NULL auto_increment,
  `yz_num` int(11) NOT NULL,
  `rz_num` int(11) NOT NULL,
  `yw_num` int(11) NOT NULL,
  `rw_num` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ticket
-- ----------------------------
CREATE TABLE `ticket` (
  `id` int(11) NOT NULL auto_increment,
  `ticketNumber` varchar(50) NOT NULL,
  `trainNumber` varchar(50) NOT NULL,
  `trainDate` varchar(50) NOT NULL,
  `startStation` varchar(50) NOT NULL,
  `endStation` varchar(50) NOT NULL,
  `price` double NOT NULL,
  `carriageNum` int(11) default NULL,
  `seatNum` int(11) NOT NULL,
  `type` varchar(50) default NULL,
  `grade` varchar(50) default NULL,
  `userId` int(11) default NULL,
  `trainTime` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  KEY `userId` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for ticketsale
-- ----------------------------
CREATE TABLE `ticketsale` (
  `id` int(11) NOT NULL auto_increment,
  `TrainNumber` varchar(50) default NULL,
  `onDate` varchar(50) default NULL,
  `YZSale` int(11) default NULL,
  `RZSale` int(11) default NULL,
  `YWSale` int(11) default NULL,
  `RWSale` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for train
-- ----------------------------
CREATE TABLE `train` (
  `id` int(11) NOT NULL auto_increment,
  `trainNumber` varchar(50) NOT NULL,
  `trainType` varchar(20) NOT NULL,
  `firstStation` varchar(50) NOT NULL,
  `passStations` varchar(50) default NULL,
  `endStation` varchar(50) NOT NULL,
  `startTime` varchar(50) NOT NULL,
  `LastTime` varchar(50) NOT NULL,
  `yznum` int(11) default NULL,
  `rznum` int(11) default NULL,
  `ywnum` int(11) default NULL,
  `rwnum` int(11) default NULL,
  `totalTime` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for traininf
-- ----------------------------
CREATE TABLE `traininf` (
  `id` int(11) NOT NULL auto_increment,
  `number` varchar(50) NOT NULL,
  `passStation` varchar(50) default NULL,
  `arriveTime` varchar(50) default NULL,
  `restartTime` varchar(50) default NULL,
  `yzprice` double default NULL,
  `rzprice` double default NULL,
  `ywprice` double default NULL,
  `rwprice` double default NULL,
  `total_distance` double default NULL,
  `trainId` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for user
-- ----------------------------
CREATE TABLE `user` (
  `id` int(11) NOT NULL auto_increment,
  `user_ID` varchar(50) NOT NULL,
  `name` varchar(50) default NULL,
  `phone` varchar(50) default NULL,
  `station` varchar(50) default NULL,
  `ticketNum` int(11) default NULL,
  `totalPrice` double default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', 'admin', 'admin');
INSERT INTO `carriage` VALUES ('1', '10', '10', '10', '10');

INSERT INTO `ticket` VALUES ('82', '1', 'K293', '2008.9.3', '青岛', '济南', '55', '1', '1', '普', '硬座', '67', '15:28');
INSERT INTO `ticket` VALUES ('83', '1', 'D27', '2008.9.5', '青岛', '济南', '180', '1', '1', '普', '硬座', '68', '14:00');
INSERT INTO `ticket` VALUES ('84', '0083', 'D27', '2008.9.5', '青岛', '济南', '91', '1', '1', '军', '硬座', '69', '14:00');
INSERT INTO `ticket` VALUES ('85', '0084', 'D27', '2008.9.5', '青岛', '济南', '91', '1', '2', '军', '硬座', '69', '14:00');
INSERT INTO `ticket` VALUES ('86', '0085', 'D27', '2008.9.5', '青岛', '济南', '91', '1', '3', '军', '硬座', '69', '14:00');
INSERT INTO `ticket` VALUES ('87', '0086', 'D27', '2008.9.5', '青岛', '济南', '91', '1', '4', '军', '硬座', '69', '14:00');
INSERT INTO `ticket` VALUES ('88', '0087', 'D27', '2008.9.5', '青岛', '济南', '91', '1', '5', '军', '硬座', '69', '14:00');
INSERT INTO `ticketsale` VALUES ('9', 'A382', '2008.9.1', '45', '44', '44', '45');
INSERT INTO `ticketsale` VALUES ('10', 'K293', '2008.9.3', '1', '0', '0', '1');
INSERT INTO `ticketsale` VALUES ('11', 'D27', '2008.9.5', '6', '5', '5', '6');
INSERT INTO `train` VALUES ('1', 'A382', '普快', '济宁', '0', '青岛', '8：30', '17：00', '9', '0', '3', '3', '10小时');
INSERT INTO `train` VALUES ('2', 'K207', '特快', '上海', '0', '青岛', '8：00', '10：00', '12', '8', '4', '4', '1天6小时');
INSERT INTO `train` VALUES ('3', 'T26', '空调特快', '青岛', '0', '北京', '05:19', '05:19', '9', '9', '9', '9', '9小时5分');
INSERT INTO `train` VALUES ('4', 'T110', '特快', '上海', '0 ', '北京', '20:42', '09:42', '9', '0', '9', '9', '13小时');
INSERT INTO `train` VALUES ('5', 'K293', '快速', '青岛', '0', '上海', '15:28', '11:13', '9', '0', '9', '9', '19小时45分');
INSERT INTO `train` VALUES ('6', 'K295', '快速', '上海', '0', '青岛', '13:19', '09:53', '9', '0', '9', '9', '20小时34分');
INSERT INTO `train` VALUES ('7', 'T109', '空调特快', '北京', '0', '上海', '20:14', '09:14', '9', '0', '9', '9', '13小时');
INSERT INTO `train` VALUES ('8', 'T25', '特快', '北京', '0', '青岛', '22:50', '07:22', '9', '0', '9', '9', '8小时32分');
INSERT INTO `train` VALUES ('9', 'D25', '动车组', '济南', '0', '青岛', '8:00', '10:20', '9', '9', '9', '9', '2小时20分');
INSERT INTO `train` VALUES ('10', 'D27', '动车组', '青岛', '0', '济南', '14:00', '16:20', '9', '9', '9', '9', '2小时20分');
INSERT INTO `traininf` VALUES ('1', 'A382', '济宁 ', '17:00', '9:52', '0', '0', '0', '0', '0', '1');
INSERT INTO `traininf` VALUES ('2', 'A382', '泰山', '9:52', '10:02', '30', '30', '30', '30', '100', '1');
INSERT INTO `traininf` VALUES ('3', 'A382', '济南', '11:00', '11:15', '45', '54', '54', '55', '400', '1');
INSERT INTO `traininf` VALUES ('4', 'A382', '青岛', '17:00', '9:52', '56', '65', '67', '67', '900', '1');