【正文】 ................................................ 9 介紹 ............................................................ 9 Eclipse 中安裝 Tomcat............................................ 10 MySQL..................................................................................................................... 12 介紹 ........................................................... 12 特點(diǎn) ........................................................... 13 SQLyog ................................................................................................................... 14 介紹 ........................................................... 14 基本功能 ....................................................... 14 3．需求分析 .......................................................................................................................... 15 系統(tǒng)目標(biāo) ............................................................................................................... 16 系統(tǒng)的功能要求 .................................................................................................... 16 系統(tǒng)的性能需求 .................................................................................................... 16 系統(tǒng)的數(shù)據(jù)需求 .................................................................................................... 17 系統(tǒng)的數(shù)據(jù)需求 .................................................................................................... 17 人力、資源及時(shí)間的約束 ......................................... 17 技術(shù)發(fā)展規(guī)律的約束 ............................................. 17 4．?dāng)?shù)據(jù)庫(kù)設(shè)計(jì) ...................................................................................................................... 18 創(chuàng)建數(shù)據(jù)庫(kù) ............................................................................................................ 18 創(chuàng)建表 ................................................................................................................... 19 博客網(wǎng)站表 (blogger_website) ..................................... 19 用戶表 (blogger_user) ............................................ 20 博文表 (blogger_blog) ............................................ 21 文件表 (blogger_upload) .......................................... 22 評(píng)價(jià)留言表 (blogger_ly) .......................................... 23 標(biāo)簽表 (blogger_tag) ............................................. 24 博文標(biāo)簽關(guān)聯(lián)表 (blogger_blog_tag) ................................ 25 博文 分類表 (blogger_clazz) ....................................... 26 用戶博客關(guān)于表 (blogger_about) ................................... 27 友情鏈接表 (blogger_link) ....................................... 28 第 IV 頁 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 裝 ┊ ┊ ┊ ┊ ┊ 訂 ┊ ┊ ┊ ┊ ┊ 線 ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ ┊ 友鏈類型表 (blogger_link_clazz) ................................. 29 5．概要設(shè)計(jì) .......................................................................................................................... 29 系統(tǒng)體系結(jié)構(gòu) ........................................................................................................ 30 主要功能設(shè)計(jì) ........................................................................................................ 30 主要功能模塊 .................................................... 30 系統(tǒng)模塊介紹 .................................................... 31 信息安全設(shè)置 ........................................................................................................ 32 網(wǎng)絡(luò)安全 ........................................................ 32 其他安全 ........................................................ 33 6．詳細(xì)設(shè)計(jì) .......................................................................................................................... 33 數(shù)據(jù)庫(kù)連接 ............................................................................................................ 33 登陸注冊(cè)模塊的具體實(shí)現(xiàn) .................................................................................... 35 ......................................................... 35 ......................................................... 37 驗(yàn)證碼實(shí)現(xiàn) ...................................................... 38 分頁技術(shù)的實(shí)現(xiàn) .................................................................................................... 39 前端導(dǎo)航的實(shí)現(xiàn) .................................................................................................... 40 搜索功能的實(shí)現(xiàn) ................................................................................................... 41 搜索功能的實(shí)現(xiàn) .................................................. 41 亂碼的解決方法 .................................................. 41 搜索結(jié)果關(guān)鍵詞加背景的實(shí)現(xiàn) ...................................... 42 隨機(jī)博客的實(shí)現(xiàn) ................................................................................................... 43 評(píng)價(jià)留言的實(shí) 現(xiàn) ................................................................................................... 44 用戶管理博文的實(shí)現(xiàn) ............................................................................................ 45 用戶個(gè)人信息設(shè)置 ............................................................................................... 47 超級(jí)用戶管理用戶的實(shí)現(xiàn) ................................................................................. 48 7．系統(tǒng)測(cè)試 .......................................................................................................................... 49 測(cè)試目的 ................................................................................................................. 50 測(cè)試方法 ................................................................................................................. 50 測(cè)試實(shí)例 ................................................................................................................. 50 注冊(cè)測(cè)試 ........................................................ 50 登陸測(cè)