基于JSP+Mybatis实现的CRM客户关系管理系统

简介: 基于JSP+Mybatis实现的CRM客户关系管理系统

项目编号:BS-XX-111

该项目主要基于JAVAWEB技术,开发了一套CRM客户关系管理系统,实现了用户登录,权限控制,数据统计,以及市场活动、线索、客户、联系人、合同的CRUD,使用Proxy实现Service层的动态代理,实现DAO层事务控制。

运行环境

jdk8+tomcat8+mysql5.7+IntelliJ IDEA

项目技术(必填)

java servlet+mybatis+layui+jquery+echarts

下面展示一下具体的功能界面:

image.png

系统主页面

image.png

市场活动管理:查询的相关数据可以导出到EXCEL表里

image.png

销售线索管理

image.png

客户管理

image.png

联系人管理

image.png

交易管理

image.png

个人信息管理

image.png

系统设置—用户管理

image.png

系统设置—角色管理

image.png

系统设置—权限管理

image.png

部分核心代码:

package com.crsbg.controller;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.IdUtil;
import cn.hutool.crypto.SecureUtil;
import cn.hutool.json.JSONArray;
import com.crsbg.entity.PageVO;
import com.crsbg.entity.User;
import com.crsbg.service.UserService;
import com.crsbg.service.impl.UserServiceImpl;
import com.crsbg.utils.JSONUtil;
import com.crsbg.utils.ServiceFactory;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 *用户管理控制器
 */
