Java项目：JSP+Servlet实现的CRM客户关系管理系统（源码+数据库脚本）

/* SQLyog Ultimate v13.1.1 (64 bit) MySQL - 5.7.33 : Database - crm ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`crm` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `crm`; /*Table structure for table `customer_care` */ DROP TABLE IF EXISTS `customer_care`; CREATE TABLE `customer_care` ( `care_id` int(10) NOT NULL AUTO_INCREMENT, `customer_id` int(10) DEFAULT NULL, `care_theme` varchar(50) DEFAULT NULL, `care_way` varchar(50) DEFAULT NULL, `care_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `care_remark` varchar(1000) DEFAULT NULL, `care_nexttime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `care_people` varchar(50) DEFAULT NULL, `is_used` varchar(10) DEFAULT '1', PRIMARY KEY (`care_id`), KEY `FK_Reference_15` (`customer_id`), CONSTRAINT `FK_Reference_15` FOREIGN KEY (`customer_id`) REFERENCES `customer_info` (`customer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; /*Data for the table `customer_care` */ insert into `customer_care`(`care_id`,`customer_id`,`care_theme`,`care_way`,`care_time`,`care_remark`,`care_nexttime`,`care_people`,`is_used`) values (1,1,'纪念日','送礼品','2013-05-23 23:12:29','节日纪念','2013-05-28 23:12:34','孙悟空','1'), (2,2,'生日','上门拜访','2013-05-23 23:14:00','过生日','2013-06-12 23:14:15','猪八戒','1'); /*Table structure for table `customer_condition` */ DROP TABLE IF EXISTS `customer_condition`; CREATE TABLE `customer_condition` ( `condition_id` int(10) NOT NULL AUTO_INCREMENT, `condition_name` varchar(50) DEFAULT NULL, `condition_explain` varchar(1000) DEFAULT NULL, `is_used` varchar(10) DEFAULT '1', PRIMARY KEY (`condition_id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; /*Data for the table `customer_condition` */ insert into `customer_condition`(`condition_id`,`condition_name`,`condition_explain`,`is_used`) values (1,'潜在客户','可能成为客户的人','1'), (2,'意向客户','有意愿车成为客户的人','1'), (3,'交易客户','正在交易的客户','1'); /*Table structure for table `customer_info` */ DROP TABLE IF EXISTS `customer_info`; CREATE TABLE `customer_info` ( `customer_id` int(10) NOT NULL AUTO_INCREMENT, `condition_id` int(10) DEFAULT NULL, `source_id` int(10) DEFAULT NULL, `user_id` int(10) DEFAULT NULL, `type_id` int(10) DEFAULT NULL, `customer_name` varchar(50) DEFAULT NULL, `customer_sex` varchar(10) DEFAULT NULL, `customer_mobile` varchar(20) DEFAULT NULL, `customer_qq` varchar(20) DEFAULT NULL, `customer_address` varchar(500) DEFAULT NULL, `customer_email` varchar(100) DEFAULT NULL, `customer_remark` varchar(1000) DEFAULT NULL, `customer_job` varchar(100) DEFAULT NULL, `customer_blog` varchar(100) DEFAULT NULL, `customer_tel` varbinary(20) DEFAULT NULL, `customer_msn` varchar(50) DEFAULT NULL, `birth_day` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `customer_addtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `customer_addman` varchar(50) DEFAULT NULL, `customer_changtime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `change_man` varchar(20) DEFAULT NULL, `customer_company` varchar(50) DEFAULT NULL, `is_used` varchar(10) DEFAULT '1', PRIMARY KEY (`customer_id`), KEY `FK_Reference_16` (`condition_id`), KEY `FK_Reference_17` (`source_id`), KEY `FK_Reference_18` (`type_id`), KEY `FK_Reference_23` (`user_id`), CONSTRAINT `FK_Reference_16` FOREIGN KEY (`condition_id`) REFERENCES `customer_condition` (`condition_id`), CONSTRAINT `FK_Reference_17` FOREIGN KEY (`source_id`) REFERENCES `customer_source` (`source_id`), CONSTRAINT `FK_Reference_18` FOREIGN KEY (`type_id`) REFERENCES `customer_type` (`type_id`), CONSTRAINT `FK_Reference_23` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; /*Data for the table `customer_info` */ insert into `customer_info`(`customer_id`,`condition_id`,`source_id`,`user_id`,`type_id`,`customer_name`,`customer_sex`,`customer_mobile`,`customer_qq`,`customer_address`,`customer_email`,`customer_remark`,`customer_job`,`customer_blog`,`customer_tel`,`customer_msn`,`birth_day`,`customer_addtime`,`customer_addman`,`customer_changtime`,`change_man`,`customer_company`,`is_used`) values (1,2,1,1,2,'李四','男','13725425426','2334343','重庆','379727687@qq.com',' 你好\r\n \r\n \r\n \r\n \r\n ','老板','3434322','54545433','23234465','2013-05-01 15:40:52','2013-05-08 22:30:40','张三','2013-05-25 09:25:43','张三','思科','1'), (2,1,1,1,1,'华纳','女','13924452345','23456','重庆三峡','379727687@qq.com',' 反反复复\r\n \r\n ','学生','6576','85858584','45454555','2013-05-01 15:40:53','2013-05-23 23:05:44','张三','2013-05-25 09:31:47','二位','天天','1'), (3,1,1,1,1,'刘欢','男','13854545454','23245','重庆','379727687@qq.com',' 如同仁堂\r\n ','学生','6567','52454789','53423134','2013-05-21 15:40:54','2013-05-23 23:08:52','张三','2013-05-25 09:32:48','热热热','微微','1'), (4,1,1,1,1,'阿黄','男','13544455544','454578','重庆三峡学院','379727687@qq.com',' 法国风格\r\n ','学生','6565','25478547','45444455','2013-05-01 15:40:54','2013-05-23 23:10:17','张三','2013-05-25 09:33:24','恒河','三峡学院','1'), (7,1,1,NULL,3,'黄晓军','男','15111866066','909239200','重庆云阳','909239200@qq.com','这个客户很水','屌丝','guanzhuwo@blog.com','42232323','2323232','1992-09-10 16:21:00','2013-05-25 16:20:38','蒋大爷','2013-05-25 16:20:38','','敏军网络科技有限公司','1'), (8,3,1,NULL,1,'温庆心','男','13652354533','','爱上对方','123156@qq.com',' \r\n \r\n ','','','','','1991-11-03 16:50:38','2013-05-25 16:49:28','admin','2013-05-25 16:52:07','','','1'), (9,1,1,6,2,'刘老师','男','15111866066','','重庆丰都','379727687@qq.com',' \r\n 这是个好老师','程序猿','','58105789','','1987-05-13 20:02:29','2013-05-25 20:00:42','蒋元征','2013-05-25 20:04:57','蒋元征','中软国际','1'); /*Table structure for table `customer_linkman` */ DROP TABLE IF EXISTS `customer_linkman`; CREATE TABLE `customer_linkman` ( `linkman_id` int(10) NOT NULL AUTO_INCREMENT, `customer_id` int(10) DEFAULT NULL, `linkman_name` varchar(50) DEFAULT NULL, `linkman_sex` varchar(20) DEFAULT NULL, `linkman_job` varchar(100) DEFAULT NULL, `linkman_mobile` varchar(20) DEFAULT NULL, `linkman_age` int(10) DEFAULT NULL, `linkman_relation` varchar(50) DEFAULT NULL, `is_used` varchar(10) DEFAULT '1', PRIMARY KEY (`linkman_id`), KEY `FK_Reference_20` (`customer_id`), CONSTRAINT `FK_Reference_20` FOREIGN KEY (`customer_id`) REFERENCES `customer_info` (`customer_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; /*Data for the table `customer_linkman` */ insert into `customer_linkman`(`linkman_id`,`customer_id`,`linkman_name`,`linkman_sex`,`linkman_job`,`linkman_mobile`,`linkman_age`,`linkman_relation`,`is_used`) values (1,2,'合格','男','老板','35667',34,'上下属','1'); /*Table structure for table `customer_linkreord` */ DROP TABLE IF EXISTS `customer_linkreord`; CREATE TABLE `customer_linkreord` ( `record_id` int(10) NOT NULL AUTO_INCREMENT, `customer_id` int(10) DEFAULT NULL, `link_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `who_link` varchar(50) DEFAULT NULL, `link_type` varchar(50) DEFAULT NULL, `link_theme` varchar(