基于BS結(jié)構(gòu)的二手交易系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)

1、二手交易系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)摘 要隨著當(dāng)今社會信息技術(shù)的進(jìn)步，基于互聯(lián)網(wǎng)的各種應(yīng)用日益受到了人們的重視，二手商品的重新利用也逐漸被人們關(guān)注，二手交易系統(tǒng)就在這種形勢下產(chǎn)生了，它利用網(wǎng)絡(luò)，改變了人們的購物方式。本文是基于現(xiàn)代二手交易的流程，結(jié)合現(xiàn)代的信息技術(shù)，通過對系統(tǒng)的結(jié)構(gòu)設(shè)計(jì)、后臺設(shè)計(jì)、前端開發(fā)，構(gòu)建了一個基于B/S結(jié)構(gòu)的，以ASP為開發(fā)平臺和SQL server 2000為數(shù)據(jù)庫的二手交易系統(tǒng)。本系統(tǒng)基本實(shí)現(xiàn)了二手交易信息的發(fā)布與管理等功能。關(guān)鍵字： B/S結(jié)構(gòu)；數(shù)據(jù)庫；二手交易The Design and Implementation of Secondary Trading SystemA

2、bstractWith the rapid development of the Internet, people depend more and more on Internet-based applications. And people pay more attention to the reuse of the second-hand goods gradually. Online secondary trading system thus comes into peoples sight. With the help of the internet, it changes the s

3、hopping ways of people.This paper is based on the flow of secondary trading, and combined with the modern information technology; moreover, following the process of development, structure design, background design, and foreground design. It tries to establish a secondary trading system based on B/S,

4、 ASP and SQL Server 2000. This system implements the general functions of secondary trading informations publication, management and so on.Key words: Database；B/S；Online Secondary Trading 目 錄論文總頁數(shù)：18頁1引言12理論基礎(chǔ)及開發(fā)工具介紹12.1ASP介紹12.2SQL Server 2000 數(shù)據(jù)庫的介紹22.3B/S結(jié)構(gòu)22.4開發(fā)工具介紹33系統(tǒng)需求分析33.1普通用戶33.2管理員43.3系統(tǒng)功

5、能模塊分析44系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)54.1數(shù)據(jù)庫設(shè)計(jì)54.2數(shù)據(jù)庫關(guān)系模型設(shè)計(jì)54.3數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計(jì)74.4數(shù)據(jù)庫表的實(shí)現(xiàn)84.5系統(tǒng)功能實(shí)現(xiàn)84.5.1信息發(fā)布-瀏覽信息84.5.2信息發(fā)布-添加信息94.5.3信息發(fā)布-搜索信息104.5.4信息管理-管理員身份驗(yàn)證124.5.5信息管理-交易信息管理124.5.6信息管理-項(xiàng)目管理134.5.7信息管理-公告管理134.5.8信息管理-鏈接管理145系統(tǒng)測試145.1 測試環(huán)境145.2 測試結(jié)果155.3 系統(tǒng)安全性測試15結(jié) 論15參考文獻(xiàn)16致 謝17聲 明181.1 系統(tǒng)功能模塊分析對上述各項(xiàng)功能進(jìn)行集中、分塊，按照結(jié)構(gòu)化程序設(shè)計(jì)的要

6、求，得到如圖2所示的系統(tǒng)功能模塊圖。圖2 系統(tǒng)功能模塊示意圖二手交易系統(tǒng)信息發(fā)布信息管理瀏覽信息添加信息搜索信息身份驗(yàn)證信息管理公告管理鏈接管理項(xiàng)目管理參考文獻(xiàn)1 王國榮，朱琳杰，王偉.ASP與WEB數(shù)據(jù)庫M.北京：人民郵電出版社，2003。2 貝尼納索.霍夫曼美，楊浩.ASP WEB站點(diǎn)高級編程M.北京：清華大學(xué)出版社，2003。3 MATTHEW美，MACDONALD美，賈小軍，于秀山，呂嘉章等.ASP.NET完全手冊M.北京：電子工業(yè)出版社，2004。4 陳峰棋，資訊教育小組.ASP與SQL網(wǎng)站數(shù)據(jù)庫程序設(shè)計(jì)M.北京：科學(xué)出版社，2005。5 莊永龍.Instant ASP實(shí)例解析與AS

7、P網(wǎng)站編程M .北京：北京希望電子出版社，2004。6 陳嫻，劉開文，李健.ASP.NET項(xiàng)目開發(fā)實(shí)踐M.北京：中國鐵道出版社，2003。7 馬嘉.精通ASP 3.0網(wǎng)絡(luò)編程M.北京：人民郵電出版社出版，2004。tgKQcWA3PtGZ7R4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGshLs50cLmTWN60eo8Wgqv7XAv2OHUm32WGeaUwYDIAWGMeR4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGZ7R4I30kA1DkaGtgKQcWA3PtGZ7R4I30

8、kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGshLs50cLmTWN60eo8Wgqv7XAv2OHUm32WGeaUwYDIAWGMeR4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGZ7R4I30kA1DkaGtgKQcWA3PtGZ7R4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGshLs50cLmTWN60eo8Wgqv7XAv2OHUm32WGeaUwYDIAWGeR4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2

9、CHhI92tgKQcWA3PtGZ7R4I30kA1DkaGtgKQcWA3PtGZ7R4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGshLs50cLmTWN60eo8Wgqv7XAv2OHUm32WGeaUwYDIAWGMeR4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGZ7R4I30kA1DkaGtgKQcWA3PtGZ7R4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGshLs50cLmTWN60eo8Wgqv7XAv2OHUm32WGeaUwYDIAWGMeR4I30kA1DkaGhn3XtKknBYCUDxqA7FHYi2CHhI92tgKQcWA3PtGZ7R4I30kA1DkaGtgKQcWA3PtGZ7R4I30kA1DkaGhn3