基于ASP.NET+SQL的公共选修课网上系统
|
摘要
大学期间总会有很多公共选修课,传统的选课方法没有预见性,无法实现课程和人数的调配。这是大学校园教学管理一个非常实际性的问题。网上选课系统,可以在开课前就在网上选课,每个学生的课程在开课前就确定好,使教学资源合理平均地分配。实现选修课网上系统的方法有很多,主要有JSP+MySql+Tomcat,PHP+MySql+Apache,ASP+SQL Server+IIS和ASP.NET+SQL Server+IIS等。这些实现方法中前三种的开发语言都是HTML,设计代码和后台编程代码不分离,造成代码不容易读懂和不利于后期维护。本文针对以上问题进行研究,
1、使用ASP.NET作为开发工具,实现了HTML设计代码与后台编程代码的分离。
2、该系统中使用ASP.NET+SQL Server+IIS,主要考虑到同学们选课主要使用Windows系统,对ASP.NET支持良好,而且ASP.NET代码更易于维护。
3、对于数据库存取操作,多数系统直接将SQL语句写在代码里进行数据库查询。在该系统中,绝大部分功能都使用存储过程来完成数据库访问的工作。
4、连接数据库的字符串可以随时在web.config里修改,并经过编码加密,增加了灵活性,保护了数据库的安全。
5、代码中通过使用进程中的Session、尽量使用存储过程和尽量减少数据库连接的打开时间等手段来提高性能。
通过分析B/S结构的特点并结合工作所在学校公共选修课的实际情况,提出了基于B/S结构网上选课系统的基本设计思想,本文简要介绍系统各功能模块及数据库的设计,着重讨论用ASP.NET技术和SQL Server 2000开发网上选课系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。
There are a lot of public electives during the university period.the traditional method of course choosing lack prescience, and there are no prior coordination.This is a very physically sexual problem in the university campus of teaching manage. With the help of the Public elective on-line select system, every students' courses can be determined before the beginning of the term, saving physical force and reasonably distributing teaching resources.The method which carries out the elective on-line select system includes a lot and mainly have JSP+MySql+Tomcat, PHP+MySql+Apache, ASP+SQL Server+IIS and ASP.NET+SQL Server+IIS etc.The development languages of these free methods are all be HTML. nondisjunction between Design code and backstage code makes code not easy to understand and support behind.This text carries on a research to above problem:
1.Using ASP.NET as a develop tool, carried out the separation design code between backstage code.
2. According to the consideration of the classmates select elective courses usually using Windows system and the easiness to support code of ASP.NET+SQL,we determined to use ASP.NET +SQL Server+t IIS.
3. The database accessing of most systems directly write a SQL language sentence in the code to carry on a database search.In this system, the overwhelming majority functions all use saving process to complete the work of database interview.
4. It increased flexibility and protected the safety of database that the through coding encrypt string of conjunction database can modify in the web.config at any time.
5. It passes the Session in the usage progress, as far as possible uses saving process and as far as possible reduces the etc. means in time of open of database conjunction to lift a high performance in the code.
This paper gives the basic design idea of the B/S—based online course elect system by analyzing the characteristic of the B/S structure and combining with the actual public elective courses conditions of our school.It introduces the function module and database design briefly,followed by a discussion on database accessing technology and the active page technology of the course elect system based on ASP.NET and SQL Server 2000 and gives a part of carring code.
1、使用ASP.NET作为开发工具,实现了HTML设计代码与后台编程代码的分离。
2、该系统中使用ASP.NET+SQL Server+IIS,主要考虑到同学们选课主要使用Windows系统,对ASP.NET支持良好,而且ASP.NET代码更易于维护。
3、对于数据库存取操作,多数系统直接将SQL语句写在代码里进行数据库查询。在该系统中,绝大部分功能都使用存储过程来完成数据库访问的工作。
4、连接数据库的字符串可以随时在web.config里修改,并经过编码加密,增加了灵活性,保护了数据库的安全。
5、代码中通过使用进程中的Session、尽量使用存储过程和尽量减少数据库连接的打开时间等手段来提高性能。
通过分析B/S结构的特点并结合工作所在学校公共选修课的实际情况,提出了基于B/S结构网上选课系统的基本设计思想,本文简要介绍系统各功能模块及数据库的设计,着重讨论用ASP.NET技术和SQL Server 2000开发网上选课系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。
There are a lot of public electives during the university period.the traditional method of course choosing lack prescience, and there are no prior coordination.This is a very physically sexual problem in the university campus of teaching manage. With the help of the Public elective on-line select system, every students' courses can be determined before the beginning of the term, saving physical force and reasonably distributing teaching resources.The method which carries out the elective on-line select system includes a lot and mainly have JSP+MySql+Tomcat, PHP+MySql+Apache, ASP+SQL Server+IIS and ASP.NET+SQL Server+IIS etc.The development languages of these free methods are all be HTML. nondisjunction between Design code and backstage code makes code not easy to understand and support behind.This text carries on a research to above problem:
1.Using ASP.NET as a develop tool, carried out the separation design code between backstage code.
2. According to the consideration of the classmates select elective courses usually using Windows system and the easiness to support code of ASP.NET+SQL,we determined to use ASP.NET +SQL Server+t IIS.
3. The database accessing of most systems directly write a SQL language sentence in the code to carry on a database search.In this system, the overwhelming majority functions all use saving process to complete the work of database interview.
4. It increased flexibility and protected the safety of database that the through coding encrypt string of conjunction database can modify in the web.config at any time.
5. It passes the Session in the usage progress, as far as possible uses saving process and as far as possible reduces the etc. means in time of open of database conjunction to lift a high performance in the code.
This paper gives the basic design idea of the B/S—based online course elect system by analyzing the characteristic of the B/S structure and combining with the actual public elective courses conditions of our school.It introduces the function module and database design briefly,followed by a discussion on database accessing technology and the active page technology of the course elect system based on ASP.NET and SQL Server 2000 and gives a part of carring code.
引文
[1]李应伟,姚素霞,景丽. ASP.NET数据库高级编程(C#篇).北京:清华大学出版社,2004:1~88
[2] Parihar M等. ASP.NET宝典(王勇,盖江南,尚红昕等).北京:电子工业出版社,2002:81~101
[3] Prince J.C#数据库编程从入门到精通(邱仲潘).北京:电子工业出版社,2003:1~204
[4]曹莉,赵文静.基于B/S结构网上选课系统的设计与实现.现代电子技术术,2006,3:93~106
[5] Deitel H M.C#大学教程(须德等).北京:电子工业出版社,2004:1~277
[6]徐进,姜世锋.SQL Server 2000编程员指南.北京:希望电子出版社,2000:37~103
[7] Silberschatz A,Korth H F,Sudarshan S.数据库系统概念(杨冬青,唐世渭).北京:机械工业出版社,2003:1~52
[8]萨师煊,王珊.数据库系统概论.第三版.北京:高等教育出版社,2000:203~242
[9] Payne C.ASP.NET从入门到精通(赵斌,张滨义,董清波).北京:人民邮电出版社,2002:215~239
[10] URL: http://www.csdn.net
[11]陈峰棋,俞彬.深入浅出ASP.NET程序设计.中国水利水电出版社,2004
[12]黄忠成.深入浅出剖析ASP.NET组件设计.电子工业出版社,2004.5
[13]微软..NET Framework开发员指南,2001
[14]刘三星.ASP开发B/S模式的Web数据库网上教学系统.微计算机信息2006,22:181
[15]陈志泊.ASP.NET数据库应用程序开发教程.人民邮电出版社,2005.5
[16]王超,张鹏.ASP.NET/XML深入编程技术.北京希望电子出版社,2002
[17] Nikhil Kothari,Vandana Datye.ASP.NET服务器控件与组件开发.2003
[18] KUFFMAN J,THANGARATHINAM T ASP.NET2.0数据库入门经典[M]4版,清华大学出版社,2006
[19]邹建峰等.ASP.NET开发技术详解[M].人民邮电出版社,2005
[20] PATEL J,ACKER B,MCGOVERN R.Data Access in ASP.NET2.[EB/OL](2006-01-12)[2006-07-20].http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/dataaccess.asp
[21] PAPA J.Data Source Controls in ASP.NET2.0[EB/OL].(2006-02-02)[2005-05-14].
[22] http://msdn.microsoft.com/msdnmag/tssues/05/01/DataPoints/default.aspx
[23] RUSS BASIURA,MIKE BATONGBACAL等著. ASP.NET Web服务高级编程(康博译).清华大学出版社,2002(6)
[24] FABIO CLAUDIO,FERRACCHIATI,JAY GLYNN等著..NET数据服务C#高级编程(毛绕飞译),清华大学出版社2002(6)
[25] Marco Bellinso.ASP.NET 2.0 Website Programming: Problem - Design - Solution (Programmer to Programmer) (Paperback). Amazon.com,2007
[26] Jesse Liberty; Dan Hurwitz .Programming ASP.NET, 3rd Edition (Programming) [ILLUSTRATED] (Paperback).Oct 1, 2005
[27] Imar Spaanjaars, Paul Wilton, and Shawn Livermore (Paperback -).ASP.NET 2.0 Instant Results (Programmer to Programmer) (Paperback). Mar 24, 2006
[28] Darren Neimke . ASP.NET 2.0 Web Parts in Action: Building Dynamic Web Portals (In Action) [ILLUSTRATED] (Paperback). Amazon.com,2007
[29] Alex Homer and Dave Sussman.ASP.NET 2.0 Illustrated (Microsoft .NET Development Series) (Paperback). Amazon.com .Jun 16, 2006
[30] Alex Homer and Apress. Pro ASP.NET Web Forms Techniques, Second Edition (Paperback). Amazon.com. Dec 8, 2003
[31] David Sussman and Alex Homer. Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter Kit (Paperback). Amazon.com. Jan 18, 2006
[32] Richard Anderson, Dan Denault, Brian Francis, and Marco Gregorini. ASP 3.0 Programmer's Reference (Paperback). Amazon.com.April 15, 2002
[2] Parihar M等. ASP.NET宝典(王勇,盖江南,尚红昕等).北京:电子工业出版社,2002:81~101
[3] Prince J.C#数据库编程从入门到精通(邱仲潘).北京:电子工业出版社,2003:1~204
[4]曹莉,赵文静.基于B/S结构网上选课系统的设计与实现.现代电子技术术,2006,3:93~106
[5] Deitel H M.C#大学教程(须德等).北京:电子工业出版社,2004:1~277
[6]徐进,姜世锋.SQL Server 2000编程员指南.北京:希望电子出版社,2000:37~103
[7] Silberschatz A,Korth H F,Sudarshan S.数据库系统概念(杨冬青,唐世渭).北京:机械工业出版社,2003:1~52
[8]萨师煊,王珊.数据库系统概论.第三版.北京:高等教育出版社,2000:203~242
[9] Payne C.ASP.NET从入门到精通(赵斌,张滨义,董清波).北京:人民邮电出版社,2002:215~239
[10] URL: http://www.csdn.net
[11]陈峰棋,俞彬.深入浅出ASP.NET程序设计.中国水利水电出版社,2004
[12]黄忠成.深入浅出剖析ASP.NET组件设计.电子工业出版社,2004.5
[13]微软..NET Framework开发员指南,2001
[14]刘三星.ASP开发B/S模式的Web数据库网上教学系统.微计算机信息2006,22:181
[15]陈志泊.ASP.NET数据库应用程序开发教程.人民邮电出版社,2005.5
[16]王超,张鹏.ASP.NET/XML深入编程技术.北京希望电子出版社,2002
[17] Nikhil Kothari,Vandana Datye.ASP.NET服务器控件与组件开发.2003
[18] KUFFMAN J,THANGARATHINAM T ASP.NET2.0数据库入门经典[M]4版,清华大学出版社,2006
[19]邹建峰等.ASP.NET开发技术详解[M].人民邮电出版社,2005
[20] PATEL J,ACKER B,MCGOVERN R.Data Access in ASP.NET2.[EB/OL](2006-01-12)[2006-07-20].http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/dataaccess.asp
[21] PAPA J.Data Source Controls in ASP.NET2.0[EB/OL].(2006-02-02)[2005-05-14].
[22] http://msdn.microsoft.com/msdnmag/tssues/05/01/DataPoints/default.aspx
[23] RUSS BASIURA,MIKE BATONGBACAL等著. ASP.NET Web服务高级编程(康博译).清华大学出版社,2002(6)
[24] FABIO CLAUDIO,FERRACCHIATI,JAY GLYNN等著..NET数据服务C#高级编程(毛绕飞译),清华大学出版社2002(6)
[25] Marco Bellinso.ASP.NET 2.0 Website Programming: Problem - Design - Solution (Programmer to Programmer) (Paperback). Amazon.com,2007
[26] Jesse Liberty; Dan Hurwitz .Programming ASP.NET, 3rd Edition (Programming) [ILLUSTRATED] (Paperback).Oct 1, 2005
[27] Imar Spaanjaars, Paul Wilton, and Shawn Livermore (Paperback -).ASP.NET 2.0 Instant Results (Programmer to Programmer) (Paperback). Mar 24, 2006
[28] Darren Neimke . ASP.NET 2.0 Web Parts in Action: Building Dynamic Web Portals (In Action) [ILLUSTRATED] (Paperback). Amazon.com,2007
[29] Alex Homer and Dave Sussman.ASP.NET 2.0 Illustrated (Microsoft .NET Development Series) (Paperback). Amazon.com .Jun 16, 2006
[30] Alex Homer and Apress. Pro ASP.NET Web Forms Techniques, Second Edition (Paperback). Amazon.com. Dec 8, 2003
[31] David Sussman and Alex Homer. Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter Kit (Paperback). Amazon.com. Jan 18, 2006
[32] Richard Anderson, Dan Denault, Brian Francis, and Marco Gregorini. ASP 3.0 Programmer's Reference (Paperback). Amazon.com.April 15, 2002