【正文】 西北民族大學(xué)電氣工程學(xué)院學(xué)士論文 1 基于 WEB 的客戶(hù) 信息 管理系統(tǒng)的實(shí)現(xiàn) 摘 要 客戶(hù)關(guān)系管理 (Customer Relationship Management， CRM)系統(tǒng)是計(jì)算機(jī)技術(shù)和現(xiàn)代管理理論結(jié)合的產(chǎn)物?？蛻?hù)信息管理系統(tǒng)以客戶(hù)為中心，將企業(yè)的市場(chǎng)、銷(xiāo)售和服務(wù)等有機(jī)地結(jié)合起來(lái)，形成跨部門(mén)的統(tǒng)一業(yè)務(wù)管理平臺(tái)。使企業(yè)能快速響應(yīng)用戶(hù) 需求，在市場(chǎng)競(jìng)爭(zhēng)中贏得更多的客戶(hù)和商機(jī)。 本文是基于 WEB+JSP＋ Tomcat ＋ SQL server2021 編程 調(diào)試平臺(tái) 設(shè)計(jì)和實(shí)現(xiàn) 的 一個(gè) Web客戶(hù)管理系統(tǒng)。文中主要介紹如何使用 URL 作為建模語(yǔ)言和 分析設(shè)計(jì)工具，完成基于 WEB 的客戶(hù) 管理系統(tǒng)的需求分析、詳細(xì)設(shè)計(jì)和總體 實(shí)現(xiàn)。 我在設(shè)計(jì)系統(tǒng)過(guò)程中，把模塊按用戶(hù)的等級(jí)（管理員，前臺(tái)職員和用戶(hù) ）分別設(shè)計(jì)了相應(yīng)的功能。該網(wǎng)站采用 JSP 應(yīng)用開(kāi)發(fā)技術(shù)，具有一些添加信息，刪除 等功能，尤其依靠 java 的優(yōu)點(diǎn)來(lái)為 酒店更好的進(jìn)行管理。 數(shù)據(jù)庫(kù)采用的 是 SQL server2021，在數(shù)據(jù)庫(kù)的利用上該系統(tǒng)用了簡(jiǎn)單的Hibernate 和 JDBC 作為和數(shù)據(jù)庫(kù)進(jìn)行數(shù)據(jù)交互的方式。 關(guān)鍵字： WEB,CRM,SQL server2021 ABSTRACT Customer Relationship Management (CRM) Relationship Management, however system is the puter technology and modern Management theory union product. Customer information management system to the customer as the center, will the enterprise market, sales and service anically, forming crossdepartment unified business management platform. Make the enterprise can 西北民族大學(xué)電氣工程學(xué)院學(xué)士論文 2 quickly respond to user needs, in market petition to win more customers and business opportunities. This paper is based on WEB + JSP + Tomcat + SQL server2021 programming debugging platform design and implementation of a WEB client management system. This paper mainly introduced how to use the URL as modeling language and analysis and design tools, plete the user management system based on WEB, and the detailed design of requirement analysis and the overall implementation. I39。m in the process of design system, according to user39。s rank (module, front desk clerk and user administrator) respectively the corresponding functional design. This website uses JSP application development technology, with some reserve guest rooms, checkout and other functions, especially for the advantages on Java user management. Database uses is SQL server2021, the use of the database on the system used simple hibernate and JDBC as and database data interactive way. Key words: WEB, CRM, , SQL server2021 西北民族大學(xué)電氣工程學(xué)院學(xué)士論文 3 目 錄 第一章 緒論 ................................................................................................................................... 4 ........................................................................................................................... 4 ........................................................................................................................ 4 ........................................................................................................................... 6 ........................................................................................................................... 6 第二章 開(kāi)發(fā)環(huán)境 ............................................................................................................................ 8 開(kāi) 發(fā)平臺(tái) .......................................................................................................................... 8 開(kāi)發(fā)工具 .......................................................................................................................... 8 Tomcat服務(wù)器 ................................................................................................................ 10 第三章 系統(tǒng)分析與設(shè)計(jì) ............................................................................................................... 12 系統(tǒng)設(shè)計(jì)目標(biāo) ................................................................................................................. 12 系統(tǒng)設(shè)計(jì)特點(diǎn) .................................................................................................................. 12 系統(tǒng)需求分析 ................................................................................................................. 13 系統(tǒng)總體結(jié)構(gòu) ....................................................................................................... 14 功能目標(biāo)分析 ....................................................................................................... 14 業(yè)務(wù)流程分析 ....................................................................................................... 15 性能需求分析 ....................................................................................................... 17 系統(tǒng)設(shè)計(jì) ........................................................................................................................ 18 系統(tǒng)總體結(jié)構(gòu)圖 ................................................................................................... 18 系統(tǒng) 流程設(shè)計(jì)圖 ................................................................................................... 18 系統(tǒng) ER圖 .......................................................................................................... 19 本章小結(jié) ........................................................................................................................ 19 第四章 系統(tǒng)實(shí)現(xiàn) .......................................................................................................................... 20 數(shù)據(jù)庫(kù)設(shè)計(jì) ..................................................................................................................... 20 創(chuàng)建數(shù)據(jù)庫(kù)表結(jié)構(gòu) ................................................................................................ 20 創(chuàng)建表 ................................................................................................................. 22 訪(fǎng)問(wèn)數(shù)據(jù)庫(kù)表 ....................................................................................................... 24 系統(tǒng)界面實(shí)現(xiàn) .....................................................................