中国职业学院网设计与实现
摘要
在国家大力发展职业教育的今天,作为职业教育的一名从业者,在教育教学过程中,我发现国内还没有一个全面为高职高专提供服务的网络平台。为推动我国高职高专教育的发展,借此硕士毕业论文撰写机会,作者对网站建设的基本理论进行了全面性的研究,在主编《电子商务网站建设》一书后,凭借大量的实践经验和理论基础研发了“中国职业学院网”。
本文在借鉴国内诸多网站建设原理的基础上,对高职高专门户网站建设的理论进行了较为深入的思考,在“中国职业学院网站建设”领域取得重大突破。
在第一章中系统介绍了本文研究的文化背景、意义以及国内教育网站建设的现状;第二章介绍了中国职业学院网开发技术的选型;第三章研究了中国职业学院网规划设计的相关内容;第四章针对网站建设运用的数据库设计理念进行了剖析。第五章解决了网站建设中存在的难点问题,及部分关键技术的实现。第六章对整个论文做了总结。
Three major tasks of site-building are envoved in this paper,which are the planning and design, database implementation and the Implementation of China's vocational colleges network. The planning and design part combined with the author’s book of "e-commerce site building" and the author’s actual production experience of China's network of vocational colleges to conduct a comprehensive study of planning and design;the part of the database implementation will analize and studies the database ofChina vocational college Network;the part of functions achievement get across through the graphical interface display, text description, code model to display the key code of China vocational college Network.
Selection work will do well before development of the site, mainly include the development of technology selection, ADO database connection technology, B / S three-tier architecture, server platform selection. E-commerce Web sites are now dynamic web sites, and users can dynamically exchange information with the site. Need to use scripting language programming to achieve its dynamic interactive features, and must be able to support database operations for membership, merchandise, transactions, database management, to achieve a database of the site. Currently, the most popular, most widely used dynamic web site development technologies include: JSP, ASP, PHP. These three technologies are in the static HTML in the embedded scripting language to implement dynamic web sites, they can be integrated very well with standard HTML pages. These three technologies each have advantages, China vocational colleges network take full account of the size of the site requirements, site development model, the site safety requirements, existing technology infrastructure, server platform, selection and other factors, using ASP technology for development.
ASP via ADO to manipulate the database, ADO is ActiveX Data Object, which is a group of dedicated access to the database object set, it provides a complete ASP database access methods. ADO contains many objects, including Connection object and the Recordset object,which are mainly used for controlling database access, to establish a database access must first create a Connection object, and then based on this Connection object's Recordset object to complete the operation on the database obtained. There are four steps to use the database, the first step is to connect to the database ASP. In the ASP ,the database should be connected firstly before use it, and should be closed at the end. The second step is to use the Recordset object processing data. With the connection of the database is established, the next is to access the database table records. We use the Recordset object to operate. The third step is the operation of the database table data. The fourth step is to close the connection, this is the last step, first using Rs.close statements off the record set, and then Conn.Close close the connection, the final connection Set conn = Nothing to release memory space occupied.
B / S structure is English Browser / server acronym, that is, client / server architecture. B / S is an Internet-based software architecture model, that is, the client uses the browser as the execution environment, server-side Web server used as the operating platform, the background using the database server as a resource platform to form a three-tier architecture. In the B / S structure, the user through a browser to be running results. In the B / S system of three-tier architecture, the user through a browser makes a request to the server, the server responds, and request processing, the processed results are returned to the client browser. Data request, information processing, the results returned, dynamic page generation, database access, etc. will be done by the server to complete. The current B / S three-tier architecture has become the first structure of software development.
The so-called site's server platform that is used by network server operating system. With the improvement of e-commerce site features, as well as an increase in site traffic, web server space occupied by an increasingly large web server's load will be heavier. Select the appropriate network server operating systems also become increasingly important. The server's operating system in business activities, organization and implementation process play a dominant role. Therefore, a large number of the server operating system, enterprises must choose an appropriate operating system they need, which is server platform selection. At present, the server operating system has three major categories: one category is Windows family, and its representative product is Windows Server 2003; the other is UNIX family, and its representative products include HP-UX, IBM AIX, etc.; the third category is Linux, which is a network server, a rising star, with an open and cost-effective and so striking feature of the rapid development in recent years, the number of users growing rapidly. The choice of server platforms to run the server determines the stability and smooth operation of e-commerce website basic security, China's vocational schools network took into account the bearing capacity of enterprises to invest in server platforms, security, server platform, full-featured, server platform, easy maneuverability, especially taking into account the continuous development of the site to grow in the server options to be able to meet the site's long-term development needs, so I chose Windows 2003 as server platform.
China Vocational College Network planning is the first step in the construction of the site, the main element of the work on site a detailed market research foundation, to conduct accurate analysis and Web site produced by the overall framework proposed structure, and then determine the site-building process and finally write the book out of the site plan. China Vocational College Network’s two columns were set up sixteen blocks, its overall goal is to strive to become China's top-ranked professional schools portal, its functions are provide many platforms: for the country's higher vocational institutions to display; for the country's higher vocational students to study; for the merchants to advertise; for the employers to provide jobs.for the students to seek jobs. the navigation of China Vocational College Network consists of two parts: functional navigation, geographical navigation. China Vocational College network to a white background as a foundation, the main colors used in blue, accompanied by a red to do secondary color, display graceful, well formed, writing in a standard 12-pixel-based letter. Demonstrated better overall portal style.
Database management system is the very important part of institutional management system stores all the data, the whole system revolved around the database design and development. the database maintenance of the structural design and safety will have a direct impact on the overall system design and development and software quality. China Vocational College network contains a large amount of resources, all resources are stored form of a database. China Vocational College Web site contains all of China's higher vocational institutions, the basic data.
China Vocational College Network’s capability are mainly to achieve the capabilities of admin and login, the background content of input function modules, the user management implementation, database management functions. By each part of the interface, composition, technical realization of the four components.
本文在借鉴国内诸多网站建设原理的基础上,对高职高专门户网站建设的理论进行了较为深入的思考,在“中国职业学院网站建设”领域取得重大突破。
在第一章中系统介绍了本文研究的文化背景、意义以及国内教育网站建设的现状;第二章介绍了中国职业学院网开发技术的选型;第三章研究了中国职业学院网规划设计的相关内容;第四章针对网站建设运用的数据库设计理念进行了剖析。第五章解决了网站建设中存在的难点问题,及部分关键技术的实现。第六章对整个论文做了总结。
Three major tasks of site-building are envoved in this paper,which are the planning and design, database implementation and the Implementation of China's vocational colleges network. The planning and design part combined with the author’s book of "e-commerce site building" and the author’s actual production experience of China's network of vocational colleges to conduct a comprehensive study of planning and design;the part of the database implementation will analize and studies the database ofChina vocational college Network;the part of functions achievement get across through the graphical interface display, text description, code model to display the key code of China vocational college Network.
Selection work will do well before development of the site, mainly include the development of technology selection, ADO database connection technology, B / S three-tier architecture, server platform selection. E-commerce Web sites are now dynamic web sites, and users can dynamically exchange information with the site. Need to use scripting language programming to achieve its dynamic interactive features, and must be able to support database operations for membership, merchandise, transactions, database management, to achieve a database of the site. Currently, the most popular, most widely used dynamic web site development technologies include: JSP, ASP, PHP. These three technologies are in the static HTML in the embedded scripting language to implement dynamic web sites, they can be integrated very well with standard HTML pages. These three technologies each have advantages, China vocational colleges network take full account of the size of the site requirements, site development model, the site safety requirements, existing technology infrastructure, server platform, selection and other factors, using ASP technology for development.
ASP via ADO to manipulate the database, ADO is ActiveX Data Object, which is a group of dedicated access to the database object set, it provides a complete ASP database access methods. ADO contains many objects, including Connection object and the Recordset object,which are mainly used for controlling database access, to establish a database access must first create a Connection object, and then based on this Connection object's Recordset object to complete the operation on the database obtained. There are four steps to use the database, the first step is to connect to the database ASP. In the ASP ,the database should be connected firstly before use it, and should be closed at the end. The second step is to use the Recordset object processing data. With the connection of the database is established, the next is to access the database table records. We use the Recordset object to operate. The third step is the operation of the database table data. The fourth step is to close the connection, this is the last step, first using Rs.close statements off the record set, and then Conn.Close close the connection, the final connection Set conn = Nothing to release memory space occupied.
B / S structure is English Browser / server acronym, that is, client / server architecture. B / S is an Internet-based software architecture model, that is, the client uses the browser as the execution environment, server-side Web server used as the operating platform, the background using the database server as a resource platform to form a three-tier architecture. In the B / S structure, the user through a browser to be running results. In the B / S system of three-tier architecture, the user through a browser makes a request to the server, the server responds, and request processing, the processed results are returned to the client browser. Data request, information processing, the results returned, dynamic page generation, database access, etc. will be done by the server to complete. The current B / S three-tier architecture has become the first structure of software development.
The so-called site's server platform that is used by network server operating system. With the improvement of e-commerce site features, as well as an increase in site traffic, web server space occupied by an increasingly large web server's load will be heavier. Select the appropriate network server operating systems also become increasingly important. The server's operating system in business activities, organization and implementation process play a dominant role. Therefore, a large number of the server operating system, enterprises must choose an appropriate operating system they need, which is server platform selection. At present, the server operating system has three major categories: one category is Windows family, and its representative product is Windows Server 2003; the other is UNIX family, and its representative products include HP-UX, IBM AIX, etc.; the third category is Linux, which is a network server, a rising star, with an open and cost-effective and so striking feature of the rapid development in recent years, the number of users growing rapidly. The choice of server platforms to run the server determines the stability and smooth operation of e-commerce website basic security, China's vocational schools network took into account the bearing capacity of enterprises to invest in server platforms, security, server platform, full-featured, server platform, easy maneuverability, especially taking into account the continuous development of the site to grow in the server options to be able to meet the site's long-term development needs, so I chose Windows 2003 as server platform.
China Vocational College Network planning is the first step in the construction of the site, the main element of the work on site a detailed market research foundation, to conduct accurate analysis and Web site produced by the overall framework proposed structure, and then determine the site-building process and finally write the book out of the site plan. China Vocational College Network’s two columns were set up sixteen blocks, its overall goal is to strive to become China's top-ranked professional schools portal, its functions are provide many platforms: for the country's higher vocational institutions to display; for the country's higher vocational students to study; for the merchants to advertise; for the employers to provide jobs.for the students to seek jobs. the navigation of China Vocational College Network consists of two parts: functional navigation, geographical navigation. China Vocational College network to a white background as a foundation, the main colors used in blue, accompanied by a red to do secondary color, display graceful, well formed, writing in a standard 12-pixel-based letter. Demonstrated better overall portal style.
Database management system is the very important part of institutional management system stores all the data, the whole system revolved around the database design and development. the database maintenance of the structural design and safety will have a direct impact on the overall system design and development and software quality. China Vocational College network contains a large amount of resources, all resources are stored form of a database. China Vocational College Web site contains all of China's higher vocational institutions, the basic data.
China Vocational College Network’s capability are mainly to achieve the capabilities of admin and login, the background content of input function modules, the user management implementation, database management functions. By each part of the interface, composition, technical realization of the four components.
引文
[1]阳波.规范与反规范在数据库设计中的应用[J]电脑开发与应用, 2003,(04)
[2]郭歌,贾焰. PostgreSQL数据库XA协议的设计和实现[J]计算机应用研究, 2000,(01)
[3]易元祥.中国高等职业教育的发展研究[J]华中科技大学学报, 2004,(09)
[4]曹炳志.高等职业教育的理念:服务、就业、创新[J]黑龙江高教研究, 2009,(06)
[5]沈华飞.如何走出高校网站建设的困境[J].硅谷, 2009, (02) .
[6]张先伟,曹雁锋.面向学员的远程教育平台的建设与探索[J]中国教育信息化, 2007,(21)
[7]胡雪君.浅谈学校教学信息化建设[J]宁夏教育, 2006,(09)
[8]王珠珠,张伟远.我国普通高校网上教学平台及网站建设的现状分析[J]中国远程教育, 2005,(02) .
[9]曲宏毅,韩锡斌,张明,武祥村.网络教学平台的研究进展[J]中国远程教育, 2006,(05) .
[10]梁文理.高校网站建设[J].内蒙古科技与经济, 2008, (19) .
[11]叶协杰,杨秀梅,邸明.高校网站建设中的问题与对策[J].医学信息, 2001, (08) .
[12]邵挺.关于高校网站建设的思考[J].青年记者, 2008, (14) .
[13]付强.网站建设与维护[J].中国新技术新产品, 2009, (01) .
[14]陈红秋,钱军.关于加强高校网站建设的思考与对策[J].泰州职业技术学院学报, 2003, (02) .
[15]潘泽乾.论网页设计与网站建设的创意与实施[J].齐鲁艺苑, 2009, (02) .
[16]陈艳.浅谈网站建设[J].内江科技, 2009, (02) .
[17]汪开寿.以创新精神加强高校网站建设与管理对策研究[J].中国教育信息化, 2008, (13) .
[18]邹丽英,孙小权.浅谈高校网站的建设与维护[J].教育信息化, 2006, (03) .
[19]唐乾林,网站界面设计案例教程[J] 2009,(02)
[20]梁晓晖:来继敏.ASP.NET2.0(C#)网站开发实用教程2009,(08)
[21]马涛.网站建设与管理2008,(09)
[22]周济.中华人民共和国全国人民代表大会常务委员会公报2009(05)
[2]郭歌,贾焰. PostgreSQL数据库XA协议的设计和实现[J]计算机应用研究, 2000,(01)
[3]易元祥.中国高等职业教育的发展研究[J]华中科技大学学报, 2004,(09)
[4]曹炳志.高等职业教育的理念:服务、就业、创新[J]黑龙江高教研究, 2009,(06)
[5]沈华飞.如何走出高校网站建设的困境[J].硅谷, 2009, (02) .
[6]张先伟,曹雁锋.面向学员的远程教育平台的建设与探索[J]中国教育信息化, 2007,(21)
[7]胡雪君.浅谈学校教学信息化建设[J]宁夏教育, 2006,(09)
[8]王珠珠,张伟远.我国普通高校网上教学平台及网站建设的现状分析[J]中国远程教育, 2005,(02) .
[9]曲宏毅,韩锡斌,张明,武祥村.网络教学平台的研究进展[J]中国远程教育, 2006,(05) .
[10]梁文理.高校网站建设[J].内蒙古科技与经济, 2008, (19) .
[11]叶协杰,杨秀梅,邸明.高校网站建设中的问题与对策[J].医学信息, 2001, (08) .
[12]邵挺.关于高校网站建设的思考[J].青年记者, 2008, (14) .
[13]付强.网站建设与维护[J].中国新技术新产品, 2009, (01) .
[14]陈红秋,钱军.关于加强高校网站建设的思考与对策[J].泰州职业技术学院学报, 2003, (02) .
[15]潘泽乾.论网页设计与网站建设的创意与实施[J].齐鲁艺苑, 2009, (02) .
[16]陈艳.浅谈网站建设[J].内江科技, 2009, (02) .
[17]汪开寿.以创新精神加强高校网站建设与管理对策研究[J].中国教育信息化, 2008, (13) .
[18]邹丽英,孙小权.浅谈高校网站的建设与维护[J].教育信息化, 2006, (03) .
[19]唐乾林,网站界面设计案例教程[J] 2009,(02)
[20]梁晓晖:来继敏.ASP.NET2.0(C#)网站开发实用教程2009,(08)
[21]马涛.网站建设与管理2008,(09)
[22]周济.中华人民共和国全国人民代表大会常务委员会公报2009(05)