软件工程第二次作业

软件工程第二次作业
  现在开始了软件工程的第二次作业啦!
  本次样例测试使用eclipse和JUnit作为开发工具,根据样例演示如以下步骤。因上学期学期课程中使用过eclipse,故不在此对eclipse的安装与配置环境做过多介绍。
  首先打开eclipse,新建工程project,并点击finish

1346030-20180322204516290-647814056.png

1346030-20180322204535420-863467760.jpg
   接着右键src,建立并命名一个名为lei的类,点击finish。

1346030-20180322204637947-240632791.jpg

1346030-20180322210458856-462950614.jpg

  建好之后会出现一个lei.java文件,此时可在图中标注的地方编写代码。

1346030-20180322204846751-592531806.jpg

  将代码编写完成后,导入JUnit,右键project,add Librarise,点击next,选择JUnit4,点击finish,最后再点击next。

1346030-20180322204921215-1205617561.jpg

1346030-20180322204931463-1763126153.jpg

1346030-20180322204942489-1173579751.jpg

1346030-20180322205155392-1146686730.jpg

在点击next之后,将第一个左上角的方块勾住,点击finish。此时后出现leiTest.Java文件,将测试样例输进去后可进行多次测试。

1346030-20180322205207300-438478271.jpg

1346030-20180322205215545-904105084.jpg

在运行测试时右击leiTest.Java→Run As→JUnit test。接着点击OK就会得到运行结果。

1346030-20180322205225472-818087873.jpg

1346030-20180322205234032-1058336514.jpg

1346030-20180322205409172-1177737339.jpg

1346030-20180322211605150-192260740.jpg

  其中(1)、Runs表示总共有几个测试方法,,已经运行了几个;
(2)、Errors表示抛出异常的测试方法的个数;
(3)、Failures表示失败的测试方法的个数;
(4)、√表示通过测试的方法;
(5)、有个绿色的进度条表示测试成功,红色的进度条表示测试失败。
  接下来是JUnit的完善,首先右击src新建Source Floder,Folder为test,点击finish。
1346030-20180322211743336-1907702430.png

1346030-20180322212225554-523402805.jpg

  此时会出现一个新的包Test,将leiTest.Java移到Test文件下。

1346030-20180322212327301-78547807.jpg

1346030-20180322212341728-1074120226.jpg

  接下来可以使用IDE自动生成测试类,生成步骤如下:
  右击src文件下的lei.Java→New→Other,Wizards填JU选择JUnit Tese Case,点next,将Sourse Folder 改为.test后,点next,将最左上角的方块打√点finish。然后就 可以看到自动生成的相应的测试方法了。

1346030-20180322212442459-529369995.jpg

1346030-20180322212452549-798429543.jpg

1346030-20180322212503425-1202590664.jpg

1346030-20180322212520546-70387929.jpg

  that's all.Thak you for your reading!

1346030-20180322213115100-1739636807.png

