市场资源挖掘管理系统

摘 要

随着全国经济的高速发展，市场在高速的发展，市场资源也在变的庞大,市场资源管理工作量就相当大而且工作也非常繁杂。但是一直以来企业都是靠人工的方式管理等级市场资源相关的信息，这种传统的市场资源客户查询方式一般要经过缓慢的人工查找过程，随着客户数量的增加，管理人员查询的工作量将会越来越大。这样的管理方式也存在着许多缺点，如：工作效率低、统计容易出错。同时,一方面时间一长，将产生大量的文件和数据，这对于查找、更新和维护都带来了不少的困难。另一方面，也不利于客户获得相关市场资源市场信息。

本系统前台主要使用JSP作为开发语言，后台使用MYSQL作为数据库管理系统，开发环境是MyEclipse，服务器采用tomcat，开发出的一个基于Web技术的B/S结构的市场资源挖掘管理系统。市场资源挖掘管理系统是将IT技术用于客户资源信息的管理, 它能够收集与存储客户的档案信息，提供更新与检索客户资源信息档案的接口；提高工作效率。系统采用JSP为编程语言。论文主要介绍了本课题的开发背景，所要完成的功能和开发的过程。重点的说明了系统设计的重点、设计思想、难点技术和解决方案。

关键字 客户资源、JSP、MYSQL、MyEclipse

I

市场资源挖掘管理系统

Abstract

With the promotion of comprehensive national English four levels of tests, each year our college students to participate in the two English four level of test, the number of exams is huge, examination management workload is very large and the work is also very complicated. But since the school is to rely on manual management of information grade examination related, artificial search process of examination results query the traditional way in general to go through the slow, with the increasing number of candidates, management staff query workload will be more and more. This management way also has many shortcomings, such as: low efficiency, the statistical error prone. At the same time, on the one hand, the time is long, will produce the massive documents and the data, this regarding the search, the renewal and the maintenance has all brought many difficulties. On the other hand, is not conducive to the students to obtain information related to the exam results.

The front of the system using JSP as the development language, the background using MYSQL as the database management system, the development environment is MyEclipse, the server using tomcat, developed a Web technology based on B/S structure of the English 4 level of test performance management system. English 4 level of test performance management system is IT technology for English 4 level of test scores and information management, it can collect and store the English 4 level of test scores to the file information, provide updates and retrieve English 4 level of test scores to information file interface; improve work efficiency. The system uses JSP is the programming language. The paper mainly introduced this topic development background, to complete the process of function and development to. Key explanation system design key, design thought, difficult technology and solutions.

Key Words： Customer resources, JSP, MYSQL, MyEclipse

II

市场资源挖掘管理系统

目 录

摘 要 .......................................................................................................................................... I Abstract ...................................................................................................................................... II 绪 论 ......................................................................................................................................... 1 1 系统概述与工具的选择 .................................................................................................... 2

1.1 B／S结构介绍 ......................................................................................................... 2 1.3 MyEclipse介绍 ......................................................................................................... 2 1.3 JavaScrip语言 ........................................................................................................... 3 1.4 JSP技术 ........................................................................................................................ 3 2 系统的分析与设计 ............................................................................................................. 5

2.1 开发环境 .................................................................................................................... 5 2.2 需求分析 .................................................................................................................... 5 2.3 可行性分析 ............................................................................................................... 6 2.4 系统用例图 ............................................................................................................... 8

2.4.1 客户信息管理................................................................................................... 8 2.4.2 商品信息管理................................................................................................... 8 2.4.3 销售信息管理................................................................................................... 9 2.5 系统功能分析 ......................................................................................................... 10 2.6 数据库结构设计 ..................................................................................................... 11

2.6.1 数据表概要说明 .......................................................................................... 11 2.6.2 主要数据表的结构 ...................................................................................... 12

3 系统的详细设计 ............................................................................................................... 17

3.1 功能模块介绍 ......................................................................................................... 17 3.2 详细设计介绍 ........................................................................................................... 17

3.2.1 管理员登录 ..................................................................................................... 17 3.2.2 客户信息管理................................................................................................. 20 3.2.3 服务模块 ......................................................................................................... 25 3.2.4商品管理系统模块 ......................................................................................... 27 3.2.5修改个人密码 .................................................................................................. 28 3.2.6退出后台管理模块 ......................................................................................... 28 3.2.7合同管理模块 .................................................................................................. 28

I

市场资源挖掘管理系统

3.2.8商品价格分布模块 ......................................................................................... 29

4 系统测试 ............................................................................................................................ 29

4.1 测试方法 .................................................................................................................. 30 4.2 系统测试结果 ......................................................................................................... 30 总结 ............................................................................................................................................ 31 参考文献 ................................................................................................................................... 32

II