基于Web-SQL Server的农业信息网站建设  

Construction of Agricultural Information Website Based on Web-SQL Server

作　　者：黄魏[1] 贺立源[1] 李辉[1] 徐胜祥[1] 李春国[1] 

机构地区：[1]华中农业大学资源与环境学院,武汉430070

出　　处：《华中农业大学学报》2004年第2期271-274,共4页Journal of Huazhong Agricultural University

基　　金：国家星火计划"农村信息化科技示范体系建设";湖北省教改项目"网络化教学平台设计与实现"资助

摘　　要：为提高农业信息网站的建设效率和系统管理水平,选择SQL Server2000为支持数据库,以ASP为开发工具,进行基于Web-SQL Server的网站建设研究。研究以华中农业信息网(http://www.ccain.net)中的”花卉林木”栏目为例,详细讨论了利用存储过程和T-SQL语言等SQL Server的特有功能进行系统开发过程。在提高了网站的开发效率和运行效率的基础上,达到合理建设和高效管理信息网站的目的,为网站进一步发展奠定技术基础。This paper is to elevate the efficiency of constructing Agricultural Information Website and enhance the systematic managing capability. Using SQL Server 2000 as supporting-databases and ASP as design-tools, the implementation of Website based on Web-SQL Server are mainly concerned a-bout. Stored Procedure and T-SQL, which are special functions of SQL Server 2000, were discussed especially in the given example of 'Flower &. Forest' column in the 'http://www. ccain. net'. It can reach the goal of building and administering website efficiently through raising the rapidity of operating and building website that can lead to the further development of Agricultural Information Website.

关 键 词：Web SQL SERVER 2000 农业信息网站 ASP 存储过程 T-SQL 

分 类 号：TP393.09[自动化与计算机技术—计算机应用技术] S126[自动化与计算机技术—计算机科学与技术]