文件名称:Train_time_database_query
- 所属分类:
- SQL Server数据库
- 资源属性:
- [Windows] [Visual.Net] [Basic/ASP] [源码]
- 上传时间:
- 2012-11-26
- 文件大小:
- 1.91mb
- 下载次数:
- 0次
- 提 供 者:
- 张**
- 相关连接:
- 无
- 下载说明:
- 别用迅雷下载,失败请重下,重下不扣分!
介绍说明--下载内容均来自于网络,请自行研究使用
最优客运乘车路线系统
--作者:山东农业大学 2006级信息与计算科学 张知临
--小组成员:彭建,姜明艳,董晓聪
--联系方式:邮箱: zhzhl202@163.com QQ:421525432
这是一个完全成型的查询系统。其算法全部写在了数据库中,并编译成了存储过程,
其中存储过程"zuiyou"是优化后的算法,"zuiyou1"是将原算法稍加改变以后形成的算法。
执行存储过程,只需先将该数据库附加到MS-SQL中,在SQL 查询分析器中执行下列语句:
exec zuiyou1 北京 , 广州
如要编成软件,只需要调用其存储过程,在该文件中有一个用delphi 调用其存储过程而做成的软件,使用时需先将数据库附加到服务器上
然后将“dbsetting”文件配置为自己的服务器。
解压密码:zhzhl202@163.com
仅供学习研究,严禁用于其他商业用途!-Optimal passenger car route system
- Author: Shandong Agricultural University, 2006 Information and Computing Science ZHANG Zhi-Pro
- Panelists: PENG Jian,姜明艳,董晓聪
- Contact us: E-mail: zhzhl202@163.com QQ: 421525432
This is a fully formed query system. Writing all of their algorithm in the database, and compile the stored procedure has become,
One stored procedure "zuiyou" are optimized algorithm, "zuiyou1" the original algorithm are a little changed after the formation of algorithms.
Implementation of stored procedure, just before the database attached to the MS-SQL, in SQL Query Analyzer to perform the following statement:
exec zuiyou1 Beijing , Canton
Such as to compiled software, only need to call the stored procedure, in which the document has a use delphi to call stored procedure and make its software, used to be attached to the first database server
And will "dbsetting" document for their own server configuration.
Unzip password: zhzhl202@163.com
--作者:山东农业大学 2006级信息与计算科学 张知临
--小组成员:彭建,姜明艳,董晓聪
--联系方式:邮箱: zhzhl202@163.com QQ:421525432
这是一个完全成型的查询系统。其算法全部写在了数据库中,并编译成了存储过程,
其中存储过程"zuiyou"是优化后的算法,"zuiyou1"是将原算法稍加改变以后形成的算法。
执行存储过程,只需先将该数据库附加到MS-SQL中,在SQL 查询分析器中执行下列语句:
exec zuiyou1 北京 , 广州
如要编成软件,只需要调用其存储过程,在该文件中有一个用delphi 调用其存储过程而做成的软件,使用时需先将数据库附加到服务器上
然后将“dbsetting”文件配置为自己的服务器。
解压密码:zhzhl202@163.com
仅供学习研究,严禁用于其他商业用途!-Optimal passenger car route system
- Author: Shandong Agricultural University, 2006 Information and Computing Science ZHANG Zhi-Pro
- Panelists: PENG Jian,姜明艳,董晓聪
- Contact us: E-mail: zhzhl202@163.com QQ: 421525432
This is a fully formed query system. Writing all of their algorithm in the database, and compile the stored procedure has become,
One stored procedure "zuiyou" are optimized algorithm, "zuiyou1" the original algorithm are a little changed after the formation of algorithms.
Implementation of stored procedure, just before the database attached to the MS-SQL, in SQL Query Analyzer to perform the following statement:
exec zuiyou1 Beijing , Canton
Such as to compiled software, only need to call the stored procedure, in which the document has a use delphi to call stored procedure and make its software, used to be attached to the first database server
And will "dbsetting" document for their own server configuration.
Unzip password: zhzhl202@163.com
(系统自动生成,下载前可以参看下载内容)
下载文件列表
列车时刻数据库查询
..................\DataBase
..................\........\DBTrains_date.mdf
..................\........\DBTrains_log.ldf
..................\存储过程
..................\........\41865612.bmp.bmp
..................\........\9f81c416.bmp.bmp
..................\........\ef7fa262.bmp.bmp
..................\........\zuiyou.sql
..................\........\zuiyou1.sql
..................\........\zuiyou2.sql
..................\........\优化版.txt
..................\........\最初版.txt
..................\........\最终版.txt
..................\视图
..................\....\0c0f1644.bmp.bmp
..................\....\1ed24ea1.bmp.bmp
..................\....\dba0f6c5.bmp.bmp
..................\....\一次中转视图(zhzh1).txt
..................\....\二次中转视图(zhzh2).txt
..................\....\直达视图(zhd).txt
..................\计算时间的语句
..................\..............\计算一次中转算法时间的查询语句.sql
..................\..............\计算一次中转算法的存储过程.sql
..................\..............\计算二次中转算法时间的存储过程.sql
..................\..............\计算二次中转算法时间的语句.sql
..................\..............\计算各种存储过程的时间.sql
..................\..............\计算时间.sql
..................\软件
..................\....\delphi
..................\....\......\dbsetting.ini
..................\....\......\Project1(1).exe
..................\....\网页版
..................\....\......\Train
..................\....\......\.....\App_Data
..................\....\......\.....\train.aspx
..................\....\......\.....\train.aspx.cs
..................\....\......\.....\Web.config
..................\DataBase
..................\........\DBTrains_date.mdf
..................\........\DBTrains_log.ldf
..................\存储过程
..................\........\41865612.bmp.bmp
..................\........\9f81c416.bmp.bmp
..................\........\ef7fa262.bmp.bmp
..................\........\zuiyou.sql
..................\........\zuiyou1.sql
..................\........\zuiyou2.sql
..................\........\优化版.txt
..................\........\最初版.txt
..................\........\最终版.txt
..................\视图
..................\....\0c0f1644.bmp.bmp
..................\....\1ed24ea1.bmp.bmp
..................\....\dba0f6c5.bmp.bmp
..................\....\一次中转视图(zhzh1).txt
..................\....\二次中转视图(zhzh2).txt
..................\....\直达视图(zhd).txt
..................\计算时间的语句
..................\..............\计算一次中转算法时间的查询语句.sql
..................\..............\计算一次中转算法的存储过程.sql
..................\..............\计算二次中转算法时间的存储过程.sql
..................\..............\计算二次中转算法时间的语句.sql
..................\..............\计算各种存储过程的时间.sql
..................\..............\计算时间.sql
..................\软件
..................\....\delphi
..................\....\......\dbsetting.ini
..................\....\......\Project1(1).exe
..................\....\网页版
..................\....\......\Train
..................\....\......\.....\App_Data
..................\....\......\.....\train.aspx
..................\....\......\.....\train.aspx.cs
..................\....\......\.....\Web.config