【正文】 e users with good service. Users in the received set for themselves after the modity can message module in the published message. The system of background database using SQL Server 2020 was established, the application procedure development using the Visual Studio 2020 platform and C language development. It achieved it realizes the trading operation, recording, statistics and other functions. Its characteristic is with friendly interface, simple operation, convenient and quick. Key words： the secondhand website of school backstage database application procedure 序言 ........................................................................................................................................... 6 一、系統(tǒng)規(guī)劃 ............................................................................................................................ 7 （一）選題背景 ..................................................................................................................... 7 （二）需求分析 ..................................................................................................................... 7 （三） 系統(tǒng)設(shè)計相關(guān)原理 ...................................................................................................... 9 技術(shù) ......................................................................................................................... 9 Studio 2020............................................................................................................10 Server 2020...............................................................................................................10 （四）可行性分析 ................................................................................................................11 ....................................................................................................................11 ....................................................................................................................12 ....................................................................................................................12 二、系統(tǒng)分析 ...........................................................................................................................14 （一）、系統(tǒng)業(yè)務(wù)流程分析 ..................................................................................................14 （二） .數(shù)據(jù)流程分析 ...........................................................................................................15 ...........................................................................................................................15 ...........................................................................................................................15 3．系統(tǒng)管理 ......................................................................................................................16 .......................................................................................................................16 .......................................................................................................................17 .......................................................................................................................17 7．購買管理模塊 ..............................................................................................................18 8．搜索功能模塊 ..............................................................................................................18 （三）數(shù)據(jù)字典 ....................................................................................................................18 ...........................................................................................................................18 ............................................................................................................19 .......................................................................................................................20 ................................................................................................................21 ................................................................................................................21 三、系統(tǒng)設(shè)計 ...........................................................................................................................23 （一）系統(tǒng)功能設(shè)計 .............................................................................................................23 （二）數(shù)據(jù)庫設(shè)計 ................................................................................................................26 1．?dāng)?shù)據(jù)庫表及表的關(guān)系 ...................................................................................................26 ...........................................................................................................................27 四、系統(tǒng)實施 ...........................................................................................................................31 （一）會員注冊 ....................................................................................................................31 （二）產(chǎn)品瀏覽 ....................................................................................................................32 （三）購物車 ........................................................................................................................34 （四）管理員登陸 ................................................................................................................35 （五）發(fā)布物品 ....................................................................................................................36 五 系統(tǒng)運行與維護 ..................................................................................................................38 （一）測試的任務(wù)及目標 ..............................................................................................