【正文】 SelectionParagraphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPointselectionParagraaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesTSelectionParbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbagraphFoLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPointse11111111111111111111111111111111lectionParagraphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPoctionParagraphFormatLineSpaci2222222222222222222222ngLinesToPoints2SelectionParagraphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPointselectionParagraphFccccccccccccccccccccccccccccccccccccccccccccccccccccccccormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPoctionParagraSelec SelectionParagraphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPointselectionParagraaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesTSelectionParbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbagraphFoLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPointse11111111111111111111111111111111lectionParagraphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPoctionParagraphFormatLineSpaci2222222222222222222222ngLinesToPoints2SelectionParagraphFormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPointselectionParagraphFccccccccccccccccccccccccccccccccccccccccccccccccccccccccormatLineSpacingLinesToPointsSelectionParagraphFormatLineSpacingLinesToPoctionParagraSelec 學(xué) 號(hào) 14062402169 畢業(yè)設(shè)計(jì)（論文 ） 題目： 基于網(wǎng)絡(luò)的同學(xué)錄設(shè)計(jì)與 實(shí)現(xiàn) 作 者 左 金 龍 屆 別 2020屆 院 別 計(jì)算機(jī) 學(xué)院 專(zhuān) 業(yè) 計(jì)算機(jī)科學(xué)與技術(shù) 指導(dǎo)老師 胡 娟 職 稱(chēng) 講 師 完成時(shí)間 2020年 5 月 15日 畢業(yè)設(shè)計(jì) (論文 ) I 摘 要 校友錄 是為 了 方便校友之間聯(lián)系 而使用的 一種系統(tǒng)。 校友錄，又叫同學(xué)錄，也是校友錄網(wǎng)站的簡(jiǎn)稱(chēng)。本論文開(kāi)頭論述了同學(xué)錄系統(tǒng)的產(chǎn)生，現(xiàn)狀和發(fā)展，以及 技術(shù)和SQL Server2020 數(shù)據(jù)庫(kù)管理系統(tǒng)的概況。主要介紹了一個(gè)同學(xué)錄系統(tǒng)的實(shí)現(xiàn)過(guò)程：主要包括系統(tǒng)的需求分析、 系統(tǒng)設(shè)計(jì)、以及主要模塊的詳細(xì)設(shè)計(jì)。主要模塊的詳細(xì)設(shè)計(jì)主要包括：用戶注冊(cè)和登陸模塊、用戶管理模塊、留言模塊、照片模塊、查詢模塊、站點(diǎn)訪問(wèn)模塊、班級(jí)排行榜等等。 本課題是基于 Windows XP 環(huán)境的數(shù)據(jù)庫(kù)管理，后臺(tái)數(shù)據(jù)庫(kù)采用 SQLServer2020，前臺(tái)使用 進(jìn)行開(kāi)發(fā) ,并通過(guò) IIS 進(jìn)行發(fā)布，屬于 WEB 數(shù)據(jù)庫(kù)開(kāi)發(fā)、用于解決實(shí)際問(wèn)題的實(shí)例，具有一定的深度，涉及到數(shù)據(jù)庫(kù)設(shè)計(jì)和前端開(kāi)發(fā)工具的開(kāi)發(fā)和設(shè)計(jì)，與之相似的應(yīng)用很廣泛。 關(guān)鍵詞： ； C； SQLServer2020； 瀏覽器 /服務(wù)器 ； 同學(xué)錄 畢業(yè)設(shè)計(jì) (論文 ) II ABSTRACT The alumnus record is in order to facilitate one kind of system which between the alumnus relates uses. The alumnus records, also is called the schoolmate to record, also is the alumnus records the website the abbreviation. The present paper opening elaborated the schoolmate to record the system the production, the present situation and the development, as well as technology and SQL Server2020 database management system survey. Mainly introduced a schoolmate records the system the realization process: Mainly includes the system the demand analysis, the system design, as well as the main module detailed design. The main module detailed design mainly includes: The user registers and lands the module, the user administration module, the message module, the picture module, the inquiry module, the stand visit module, the class and grade order list and so on 。 This subject is data base administration based on Windows XP environment, backstage supporter39。s database adopts SQLServer2020 the front uses to develop, and release through IIS, is WEB database development , instance used for solving the practical problem, have certain depth , involve database design and development and design of the front developing instrument, the application similar to it is very extensive. Keywords: ， C， SQLServer2020, Browse/Server, Alumni 畢業(yè)設(shè)計(jì) (論文 ) III 目 錄 摘 要 .................................................... I ABSTRACT ................................................... II 目 錄 ..................................................... III 1 緒論 ...................................................... 1 ............................................... 1 .......................................... 1 前景及趨勢(shì) .................................. 2 .................................. 3 .................................... 4 2 系統(tǒng)需求分析 .............................................. 5 ............................................. 5 數(shù)據(jù)流分析 ............................................. 5 數(shù)據(jù)字典 ............................................... 8 3 系統(tǒng)設(shè)計(jì) ................................................. 10 ....................................... 10 ....................................... 11 ................................. 14 4 用戶模塊設(shè)計(jì) .............................................. 18 ................................. 18 ............................... 25 ....................................... 37 ....................................... 39 5 其它功能模塊的設(shè)計(jì) ........................................ 42 ......................................... 42 ..................................... 43 .................. 43 6 用戶手冊(cè) .................................................. 44 ........................................... 44 ........................................... 44 ..................................... 45 7 結(jié)束語(yǔ) ................................................... 46 畢業(yè)設(shè)計(jì) (論文 ) IV 致 謝 ..................................................... 47 參考文獻(xiàn) ................................................... 48 附錄 (部分 )源代碼 .........