摘要
"一网+多库"是指一个平台连接不同服务器上的数据库。以ASP.NET和C#为技术手段,实现一个平台连接不同服务器上的SQL SERVER和My SQL数据库,重点提出.NET三层架构。在数据层、业务层和表示层使用示例代码分别操作SQL SERVER和My SQL两种数据库,完成Repeater控件和Pager自定义控件进行存储过程分页。在构建Web平台实现资源共享具有一定的指导意义。
＂One network and multiple databases＂ refers to that one platform connects multiple databases which are on different servers. Using ASP.NET and C# as technical means, a platform to connect SQL SERVER and My SQL databases on different servers is realized, and.NET three layer architecture is the emphasis. In the data layer, business layer and presentation layer, the sample codes are used to operate SQL SERVER and My SQL two kinds of databases respectively, to realize the storage procedure paging with the Repeater control and the Pager custom control. It has some guiding significance, in the construction of Web platform to realize the resource sharing.
作者
余杨奎
Yu Yangkui(Zhanjiang Radio＆TV Univsity, Zhanjiang, Guangdong 524003, Chin)
出处
《计算机时代》
2017年第10期25-29,共5页
Computer Era
基金
2015年度湛江市科学技术局重大科技专项"信融天下互联网金融P2P网贷系统研发及平台运营"(15A102)
关键词
开发技术
一网+多库
存储过程
分页
development technology
one network and multiple databases
storage procedure
paging
