【正文】 的進(jìn)入不同的聊天室。 綜上所述，本聊天室主要實現(xiàn)了以下的功能： (1) 提供支持用戶注冊、登錄以及身份驗證的 WEB 界面和實現(xiàn)后臺對應(yīng)功能的模塊。管理員除 了具有普通用戶的功能外，還可以對在線用戶和所有數(shù)據(jù)庫中的用戶進(jìn)行 管理 ，以便對聊天室進(jìn)行維護(hù)。聊天2 室必須不斷的創(chuàng)新才有好的發(fā)展途徑 [1]。這是目前其他媒體所不能提供的。因此，對于青少年聚集的網(wǎng)上聊天室，網(wǎng)絡(luò)公司自然沒有太高的熱情?；ヂ?lián)網(wǎng)傳播的東西應(yīng)該是健康的東西。網(wǎng)絡(luò)聊天室 給人們的學(xué)習(xí)和生活帶來極大的便利。s learning and the convenience of a great life. The system uses JSP as the development tools, backend database using SQL Server 2020 database design, use of JDBCODBCbased database access technology for database management operations, the realization of the chat room chat online chat function and shows features such as user information. KEYWORDS： chatroom； database access technology ODBC； SQL Server 2020 III 目錄 摘要 .................................................................................................................................I ABSTRACT .................................................................................................................. II 第 1章 緒論 .................................................................................................................. 1 背景 ................................................................................................................. 1 研究內(nèi)容 ......................................................................................................... 2 第 2章 系統(tǒng)開發(fā)環(huán)境 .................................................................................................. 3 系統(tǒng)環(huán)境 .......................................................................................................... 3 開發(fā)工具介紹 .................................................................................................. 3 Myclipse 介紹 ....................................................................................... 3 Dreamweaver8 ...................................................................................... 4 SQL Server 2020 介紹 .......................................................................... 4 系統(tǒng)開發(fā)技術(shù)介紹 ......................................................................................... 5 JSP 技術(shù) ................................................................................................ 5 JavaBean組件技術(shù) .............................................................................. 5 數(shù)據(jù)庫訪問技術(shù)分析 ........................................................................... 6 Servlet 技術(shù) .......................................................................................... 7 SQL語句簡介 ...................................................................................... 7 第 3章 數(shù)據(jù)庫設(shè)計 ...................................................................................................... 9 需求分析 ......................................................................................................... 9 概念結(jié)構(gòu)設(shè)計 ................................................................................................. 9 概念模型 .............................................................................................. 9 數(shù)據(jù)流圖 ............................................................................................ 10 數(shù)據(jù)字典 ............................................................................................ 11 邏輯結(jié)構(gòu)設(shè)計 ............................................................................................... 12 數(shù)據(jù)模型 ............................................................................................ 12 模塊結(jié)構(gòu) ............................................................................................ 12 數(shù)據(jù)庫安全性和完整性 ............................................................................... 14 數(shù)據(jù)庫的安全性 ................................................................................ 14 數(shù)據(jù)完整性 ........................................................................................ 14 IV 第 4章 系統(tǒng)設(shè)計與實現(xiàn) ............................................................................................ 16 數(shù)據(jù)庫通用管理模塊 ................................................................................... 16 用戶登錄和注冊模塊 .................................................................................... 19 登錄界面 ............................................................................................. 19 登錄信息后臺處理頁面 ..................................................................... 20 封裝功能的 JavaBean ........................................................................ 21 聊天室模塊 .................................................................................................... 23 聊天房間選擇頁面 ............................................................................. 23 封裝選擇聊天室的 JavaBean組建 ................................................... 24 聊天界面 ........................................................................................................ 27 用戶發(fā)送消息頁面 ............................................................................. 27 在線用戶列表模塊 ............................................................................. 29 聊天信息顯示頁面 ............................................................................. 30 封裝聊天功能的 JavaBean組件 ....................................................... 31 管理員功能模塊 ............................................................................................ 34 第 5章 系統(tǒng)的測試和維護(hù) ........................................................................................ 36 前臺用戶登錄測試結(jié)果 ................................................................................ 36 前臺信息發(fā)送模塊測試結(jié)果 ........................................................................ 36 后臺管理員管理用戶模塊測試結(jié)果 ............................................................ 36 第 6章 結(jié)論 ................................................................................................................ 38 致謝 ................................................................................................................