public class UserController extends HttpServlet {
  private UserService userService = null;
  @Override
  protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String path = request.getServletPath();
      if("/controller/login".equals(path)){
        login(request,response);
        }else if("/controller/getUsers".equals(path)){
          getUsers(request,response);
        }else if("/controller/updateUser".equals(path)){
            updateUser(request,response);
        }else if("/controller/changePwd".equals(path)){
            changePwd(request,response);
        }else if("/controller/addUser".equals(path)){
            addUser(request,response);
        }else if("/controller/getUserList".equals(path)){
            getUserList(request,response);
        }else if("/controller/deleteUsers".equals(path)){
            deleteUsers(request,response);
        }else if("/controller/getUserById".equals(path)){
            getUserById(request,response);
        }else if("/controller/updateUser2".equals(path)){
            updateUser2(request,response);
        }else if("/controller/resetPwd".equals(path)){
            resetPwd(request,response);
        }else if("/controller/welcome".equals(path)){
            getDatas(request,response);
        }
  }
    private void getDatas(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
        System.out.println("进入首页获取数据getDatas...");
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        Map<String,Object> map = userService.getDatas();
        request.setAttribute("activities",map.get("activities"));
        request.setAttribute("clues",map.get("clues"));
        request.setAttribute("trans",map.get("trans"));
        request.setAttribute("owners",map.get("owners"));
        request.setAttribute("volumes",map.get("volumes"));
        request.getRequestDispatcher("/pages/welcome.jsp").forward(request,response);
    }
    private void resetPwd(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入重置密码resetPwd...");
        String id = request.getParameter("id");
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        boolean flag = userService.resetPwd(id);
        response.getWriter().print(flag);
    }
    private void updateUser2(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入修改用户详情updateUser2...");
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String username = request.getParameter("username");
        String isEnable =request.getParameter("isEnable");
        String isAdmin =request.getParameter("isAdmin");
        String[] roleIds = request.getParameterValues("roleIds");
        String email =request.getParameter("email");
        String remark =request.getParameter("remark");
        User user = new User();
        user.setId(id);
        user.setName(name);
        user.setUsername(username);
        user.setIsEnable(isEnable);
        user.setIsAdmin(isAdmin);
        user.setEmail(email);
        user.setRemark(remark);
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        Map<String,Object> map = userService.updateUser2(user,roleIds);
        JSONUtil.getJSON(response,map);
    }
    private void getUserById(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入查询用户详情getUserById...");
        String id = request.getParameter("id");
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        User user = userService.getUserById(id);
        JSONUtil.getJSON(response,user);
    }
    private void deleteUsers(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入批量删除用户deleteUsers...");
        String[] ids = request.getParameterValues("id");
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        boolean flag = userService.deleteUsers(ids);
        response.getWriter().print(flag);
    }
    private void getUserList(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入获取用户列表getUserList...");
        String name = request.getParameter("name");
        int page = Integer.parseInt(request.getParameter("page"));
        int limit = Integer.parseInt(request.getParameter("limit"));
        int pageNumber = (page-1)*limit;
        int pageSize = limit;
        Map<String,Object> param = new HashMap<>();
        param.put("name",name);
        param.put("pageNumber",pageNumber);
        param.put("pageSize",pageSize);
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        PageVO<User> vo = userService.getUserList(param);
        Map<String,Object> map = new HashMap<>();
        map.put("code",0);
        map.put("message","请求成功");
        map.put("count",vo.getTotal());
        map.put("data",vo.getDatas());
        JSONUtil.getJSON(response,map);
    }
    private void addUser(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入添加用户addUser...");
        String name = request.getParameter("name");
        String username = request.getParameter("username");
        String isEnable =request.getParameter("isEnable");
        String isAdmin =request.getParameter("isAdmin");
        String[] roleIds = request.getParameterValues("roleIds");
        String email =request.getParameter("email");
        String remark =request.getParameter("remark");
        User user = new User();
        user.setId(IdUtil.simpleUUID());
        user.setName(name);
        user.setUsername(username);
        user.setPassword(SecureUtil.md5("123")); //123
        user.setIsEnable(isEnable);
        user.setIsAdmin(isAdmin);
        user.setEmail(email);
        user.setRemark(remark);
        user.setRegistTime(DateUtil.now());
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        Map<String,Object> map = userService.addUser(user,roleIds);
        JSONUtil.getJSON(response,map);
    }
    private void changePwd(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入重置密码changePwd...");
        String oldPwd = SecureUtil.md5(request.getParameter("oldPwd"));
        String password = SecureUtil.md5(request.getParameter("password"));
        HttpSession session = request.getSession();
        User user = (User) session.getAttribute("user");
        Map<String,Object> map = new HashMap<>();
        if(!user.getPassword().equals(oldPwd)){
            map.put("success",false);
            map.put("msg","修改失败,旧密码错误");
            JSONUtil.getJSON(response,map);
            //response.getWriter().print("{\"success\":false,\"msg\":\"重置失败,旧密码错误\"}");
        }else{
            user.setPassword(password);
            userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
            boolean flag = userService.changePwd(user);
            if(flag){
                session.setAttribute("user",user);
                map.put("success",true);
                map.put("msg","修改成功");
                JSONUtil.getJSON(response,map);
                //response.getWriter().print("{\"success\":true,\"msg\":\"重置成功\"}");
            }else{
                map.put("success",false);
                map.put("msg","修改失败");
                JSONUtil.getJSON(response,map);
                //response.getWriter().print("{\"success\":false,\"msg\":\"重置失败\"}");
            }
        }
    }
    private void updateUser(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入修改个人信息adminInfo...");
        String name = request.getParameter("name");
        String email = request.getParameter("email");
        String remark = request.getParameter("remark");
        User user = (User) request.getSession().getAttribute("user");
        user.setName(name);
        user.setEmail(email);
        user.setRemark(remark);
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
        boolean flag = userService.updateUser(user);
        if(flag){
            request.getSession().setAttribute("user",user);
        }
        response.getWriter().print(flag);
    }
    private void getUsers(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入getUsers方法");
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
      List<User> userList = userService.getUsers();
        JSONUtil.getJSON(response,userList);
    }
    private void login(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入login方法");
        userService = (UserService) ServiceFactory.getService(new UserServiceImpl());
      String username = request.getParameter("username");
        String password = SecureUtil.md5(request.getParameter("password"));
        Map<String,Object> map = new HashMap<>();
        try {
            User user = userService.login(username,password);
            request.getSession().setAttribute("user",user);
            map.put("success",true);
            JSONUtil.getJSON(response,map);
        } catch (Exception e) {
            String msg = e.getMessage();
            map.put("success",false);
            map.put("msg",msg);
            JSONUtil.getJSON(response,map);
        }
    }
}
package com.crsbg.controller;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.IdUtil;
import com.crsbg.entity.PageVO;
import com.crsbg.entity.Permission;
import com.crsbg.entity.Role;
import com.crsbg.service.PermissionService;
import com.crsbg.service.RoleService;
import com.crsbg.service.impl.PermissionServiceImpl;
import com.crsbg.service.impl.RoleServiceImpl;
import com.crsbg.utils.JSONUtil;
import com.crsbg.utils.ServiceFactory;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 * 角色管理控制器
 */
