基于ssm的客户管理系统
作者： C you again，从事软件开发 努力在IT搬砖路上的技术小白
01 概述
一个简单的客户关系管理系统 管理用户的基本数据 客户的分配 客户的流失 已经客户的状态
02 技术
ssm jdk1.8 mysql5.4
03 运行环境
ecplice jdk1.8 tomcat
04 功能
1- 字典管理
2- 用户管理
3- 角色管理
4- 权限管理
5- 部门管理
6-客户信息管理
7-数据添加-编辑-删除
8-客户信息的跟进
9-客户信息状态
05 运行截图
客户信息
跟进信息
登录信息
权限管理
06 主要代码
客户信息
package com.controller;import java.text.SimpleDateFormat;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import javax.annotation.Resource;import javax.servlet.http.HttpServletRequest;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import com.dao.KhClientinfoMapper;import com.dao.KhHuiMapper;import com.dao.LogsMapper;import com.entity.KhClientinfo;import com.entity.KhHui;import com.entity.Logs;import com.util.Pagination;@Controller@RequestMapping("/khclient")public class KhClientinfoController extends BaseController{ @Resource//客户表 KhClientinfoMapper khclientDao; @Resource//客户跟进表 KhHuiMapper khhuiDao; @Resource LogsMapper logsDao; //客户表显示 @RequestMapping("/show") public String show(Integer index,HttpServletRequest request) { int pageNO = 1; if(index!=null){ pageNO = index; } String names = (String) request.getSession().getAttribute("name"); String relo = (String) request.getSession().getAttribute("relo"); Pagination pager = new Pagination(); Map params = new HashMap(); params.put("start", (pageNO-1)*40); params.put("pagesize", 40); if("客服".equals(relo)) { params.put("kefuname", names); } List all = khclientDao.show(params); pager.setData(all); pager.setIndex(pageNO); request.getSession().setAttribute("pageNO", pager.getIndex()); pager.setPageSize(40); pager.setTotal(khclientDao.getTotal()); pager.setPath("show.do?"); request.setAttribute("pager", pager); return "client/cl-show"; } //客户表新建 @RequestMapping(value = "/add") public String add(KhClientinfo data,HttpServletRequest request) { Date now = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");//设置时间显示格式 String str = sdf.format(now); String names = (String) request.getSession().getAttribute("name"); data.setKehuday(str); data.setKefuname(names); data.setKhstate("未到访"); Date time = null; if ("A:已交房客户".equals(data.getKehulei())) { time= new Date(now.getTime() (long)3 * 24 * 60 * 60 * 1000);//加3天 } if ("B:3个月内交房客户".equals(data.getKehulei())) { time= new Date(now.getTime() (long)7 * 24 * 60 * 60 * 1000);//加7天 } if ("C:3-6交房客户".equals(data.getKehulei())) { time= new Date(now.getTime() (long)15 * 24 * 60 * 60 * 1000);//加15天 } if ("D:6个月以上交房客户".equals(data.getKehulei())) { time= new Date(now.getTime() (long)30 * 24 * 60 * 60 * 1000);//加30天 } String stc = sdf.format(time); if (data.getKehutel().length()>1) { KhClientinfo khClient=khclientDao.tel(data.getKehutel()); if (khClient!=null) { request.setAttribute("all", khClient.getKefuname()); return "client/chongfu"; } } khclientDao.insertSelective(data); KhClientinfo khClientinfo=khclientDao.isdn(); KhHui khHui=new KhHui(); khHui.setYuday(stc); khHui.setWenti("客户第一次跟进"); khHui.setInid(khClientinfo.getId()); khHui.setScday(str); khhuiDao.insertSelective(khHui); Integer pagerNO=(Integer)request.getSession().getAttribute("pageNO"); return "redirect:/khclient/show?index=" pagerNO; } //客户表删除 @RequestMapping("/{id}/del") public String del(@PathVariable("id") int id,HttpServletRequest request) { SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); // 时间字符串产生方式 String uid = format.format(new Date()); String names = (String) request.getSession().getAttribute("name"); KhClientinfo khClientinfo=khclientDao.selectByPrimaryKey(id); Logs logs =new Logs(); logs.setDay(uid); logs.setLoname(names); logs.setLei("删除"); logs.setBiaoid(khClientinfo.getKuhuname() " " khClientinfo.getKehutel()); logs.setBiao("客户表及跟进详情"); logsDao.insertSelective(logs); khclientDao.deleteByPrimaryKey(id); Integer pagerNO=(Integer)request.getSession().getAttribute("pageNO"); String like=request.getParameter("like"); if (like!=null&&like.length()>0) { return "redirect:/khclient/like?index=" pagerNO; }else { return "redirect:/khclient/show?index=" pagerNO; } } //客户表编辑前取数据 @RequestMapping("/{id}/load") public String load(@PathVariable("id") int id,HttpServletRequest request, ModelMap model) { KhClientinfo record = (KhClientinfo) khclientDao.selectByPrimaryKey(id); model.addAttribute("record", record); String like=request.getParameter("like"); if (like!=null) { request.setAttribute("like", like); } return "client/cl-modify"; } //客户表编辑 @RequestMapping(value = "/update") public String update(KhClientinfo data,HttpServletRequest request) { khclientDao.updateByPrimaryKeySelective(data); Integer pagerNO=(Integer)request.getSession().getAttribute("pageNO"); String like=request.getParameter("like"); if (like!=null&&like.length()>0) { return "redirect:/khclient/like?index=" pagerNO; }else { return "redirect:/khclient/show?index=" pagerNO; } } //客户表模糊查找 @RequestMapping("/like") public String like(Integer index, KhClientinfo data,HttpServletRequest request) { int pageNO = 1; if(index!=null){ pageNO = index; } Pagination pager = new Pagination(); Map params = new HashMap(); String lk=request.getParameter("lk"); String names = (String) request.getSession().getAttribute("name"); String relo = (String) request.getSession().getAttribute("relo"); if (lk!=null&&lk.length()>0) { request.getSession().setAttribute("kuhuname",data.getKuhuname()); request.getSession().setAttribute("kehuaddres",data.getKehuaddres()); request.getSession().setAttribute("kehutel",data.getKehutel()); request.getSession().setAttribute("kehulei",data.getKehulei()); request.getSession().setAttribute("kehugenre",data.getKehugenre()); request.getSession().setAttribute("kaiday",data.getKaiday()); request.getSession().setAttribute("weixin",data.getWeixin()); request.getSession().setAttribute("channel",data.getChannel()); request.getSession().setAttribute("khstate",data.getKhstate()); request.getSession().setAttribute("kefuname",data.getKefuname()); request.getSession().setAttribute("kehuday",data.getKehuday()); request.getSession().setAttribute("qu",data.getQu()); request.getSession().setAttribute("an",data.getAn()); request.getSession().setAttribute("jiename",data.getJiename()); } String qu= (String) request.getSession().getAttribute("qu"); if(qu!=null&&qu.length()>0) { params.put("qu", qu); } String an= (String) request.getSession().getAttribute("an"); if(an!=null&&an.length()>0) { params.put("an", an); } String jiename= (String) request.getSession().getAttribute("jiename"); if(jiename!=null&&jiename.length()>0) { params.put("jiename", jiename); } String kaiday= (String) request.getSession().getAttribute("kaiday"); if(kaiday!=null&&kaiday.length()>0) { params.put("kaiday", kaiday); } String weixin= (String) request.getSession().getAttribute("weixin"); if(weixin!=null&&weixin.length()>0) { params.put("weixin", weixin); } String channel= (String) request.getSession().getAttribute("channel"); if(channel!=null&&channel.length()>0) { params.put("channel", channel); } String khstate= (String) request.getSession().getAttribute("khstate"); if(khstate!=null&&khstate.length()>0) { params.put("khstate", khstate); } String kehuday= (String) request.getSession().getAttribute("kehuday"); if(kehuday!=null&&kehuday.length()>0) { params.put("kehuday", kehuday); } String kuhuname= (String) request.getSession().getAttribute("kuhuname"); if(kuhuname!=null&&kuhuname.length()>0) { params.put("kuhuname", kuhuname); } String kehuaddres= (String) request.getSession().getAttribute("kehuaddres"); if(kehuaddres!=null&&kehuaddres.length()>0) { params.put("kehuaddres", kehuaddres); } String kehugenre= (String) request.getSession().getAttribute("kehugenre"); if(kehugenre!=null&&kehugenre.length()>0) { params.put("kehugenre", kehugenre); } String kehulei= (String) request.getSession().getAttribute("kehulei"); if(kehulei!=null&&kehulei.length()>0) { params.put("kehulei", kehulei); } String kehutel= (String) request.getSession().getAttribute("kehutel"); if(kehutel!=null&&kehutel.length()>0) { params.put("kehutel", kehutel); } String kefuname= (String) request.getSession().getAttribute("kefuname"); if("客服".equals(relo)) { params.put("kefuname", names); }else { if(kefuname!=null&&kefuname.length()>0) { params.put("kefuname", kefuname); } } params.put("start", (pageNO-1)*40); params.put("pagesize",40); List all = khclientDao.like(params); pager.setData(all); pager.setIndex(pageNO); request.getSession().setAttribute("pageNO",pager.getIndex()); pager.setPageSize(40); pager.setTotal(khclientDao.getlikeTotal(params)); pager.setPath("like?"); request.setAttribute("pager", pager); return "client/cl-showlike"; }}
用户登录
package com.controller;import java.util.*;import javax.annotation.Resource;import javax.servlet.http.HttpServletRequest;import org.springframework.stereotype.Controller;import org.springframework.ui.ModelMap;import org.springframework.web.bind.annotation.RequestMapping;import com.dao.LogMapper;import com.dao.LogsMapper;import com.entity.Log;import com.util.Pagination;@Controller@RequestMapping("/log")public class LogController extends BaseController{ @Resource LogMapper logDao; @Resource LogsMapper logsDao; //登录信息显示 @RequestMapping("/show") public String show(Integer index,HttpServletRequest request,ModelMap model) { int pageNO = 1; if(index!=null){ pageNO = index; } Pagination pager = new Pagination(); Map params = new HashMap(); params.put("start", (pageNO-1)*40); params.put("pagesize", 40); List all = logDao.show(params); pager.setData(all); pager.setIndex(pageNO); request.getSession().setAttribute("pageNO", pager.getIndex()); pager.setPageSize(40); pager.setTotal(logDao.getTotal()); pager.setPath("show.do?"); request.setAttribute("pager", pager); return "dept/denlu/show"; } //登录信息模糊查找 @RequestMapping("/like") public String like(Integer index, Log data,HttpServletRequest request) { int pageNO = 1; if(index!=null){ pageNO = index; } Pagination pager = new Pagination(); Map params = new HashMap(); String lk=request.getParameter("lk"); String account=""; String onlineTime=""; String exitTime=""; if (lk!=null&&lk.length()>0) { request.getSession().setAttribute("account",data.getAccount()); request.getSession().setAttribute("onlineTime",data.getOnlineTime()); request.getSession().setAttribute("exitTime",data.getExitTime()); } account=(String) request.getSession().getAttribute("account"); onlineTime=(String) request.getSession().getAttribute("onlineTime"); exitTime=(String) request.getSession().getAttribute("exitTime"); if(account!=null&&account.length()>0) { params.put("account",account); } if(onlineTime!=null&&onlineTime.length()>0) { params.put("onlineTime",onlineTime); } if(exitTime!=null&&exitTime.length()>0) { params.put("exitTime",exitTime); } params.put("start", (pageNO-1)*40); params.put("pagesize", 40); List all = logDao.like(params); pager.setData(all); pager.setIndex(pageNO); request.getSession().setAttribute("pageNO", pager.getIndex()); pager.setPageSize(40); pager.setTotal(logDao.getlikeTotal(params)); pager.setPath("like.do?"); request.setAttribute("pager", pager); return "dept/denlu/show"; } //个人操作记录显示 @RequestMapping("/shows") public String shows(Integer index,HttpServletRequest request,ModelMap model) { int pageNO = 1; if(index!=null){ pageNO = index; } Pagination pager = new Pagination(); Map params = new HashMap(); params.put("start", (pageNO-1)*40); params.put("pagesize", 40); List all = logsDao.show(params); pager.setData(all); pager.setIndex(pageNO); request.getSession().setAttribute("pageNO", pager.getIndex()); pager.setPageSize(40); pager.setTotal(logsDao.getTotal()); pager.setPath("shows.do?"); request.setAttribute("pager", pager); return "dept/caozuo/show"; }}
07 源码下载
关注公众号【C you again】，回复“基于ssm的客户管理系统”免费领取。
亦可直接扫描主页二维码关注，回复“基于ssm的客户管理系统”免费领取，点此打开个人主页
运行
找到文件夹sql中的sql文件，导入到mysql中
将工程导入到eclipse中，修改数据库连接信息
启动项目，浏览器地址栏输入：http://localhost:8080/ssmClient
说明：此源码来源于网络，若有侵权，请联系删除！！
赞 (0)