转载于:https://www.cnblogs.com/fanshilin/p/8617457.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
软件工程铁路售票系统: 铁路售票管理系统软件使用说明书 铁路售票管理系统软件系统测试报告 铁路售票系统软件设计说明书 铁路售票系统需求说明书 create database railwaymanagementdb go use railwaymanagementdb go create table commontrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table dtrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table ktrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table ttrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) create table ztrain ( trainnum varchar(10) , traintype varchar(30), stationnum int , stationname varchar(20) , starttime varchar(20), pause int, arrivetime varchar(20) , timeused varchar(20), length int , price1 int , price2 int , price3 int ) CREATE TABLE adultticket ( ticketnum varchar(10), origin varchar(30) , destination varchar(30) , length int , starttime varchar(20) , arrivetime varchar(20), timeused varchar(20) , tickettype varchar(10), price int, leftnum int ) CREATE TABLE childticket ( ticketnum varchar(10) , origin varchar(30) , destination varchar(30) , length int , starttime varchar(20) , arrivetime varchar(20) , timeused varchar(20) , tickettype varchar(10) , price int, leftnum int ) CREATE TABLE stuticket ( ticketnum varchar(10) , origin varchar(30) , destination varchar(30) , length int , starttime varchar(20) , arrivetime varchar(20) , timeused varchar(20) , tickettype varchar(10) , price int, leftnum int ) CREATE TABLE admin ( adminID varchar(30) , adminpwd varchar(30) , adminusername varchar(30) , adminsalary int ) CREATE TABLE seller ( sellerID varchar(30) , sellerpwd varchar(30) , sellerusername varchar(30) , sellernum int, sellersalary int ) CREATE TABLE ticketstatistics ( ticketnum varchar(10) , sellnum int, totalmoney int ) insert into commontrain values ('2509' ,'普通火车', 1 ,'哈尔滨', '14:32', 0 ,'始发站' ,'0' ,0 ,0, 0, 0) insert into commontrain values('2509' ,'普通火车', 2 ,'肇东', '15:16' ,2, '15:14', '42分钟' ,80, 8, 16, 30) insert into commontrain values('2509', '普通火车' ,3 ,'大庆' ,'16:29', 4 ,'16:25' ,'1小时53分钟', 260 ,19, 40 ,75) insert into commontrain values('2509', '普通火车', 4, '齐齐哈尔', '---', -1, '18:16', '3小时44分钟', 500 ,25 ,50 ,95) insert into commontrain values('2124' ,'普通火车', 1, '哈尔滨' ,'04:03', 0, '0', '0', 0, 0, 0 ,0) insert into commontrain values('2124' ,'普通火车', 2, '呼兰', '04:39', 3 ,'04:36' ,'33分钟' ,32, 5 ,10, 22) insert into commontrain values('2124', '普通火车' ,3, '康金井', '05:00', 2, '04:58', '55分钟', 60 ,8, 15 ,30) insert into commontrain values('2124', '普通火车' ,4 ,'绥化' ,'06:01' ,4, '05:57', '1小时54分钟' ,125, 14 ,30, 56) insert into commontrain values('1394', '普通火车', 1 ,'哈尔滨', '18:11' ,0 ,'始发站', '0' ,0, 0 ,0, 0) insert into commontrain values('1394' ,'普通火车', 2 ,'沈阳北', '00:53', 0 ,'00:42', '11分钟', 520, 60 ,115, 220) insert into commontrain values('1394', '普通火车', 3 ,'天津西', '08:54', 0 ,'08:46', '8分钟', 1203 ,105, 210 ,400) insert into commontrain values('1394' ,'普通火车', 4, '济南' ,'13:36', 0 ,'13:20', '16分钟', 1520 ,140 ,278 ,550) insert into dtrain values('D12', 'D12', 12, '12', '12', 12, '12', '12', 12, 12, 12, 12) insert into dtrain values('D28', '动车组', 1, '哈尔滨', '09:02', 0, '始发站', '0', 0, 0, 0, 0) insert into dtrain values('D28', '动车组', 2, '长春', '10:50', 2, '10:48', '1小时46分钟', 246, 91, 180, 270) insert into dtrain values('D28', '动车组', 3, '秦皇岛', '15:10', 1, '15:09', '6时7分钟', 950, 270, 430, 600) insert into dtrain values('D28', '动车组', 4, '北京', '15:10', 0, '17:10', '8小时8分钟 ', 1249, 360, 500, 700) insert into dtrain values('D18', '动车组', 1, '哈尔滨', '08:50', 0, '始发站', '0', 0, 0, 0, 0) insert into dtrain values('D18', '动车组', 2, '齐齐哈尔', '---', -1, '10:30', '1小时40分钟', 300, 42, 84, 150) insert into dtrain values('D417', '动车组', 1, '哈尔滨', '7:00', 0, '始发站', '0', 0, 0, 0, 0) insert into dtrain values('D417', '动车组', 2, '天津', '---', -1, '19:32', '12小时32分钟', 1200, 152, 300, 512) insert into ktrain values('K12', 'K12', 12, '12', '12', 12, '12', '12', 12, 12, 12, 12) insert into ktrain values('K265', '快车', 1, '哈尔滨', '03:40 ', 0, '始发站', '0', 0, 0, 0, 0) insert into ktrain values('K265', '快车', 2, '一面坡', '06:03', 2, '06:01', '2小时21分钟', 160, 20, 40, 80) insert into ktrain values('K265', '快车', 3, '牡丹江', '---', 0, '09:09', '5小时29分钟', 420, 42, 85, 180) insert into ktrain values('K339', '快车', 1, '哈尔滨', '04:37', 0, '始发站', '0', 0, 0, 0, 0) insert into ktrain values('K339', '快车', 2, '绥化', '06:26 ', 5, '06:21', '2小时44分钟', 140, 16, 35, 77) insert into ktrain values('K339', 'K339', 3, '铁力', '07:55', 6, '07:49', '3小时12分钟', 233, 25, 52, 110) insert into ktrain values('K339', '快车', 4, '佳木斯', '---', 0, '12:06', '7小时29分钟', 550, 52, 110, 230) insert into ktrain values('K546', '快车', 1, '哈尔滨', '05:46', 0, '始发站', '0', 0, 0, 0, 0) insert into ktrain values('K546', '快车', 2, '肇东', '06:31', 3, '06:28', '42分钟', 70, 10, 20, 40) insert into ktrain values('K546', '快车', 3, '大庆', '07:38', 3, '07:35', '1小时49分钟', 163, 21, 45, 90) insert into ktrain values('K546', '快车', 4, '让胡路', '07:50', 2, '07:48', '2小时2分钟', 180, 26, 52, 100) insert into ttrain values('T184', '特快', 1, '哈尔滨', '08:40', 0, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T184', '特快', 2, '扶余 ', '09:51', 11, '09:40', '1小时', 102, 17, 109, 162) insert into ttrain values('T184', '特快', 3, '长春', '11:14', 6, '11:08', '2小时28分钟', 246, 41, 109, 162) insert into ttrain values('T184', '特快', 4, '四平', '12:20', 2, '12:18', ' 3小时38分钟', 361, 54, 109, 162) insert into ttrain values('T47', '特快', 1, '哈尔滨', '05:09', 15, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T47', '特快', 2, '大庆', '06:45', 9, '06:36', '1小时48分钟', 150, 30, 70, 100) insert into ttrain values('T47', '特快', 3, '齐齐哈尔', '---', 0, '07:57', '3小时', 220, 42, 90, 150) insert into ttrain values('T238', '特快', 1, '哈尔滨', '19:09', 0, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T238', '特快', 2, '长春', '21:28', 6, '21:22', '2小时13分钟', 246, 42, 109, 162) insert into ttrain values('T238', '特快', 3, '沈阳北', '00:15', 8, '00:07', '4小时58分钟', 546, 76, 143, 215) insert into ttrain values('T238', '特快', 4, '山海关', '03:59', 10, '03:49', '8小时40分钟', 934, 120, 222, 338) insert into ttrain values('T262', '特快', 1, '哈尔滨', '21:18', 0, '始发站', '0', 0, 0, 0, 0) insert into ttrain values('T262', '特快', 2, '沈阳北', '02:31', 10, '02:21', '5小时3分钟', 546, 76, 143, 215) insert into ttrain values('T262', '特快', 3, '大连', '---', 0, '06:33', '9小时15分钟 ', 946, 125, 231, 352) insert into ztrain values('Z16', '直达车', 1, '哈尔滨', '21:36 ', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z16', '直达车', 2, '唐山', '---', -1, '07:20', '9小时44分钟', 1249, 125, 250, 429) insert into ztrain values('Z18', '直达车', 1, '哈尔滨', '20:36', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z18', '直达车', 2, '天津', ' ---', -1, '07:20', '10小时44分钟', 1400, 150, 284, 450) insert into ztrain values('Z22', '直达车', 1, '哈尔滨', '21:36', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z22', '直达车', 2, '大连', '---', -1, '05:20', '7小时44分钟', 1049, 88, 180, 361) insert into ztrain values('Z25', '直达车', 1, '哈尔滨', '19:36', 0, '始发站', '0', 0, 0, 0, 0) insert into ztrain values('Z25', '直达车', 2, '石家庄', '---', -1, '07:20', '11小时44分钟', 1621, 188, 324, 562) insert into adultticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬座', 8, 400) insert into adultticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬卧下', 16, 100) insert into adultticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','软卧下', 30, 40) insert into adultticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬座', 19, 400) insert into adultticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬卧下', 40, 100) insert into adultticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','软卧下', 75, 40) insert into adultticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬座', 25, 400) insert into adultticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬卧下', 50, 100) insert into adultticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','软卧下', 95, 40) insert into adultticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬座', 91, 400) insert into adultticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬卧下', 180, 100) insert into adultticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','软卧下', 270, 40) insert into adultticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬座', 270, 400) insert into adultticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬卧下', 430, 100) insert into adultticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','软卧下', 600, 40) insert into adultticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬座', 360, 400) insert into adultticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬卧下', 500, 100) insert into adultticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','软卧下', 700, 40) insert into adultticket values('K339','哈尔滨','绥化',140,'04:37','06:21','2小时44分钟','硬座', 16, 400) insert into adultticket values('K339','哈尔滨','绥化',140,'04:37','06:21','2小时44分钟','硬卧下', 35, 100) insert into adultticket values('K339','哈尔滨','绥化',140,'04:37','06:21','2小时44分钟','软卧下', 77, 40) insert into adultticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬座', 25, 400) insert into adultticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬卧下', 52, 100) insert into adultticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','软卧下', 110, 40) insert into adultticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬座', 52, 400) insert into adultticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬卧下', 110, 100) insert into adultticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','软卧下', 230, 40) insert into adultticket values('T184','哈尔滨','扶余',102,'08:40','09:40','1小时','硬座', 17, 400) insert into adultticket values('T184','哈尔滨','扶余',102,'08:40','09:40','1小时','硬卧下', 109, 100) insert into adultticket values('T184','哈尔滨','扶余',102,'08:40','09:40','1小时','软卧下', 162, 50) insert into adultticket values('T184','哈尔滨','长春',246,'08:40','11:08','2小时28分钟','硬座', 41, 400) insert into adultticket values('T184','哈尔滨','长春',246,'08:40','11:08','2小时28分钟','硬卧下', 109, 100) insert into adultticket values('T184','哈尔滨','长春',246,'08:40','11:08','2小时28分钟','软卧下', 162, 40) insert into adultticket values('T184','哈尔滨','四平',361,'08:40','12:18','3小时38分钟','硬座', 54, 400) insert into adultticket values('T184','哈尔滨','四平',361,'08:40','12:18','3小时38分钟','硬卧下', 109, 1000) insert into adultticket values('T184','哈尔滨','四平',361,'08:40','12:18','3小时38分钟','软卧下', 163, 40) insert into adultticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬座', 125, 400) insert into adultticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬卧下', 250, 100) insert into adultticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','软卧下', 429, 50) insert into adultticket values('Z18','哈尔滨','天津',1400,'20:36','07:20','10小时44分钟','硬座', 150, 400) insert into adultticket values('Z18','哈尔滨','天津',1400,'20:36','07:20','10小时44分钟','硬卧下', 284, 100) insert into adultticket values('Z18','哈尔滨','天津',1400,'20:36','07:20','10小时44分钟','软卧下', 450, 50) insert into adultticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬座', 88, 400) insert into adultticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬卧下', 180, 100) insert into adultticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','软卧下', 361, 50) insert into adultticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬座', 188, 400) insert into adultticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬卧下', 324, 100) insert into adultticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','软卧下', 562, 50) insert into childticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬座', 4, 80) insert into childticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬卧下', 8, 20) insert into childticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','软卧下', 15, 20) insert into childticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬座', 10, 80) insert into childticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬卧下', 20, 20) insert into childticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','软卧下', 36, 20) insert into childticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬座', 13, 80) insert into childticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬卧下', 25, 20) insert into childticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','软卧下', 50, 20) insert into childticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬座', 45, 80) insert into childticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬卧下', 90, 20) insert into childticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','软卧下', 135, 20) insert into childticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬座', 135, 80) insert into childticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬卧下', 210, 20) insert into childticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','软卧下', 300, 20) insert into childticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬座', 180, 80) insert into childticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬卧下', 250, 20) insert into childticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','软卧下', 350, 20) insert into childticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬座', 8, 80) insert into childticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬卧下', 18, 20) insert into childticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','软卧下', 40, 20) insert into childticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬座', 13, 80) insert into childticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬卧下', 26, 20) insert into childticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','软卧下', 56, 20) insert into childticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬座', 26, 80) insert into childticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬卧下', 55, 20) insert into childticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','软卧下', 115, 20) insert into childticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬座', 22, 80) insert into childticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬卧下', 51, 20) insert into childticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','软卧下', 80, 50) insert into childticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬座', 20, 80) insert into childticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬卧下', 50, 20) insert into childticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','软卧下', 82, 20) insert into childticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬座', 28, 80) insert into childticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬卧下', 53, 200) insert into childticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','软卧下', 80, 20) insert into childticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬座', 63, 80) insert into childticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬卧下', 125, 20) insert into childticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','软卧下', 220, 20) insert into childticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬座', 80, 80) insert into childticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬卧下', 144, 20) insert into childticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','软卧下', 230, 20) insert into childticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬座', 45, 80) insert into childticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬卧下', 90, 20) insert into childticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','软卧下', 180, 20) insert into childticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬座', 92, 80) insert into childticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬卧下', 160, 20) insert into childticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','软卧下', 280, 20) insert into stuticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬座', 4, 80) insert into stuticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','硬卧下', 8, 20) insert into stuticket values('2509','哈尔滨','肇东',80,'14:32','15:14','42分钟','软卧下', 15, 20) insert into stuticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬座', 10, 80) insert into stuticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','硬卧下', 20, 20) insert into stuticket values('2509','哈尔滨','大庆',260,'14:32','16:25','小时53分钟','软卧下', 36, 20) insert into stuticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬座', 13, 80) insert into stuticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','硬卧下', 25, 20) insert into stuticket values('2509','哈尔滨','齐齐哈尔',500,'14:32','18:16','3小时44分钟','软卧下', 50, 20) insert into stuticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬座', 45, 80) insert into stuticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','硬卧下', 90, 20) insert into stuticket values('D28','哈尔滨','长春',246,'09:02','10:48','1小时46分钟','软卧下', 135, 20) insert into stuticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬座', 135, 80) insert into stuticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','硬卧下', 210, 20) insert into stuticket values('D28','哈尔滨','秦皇岛',950,'09:02','15:09','6时7分钟','软卧下', 300, 20) insert into stuticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬座', 180, 80) insert into stuticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','硬卧下', 250, 20) insert into stuticket values('D28','哈尔滨','北京',1249,'09:02','17:10','8小时8分钟','软卧下', 350, 20) insert into stuticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬座', 8, 80) insert into stuticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','硬卧下', 18, 20) insert into stuticket values('K339','哈尔滨','绥化',120,'04:37','06:21','2小时44分钟','软卧下', 40, 20) insert into stuticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬座', 13, 80) insert into stuticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','硬卧下', 26, 20) insert into stuticket values('K339','哈尔滨','铁力',233,'04:37','07:49','3小时12分钟','软卧下', 56, 20) insert into stuticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬座', 26, 80) insert into stuticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','硬卧下', 55, 20) insert into stuticket values('K339','哈尔滨','佳木斯',550,'04:37','12:06','7小时29分钟','软卧下', 115, 20) insert into stuticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬座', 22, 80) insert into stuticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','硬卧下', 51, 20) insert into stuticket values('T184','哈尔滨','扶余',102,'08:20','09:20','1小时','软卧下', 80, 50) insert into stuticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬座', 20, 80) insert into stuticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','硬卧下', 50, 20) insert into stuticket values('T184','哈尔滨','长春',246,'08:20','11:08','2小时28分钟','软卧下', 82, 20) insert into stuticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬座', 28, 80) insert into stuticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','硬卧下', 53, 200) insert into stuticket values('T184','哈尔滨','四平',361,'08:20','12:18','3小时38分钟','软卧下', 80, 20) insert into stuticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬座', 63, 80) insert into stuticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','硬卧下', 125, 20) insert into stuticket values('Z16','哈尔滨','唐山',1249,'21:36','07:20','9小时44分钟','软卧下', 220, 20) insert into stuticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬座', 80, 80) insert into stuticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','硬卧下', 144, 20) insert into stuticket values('Z18','哈尔滨','天津',1201,'20:36','07:20','10小时44分钟','软卧下', 230, 20) insert into stuticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬座', 45, 80) insert into stuticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','硬卧下', 90, 20) insert into stuticket values('Z22','哈尔滨','大连',1049,'21:36','05:20','7小时44分钟','软卧下', 180, 20) insert into stuticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬座', 92, 80) insert into stuticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','硬卧下', 160, 20) insert into stuticket values('Z22','哈尔滨','石家庄',1621,'19:36','07:20','11小时44分钟','软卧下', 280, 20) insert into admin values ('admin','111111','张三',1000) insert into admin values ('lovett','123456','张银',1000) insert into admin values ('baliang','456789','八两',1000) insert into admin values ('yangchao','111111','杨超',1000) insert into admin values ('lushuai','456789','路帅',1000) insert into seller values ('keky','456789','大阪',1,1000) insert into seller values ('xiaoE','123456','小一',2,1000) insert into seller values ('smallwood','456789','刘林',3,1000) insert into seller values ('zhimin','456789','志民',4,1000) insert into seller values ('fenglv','456789','封侣',5,1000) insert into ticketstatistics values('T184', 0, 0) insert into ticketstatistics values('2509', 0, 0) insert into ticketstatistics values('D28', 0, 0) insert into ticketstatistics values('K339', 0, 0) insert into ticketstatistics values('Z16', 0, 0) insert into ticketstatistics values('Z18', 0, 0) insert into ticketstatistics values('Z22', 0, 0)

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值