基于java的CRM客户关系管理系统的设计和实现

qq_1406299528

于 2021-07-18 13:59:34 发布

阅读量951

点赞数

分类专栏：计算机毕业设计 Java javaweb 文章标签： java 计算机毕业设计

本文链接：https://blog.csdn.net/m0_50936939/article/details/118876640

版权

计算机毕业设计同时被 3 个专栏收录

1681 篇文章 83 订阅

订阅专栏

javaweb

111 篇文章 6 订阅

订阅专栏

Java

90 篇文章 5 订阅

订阅专栏

基于java的CRM客户关系管理系统的设计和实现这个系统开发的开发环境：
开发工具：MyEclipse2010版数据库：MySql+HeidiSqlJDK：MyEclipse2010自带的JDK1.7Tomact：MyEclipse自带的Tomcat

基于java的CRM客户关系管理系统的设计和实现

这个系统开发的开发环境：

开发工具：MyEclipse2010版

数据库：MySql+HeidiSql

JDK：MyEclipse2010自带的JDK1.7

Tomact：MyEclipse自带的Tomcat7.0

核心jar包：Struts2+Hibernate3+Spring4

截图：
在这里插入图片描述

数据库表：

CREATE TABLE IF NOT EXISTS crm_contact (
id int(8) NOT NULL AUTO_INCREMENT COMMENT ‘联系人主键ID’,
c_name varchar(250) DEFAULT NULL COMMENT ‘姓名’,
c_sex varchar(250) DEFAULT ‘先生’ COMMENT ‘性别’,
c_department varchar(250) DEFAULT NULL COMMENT ‘部门’,
c_position varchar(250) DEFAULT NULL COMMENT ‘职位’,
c_birthday varchar(250) DEFAULT NULL COMMENT ‘生日’,
c_tel varchar(250) DEFAULT NULL COMMENT ‘电话’,
c_email varchar(250) DEFAULT NULL COMMENT ‘邮箱’,
c_mob varchar(250) DEFAULT NULL COMMENT ‘手机’,
c_qq varchar(250) DEFAULT NULL COMMENT ‘QQ’,
c_address varchar(250) DEFAULT NULL COMMENT ‘地址’,
c_hobby varchar(250) DEFAULT NULL COMMENT ‘爱好’,
c_remarks longtext COMMENT ‘备注’,
c_customerid int(8) DEFAULT NULL COMMENT ‘FK客户ID FK’,
c_createid int(8) DEFAULT NULL COMMENT ‘创建人ID FK’,
c_createdate date DEFAULT NULL COMMENT ‘创建日期’,
isdelete int(1) DEFAULT ‘1’ COMMENT ‘是否已删除0/1’,
delete_time date DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (id),
KEY ix_crm_contact (c_customerid),
KEY c_createid (c_createid),
CONSTRAINT crm_contact_ibfk_1 FOREIGN KEY (c_customerid) REFERENCES crm_customer (id),
CONSTRAINT crm_contact_ibfk_2 FOREIGN KEY (c_createid) REFERENCES hr_employee (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

Dumping data for table mycrmdb.crm_contact: ~8 rows (approximately)

/*!40000 ALTER TABLE crm_contact DISABLE KEYS /;
REPLACE INTO crm_contact (id, c_name, c_sex, c_department, c_position, c_birthday, c_tel, c_email, c_mob, c_qq, c_address, c_hobby, c_remarks, c_customerid, c_createid, c_createdate, isdelete, delete_time) VALUES
(1, ‘杨梅花’, ‘女士’, ‘总经办’, ‘总裁’, ‘1999-05-10’, ‘0917-8311612’, ‘stnc@163.com’, ‘18710671549’, ‘24464636’, ‘甘肃省’, '吃喝玩 haha ', ‘范22德萨公交卡破的感觉哦破碎的房价合理股价看来应该看，；来到撒娇突然符合’, 3, 4, ‘2014-09-13’, 1, NULL),
(2, ‘吴尚艺’, ‘女士’, ‘二蛋’, ‘一蛋’, ‘1999-05-09’, ‘0917-8224692’, ‘wwww@163.com’, ‘18700765273’, ‘189984562’, ‘倒萨dna空间的’, ‘吃喝玩dsadadasd’, ‘231范德萨发生的过i哦啊额ugjiosjfgoisdfgmvfepoek’, 3, 4, ‘2014-09-13’, 1, NULL),
(3, ‘童宗杰’, ‘先生’, ‘片王’, ‘小蛮’, ‘1995-06-15’, ‘0917-8213872’, ‘dsaad@163.com’, ‘18791770451’, ‘24464636’, ‘231231范德萨发烧发到’, ‘吃喝玩佛挡杀佛第三方’, 'cxgsdfglkasjdgfgoadfjogjdfogadg发动机看来根据发动机哦 ', 3, 4, ‘2014-09-13’, 1, NULL),
(4, ‘张三’, ‘女士’, ‘三哥’, ‘牛逼’, ‘1990-05-09’, ‘0917-6462582’, ‘54fsdafa@163.com’, ‘18791385356’, ‘56484516565’, ‘ds22fdsfdasffdsfaf’, ‘吃喝玩DSAFSDAF’, ‘fdasfmllfkhdskfha看来今年疯狂的拉萨积分卡三等奖菲拉斯将大幅拉升的平台公司的广泛大概’, 3, 4, ‘2014-09-13’, 1, NULL),
(5, ‘俞敏洪’, ‘先生’, ‘新东方’, ‘CEO’, ‘1980-01-15’, ‘029-81109822’, ‘yuminghun@.163.com’, ‘18710722981’, ‘231543543’, ‘北京----------’, ‘hobby 讲课’, ‘很牛的这人’, 6, NULL, ‘2015-01-09’, 1, NULL),
(6, ‘党小斌’, ‘先生’, ‘总经办’, ‘CTO’, ‘2015-01-09’, ‘029-89745614’, ‘146546@qq.com’, ‘19465812357’, ‘1234567890’, ‘西安’, ‘唱歌跳舞’, ‘梅花是猪3倒萨dad哈哈’, 4, NULL, ‘2015-01-09’, 1, NULL),
(7, ‘刘东名’, ‘先生’, ‘维护部’, ‘菜鸟’, ‘2017-04-07’, ‘13641928647’, ‘2279228056@qq.com’, ‘13641928647’, ‘2279228056’, ‘上海’, ‘movie’, ‘123456’, 7, NULL, ‘2017-04-07’, 1, NULL),
(8, ‘’, NULL, ‘维护’, ‘boss’, ‘2017-04-07’, ‘18779111111’, ‘18779111111@qq.com’, ‘18779111111’, ‘18779111111’, ‘上海’, ‘玩’, ‘上海boss’, 7, NULL, ‘2017-04-07’, 1, NULL),
(9, ‘费新文’, ‘先生’, ‘维护部’, ‘经理’, ‘2017-04-04’, ‘1879117396’, ‘2376166307@qq.com’, ‘18779117396’, ‘2376166307’, ‘上海市九亭’, ‘电子竞技’, ‘很强’, 8, NULL, ‘2017-04-09’, 1, NULL);
/!40000 ALTER TABLE crm_contact ENABLE KEYS */;

Dumping structure for table mycrmdb.crm_contract

DROP TABLE IF EXISTS crm_contract;
CREATE TABLE IF NOT EXISTS crm_contract (
id int(8) NOT NULL AUTO_INCREMENT COMMENT ‘合同主键PK ID’,
contract_name varchar(250) DEFAULT NULL COMMENT ‘合同名称’,
serialnumber varchar(250) DEFAULT NULL COMMENT ‘合同编号’,
customer_id int(8) DEFAULT NULL COMMENT ‘客户ID Fk’,
c_depid int(8) DEFAULT NULL COMMENT ‘促进部门ID Fk’,
c_empid int(8) DEFAULT NULL COMMENT ‘促进人ID FK’,
contract_amount double DEFAULT NULL COMMENT ‘合同金额’,
pay_cycle int(8) DEFAULT NULL COMMENT ‘付款期数’,
start_date date DEFAULT NULL COMMENT ‘开始日期’,
end_date date DEFAULT NULL COMMENT ‘结束日期’,
sign_date date DEFAULT NULL COMMENT ‘签定日期’,
customer_contractor varchar(250) DEFAULT NULL COMMENT ‘客户定约人’,
our_contractor_depid int(8) DEFAULT NULL COMMENT ‘我们签定负责部门ID Fk’,
our_contractor_id int(8) DEFAULT NULL COMMENT ‘我们签订负责人ID FK’,
creater_id int(8) DEFAULT NULL COMMENT ‘创建人ID Fk’,
create_time date DEFAULT NULL COMMENT ‘创建时间’,
main_content longtext COMMENT ‘合同主体条款’,
remarks longtext COMMENT ‘备注内容’,
isdelete int(1) DEFAULT ‘1’ COMMENT ‘是否已删除0/1’,
delete_time date DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (id),
KEY customer_id (customer_id),
KEY c_depid (c_depid),
KEY c_empid (c_empid),
KEY our_contractor_depid (our_contractor_depid),
KEY our_contractor_id (our_contractor_id),
KEY creater_id (creater_id),
CONSTRAINT crm_contract_ibfk_1 FOREIGN KEY (customer_id) REFERENCES crm_customer (id),
CONSTRAINT crm_contract_ibfk_2 FOREIGN KEY (c_depid) REFERENCES hr_department (id),
CONSTRAINT crm_contract_ibfk_3 FOREIGN KEY (c_empid) REFERENCES hr_employee (id),
CONSTRAINT crm_contract_ibfk_4 FOREIGN KEY (our_contractor_depid) REFERENCES hr_department (id),
CONSTRAINT crm_contract_ibfk_5 FOREIGN KEY (our_contractor_id) REFERENCES hr_employee (id),
CONSTRAINT crm_contract_ibfk_6 FOREIGN KEY (creater_id) REFERENCES hr_employee (id)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

/*!40000 ALTER TABLE crm_contract DISABLE KEYS /;
REPLACE INTO crm_contract (id, contract_name, serialnumber, customer_id, c_depid, c_empid, contract_amount, pay_cycle, start_date, end_date, sign_date, customer_contractor, our_contractor_depid, our_contractor_id, creater_id, create_time, main_content, remarks, isdelete, delete_time) VALUES
(1, ‘租房12132’, ‘121222’, 1, 1, 1, 22110.22, 12, ‘2014-12-07’, ‘2014-12-06’, ‘2014-12-08’, ‘dfdf2dasdad’, 2, 2, 1, NULL, ‘的撒发送到范德萨发大水发的是范德萨是的@’, ‘阿打发的手法十分同意后符合规范化@’, 1, NULL),
(2, ‘租房2’, ‘121’, 1, 2, 2, 1, 1, ‘2014-12-04’, ‘2014-12-05’, ‘2014-12-02’, ‘dfdf’, 2, 2, 1, ‘2014-12-12’, ‘的撒发送到范德萨发大水发的是范德萨是的’, ‘阿打发的手法十分同意后符合规范化’, 1, NULL),
(3, ‘租房3’, ‘121’, 1, 2, 2, 1, 1, ‘2014-12-04’, ‘2014-12-05’, ‘2014-12-02’, ‘dfdf’, 4, 4, 1, ‘2014-12-12’, ‘的撒发送到范德萨发大水发的是范德萨是的’, ‘阿打发的手法十分同意后符合规范化’, 1, NULL),
(4, ‘namecontract’, ‘1212313’, 1, 2, 2, 111111, 22, ‘2015-01-05’, ‘2015-01-07’, ‘2015-01-08’, ‘KKKKF’, 1, 1, NULL, ‘2015-01-07’, ‘pppppppppppppppppppppppppppppp’, ‘wwwwwwwwwwwwwwwwwwwwwww’, 1, NULL),
(5, ‘ccccccc’, ‘12132131’, 1, 4, 4, 22, 11, ‘2015-01-01’, ‘2015-01-02’, ‘2015-01-03’, ‘QQQQ’, 1, 1, NULL, ‘2015-01-07’, ‘DDDDDDDDDDDDD’, ‘AAAAAAAAAAAAAAAAAAAAA’, 1, NULL);
/!40000 ALTER TABLE crm_contract ENABLE KEYS */;