基于ASP的個人網(wǎng)站設(shè)計
——后臺數(shù)據(jù)庫設(shè)計
摘 要
現(xiàn)代社會是一個信息化的社會，人們對信息的需求越來越大，對信息的傳遞速度要求越來越快，在Internet飛速發(fā)展的今天,互聯(lián)網(wǎng)成為人們快速獲取、發(fā)布和傳遞信息的重要渠道,它及時.迅捷的給人們提供了所需要的信息，各種網(wǎng)站便是這信息傳播的樞紐，大量的信息，大批量的訪客對網(wǎng)站的管理都是一種挑戰(zhàn)，而實現(xiàn)這一管理的就是數(shù)據(jù)庫的操作，由此可見數(shù)據(jù)庫的完善與否直接影響著網(wǎng)站的穩(wěn)定性。
網(wǎng)站數(shù)據(jù)庫的規(guī)劃設(shè)計以及網(wǎng)站的頁面開發(fā)，都是對應(yīng)網(wǎng)站所要實現(xiàn)的功能而進行開發(fā)設(shè)計的，我將通過各種網(wǎng)頁制作以及數(shù)據(jù)庫設(shè)計工具制作出能達預(yù)期效果的數(shù)據(jù)管理系統(tǒng)以及網(wǎng)站頁面，使網(wǎng)站管理人員更加快捷的，準確的對網(wǎng)站做出正確的維護和更新；使美觀網(wǎng)站成為我們與外界溝通和交流的平臺，讓更多的人了解自己，在以后的社會競爭中能起到自我推薦的作用。
關(guān)鍵詞：數(shù)據(jù)庫,管理,網(wǎng)站


Design According to ASP Personal State Website
——The Design of Backstage Database
ABSTRACT
Modern society is an information-based society, people's growing demand for information on the transmission of information required in an increasingly fast pace, the rapid development in the Internet today, the rapid acquisition of a people, an important channel for information dissemination and communication, it timely. Respect for the people with the required information, This website is the dissemination of information hub, a lot of information, the bulk of visitors to the web site management is a challenge, and the management is to achieve the operational database, the database can improve or not directly affecting the stability of the website.
Website and database design website page development, the corresponding website is to be achieved for the development of functional design, and I will, through various web design tools and databases produced the expected results can be achieved in data management systems and web site pages to the website managers more efficient, to make a correct and accurate web site maintenance and updating; website for aesthetic communication and exchange with the outside world become our platform so as to let more people understand themselves and the community at a later competition can play the role of selfrecommendation.
KEY WORDS: database, management, website



目 錄
摘 要 I
ABSTRACT II
1 緒論 1
1.1 引言 1
1.2 設(shè)計思想 2
1.3 設(shè)計預(yù)期效果 2
2 開發(fā)主要技術(shù) 3
2.1 ASP 簡介 3
2.2 ACCESS數(shù)據(jù)庫 5
2.3 DREAMWEAVER 6
2.4 IIS介紹 7
2.5 小結(jié) 9
3 數(shù)據(jù)庫設(shè)計 10
3.1 數(shù)據(jù)庫的概念 10
3.2 數(shù)據(jù)庫的設(shè)計及表單 10
3.3 數(shù)據(jù)庫設(shè)計步驟 13
3.4 數(shù)據(jù)庫的建立及操作 14
3.4.1 創(chuàng)建數(shù)據(jù)庫 14
3.4.2 數(shù)據(jù)庫查尋語言SQL常用命令 17
3.4.3 數(shù)據(jù)庫的連接和讀取記錄 17
3.4.4 數(shù)據(jù)庫的基本操作:寫入記錄 19
3.4.5 數(shù)據(jù)庫的基本操作:查詢記錄 20
3.4.6 數(shù)據(jù)庫的基本操作:刪除記錄 21
3.4.7 數(shù)據(jù)庫的基本操作:修改記錄 23
3.5 數(shù)據(jù)庫的安全隱患及對策 25
3.5.1 Access數(shù)據(jù)庫的安全隱患 25
3.5.2 提高數(shù)據(jù)庫安全性的方法 26
3.6 小結(jié) 27
4 部分實現(xiàn)功能 28
4.1 功能演示 28
4.1.1 后臺管理頁面結(jié)構(gòu) 28
4.1.2 部分功能 30
4.1.3 前臺主頁效果圖 31
4.2 小結(jié) 31
5 網(wǎng)站的現(xiàn)況與展望 33
5.1 網(wǎng)站的現(xiàn)狀 33
5.2 網(wǎng)站日后規(guī)劃 33
致 謝 34
參考文獻 35