public class RoleController extends HttpServlet {
  private RoleService roleService = null;
  @Override
  protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String path = request.getServletPath();
      if("/controller/getRoleList".equals(path)){
            getRoleList(request,response);
        }else if("/controller/addRole".equals(path)){
            addRole(request,response);
        }else if("/controller/deleteRoles".equals(path)){
            deleteRoles(request,response);
        }else if("/controller/getPermissionIds".equals(path)){
            getPermissionIds(request,response);
        }else if("/controller/updateRole".equals(path)){
            updateRole(request,response);
        }
  }
    private void updateRole(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入修改角色信息updateRole...");
        String id = request.getParameter("id");
        String name = request.getParameter("name");
        String orderNo = request.getParameter("orderNo");
        String[] permissionIds = request.getParameterValues("permissionIds");
        Role role = new Role();
        role.setId(id);
        role.setName(name);
        role.setOrderNo(orderNo);
        roleService = (RoleService) ServiceFactory.getService(new RoleServiceImpl());
        Map<String,Object> map = roleService.updateRole(role,permissionIds);
        JSONUtil.getJSON(response,map);
    }
    private void getPermissionIds(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入查询当前角色权限getPermissionIds...");
        String roleId = request.getParameter("roleId");
        roleService = (RoleService) ServiceFactory.getService(new RoleServiceImpl());
        List<String> permissionIds = roleService.getPermissionIds(roleId);
        Map<String,List<String>> map = new HashMap<>();
        map.put("pids",permissionIds);
        JSONUtil.getJSON(response,map);
    }
    private void deleteRoles(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入批量删除角色deleteRoles...");
        String[] ids = request.getParameterValues("id");
        roleService = (RoleService) ServiceFactory.getService(new RoleServiceImpl());
        boolean flag = roleService.deleteRoles(ids);
        response.getWriter().print(flag);
    }
    private void addRole(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入添加角色addRole...");
        String name = request.getParameter("name");
        String orderNo = request.getParameter("orderNo");
        String[] permissionIds = request.getParameterValues("permissionIds");
        Role role = new Role();
        role.setId(IdUtil.simpleUUID());
        role.setName(name);
        role.setOrderNo(orderNo);
        role.setCreateTime(DateUtil.now());
        roleService = (RoleService) ServiceFactory.getService(new RoleServiceImpl());
        Map<String,Object> map = roleService.addRole(role,permissionIds);
        if((boolean)map.get("success")){
            updateApplication(request,response);
        }
        JSONUtil.getJSON(response,map);
    }
    private void getRoleList(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入获取角色列表getPermissionList...");
        String name = request.getParameter("name");
        int page = Integer.parseInt(request.getParameter("page"));
        int limit = Integer.parseInt(request.getParameter("limit"));
        int pageNumber = (page-1)*limit;
        int pageSize = limit;
        Map<String,Object> param = new HashMap<>();
        param.put("name",name);
        param.put("pageNumber",pageNumber);
        param.put("pageSize",pageSize);
        roleService = (RoleService) ServiceFactory.getService(new RoleServiceImpl());
        PageVO<Role> vo = roleService.getRoleList(param);
        Map<String,Object> map = new HashMap<>();
        map.put("code",0);
        map.put("message","请求成功");
        map.put("count",vo.getTotal());
        map.put("data",vo.getDatas());
        JSONUtil.getJSON(response,map);
    }
    //更新application中的缓存
    private void updateApplication(HttpServletRequest request, HttpServletResponse response){
        ServletContext application = request.getServletContext();
        RoleService roleService = (RoleService) ServiceFactory.getService(new RoleServiceImpl());
        List<Role> roleList = roleService.getRole();
        application.setAttribute("roles",roleList);
    }
}
package com.crsbg.controller;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.util.IdUtil;
import cn.hutool.crypto.SecureUtil;
import com.crsbg.entity.PageVO;
import com.crsbg.entity.Permission;
import com.crsbg.entity.User;
import com.crsbg.service.PermissionService;
import com.crsbg.service.UserService;
import com.crsbg.service.impl.PermissionServiceImpl;
import com.crsbg.service.impl.UserServiceImpl;
import com.crsbg.utils.JSONUtil;
import com.crsbg.utils.ServiceFactory;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 * 权限管理控制器
 */
