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

QQ1061662411

于 2023-04-27 18:20:42 发布

阅读量133

点赞数

文章标签： java myeclipse eclipse

本文链接：https://blog.csdn.net/QQ1061662411/article/details/130412579

版权

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

<h1><a id="Dumping_data_for_table_mycrmdbcrm_contact_8_rows_approximately_51"></a>Dumping data for table mycrmdb.crm_contact: ~8 rows (approximately)</h1>
/*!40000 ALTER TABLE <code>crm_contact</code> DISABLE KEYS <em>/;
REPLACE INTO <code>crm_contact</code> (<code>id</code>, <code>c_name</code>, <code>c_sex</code>, <code>c_department</code>, <code>c_position</code>, <code>c_birthday</code>, <code>c_tel</code>, <code>c_email</code>, <code>c_mob</code>, <code>c_qq</code>, <code>c_address</code>, <code>c_hobby</code>, <code>c_remarks</code>, <code>c_customerid</code>, <code>c_createid</code>, <code>c_createdate</code>, <code>isdelete</code>, <code>delete_time</code>) 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);
/</em>!40000 ALTER TABLE <code>crm_contact</code> ENABLE KEYS */;

<h1><a id="Dumping_structure_for_table_mycrmdbcrm_contract_66"></a>Dumping structure for table mycrmdb.crm_contract</h1>
DROP TABLE IF EXISTS <code>crm_contract</code>;
CREATE TABLE IF NOT EXISTS <code>crm_contract</code> (
<code>id</code> int(8) NOT NULL AUTO_INCREMENT COMMENT ‘合同主键PK ID’,
<code>contract_name</code> varchar(250) DEFAULT NULL COMMENT ‘合同名称’,
<code>serialnumber</code> varchar(250) DEFAULT NULL COMMENT ‘合同编号’,
<code>customer_id</code> int(8) DEFAULT NULL COMMENT ‘客户ID Fk’,
<code>c_depid</code> int(8) DEFAULT NULL COMMENT ‘促进部门ID Fk’,
<code>c_empid</code> int(8) DEFAULT NULL COMMENT ‘促进人ID FK’,
<code>contract_amount</code> double DEFAULT NULL COMMENT ‘合同金额’,
<code>pay_cycle</code> int(8) DEFAULT NULL COMMENT ‘付款期数’,
<code>start_date</code> date DEFAULT NULL COMMENT ‘开始日期’,
<code>end_date</code> date DEFAULT NULL COMMENT ‘结束日期’,
<code>sign_date</code> date DEFAULT NULL COMMENT ‘签定日期’,
<code>customer_contractor</code> varchar(250) DEFAULT NULL COMMENT ‘客户定约人’,
<code>our_contractor_depid</code> int(8) DEFAULT NULL COMMENT ‘我们签定负责部门ID Fk’,
<code>our_contractor_id</code> int(8) DEFAULT NULL COMMENT ‘我们签订负责人ID FK’,
<code>creater_id</code> int(8) DEFAULT NULL COMMENT ‘创建人ID Fk’,
<code>create_time</code> date DEFAULT NULL COMMENT ‘创建时间’,
<code>main_content</code> longtext COMMENT ‘合同主体条款’,
<code>remarks</code> longtext COMMENT ‘备注内容’,
<code>isdelete</code> int(1) DEFAULT ‘1’ COMMENT ‘是否已删除0/1’,
<code>delete_time</code> date DEFAULT NULL COMMENT ‘删除时间’,
PRIMARY KEY (<code>id</code>),
KEY <code>customer_id</code> (<code>customer_id</code>),
KEY <code>c_depid</code> (<code>c_depid</code>),
KEY <code>c_empid</code> (<code>c_empid</code>),
KEY <code>our_contractor_depid</code> (<code>our_contractor_depid</code>),
KEY <code>our_contractor_id</code> (<code>our_contractor_id</code>),
KEY <code>creater_id</code> (<code>creater_id</code>),