【正文】 I 摘 要 網(wǎng)上書店系統(tǒng) 是一個(gè)基于 技術(shù)和 SQL Server 數(shù)據(jù)庫 開發(fā)的系統(tǒng)。本論文首先介紹了網(wǎng)上書店系統(tǒng)開發(fā)的背景，然后詳細(xì)描述了系統(tǒng)分析和數(shù)據(jù)庫設(shè)計(jì)，最后又詳細(xì)介紹了網(wǎng)上書店系統(tǒng)的模塊設(shè)計(jì)與實(shí)現(xiàn)。 通過本系統(tǒng)管理員可以通過 Web 瀏覽器進(jìn)入后臺(tái)，實(shí)現(xiàn)網(wǎng)上圖書添加、刪除、圖書分類管理及定單管理、用戶管理等功能和用戶登錄、注冊(cè)，在站內(nèi)進(jìn)行搜索等功能。系統(tǒng)運(yùn)行后，操作界面簡(jiǎn)單流暢，實(shí)用性強(qiáng)。 關(guān)鍵詞： 網(wǎng)上書店；數(shù)據(jù)庫； ABSTRACT Online bookstore system is a based on ASP technology and SQL Server database development system. This paper firstly introduces the background of the development of online bookstore system, then describes the detailed system analysis and database design, then introduced the module of online bookstore system design and implementation. Through the system administrator can through the Web browser into the background, the realization of online books add, delete, book classification management and order management, customer management function and user login, registered, standing in within the search, and other functions. After the operation of the system, operation interface is simple and fluent, the function is strong. Key words:Online bookstore。Database。 II 目 錄 1 緒論 ......................................................... 1 課題背景 ......................................................................................................... 1 開發(fā)目標(biāo) ......................................................................................................... 1 2 系統(tǒng)分析 ..................................................... 2 需求分析 ......................................................................................................... 2 可行性分析 ..................................................................................................... 2 需求可行性 .................................................................................................. 2 技術(shù)可行性 .................................................................................................. 2 3 總體設(shè)計(jì) ..................................................... 4 設(shè)計(jì)方案 ......................................................................................................... 4 數(shù)據(jù)庫設(shè)計(jì) ..................................................................................................... 4 數(shù)據(jù)庫概念設(shè)計(jì) .......................................................................................... 4 數(shù)據(jù)庫 ER圖 ............................................................................................... 5 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計(jì) .................................................................................. 5 ........................................................................................................... 7 4 實(shí)現(xiàn)數(shù)據(jù)庫訪問層 ............................................ 10 一般數(shù)據(jù)庫操 作的封裝 ................................................................................10 ......................................................................................12 5 詳細(xì)設(shè)計(jì)與實(shí)現(xiàn) .............................................. 13 用戶管理模塊 ................................................................................................13 用戶注冊(cè) .....................................................................................................13 用戶登錄 .....................................................................................................14 找回丟失密碼 .............................................................................................15 修改個(gè)人信息 .............................................................................................16 圖書管理模塊 ................................................................................................17 管理圖書類別 .............................................................................................18 添加、刪除、修改圖書信息 ......................................................................19 列表顯示圖書 .............................................................................................20 搜索圖書 .....................................................................................................20 購物車管理模塊 ............................................................................................22 查看購物列表 .............................................................................................22 結(jié)賬 ............................................................................................................23 訂單管理模塊 ................................................................................................24 客戶訂單管理 .............................................................................................24 管理員訂單管理 .........................................................................................25 后臺(tái)管理模塊 ................................................................................................27