This paper mainly expounds that with China's entry into WTO, the Internet has developed rapidly in China. With its excellent interactivity and convenient means of communication, the network is becoming the new media with the most development potential and future, and it has become a publicity hotspot that many businesses pay attention to. In particular, small enterprises should make full use of Internet technology, provide information services for customers and partners on the Internet, and use the Internet to keenly capture business opportunities. Chongqing Saizhi Network Information Technology Service Center, which specializes in the sales of classified and security products, needs to build a good website as a carrier for external publicity, service and communication. With the rapid development of the company, the website has distinctive industry characteristics, so that more enterprises can form alliances through the network and more customers can understand Saizhi network through the network.
Asp+ACCESS is a mature technology, so this project uses Asp language as the foundation, chooses the classic B/S development framework, and uses ACCESS in the database.
Keywords: Internet; Corporate website; Database; WEBB/S architecture; ASPHTMLCSSAccess 2003 .
abstract
This paragraph mainly talks about the rapid growth and changes of the Internet with China's entry into WTO. Network is becoming a new media with the most development potential and future, and it is also a hot spot for many businesses to publicize. We should make full use of network technology to provide information services for customers and cooperative enterprises, especially to attract business for small enterprises. As a securities company, Chongqing Xinda Network Co., Ltd. should better build its own homepage as a carrier of publicity, service and communication, so as to make itself grow up rapidly. Let more enterprises and customers join and understand Chongqing Xinsi Network Co., Ltd. through the homepage.
ASP+ACCESS is a mature technology. So this website uses ASP as the basic language and Access as the database.
Keywords: Internet; Company website; Database; WEBB/S structure; ASPHTMLCSSAccess 2003。
catalogue
Abstract 1
Abstract 2
Directory 1
1 Introduction 1
1. 1 development background 1
1.2 objectives and expectations of project development
1.3 paper structure 2
2 Introduction to website development technology 3
2. Introduction to1ASP 3
2.2 introduction to Microsoft access 2003 3
3 website demand analysis 4
3. 1 overview 4
3.2 Functional Requirements 4
3.3 Performance Requirements 5
3.4 Website Flow Chart 5
4 overall design of the website 7
4. 1 website design principles 7
4.2 The overall structure of the website 7
4.3 Overview of website function modules 10
5 database design and implementation 1 1
5. 1 database design
5.2 Database Requirements Analysis 1 1
5.3 Conceptual structure design of database 1 1
5.4 Database logical structure design 12
6 website detailed design 16
6. 1 background management system interface 16
6.2 Website main interface 2 1
7 website debugging and user instructions 23
7. 1 website debugging 23
7.2 User Instructions 23
8 Conclusion 24
Reference 25
Thanks 26
Appendix (Part) Source Code 27
1 Introduction
The information age has arrived, and the tentacles of the Internet have already covered every corner of the world. Nowadays, establishing your own corporate website has become a necessary means for enterprises in the information age.
The development background of 1. 1
Nowadays, the development of network has shown the trend of commercialization, popularization and globalization. At present, almost all companies in the world are using the Internet to transmit business information and carry out business activities, from promoting enterprises, advertising, recruiting employees, transmitting business documents and even expanding markets and online sales. Nowadays, the network has become a strategic means of enterprise competition. The diversified expansion of enterprise management and the further expansion of enterprise scale put forward higher requirements for enterprise management, business development and enterprise brand image. Under the new economic conditions supported by information technology, more and more enterprises regard the network as an effective tool. The website has already entered the substantive stage from the demonstration stage, especially providing a stage for enterprises to show themselves and creating a shortcut for consumers to understand enterprises. The company can establish a business platform through the Internet, implement all-weather sales service, publicize corporate image, publicize corporate products and release corporate news, and at the same time make the company better understand the psychology and needs of customers through information feedback. The organic combination of website virtual company and entity company will be beneficial to the expansion of the company's product sales channels, save a lot of advertising and operating costs, and better grasp the business opportunities. With the development of global information network, the Internet is not only a technology, but more importantly, it has become a new business model. From 4C (connect. At the level of communication, commerce and cooperation, it has completely changed the way of human work, study, life and entertainment, and has become the main driving force for national and regional economic growth. Internet is becoming the largest public information database in the world, which contains countless information resources, and all the latest information can be obtained through network search. More importantly, most of the information is free, and the application of e-commerce can enable enterprises to obtain a large amount of commercial information that can not be obtained under the traditional mode, thus leading the competitors in the fierce market competition.
1.2 objectives and expectations of project development
(1) Establish a brand-new corporate image
For a small enterprise focusing on software development and security product sales, the brand image of the enterprise is very important. Especially for today's highly developed Internet technology, most customers learn about enterprise products, enterprise image and enterprise strength through the Internet. Therefore, the image of corporate websites often determines the confidence of customers in corporate products. Establishing a website with international standards can greatly enhance the overall image of the enterprise.
(2) Improve sales ability
Sales force refers to the embodiment of the comprehensive quality advantages of products in sales. Modern marketing theory holds that sales is communication. The success of sales depends not only on whether the advantages of products can be fully disseminated, but also on how much effective information the target audience can get from them. Because of the "one-to-one" feature of the Internet, the target object can choose the information that is useful to him. This in itself determines that consumers are interested in information. So that the dissemination of information is not subjectively added by consumers, but selectively absorbed by consumers. At the same time, through the advanced design of the website, the product information not only has the advantage of large amount of information in newspapers, but also combines the comprehensive stimulation advantages of TV sound, light and electricity, which can firmly attract the target audience. Therefore, the effectiveness of product information dissemination will be greatly improved, while improving the sales force of products.
(3) increase the added value
As many people know, buying products is not only about buying visible objects, but also about invisible after-sales service. This is the added value of the product. The higher the added value of products, the more competitive they are in the market and the more popular they are with consumers. Therefore, in order to win the market, enterprises must do everything possible to increase the added value of products. At this stage, the traditional after-sales service means can no longer meet the needs of customers. Providing consumers with convenient, effective and instant 24-hour online service is a new direction to reflect the added value of the project. Customers all over the world can download the information they need at any time through the website, get the answers to their questions online and submit their own questions online.
To sum up the above points, the website construction goal of Chongqing Saizhi Network Information Technology Center can be summarized as follows:
1) Help enterprises to establish effective corporate image publicity, corporate style display and product promotion, and create a new image of "Saizhi.com".
2) Make full use of the fast and cross-regional advantages of the network to transmit information and report the company news in time.
3) Through the online supply and demand system, the online supply and demand information can be inquired, ordered and traded, and the information circulation channels can be optimized.
1.3 paper structure arrangement
The main content of this paper is the design and implementation of small business website, which is divided into seven chapters:
Chapter 1 is the introduction, which describes the development background, objectives and expectations of this paper.
Chapter 2 is a brief introduction of website development technology, focusing on ASP, Access2003 database and other technical knowledge.
The third chapter is the analysis of website requirements, which mainly introduces the functional requirements, performance requirements, operational requirements and website flow chart.
Chapter 4 is the realization of the overall structure of the website, which mainly introduces the principles of website design, the overall structure of the website and the functional modules of the website, with emphasis on the functional modules of the website.
Chapter 5 is database design and implementation, which mainly introduces database design steps: database demand analysis, database conceptual structure design and database logical structure design, with emphasis on database logical structure design.
Chapter 6 is the detailed design of the website, mainly aiming at several functional modules: website backstage, website foreground, BBS and other modules.
The seventh chapter is the website debugging and user instructions, mainly introducing the website debugging and user instructions.
Chapter 8 is the conclusion.
2 Introduction to website development technology
2. Introduction of1ASP
The full name of ASP is Active Server Pages, that is, dynamic server pages. Why is it called dynamic server page? This is because the Internet used to be composed of static HTML pages. If you need to update the content of your website, you must make a large number of HTML pages. With ASP, we can display different contents to users at different times according to different users. The content update of the website is no longer a boring repetitive process, but begins to become simple and interesting. Therefore, there is an upsurge of learning ASP in China.
ASP programming is more convenient and flexible than HTML. It runs on a Web server, and then sends the running results to the browser of the client in HTML format. So ASP is much safer than ordinary scripting languages. The biggest advantage of ASP is that it can contain HTML tags, access the database directly, and use infinitely extended ActiveX controls. Users can use ActiveX controls directly. Call object methods and properties to realize powerful interactive functions in a simple way. However, ASP technology is not perfect, because it is basically limited to Microsoft's operating system platform, the main working environment is Microsoft's IIS application structure, and because ActiveX objects have platform characteristics, ASP technology should work on cross-platform Web servers. It is not easy. Microsoft's asp technology has now developed to. Online version. For many people, using ASP to create dynamic Web pages, whole websites and web-based applications on Windows server platform has become a very natural method. In the browser address bar, the file extension. ASP is the same as the file extension. Pl or. Dynamically create cgi of web pages. It has been accepted by tourists. When developing ASP programs, the column format and typesetting of static web pages are often designed into HTML language, and then script programs are added on the basis of HTML to form ASP programs, thus realizing dynamic web pages. In the development of ASP programs, JavaScript and VBscript are used, and VBscript is used by default. VBScript is a subset of VB programming language, and its syntax is basically the same as VB [6].
2.2 introduction to Microsoft access 2003
Access is powerful and easy to use, and it is one of the best desktop database development tools. There is a significant difference between Access and other database development systems: Access database system moves the establishment of database applications to the user environment, and users can develop a powerful and quite professional database application in a short time without writing a line of code, and this process is completely visible [3].
Another important difference between Access and other desktop databases is that database files in Access include both tables for storing data and other objects for manipulating or controlling data. It consists of seven objects: tables, queries, forms, reports, web pages, macros and modules [2].
Access 2003 has greatly improved its network function. In the database, you can directly link to the specified web page or network file through the hyperlink field, or publish the data in the database file to the network through the "data access page" to realize data sharing.
3 website demand analysis
3. 1 overview
At present, enterprises are still dominated by traditional management methods. However, with the advent of economic globalization and e-commerce economy, enterprises can no longer adapt to the trend of economic globalization if they stick to the traditional model. Many enterprises are not aware of the danger of being eliminated because they are well-run and do not adapt to the economic development environment. It is an unavoidable reality for enterprises to develop e-commerce online. When your competitors are enjoying information through the Internet, reducing costs and expanding sales channels through e-commerce, you can only miss the opportunity.
Enterprises with their own websites can increase your business and bring more customers. The network is not regional. As long as you have a website, people all over the world can find your information and serve more customers. Moreover, the website can promote your enterprise accordingly, which not only reduces your promotion expenses, but also establishes a better image for your enterprise.
3.2 Functional requirements
Different roles should have different functions in the system according to the different needs and permissions of different users. The following are the roles of three roles in corporate websites.
(1) The functions that a webmaster should have.
Manage product information, add, modify and delete product categories;
The management of enterprise news can add, delete and modify news accordingly;
Manage product orders, and be able to review and operate the orders accordingly;
Message information management can add and delete information submitted by registered users.
(2) The functions that registered users of websites should have.
For registered users of the website, they can log in, browse the webpage information, and express their opinions on the private message board after logging in.
(3) The functions that non-registered users of the website should have.
For non-registered users of the website, the system can provide the function of registration, and can also browse the website and express opinions on public message boards without registered users. .
3.3 Performance requirements
In order to ensure the long-term, safe, stable, reliable and efficient operation of the website system, the operation of the enterprise website should meet the following performance requirements:
1. Operation requirements of server-side subsystem:
System software: Window NT server
Database management system: SQL Server/Access
Hardware requirements: Pentium IV 450 or above, 1G RAM.
2. The client subsystem operation requirements:
System software: Window NT workstation
Database management system: SQL Server/Access
Hardware requirements: Pentium III or above, 256M memory.
3.4 Website Flow Chart
The following is a functional flow chart analysis of each user.
The process analysis of membership function is shown in Figure 3. 1.
Fig. 3. Flow chart of1membership function
The function flow analysis of the administrator is shown in Figure 3.2.
Figure 3.2 Administrator Function Flowchart
4 overall design of the website
4. 1 website design principles
Practical principle: Ensure that the website has good system performance, friendly user interface and high processing efficiency. It is convenient for managers to use and maintain, and adopts mature technology.
Principle of advanced nature: adopt advanced and mature technology to make it have a higher technical level and a longer life cycle.
Compatibility principle: The selected hardware system and platform can be well adapted to development and use.
Normative principle: the software design process is carried out in strict accordance with the "software engineering" specification, and the system coding, operating system platform and adopted development methods meet the corresponding international standards and national standards.
4.2 The overall structure of the website
The website mainly includes three parts: the website foreground, the website background management system and the database. The front desk of the website includes 8 functional columns about us, news center, honor and qualification, product display, talent recruitment, customer service, SMXH community and contact us.
The website reflects the deposit of the enterprise itself, and the company itself has more planning texts, rules and regulations and activities, so it needs to enrich the content of the website. Enriching website content (increasing information, enhancing readability, expanding knowledge and strengthening corporate culture propaganda) is a problem that must be seriously considered in front desk function design. For example, the foreground function module of every enterprise website needs enterprise news and product display. Talent recruitment and customer service are the perfection of website functions. Regarding us and the honorary qualification, the company publicizes from the side that SMXH Community (Forum) is a column set up by Saizhi Network Co., Ltd. according to the special needs of enterprises. Because it is the organizer of Chongqing Secret-related Enterprise Association, the company must provide members with a network communication platform and provide some special services. In short, the front desk function design must be done, each module has its necessity, and the function of the whole website should be improved.
The backstage function design of the website must fully meet the requirements of the foreground function module. Of course, there are also many companies that specialize in website backstage development (such as Dongyi) that can provide powerful professional website backstage. As a small enterprise, this background is not very practical, because the professional background management procedures are too complicated for internal personnel to manage. Therefore, it is very necessary to develop a small website background management system in the design of small enterprise websites.
4.3 Overview of website function modules
The main task of enterprise website is to publish enterprise news and product information; Administrators can add the latest product information and enterprise news, and can also modify, delete and modify them. And provide the latest product information and corporate news for visitors to browse.
The main functions of the front desk columns of the website are as follows:
About us: the first-level navigation bar, that is, the company profile, the company's corporate culture propaganda position;
② News Center: the first-level navigation bar, that is, the company's corporate news, major event reports and important industry news;
(3) Product display: the first-level navigation bar, that is, the company's current product introduction, consists of five series of products that the company currently sells;
(4) Talent recruitment: the first-level navigation bar, where enterprise recruitment publishes the job recruitment information of the personnel administration department;
⑤ Customer Service: The first-level navigation bar provides functions such as data modification, order inquiry, and member messages for website customers (member messages are used to protect customer data from illegal theft and utilization);
⑥ Partner: the first-level navigation bar, the information of the company's current partners.
⑦ Contact us: Level 1 navigation bar, including company contact information, general user message board (no need to register), technical support and electronic map;
⑧ smxh community: first-class navigation bar, forum of secret-related enterprise association, providing information exchange and learning for members of secret-related enterprise association.
5 database design and implementation
5. 1 database design
Database plays a very important role in a website system, and the design of database structure will directly affect the execution efficiency and implementation effect of the website. Database design is to build an optimal database model, establish a database and its application system for a given application environment, effectively store data, and meet users' information and processing requirements. Reasonable database structure design can improve data storage efficiency and ensure data integrity and consistency [2].
When designing a database system, we should first fully understand the needs of users in all aspects, including existing and possible future needs. Database design generally includes the following steps:
(1) database requirements analysis;
(2) Conceptual structure design of database;
(3) The logical structure design of the database.
5.2 Database Requirements Analysis
To design the whole database, we must accurately understand and analyze users' needs (including data and processing). User demand analysis is the basis of the whole design process, and it is also the most difficult and time-consuming step. As the most basic requirement analysis, whether it is done fully and accurately determines the speed and quality of database construction.
Users' needs are reflected in the provision, storage, update and query of various information, which requires the database structure to fully meet the output and input of various information. Collect basic data, data structure and data processing flow, form a detailed data dictionary, and lay the foundation for the specific design. With this idea as a design strategy, a small business website has at least the following three requirements:
(1) User table: including user name, password and other data items.
(2) Product list: The data items include product number, product category, product picture, etc.
(3) News table: The data items included include title, category, time, etc.
5.3 Conceptual structure design of database
Conceptual structure design is a process of abstracting the analyzed user demand information into a conceptual model. That is, on the basis of demand analysis, various entities and their interrelated conceptual structure design models that can meet the needs of users are designed. Only in this way can we use a DBMS to realize these requirements better and more accurately, which is the key to the whole database design.
The main characteristics of conceptual structure are that it can truly and comprehensively reflect the real world, and it is easy to understand and change, and it is easy to transform into various data models such as relationships, networks and levels. A powerful tool to describe conceptual model is E-R model.
There are usually four ways to design a conceptual structure:
(1) Top-down, that is, define the framework of the global conceptual structure first, and then gradually refine it.
(2) Bottom-up, that is, first define the conceptual structure of each local application, and then integrate them to get the global conceptual structure.
(3) Gradually expand: first define the most important core conceptual structure, then expand outward, and gradually generate other conceptual structures by snowballing until the overall conceptual structure.
(4) Mixed strategy, that is, combining top-down and bottom-up, designs a framework of global conceptual structure with top-down strategy, and integrates all local conceptual structures designed in bottom-up strategy with it as the skeleton. The most commonly used strategy is the bottom-up method, that is, top-down demand analysis, and then bottom-up conceptual structure design.
According to the above demand analysis and database design planning, the entities of this website are: member entities, product entities, news entities and administrator entities. E-R diagram of the relationship between administrators and news entities, as shown in Figure 5. 1.
Figure 5. 1 E-R diagram of administrators and news
5.4 Database logical structure design
Conceptual structure is an information structure independent of any data model. The task of logical structure design is to transform the basic E-R diagram designed in the conceptual structure design stage into a logical structure consistent with the data model supported by DBMS products.
When designing a logical structure, it is usually divided into three steps:
(1) Transform the conceptual structure into a general relationship, network and hierarchical model;
(2) Transforming the transformed relational, mesh and hierarchical models into data models supported by specific database management systems;
(3) Optimize the data model.
Convert the conceptual structure design of the above database into a relational model. The database table takes membership table, news table and talent recruitment table as examples, and the design results are as follows:
6 website detailed design
6. 1 background management system interface
6.2 Website main interface
7 website debugging and user instructions
7. 1 website debugging
Debugging applications is a very important programming work. When there is an error in the program, find out the problem and solve it through debugging. The application steps are as follows:
(1) Select the object or file to debug, open the corresponding file, the code will be displayed in DreamWave, and then debug in DreamWave.
(2) After modifying a piece of code, you can preview the result in the browser, and repeat it if there are any questions (1).
Repeat steps (1) and (2) again until there are no errors in the program.
8 concluding remarks
After more than three months of design and development, the small business website has been basically developed. Its function basically meets the needs of enterprises, and it can complete basic news release and product release. This program effectively solves the problems of data input, modification and query. And can manage the permissions of the database. However, due to the lack of knowledge and time, some subtle functions have not been realized, mainly because some algorithms are not concise enough and need to be improved and tempered in the future work. During this period of design, I feel that I have learned a lot of knowledge that I didn't know deeply before, as well as knowledge that I have never been exposed to. Such as ASP and Microsoft Office Access database knowledge and website design. In the previous study, I also studied ASP and Microsoft Office Access, but that only stayed at the stage of understanding. However, this graduation project gave me an opportunity to further understand and apply this knowledge. In the process of graduation design, I am familiar with the application and development of database, and have a deeper understanding of the installation principle of many softwares; Have a further understanding of software development process and software engineering theory, greatly enriching the experience of software development; And have a deeper understanding of the relevant knowledge learned in the previous learning process, and further apply it to the graduation project.
However, due to the short graduation design time and my limited knowledge, there are still many unsatisfactory places in this website, and there are still some problems in this website:
(1) system still has some security problems;
(2) Some functions of the system can not be well realized, and some aspects of the system are not considered;
(3) The system has some shortcomings in cross-platform operation.
These need to be further improved.
Therefore, we should strengthen the work and research in these aspects in the future: research and strengthen the safety management of websites; Familiar with some commonly used application software; Strengthen the learning of network function library knowledge.
refer to
[1] ASP Network Programming Technology and Examples, edited by Hu Biao, Peripheral Science and Technology People's Posts and Telecommunications Publishing House, May 2004,1edition.
[2] "Introduction to Database System (4th Edition)" edited by Sashixuan Wang Higher Education Press, 3rd Edition, June 65438+February 2006.
[3] Li Yanling and Chen Guang. Access 2000 foundation and application [M]. Beijing: Tsinghua University Publishing House, 2003.
[4][ America] Khristine Anwnpage translated by Wang Jun, Dreamweaver MX 2004 web design standard textbook (Chinese version) Electronic Industry Press, 2004-09.
[5] Decryption SEO-Search Engine Optimization and Website Success Strategy Author: (United States) Europe Zhao Hui Electronic Industry Press
[6] Shang, Network Programming -ASP Case Course, Tsinghua University Publishing House 2004- 1- 1.
Ren Shengbing, Xing Lin. Software engineering [M]. First edition. Beijing University of Posts and Telecommunications Press, 2004.
Wang Xingdong, ASP &；; ASP.NET Application Programming 150 Case, Electronic Industry Press, May 2004.
thank you
In the process of completing the thesis, my tutor Chen Libin gave me careful care and guidance, and I would like to express my heartfelt thanks. Teacher Chen's serious and responsible work attitude, rigorous academic style and diligent work style deeply touched me. I will learn his spirit in my future study and work.
While developing the website, I also benefited a lot from the mutual discussion with my classmates. Within a few months, in addition to learning to develop databases, I also learned the spirit of serious study, which is a strength in my future life.
In addition, I would like to thank all the teachers in Hunan Institute of Science and Technology, who have guided me forward. Their earnest teaching and hard work have given me a comprehensive study and understanding of computer knowledge. I also want to thank all my classmates who have cared and helped me, enriching my college life.
Finally, I want to thank my parents for their hard work and painstaking teaching over the years, which gave me the opportunity to study in the university and gave me today's knowledge.