public class PermissionController extends HttpServlet {
  private PermissionService permissionService = null;
  @Override
  protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String path = request.getServletPath();
      if("/controller/getPermissionList".equals(path)){
            getPermissionList(request,response);
        }else if("/controller/addPermission".equals(path)){
            addPermission(request,response);
        }else if("/controller/updatePermission".equals(path)){
            updatePermission(request,response);
        }else if("/controller/deletePermissions".equals(path)){
            deletePermissions(request,response);
        }
  }
    private void deletePermissions(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入批量删除权限deletePermissions...");
        String[] ids = request.getParameterValues("id");
        permissionService = (PermissionService) ServiceFactory.getService(new PermissionServiceImpl());
        boolean flag = permissionService.deletePermissions(ids);
        response.getWriter().print(flag);
    }
    private void updatePermission(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入修改权限updatePermission...");
        String id = request.getParameter("id");
        String title = request.getParameter("title");
        String url = request.getParameter("url");
        String orderNo = request.getParameter("orderNo");
        Permission permission = new Permission();
        permission.setId(id);
        permission.setTitle(title);
        permission.setUrl(url);
        permission.setOrderNo(orderNo);
        permissionService = (PermissionService) ServiceFactory.getService(new PermissionServiceImpl());
        boolean flag = permissionService.updatePermission(permission);
        response.getWriter().print(flag);
    }
    private void addPermission(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入添加权限addPermission...");
        String title = request.getParameter("title");
        String url = request.getParameter("url");
        String orderNo = request.getParameter("orderNo");
        Permission permission = new Permission();
        permission.setId(IdUtil.simpleUUID());
        permission.setTitle(title);
        permission.setUrl(url);
        permission.setOrderNo(orderNo);
        permission.setCreateTime(DateUtil.now());
        permissionService = (PermissionService) ServiceFactory.getService(new PermissionServiceImpl());
        Map<String,Object> map = permissionService.addPermission(permission);
        if((boolean)map.get("success")){
            updateApplication(request,response);
        }
        JSONUtil.getJSON(response,map);
    }
    private void getPermissionList(HttpServletRequest request, HttpServletResponse response) throws IOException {
        System.out.println("进入获取权限列表getPermissionList...");
        String title = request.getParameter("title");
        int page = Integer.parseInt(request.getParameter("page"));
        int limit = Integer.parseInt(request.getParameter("limit"));
        int pageNumber = (page-1)*limit;
        int pageSize = limit;
        Map<String,Object> param = new HashMap<>();
        param.put("title",title);
        param.put("pageNumber",pageNumber);
        param.put("pageSize",pageSize);
        permissionService = (PermissionService) ServiceFactory.getService(new PermissionServiceImpl());
        PageVO<Permission> vo = permissionService.getPermissionList(param);
        Map<String,Object> map = new HashMap<>();
        map.put("code",0);
        map.put("message","请求成功");
        map.put("count",vo.getTotal());
        map.put("data",vo.getDatas());
        JSONUtil.getJSON(response,map);
    }
    //更新application中的缓存
    private void updateApplication(HttpServletRequest request, HttpServletResponse response){
        ServletContext application = request.getServletContext();
      PermissionService permissionService = (PermissionService) ServiceFactory.getService(new PermissionServiceImpl());
        List<Permission> permissionList = permissionService.getPermission();
        application.setAttribute("permissions",permissionList);
    }
}
相关文章
|
4月前
|
安全 数据挖掘 数据安全/隐私保护
国产CRM品牌巡礼:系统品牌的核心优势与特色
本文深度解析国产CRM系统的四大知名品牌:销售易、神州云动、销帮帮和天衣云。 销售易:中国领先的CRM解决方案提供商,提供全渠道获客、智能化销售流程及AIGC技术应用,赢得500强企业信赖。 神州云动:以PaaS+SaaS模式、灵活定制和行业解决方案著称,支持企业实现客户关系管理的数字化和智能化。 销帮帮:面向中小企业的实用型CRM系统,提供销售跟踪、客户视图等功能,提高销售效率和客户满意度。 天衣云:专注于云端部署,提供快速部署、高安全性的CRM解决方案,确保企业信息安全。 各品牌各有特色,企业应根据自身需求选择合适的CRM系统,以实现客户关系的全面管理,提升业务效率和客户满意度。
|
5月前
|
搜索推荐 数据库 UED
CRM系统源码|客户管理系统源码开发
CRM系统通过提供个性化的用户体验、提高生产力、改善客户体验和增加销售额来助力企业成长。集成CRM能自动化数据输入,减少管理时间,提高销售代表的效率。此外,CRM还能增强客户互动,降低跳出率,增加透明度,确保整个公司的协调合作。
145 5
|
5月前
|
机器学习/深度学习 人工智能 运维
电话机器人源码-智能ai系统-freeswitch-smartivr呼叫中心-crm
电话机器人源码-智能ai系统-freeswitch-smartivr呼叫中心-crm
244 0
|
8月前
|
搜索推荐
实现CRM与ERP系统无缝集成,优化客户关系管理
在当今竞争激烈的市场环境中,企业要想保持领先地位,必须高效地管理客户关系并优化内部资源。CRM(客户关系管理)系统与ERP(企业资源规划)系统的无缝集成,为企业提供了一种强大的工具,以实现这一目标
108 2
|
8月前
|
Web App开发 前端开发 关系型数据库
基于SpringBoot+Vue+Redis+Mybatis的商城购物系统 【系统实现+系统源码+答辩PPT】
这篇文章介绍了一个基于SpringBoot+Vue+Redis+Mybatis技术栈开发的商城购物系统,包括系统功能、页面展示、前后端项目结构和核心代码,以及如何获取系统源码和答辩PPT的方法。
|
8月前
|
供应链 前端开发 Java
服装库存管理系统 Mybatis+Layui+MVC+JSP【完整功能介绍+实现详情+源码】
该博客文章介绍了一个使用Mybatis、Layui、MVC和JSP技术栈开发的服装库存管理系统,包括注册登录、权限管理、用户和货号管理、库存管理等功能,并提供了源码下载链接。
服装库存管理系统 Mybatis+Layui+MVC+JSP【完整功能介绍+实现详情+源码】
|
8月前
|
Java 数据库连接 mybatis
基于SpringBoot+MyBatis的餐饮点餐系统
本文介绍了一个基于SpringBoot和MyBatis开发的餐饮点餐系统,包括系统的主控制器`IndexController`的代码实现,该控制器负责处理首页、点餐、登录、注册、订单管理等功能,适用于毕业设计项目。
103 0
基于SpringBoot+MyBatis的餐饮点餐系统
|
8月前
|
供应链 前端开发 Java
JSP+servlet+mybatis+layui服装库存管理系统(大三上学期课程设计)
这篇文章通过一个服装库存管理系统的实例,展示了在Spring Boot项目中使用Ajax、JSON、layui、MVC架构和iframe等技术,涵盖了注册登录、权限管理、用户管理、库存管理等功能,并提供了系统运行环境和技术要求的详细说明。
JSP+servlet+mybatis+layui服装库存管理系统(大三上学期课程设计)
|
8月前
|
监控 搜索推荐 数据管理
crm客户管理系统来帮助企业管理和提高运营效率
crm系统帮助企业简化销售流程,提高工作效率。CRM 客户管理系统确实能够在多个方面帮助企业管理和提高运营效率,具体表现如下:
75 3
|
9月前
|
监控 数据挖掘 数据安全/隐私保护
ERP系统中的客户关系管理(CRM)
【7月更文挑战第25天】 ERP系统中的客户关系管理(CRM)
728 3

热门文章

最新文章