【正文】 import 。 } private SQLCode() { _load()。 } } 文件（ sql 語句的存放位置 ） /******************************* **********************************/ 基礎(chǔ)信息維護(hù) 對區(qū)域信息表的操作 (tb_Client_qyxx) 查詢的操作 — =select * from tb_Client_qyxx 插入的操作 — =insert into tb_Client_qyxx values(39。 由于查詢的語句不是一條，是一個(gè)集合所以最后需要?jiǎng)?chuàng)建結(jié)果集，最后使用上一步 的 statement 對象執(zhí)行 executeQuery 方法獲得數(shù)據(jù)。 public class DBConn { static{ try{ ()。 表 411 tb_bdwxx 的結(jié)構(gòu) 字段名 數(shù)據(jù)類型 長度 是否主鍵 描述 bdwxx_mc nvarchar 50 單位名稱 bdwxx_lxdz nvarchar 50 聯(lián)系地址 bdwxx_yb nvarchar 50 郵政編碼 bdwxx_cz nvarchar 50 傳真 bdwxx_frdb nvarchar 50 法人代表 bdwxx_lxdh nvarchar 50 聯(lián)系電話 bdwxx_khyh nvarchar 50 開戶銀行 bdwxx_yhzh nvarchar 50 銀行賬號(hào) bdwxx_wz nvarchar 50 網(wǎng)址 bdwxx_nsh nvarchar 50 納稅號(hào) （ 12） tb_Client_cpxs（產(chǎn)品銷售表） 產(chǎn)品銷售表用來保存產(chǎn)品銷售信息。 表 43 tb_Client_qylx 的結(jié)構(gòu) 字段名 數(shù)據(jù)類型 長度 是否主鍵 描述 qylx_id varchar 30 企業(yè)類型編號(hào) qylx_lxmc varchar 50 類型名稱 qylx_bz text 16 備注信息 id int 4 數(shù)據(jù)庫流水號(hào) （ 4） tb_Client_qyzx（企業(yè)資信信息表） 企業(yè)資信信息表 主要用來保存客戶的企業(yè)資信信息。 SQL Server 在網(wǎng)絡(luò)組件的頂部添加了服務(wù)器特有的中介組件，諸如開放式數(shù)據(jù)庫連接 (ODBC)后能使不同客戶機(jī)進(jìn)行相互連接 ,它可處理基于 Inter 的應(yīng)用程序 ,幫助用戶把 SQL Server 數(shù)據(jù)庫信息集成到 Web 頁面。 此系統(tǒng)界面設(shè)計(jì)清晰，操作簡潔，有完善的異常處理機(jī)制，用戶只要經(jīng)過簡單的了解就可使用，因此在使用方面簡單易懂 ,容易操作 ,完全可行。 11．系統(tǒng) 運(yùn)行穩(wěn)定、安全可靠。 4． J2EE 平臺(tái)簡介 ： 目前， Java 2 平臺(tái)有 3 個(gè)版本，它們是適用于小型設(shè)備和智能卡的 Java 2 平臺(tái) Micro 版（ Java 2 Platform Micro Edition， J2ME）、適用于桌面系統(tǒng)的 Java 2 平臺(tái)標(biāo)準(zhǔn)版（ Java 2 Platform Standard Edition， J2SE）、適用于創(chuàng)建服務(wù)器應(yīng)用程序和服務(wù)的 Java 2 平臺(tái)企業(yè)版（ Java 2 Platform Enterprise Edition， J2EE）。 Tomcat 很受廣大程序員的喜歡，因?yàn)樗\(yùn)行時(shí)占用的系統(tǒng)資源小，擴(kuò)展性好，支持負(fù)載平衡與郵件服務(wù)等開發(fā)應(yīng)用系統(tǒng)常用的功能；而且它還在不斷的改進(jìn)和完善中，任何一個(gè)感興趣的程序員都可以更改它或在其中加入新的功能。這些優(yōu)點(diǎn)能夠極大地提高客戶信息管理的效率 ,也是一個(gè)單位的科學(xué)化、正規(guī)化管理 ,與世界接軌的重要條件。s many environmental factor, enterprise when processing with exterior customer relations, more and more felt to does not have the information technology support the customer relations management to lack the ability to do what one would like, on the the customer management system management system arises at the historic moment. Customer management system management system to enterprise service flow reanization conformity user information resources, in order to the effective method manages the customer relations, in enterprise interior realization information and resources sharing. The customer management system management system by helps the enterprise in the system design the manager personnel management department to enhance the working efficiency, the realization enterprise customer information management as well as the management systematization, the standardization and automatically changes into the final goal. Therefore, the use work management, causes the enterprise to enhance the efficiency, to develop the market and the retention customer three aspects improves greatly, regarding the promotion petition superiority, has the significant significance. This article introduced the customer management system management system realization method. The goal lies in lets everybody sharing study and utilize this language the experience and the harvest. This system is Inter/Under Intra environment to electronic merce customer relations management, through business management technology, electronic merce and information technology high integration,Discussed the customer mana gement system management system system skeleton, the system work way and the database design significance. Through the database, the data pool, the JSP code, carries on to the customer management system management system realization, and carries on the forecast to the customer management system management system development. The customer management system including basic information maintenance, customer information maintenance, customer service , information inquiry, customer manages and so on several big modules. Key word: customer relations management JSP the database management system 目 錄 第一章 系統(tǒng)概述 .................................................................................................................... 1 課題來源及意義 .................................................................................................................. 1 國內(nèi)外發(fā)展?fàn)顩r .................................................................................................................. 1 系統(tǒng)開發(fā)環(huán)境及技術(shù)介紹 .................................................................................................. 2 第二章 系統(tǒng)設(shè)計(jì)分析 ............................................................................................................ 5 研究目標(biāo)與內(nèi)容 .................................................................................................................. 5 研究目標(biāo) ........................................................................................................................... 5 研究內(nèi)容 ........................................................................................................................... 5 可行性分析 .......................................................................................................................... 6 第三章 系統(tǒng)總體設(shè)計(jì) ............................................................................................................ 7 系統(tǒng)功能模塊劃分 .............................................................................................................. 7 系統(tǒng)主要功能結(jié)構(gòu) .............................................................................................................. 8 處理流程設(shè)計(jì) ...................................................................................................................... 9 第四章 數(shù)據(jù)庫設(shè)計(jì) .............................................................................................................. 10 SQL SERVER 2020 數(shù)據(jù)庫 .................................................................................................. 10 需求分析 ....................