基于javaweb+mysql的ssm客户管理系统(java+ssm+jsp+easyui+highcharts+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM客户管理系统(java+ssm+jsp+easyui+highcharts+mysql)
项目介绍
本项目包含管理员、销售主管、客户经理、高管等角色;
主要包含以下功能: 营销管理:营销机会管理、客户开发计划; 客户管理:客户信息管理、客户流失管理; 服务管理:服务创建、服务分配、服务处理、服务反馈、服务归档; 统计报表:客户贡献分析、客户构成分析、客户服务分析、客户流失分析; 基础数据管理:数据字典管理、产品信息查询、用户信息管理; 系统管理:修改密码、安全退出;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目 6.数据库:MySql 5.7/8.0等版本均可;
技术栈
- 后端:Spring springmvc mybatis 2. 前端:JSP+css+javascript+jQuery+easyUI+highcharts
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,修改配置,运行项目; 3. 将项目中applicationContext.xml配置文件中的数据库配置改为自己的配置,然后运行; 4. 运行成功后,在浏览器中输入:http://localhost:8080/CRM/ 管理员账号密码:admin/123 销售主管账号密码:json1234/123 客户经理账号密码:xiaoming/123
* @throws Exception
*/
@RequestMapping("/save")
public String save(LinkMan linkMan,HttpServletResponse response)throws Exception{
int resultTotal=0; // 操作的记录条数
if(linkMan.getId()==null){
resultTotal=linkManService.add(linkMan);
}else{
resultTotal=linkManService.update(linkMan);
}
JSONObject result=new JSONObject();
if(resultTotal>0){
result.put("success", true);
}else{
result.put("success", false);
}
ResponseUtil.write(response, result);
return null;
}
/**
* 删除联系人
* @param ids
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/delete")
public String delete(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{
linkManService.delete(Integer.parseInt(id));
JSONObject result=new JSONObject();
result.put("success", true);
ResponseUtil.write(response, result);
return null;
}
}
package com.java1234.controller;
* @throws Exception
*/
@RequestMapping("/save")
public String save(User user,HttpServletResponse response)throws Exception{
int resultTotal=0; // 操作的记录条数
if(user.getId()==null){
resultTotal=userService.add(user);
}else{
resultTotal=userService.update(user);
}
JSONObject result=new JSONObject();
if(resultTotal>0){
result.put("success", true);
}else{
result.put("success", false);
}
ResponseUtil.write(response, result);
return null;
}
/**
* 删除用户
* @param ids
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/delete")
public String delete(@RequestParam(value="ids")String ids,HttpServletResponse response)throws Exception{
String []idsStr=ids.split(",");
for(int i=0;i<idsStr.length;i++){
userService.delete(Integer.parseInt(idsStr[i]));
}
JSONObject result=new JSONObject();
result.put("success", true);
ResponseUtil.write(response, result);
return null;
}
/**
* 修改用户密码
* @param user
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/modifyPassword")
public String modifyPassword(Integer id,String newPassword,HttpServletResponse response)throws Exception{
User user=new User();
user.setId(id);
/**
* 联系人Controller层
*
*/
@Controller
@RequestMapping("/linkMan")
public class LinkManController {
@Resource
private LinkManService linkManService;
/**
* 分页条件查询联系人
* @param page
* @param rows
* @param s_linkMan
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="cusId",required=false)String cusId,HttpServletResponse response)throws Exception{
Map<String,Object> map=new HashMap<String,Object>();
map.put("cusId", cusId);
List<LinkMan> linkManList=linkManService.find(map);
JSONObject result=new JSONObject();
ResponseUtil.write(response, result);
return null;
}
}
package com.java1234.controller;
/**
* 客户流失暂缓措施Controller层
*
*/
@Controller
@RequestMapping("/customerReprieve")
public class CustomerReprieveController {
@Resource
private CustomerReprieveService customerReprieveService;
/**
* 分页条件查询客户流失暂缓措施
@InitBinder
public void initBinder(WebDataBinder binder) {
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm");
dateFormat.setLenient(false);
binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, true)); //true:允许输入空值,false:不能为空值
}
/**
* 分页条件查询销售机会
* @param page
* @param rows
* @param s_saleChance
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,SaleChance s_saleChance,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("customerName", StringUtil.formatLike(s_saleChance.getCustomerName()));
map.put("overView", StringUtil.formatLike(s_saleChance.getOverView()));
map.put("createMan", StringUtil.formatLike(s_saleChance.getCreateMan()));
map.put("state", s_saleChance.getState());
map.put("devResult", s_saleChance.getDevResult());
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
List<SaleChance> saleChanceList=saleChanceService.find(map);
Long total=saleChanceService.getTotal(map);
JSONObject result=new JSONObject();
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd HH:mm"));
JSONArray jsonArray=JSONArray.fromObject(saleChanceList,jsonConfig);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}
/**
* 添加或者修改销售机会
}
ResponseUtil.write(response, result);
return null;
}
/**
* 删除客户流失暂缓措施
* @param ids
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/delete")
public String delete(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{
customerReprieveService.delete(Integer.parseInt(id));
JSONObject result=new JSONObject();
result.put("success", true);
ResponseUtil.write(response, result);
return null;
}
}
package com.java1234.controller;
/**
* 订单Controller层
/**
* 添加或者修改联系人
* @param linkMan
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/save")
public String save(LinkMan linkMan,HttpServletResponse response)throws Exception{
int resultTotal=0; // 操作的记录条数
if(linkMan.getId()==null){
resultTotal=linkManService.add(linkMan);
}else{
resultTotal=linkManService.update(linkMan);
}
JSONObject result=new JSONObject();
if(resultTotal>0){
result.put("success", true);
}else{
result.put("success", false);
}
ResponseUtil.write(response, result);
return null;
}
/**
* 删除联系人
* @param ids
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/delete")
public String delete(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{
linkManService.delete(Integer.parseInt(id));
JSONObject result=new JSONObject();
result.put("success", true);
ResponseUtil.write(response, result);
return null;
}
* @param s_order
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,@RequestParam(value="cusId",required=false)String cusId,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("cusId", cusId);
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
List<Order> orderList=orderService.find(map);
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.setExcludes(new String[]{"order"});
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));
JSONObject result=new JSONObject();
Long total=orderService.getTotal(map);
JSONArray jsonArray=JSONArray.fromObject(orderList,jsonConfig);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}
/**
* 通过ID查找实体
* @param id
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/findById")
public String findById(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{
Order order=orderService.findById(Integer.parseInt(id));
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.setExcludes(new String[]{"order"});
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));
JSONObject jsonObject=JSONObject.fromObject(order,jsonConfig);
ResponseUtil.write(response, jsonObject);
return null;
}
}
}
/**
* 分页条件查询客户开发计划
* @param page
* @param rows
* @param s_cusDevPlan
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="saleChanceId",required=false)String saleChanceId,HttpServletResponse response)throws Exception{
Map<String,Object> map=new HashMap<String,Object>();
map.put("saleChanceId", saleChanceId);
List<CusDevPlan> cusDevPlanList=cusDevPlanService.find(map);
JSONObject result=new JSONObject();
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.setExcludes(new String[]{"saleChance"});
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));
JSONArray jsonArray=JSONArray.fromObject(cusDevPlanList,jsonConfig);
result.put("rows", jsonArray);
ResponseUtil.write(response, result);
return null;
}
/**
* 添加或者修改客户开发计划
* @param cusDevPlan
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/save")
public String save(CusDevPlan cusDevPlan,HttpServletResponse response)throws Exception{
int resultTotal=0; // 操作的记录条数
if(cusDevPlan.getId()==null){
SaleChance saleChance=new SaleChance();
saleChance.setId(cusDevPlan.getSaleChance().getId());
saleChance.setDevResult(1); // 状态修改成"开发中"
saleChanceService.update(saleChance);
resultTotal=cusDevPlanService.add(cusDevPlan);
}else{
resultTotal=cusDevPlanService.update(cusDevPlan);
}
JSONObject result=new JSONObject();
if(resultTotal>0){
result.put("success", true);
}else{
result.put("success", false);
}
ResponseUtil.write(response, result);
* @param contact
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/save")
public String save(CustomerService customerService,HttpServletResponse response)throws Exception{
int resultTotal=0; // 操作的记录条数
if(customerService.getId()==null){
resultTotal=customerServiceService.add(customerService);
}else{
resultTotal=customerServiceService.update(customerService);
}
JSONObject result=new JSONObject();
if(resultTotal>0){
result.put("success", true);
}else{
result.put("success", false);
}
ResponseUtil.write(response, result);
return null;
}
}
package com.java1234.controller;
/**
* 客户流失Controller层
*
@Resource
private DataDicService dataDicService;
/**
* 分页条件查询数据字典
* @param page
* @param rows
* @param s_dataDic
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,DataDic s_dataDic,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("dataDicName", s_dataDic.getDataDicName());
map.put("dataDicValue", StringUtil.formatLike(s_dataDic.getDataDicValue()));
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
List<DataDic> dataDicList=dataDicService.find(map);
Long total=dataDicService.getTotal(map);
JSONObject result=new JSONObject();
JSONArray jsonArray=JSONArray.fromObject(dataDicList);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}
/**
* 根据数据字典名称查找,用户下拉框
* @param dataDicName
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/dataDicComboList")
public String dataDicComboList(String dataDicName,HttpServletResponse response)throws Exception{
JSONArray jsonArray=new JSONArray();
Map<String,Object> map=new HashMap<String,Object>();
map.put("dataDicName", dataDicName);
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,@RequestParam(value="cusId",required=false)String cusId,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("cusId", cusId);
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
List<Order> orderList=orderService.find(map);
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.setExcludes(new String[]{"order"});
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));
JSONObject result=new JSONObject();
Long total=orderService.getTotal(map);
JSONArray jsonArray=JSONArray.fromObject(orderList,jsonConfig);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}
/**
* 通过ID查找实体
* @param id
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/findById")
public String findById(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{
Order order=orderService.findById(Integer.parseInt(id));
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.setExcludes(new String[]{"order"});
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));
JSONObject jsonObject=JSONObject.fromObject(order,jsonConfig);
ResponseUtil.write(response, jsonObject);
return null;
}
/**
* 分页条件查询用户
* @param page
* @param rows
* @param s_user
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,User s_user,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("userName", StringUtil.formatLike(s_user.getUserName()));
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
List<User> userList=userService.find(map);
Long total=userService.getTotal(map);
JSONObject result=new JSONObject();
JSONArray jsonArray=JSONArray.fromObject(userList);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}
/**
* 获取客户经理信息 下拉框数据用到
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/customerManagerComboList")
public String customerManagerComboList(HttpServletResponse response)throws Exception{
Map<String,Object> map=new HashMap<String,Object>();
map.put("roleName", "客户经理");
List<User> userList=userService.find(map);
JSONArray row=JSONArray.fromObject(userList);
ResponseUtil.write(response, row);
return null;
}
/**
* 添加或者修改用户
* 查询客户分析构成
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/findCustomerGc")
public String findCustomerGc(HttpServletResponse response)throws Exception{
List<CustomerGc> customerGcList=customerService.findCustomerGc();
JSONArray jsonArray=JSONArray.fromObject(customerGcList);
ResponseUtil.write(response, jsonArray);
return null;
}
/**
* 查询客户服务分析
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/findCustomerFw")
public String findCustomerFw(HttpServletResponse response)throws Exception{
List<CustomerFw> customerFwList=customerService.findCustomerFw();
JSONArray jsonArray=JSONArray.fromObject(customerFwList);
ResponseUtil.write(response, jsonArray);
return null;
}
}
package com.java1234.controller;
* 客户流失Controller层
*
*/
@Controller
@RequestMapping("/customerLoss")
public class CustomerLossController {
@Resource
private CustomerLossService customerLossService;
/**
* 分页条件查询客户流失
* @param page
* @param rows
* @param s_customerLoss
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/list")
public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,CustomerLoss s_customerLoss,HttpServletResponse response)throws Exception{
PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));
Map<String,Object> map=new HashMap<String,Object>();
map.put("cusName", StringUtil.formatLike(s_customerLoss.getCusName()));
map.put("cusManager", StringUtil.formatLike(s_customerLoss.getCusManager()));
map.put("state", s_customerLoss.getState());
map.put("start", pageBean.getStart());
map.put("size", pageBean.getPageSize());
List<CustomerLoss> customerLossList=customerLossService.find(map);
JsonConfig jsonConfig=new JsonConfig();
jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));
JSONObject result=new JSONObject();
Long total=customerLossService.getTotal(map);
JSONArray jsonArray=JSONArray.fromObject(customerLossList,jsonConfig);
result.put("rows", jsonArray);
result.put("total", total);
ResponseUtil.write(response, result);
return null;
}
/**
* 通过ID查找实体
* @param id
* @param id
* @param lossReason
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/confirmLoss")
public String confirmLoss(int id,String lossReason,HttpServletResponse response)throws Exception{
CustomerLoss customerLoss=new CustomerLoss();
customerLoss.setId(id);
customerLoss.setLossReason(lossReason);
customerLoss.setConfirmLossTime(new Date());
customerLoss.setState(1);
customerLossService.update(customerLoss);
JSONObject result=new JSONObject();
result.put("success", true);
ResponseUtil.write(response, result);
return null;
}
}
package com.java1234.controller;
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/delete")
public String delete(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{
contactService.delete(Integer.parseInt(id));
JSONObject result=new JSONObject();
result.put("success", true);
ResponseUtil.write(response, result);
return null;
}
}
package com.java1234.controller;
/**
* 客户流失暂缓措施Controller层
*
*/
@Controller
@RequestMapping("/customerReprieve")
public class CustomerReprieveController {
@Resource
private CustomerReprieveService customerReprieveService;
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/customerManagerComboList")
public String customerManagerComboList(HttpServletResponse response)throws Exception{
Map<String,Object> map=new HashMap<String,Object>();
map.put("roleName", "客户经理");
List<User> userList=userService.find(map);
JSONArray row=JSONArray.fromObject(userList);
ResponseUtil.write(response, row);
return null;
}
/**
* 添加或者修改用户
* @param user
* @param response
* @return
* @throws Exception
*/
@RequestMapping("/save")
public String save(User user,HttpServletResponse response)throws Exception{
int resultTotal=0; // 操作的记录条数
if(user.getId()==null){
resultTotal=userService.add(user);
}else{
resultTotal=userService.update(user);
}
JSONObject result=new JSONObject();
if(resultTotal>0){
result.put("success", true);
}else{
result.put("success", false);
}
ResponseUtil.write(response, result);
return null;
}
/**
* 删除用户
* @param ids
* @param response
* @return