create database StationHelper;
use StationHelper;
CREATE TABLE `StationHelper`.`stations` (
`sid` INTEGER NOT NULL AUTO_INCREMENT,
`sname` VARCHAR(20) NOT NULL,
PRIMARY KEY (`sid`),
INDEX `sname`(`sname`)
)
ENGINE = InnoDB
CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
CREATE TABLE `StationHelper`.`trains` (
`tid` INTEGER NOT NULL,
`ttype` VARCHAR(10) NOT NULL,
`startstation` INTEGER NOT NULL,
`endstation` INTEGER NOT NULL,
PRIMARY KEY (`tid`),
CONSTRAINT `startstation` FOREIGN KEY `startstation` (`startstation`)
REFERENCES `stations` (`sid`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `endstation` FOREIGN KEY `endstation` (`endstation`)
REFERENCES `stations` (`sid`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
CREATE TABLE `StationHelper`.`stations_train_pass` (
`tid` INTEGER NOT NULL,
`sid` INTEGER NOT NULL,
`time` VARCHAR(20) NOT NULL,
`seq` INTEGER NOT NULL,
`starttime` VARCHAR(20) NOT NULL,
CONSTRAINT `tid` FOREIGN KEY `tid` (`tid`)
REFERENCES `trains` (`tid`)
ON DELETE RESTRICT
ON UPDATE RESTRICT,
CONSTRAINT `sid` FOREIGN KEY `sid` (`sid`)
REFERENCES `stations` (`sid`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB
CHARACTER SET gb2312 COLLATE gb2312_chinese_ci;
insert into stations(sname) values('大连')
insert into stations(sname) values('上海')
insert into stations(sname) values('北京')
insert into stations(sname) values('锦州')
insert into stations(sname) values('天津')
insert into stations(sname) values('沧州')
insert into stations(sname) values('唐山')
insert into stations(sname) values('山海关')
insert into stations(sname) values('盘锦')
insert into stations(sname) values('德州')
insert into stations(sname) values('济南')
insert into stations(sname) values('徐州')
insert into stations(sname) values('南京')
insert into trains(tid,ttype,startstation,endstation) values(131,'T',1,2)
insert into trains(tid,ttype,startstation,endstation) values(278,'T',1,3)
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,1,'0',1,'12:02')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,3,'14:10',25,'0')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,4,'13:35',6,'13:50')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,5,'22:30',15,'22:35')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,6,'00:10',18,'00:15')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,8,'19:18',13,'19:28')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,9,'17:18',8,'17:28')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,10,'02:08',19,'02:18')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,11,'03:38',20,'03:43')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,12,'05:58',21,'06:03')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(131,13,'11:08',23,'11:13')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(278,1,'0',1,'18:00')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(278,3,'5:46',9,'0')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(278,7,'04:06',7,'04:15')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(278,8,'00:06',4,'00:15')
insert into stations_train_pass(tid,sid,time,seq,starttime) values(278,4,'02:06',6,'02:15')
Linux环境下QT4图形界面与MySQL编程-程序源代码.rar （975个子文件） 
SoftwareAssistant.pro.user.2.1pre1 8KB foodorder.pro.user.2.1pre1 8KB hotel.pro.user.2.1pre1 8KB SoftwareAssistant.pro.user.1.3 9KB foodorder.pro.user.1.3 0B BookShop-qt4 140KB NULLzero.chat 78B qrc_images.cpp 3.87MB qrc_images.cpp 713KB qrc_images.cpp 704KB qrc_Resource.cpp 675KB qrc_Picture.cpp 254KB widget.cpp 16KB gamearea.cpp 13KB mainwindow.cpp 11KB textEditor.cpp 10KB dlgorder.cpp 9KB chatwidgit.cpp 9KB player.cpp 8KB welcomeAdmin.cpp 8KB paymentfrm.cpp 8KB Palette.cpp 7KB searchhouse.cpp 7KB findfileform.cpp 6KB studentform.cpp 6KB stuaddlist.cpp 6KB vipform.cpp 5KB ftpclientwindow.cpp 5KB dlgcount.cpp 5KB moc_chatwidgit.cpp 5KB houserenter.cpp 5KB welcomeWorker.cpp 5KB ftpclient.cpp 5KB moc_ftpclient.cpp 5KB moc_ftpclient.cpp 5KB filesender.cpp 5KB dlgdelete_update.cpp 4KB mainwindow.cpp 4KB Form.cpp 4KB moc_widget.cpp 4KB teacherform.cpp 4KB moc_ftpclientwindow.cpp 4KB filereceiver.cpp 4KB mainwindow.cpp 4KB welcomeStu.cpp 4KB moc_ftpclientwindow.cpp 4KB addnewhouse.cpp 4KB moc_textEditor.cpp 4KB dlgsearch.cpp 4KB searchrenter.cpp 4KB moc_textEditor.cpp 3KB draweditor.cpp 3KB toolbox.cpp 3KB moc_draweditor.cpp 3KB moc_mainwindow.cpp 3KB dbookmanage.cpp 3KB moc_player.cpp 3KB adminform.cpp 3KB moc_mainwindow.cpp 3KB moc_filesender.cpp 3KB moc_draweditor.cpp 3KB mainform.cpp 3KB moc_Palette.cpp 3KB myitem.cpp 3KB moc_teacherform.cpp 3KB moc_welcomeWorker.cpp 3KB moc_studentform.cpp 3KB moc_filereceiver.cpp 3KB register.cpp 3KB moc_mainwindow.cpp 3KB moc_adminform.cpp 3KB moc_findfileform.cpp 3KB dlgfoodmanger.cpp 3KB moc_Palette.cpp 3KB moc_mainwindow.cpp 3KB moc_dlgfoodmanger.cpp 3KB moc_mainform.cpp 3KB addowner.cpp 3KB moc_searchhouse.cpp 3KB moc_mainwindow.cpp 3KB moc_mainwindow.cpp 3KB moc_dlgorder.cpp 3KB moc_Form.cpp 3KB moc_mainwindow.cpp 3KB moc_owner.cpp 3KB mainwindow.cpp 3KB main.cpp 3KB mainwindow.cpp 3KB moc_welcomeAdmin.cpp 3KB moc_showhouse.cpp 3KB moc_dlgdelete_update.cpp 3KB moc_findfileform.cpp 3KB moc_PreViewLabel.cpp 3KB moc_welcomeStu.cpp 3KB moc_mainwindow.cpp 3KB moc_mainwindow.cpp 3KB moc_mainwindow.cpp 3KB moc_searchrenter.cpp 3KB moc_mainwindow.cpp 3KB owner.cpp 2KB共 975 条
- 1
- 2
- 3
- 4
- 5
- 6
- 10
资源评论
亚傲智慧
- 粉丝: 142
最新资源
- 网络信息安全B作业题和考试复习题.doc
- 互联网背景下如何提高图书编校质量.docx
- tcpip协议与网络管理标准教程.doc
- 大数据背景下高校思想政治教育过程融入路径探究.docx
- 云南基层干部教育培训信息化建设应用研究教育文档.doc
- 团购网站Groupon及中国电子商务发展分析.doc
- 外贸建站-营销型网站建设.doc
- 斩波电路Matlab仿真电力电子技术课程设计.doc
- 互联网+大连海参养殖新模式探究.docx
- python-游戏数据搜索引擎-基于Python开发的游戏信息检索系统-整合多平台游戏数据-提供快速搜索与详细展示功能-支持用户自定义筛选与收藏-适用于游戏爱好者与开发者查询游戏资.zip
- 人工智能双面观.docx
- 基于欧氏距离的K均方聚类算法研究与应用.docx
- 对安徽江苏山东网络电视台的比较分析.docx
- JavaEEJsp图书系统实用技术文档.doc
- 网络信息安全项目教程习题-解答.doc
- 物联网技术在现代种植业中的应用.docx
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
