Ajax增删改查(ssm+spring boot)

首先导入所需jar包，再连接数据库：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com</groupId>
    <artifactId>manager</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>
    <name>manager</name>
    <description>Demo project for Spring Boot</description>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.4.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- 数据源 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.9</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/com.alipay.sdk/alipay-sdk-java -->
        <dependency>
            <groupId>com.alipay.sdk</groupId>
            <artifactId>alipay-sdk-java</artifactId>
            <version>3.0.0</version>
        </dependency>
        <!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!--json转换工具包-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.47</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

application.properties代码：

server.port=80
spring.mvc.view.prefix=classpath:/templates/
spring.mvc.view.suffix=.html
#thymeleaf start
spring.thymeleaf.mode=HTML5
spring.thymeleaf.encoding=UTF-8
#开发时关闭缓存,不然没法看到实时页面
spring.thymeleaf.cache=false
#thymeleaf end
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql://localhost:3306/ManageDB?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=994994
spring.datasource.driverClassName=com.mysql.jdbc.Driver
mybatis.mapper-locations=classpath:/mybatis/*.xml
mybatis.type-aliases-package=com.manager.pojo
mybatis.configuration.auto-mapping-behavior=full
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#logging.level.org.springframework=WARN
#logging.level.org.spring.springboot.dao=DEBUG
#logging.file=logs/spring-boot-logging.log

员工实体类代码：

package com.manager.pojo;
import com.fasterxml.jackson.annotation.JsonFormat;
import java.util.Date;
public class Employees {
    private Integer e_Id;
    private String e_Code;
    private String e_LoginName;
    private String e_Pwd;
    private String e_RealName;
    private Sex e_Sex;
    private String e_Phone;
    private Role e_Role;
    private Dept e_DeptId;
    private Employees e_Superior;
    private Status e_Status;
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private Date e_CreateTime;
    private Employees e_ModifyId;
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private Date e_ModifyTime;
    private String e_Description;
    private Date e_LastLoginTime;
    public Sex getE_Sex() {
        return e_Sex;
    }
    public void setE_Sex(Sex e_Sex) {
        this.e_Sex = e_Sex;
    }
    public Status getE_Status() {
        return e_Status;
    }
    public void setE_Status(Status e_Status) {
        this.e_Status = e_Status;
    }
    public Employees getE_Superior() {
        return e_Superior;
    }
    public void setE_Superior(Employees e_Superior) {
        this.e_Superior = e_Superior;
    }
    public Employees(){}
    public Employees(String loginName){
        this.e_LoginName = loginName;
    }
    public Employees(Integer id){this.e_Id = id;}
    public String getE_Code() {
        return e_Code;
    }
    public void setE_Code(String e_Code) {
        this.e_Code = e_Code;
    }
    public Date getE_LastLoginTime() {
        return e_LastLoginTime;
    }
    public void setE_LastLoginTime(Date e_LastLoginTime) {
        this.e_LastLoginTime = e_LastLoginTime;
    }
    public Integer getE_Id() {
        return e_Id;
    }
    public void setE_Id(Integer e_Id) {
        this.e_Id = e_Id;
    }
    public String getE_LoginName() {
        return e_LoginName;
    }
    public void setE_LoginName(String e_LoginName) {
        this.e_LoginName = e_LoginName;
    }
    public String getE_Pwd() {
        return e_Pwd;
    }
    public void setE_Pwd(String e_Pwd) {
        this.e_Pwd = e_Pwd;
    }
    public String getE_RealName() {
        return e_RealName;
    }
    public void setE_RealName(String e_RealName) {
        this.e_RealName = e_RealName;
    }
    public String getE_Phone() {
        return e_Phone;
    }
    public void setE_Phone(String e_Phone) {
        this.e_Phone = e_Phone;
    }
    public Role getE_Role() {
        return e_Role;
    }
    public void setE_Role(Role e_Role) {
        this.e_Role = e_Role;
    }
    public Dept getE_DeptId() {
        return e_DeptId;
    }
    public void setE_DeptId(Dept e_DeptId) {
        this.e_DeptId = e_DeptId;
    }
    public Date getE_CreateTime() {
        return e_CreateTime;
    }
    public void setE_CreateTime(Date e_CreateTime) {
        this.e_CreateTime = e_CreateTime;
    }
    public Employees getE_ModifyId() {
        return e_ModifyId;
    }
    public void setE_ModifyId(Employees e_ModifyId) {
        this.e_ModifyId = e_ModifyId;
    }
    public Date getE_ModifyTime() {
        return e_ModifyTime;
    }
    public void setE_ModifyTime(Date e_ModifyTime) {
        this.e_ModifyTime = e_ModifyTime;
    }
    public String getE_Description() {
        return e_Description;
    }
    public void setE_Description(String e_Description) {
        this.e_Description = e_Description;
    }
}

部门实体类代码：

package com.manager.pojo;
public class Dept {
  private Integer d_Id;
  private String d_Name;
  private String d_Intro;
  public String getD_Intro() {
    return d_Intro;
  }
  public void setD_Intro(String d_Intro) {
    this.d_Intro = d_Intro;
  }
  public Integer getD_Id() {
    return d_Id;
  }
  public void setD_Id(Integer d_Id) {
    this.d_Id = d_Id;
  }
  public String getD_Name() {
    return d_Name;
  }
  public void setD_Name(String d_Name) {
    this.d_Name = d_Name;
  }
}

角色表实体类代码：

package com.manager.pojo;
import com.fasterxml.jackson.annotation.JsonFormat;
import java.util.Date;
public class Role {
    private Integer r_Id;
    private String r_Code;
    private String r_Name;
    private Dept r_DeptNo;
    private Employees r_ModifyId;
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd HH:mm:ss")
    private Date r_ModifyTime;
    private String r_Description;
    public Role(){
    }
    public Role(Integer id){
        this.r_Id = id;
    }
    public Integer getR_Id() {
        return r_Id;
    }
    public void setR_Id(Integer r_Id) {
        this.r_Id = r_Id;
    }
    public String getR_Code() {
        return r_Code;
    }
    public void setR_Code(String r_Code) {
        this.r_Code = r_Code;
    }
    public String getR_Name() {
        return r_Name;
    }
    public void setR_Name(String r_Name) {
        this.r_Name = r_Name;
    }
    public Dept getR_DeptNo() {
        return r_DeptNo;
    }
    public void setR_DeptNo(Dept r_DeptNo) {
        this.r_DeptNo = r_DeptNo;
    }
    public Employees getR_ModifyId() {
        return r_ModifyId;
    }
    public void setR_ModifyId(Employees r_ModifyId) {
        this.r_ModifyId = r_ModifyId;
    }
    public Date getR_ModifyTime() {
        return r_ModifyTime;
    }
    public void setR_ModifyTime(Date r_ModifyTime) {
        this.r_ModifyTime = r_ModifyTime;
    }
    public String getR_Description() {
        return r_Description;
    }
    public void setR_Description(String r_Description) {
        this.r_Description = r_Description;
    }
}

员工类xml代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.manager.mapper.EmployeesMapper">
    <resultMap id="EmployeesMap" type="Employees">
        <id column="e_id" property="e_Id"/>
        <association property="e_ModifyId" javaType="Employees">
            <id column="e1_id" property="e_Id"/>
            <result column="e1_realName" property="e_RealName"/>
        </association>
        <association property="e_Role" javaType="Role">
            <id column="r_id" property="r_Id"/>
        </association>
        <association property="e_DeptId" javaType="Dept">
            <id column="d_id" property="d_Id"/>
        </association>
        <association property="e_Superior" javaType="Employees">
            <id column="e1_id" property="e_Id"/>
            <result column="e1_realName" property="e_RealName"/>
        </association>
        <association property="e_Sex" javaType="Sex">
            <id column="sex_id" property="sex_Id"/>
        </association>
        <association property="e_Status" javaType="Status">
            <id column="st_id" property="st_Id"/>
        </association>
    </resultMap>
    <select id="lowerList" resultMap="EmployeesMap">
        select e.*,d.*,r.*,s.*,st.*,e1.e_realName e1_realName,e1.e_id e1_id from employees e,dept d, role r,sex s,status
        st,employees e1
        <trim prefix="where" prefixOverrides="and">
            e.e_role = r.r_id and e.e_deptid = d.d_id and e.e_modifyId = e1.e_id and e.e_sex = s.sex_id and e.e_status =
            st.st_id
            <if test="e_Id != null">
                and e.e_Superior = #{e_Id}
            </if>
        </trim>
    </select>
    <select id="getEmployees" resultMap="EmployeesMap">
        select e.*,d.*,r.*,s.*,st.*,e1.e_realName e1_realName,e1.e_id e1_id from employees e,dept d, role r,sex s,status
        st,employees e1
        <trim prefix="where" prefixOverrides="and">
            e.e_role = r.r_id and e.e_deptid = d.d_id and e.e_modifyId = e1.e_id and e.e_sex = s.sex_id and e.e_status =
            st.st_id
            <if test="e_LoginName != null and e_LoginName != ''">
                and e.e_loginName = #{e_LoginName}
            </if>
            <if test="e_Id != null">
                and e.e_id = #{e_Id}
            </if>
        </trim>
    </select>
    <select id="employeeList" resultMap="EmployeesMap">
        select e.*,d.*,r.*,s.*,st.*,e1.e_realName e1_realName,e1.e_id e1_id from employees e,dept d, role r,sex s,status
        st,employees e1
        <trim prefix="where" prefixOverrides="and">
            e.e_role = r.r_id and e.e_deptid = d.d_id and e.e_modifyId = e1.e_id and e.e_sex = s.sex_id and e.e_status =
            st.st_id
            <if test="employee.e_RealName != null and employee.e_RealName != ''">
                and e.e_RealName like concat('%',#{employee.e_RealName},'%')
            </if>
            limit #{begin},#{end}
        </trim>
    </select>
    <select id="count" resultType="int">
        select count(*) from employees e,dept d, role r,sex s,status st
        <trim prefix="where" prefixOverrides="and">
            e.e_role = r.r_id and e.e_deptid = d.d_id and e.e_modifyId = e.e_id and e.e_sex = s.sex_id and e.e_status =
            st.st_id
            <if test="e_RealName != null and e_RealName != ''">
                and e.e_RealName like concat('%',#{e_RealName},'%')
            </if>
        </trim>
    </select>
    <update id="alterEmployees">
        update employees
        <trim prefix="set" suffixOverrides="," suffix="where e_Id = #{e_Id}">
            <if test="e_LastLoginTime != null">
                e_lastLoginTime = #{e_LastLoginTime},
            </if>
            <if test="e_Phone != null">
                e_Phone = #{e_Phone},
            </if>
            <if test="e_Pwd != null">
                e_Pwd = #{e_Pwd},
            </if>
            <if test="e_Code != null">
                e_Code = #{e_Code},
            </if>
            <if test="e_RealName != null">
                e_RealName = #{e_RealName},
            </if>
            <if test="e_Description != null">
                e_Description = #{e_Description},
            </if>
            <if test="e_Sex != null">
                e_Sex = #{e_Sex.sex_Id},
            </if>
            <if test="e_Status != null">
                e_Status = #{e_Status.st_Id},
            </if>
            <if test="e_DeptId != null">
                e_DeptId = #{e_DeptId.d_Id},
            </if>
        </trim>
    </update>
    <delete id="deleteEmployees">
        delete from employees where e_id = #{e_Id}
    </delete>
    <insert id="addEmployees">
        insert into employees values (default,#{e_Code},#{e_LoginName},#{e_Pwd},#{e_RealName},#{e_Sex.sex_Id},#{e_Phone},#{e_Role.r_Id},#{e_DeptId.d_Id},#{e_Superior.e_Id},#{e_Status.st_Id},#{e_CreateTime},#{e_ModifyId.e_Id},#{e_ModifyTime},#{e_LastLoginTime},#{e_Description})
    </insert>
    <select id="existEmployeeCode" resultType="Employees">
        select * from employees where 1=1
        <if test="e_Code!=null">
            and e_Code = #{e_Code}
        </if>
    </select>
    <select id="existEmployeeLoginName" resultType="Employees">
        select * from employees where 1=1
        <if test="e_LoginName!=null">
            and e_LoginName = #{e_LoginName}
        </if>
    </select>
</mapper>

部门xml代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.manager.mapper.DeptMapper">
    <select id="deptAll" resultType="Dept">
        select * from dept
    </select>
</mapper>

角色xml代码：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.manager.mapper.RoleMapper">
    <resultMap id="roleMap" type="Role">
        <id column="r_id" property="r_Id"/>
        <association property="r_DeptNo" javaType="Dept">
            <id column="d_id" property="d_Id"/>
        </association>
        <association property="r_ModifyId" javaType="Employees">
            <id column="e_id" property="e_Id"/>
        </association>
    </resultMap>
    <select id="roleList" resultMap="roleMap">
        SELECT r.*,e.*,d.* FROM role r,employees e,dept d
        <trim prefix="where" prefixOverrides="and">
            r.r_modifyId = e.e_id AND r.r_deptNo = d.d_id
            <if test="role.r_Name != null and role.r_Name != ''">
                and r_Name like concat('%',#{role.r_Name},'%')
            </if>
            limit #{begin},#{end}
        </trim>
    </select>
    <select id="count" resultType="int">
        select count(*) from role r,employees e,dept d
        <trim prefix="where" prefixOverrides="and">
            r.r_modifyId = e.e_id AND r.r_deptNo = d.d_id
            <if test="r_Name != null and r_Name != ''">
                and r_Name like concat('%',#{r_Name},'%')
            </if>
        </trim>
    </select>
    <select id="getRole" resultMap="roleMap">
        SELECT r.*,e.*,d.* FROM role r,employees e,dept d
        <trim prefix="where" prefixOverrides="and">
            r.r_modifyId = e.e_id AND r.r_deptNo = d.d_id
            <if test="r_Id != null and r_Id != ''">
                and r_id = #{r_Id}
            </if>
        </trim>
    </select>
    <select id="roleAll" resultType="Role">
        select * from role
    </select>
    <update id="modify">
        update role
        <trim prefix="set" suffixOverrides="," suffix="where r_code = #{r_Code}">
            <if test="r_DeptNo.d_Id != null and r_DeptNo.d_Id != 0">
                r_deptNo = #{r_DeptNo.d_Id},
            </if>
            <if test="r_ModifyId != null">
                r_ModifyId = #{r_ModifyId.e_Id},
            </if>
            <if test="r_ModifyTime != null">
                r_ModifyTime = #{r_ModifyTime},
            </if>
            <if test="r_Description != null">
                r_Description = #{r_Description},
            </if>
        </trim>
    </update>
    <delete id="delRole">
        delete from role where r_id = #{r_Id}
    </delete>
    <insert id="addRole">
        insert into role values(default,#{r_Code},#{r_Name},#{r_DeptNo.d_Id},#{r_ModifyId.e_Id},#{r_ModifyTime},#{r_Description})
    </insert>
    <select id="validationRole" resultType="int">
        select count(*) from role
        <trim prefix="where" prefixOverrides="and">
            <if test="r_Code != null and r_Code != ''">
                and r_Code = #{r_Code}
            </if>
            <if test="r_Name != null and r_Name != ''">
                and r_Name = #{r_Name}
            </if>
        </trim>
    </select>
</mapper>

员工Mapper层代码：

package com.manager.mapper;
import com.manager.pojo.Employees;
import java.util.List;
import java.util.Map;
public interface EmployeesMapper {
    Employees getEmployees(Employees employees);
    int alterEmployees(Employees employees);
    List<Employees> employeeList(Map map);
    int count(Employees employees);
    List<Employees> lowerList(Employees employees);
    int deleteEmployees(Employees employees);
    int addEmployees(Employees employees);
    Employees existEmployeeCode(Employees employees);
    Employees existEmployeeLoginName(Employees employees);
}

部门Mapper层代码：

package com.manager.mapper;
import com.manager.pojo.Dept;
import java.util.List;
public interface DeptMapper {
    List<Dept> deptAll();
}

角色Mapper层代码：

package com.manager.mapper;
import com.manager.pojo.Role;
import java.util.List;
import java.util.Map;
public interface RoleMapper {
    List<Role> roleList(Map map);
    int count(Role role);
    Role getRole(Role role);
    List<Role> roleAll();
    int modify(Role role);
    int delRole(Role role);
    int addRole(Role role);
    int validationRole(Role role);
}

员工Service层代码：

package com.manager.service.users;
import com.manager.pojo.Employees;
import java.util.List;
public interface EmployeesService {
    Employees getEmployees(Employees employees);
    int alterEmployees(Employees employees);
    List<Employees> employeeList(Integer begin, Integer end, Employees employees);
    int count(Employees employees);
    List<Employees> lowerList(Employees employees);
    int deleteEmployees(Employees employees);
    int addEmployees(Employees employees);
    String existEmployeeCode(Employees employees);
    String existEmployeeLoginName(Employees employees);
}

员工ServiceImpl代码：

package com.manager.service.users;
import com.alibaba.fastjson.JSON;
import com.manager.mapper.EmployeesMapper;
import com.manager.pojo.Employees;
import org.apache.ibatis.session.SqlSession;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Service
public class EmployeesServiceImpl implements EmployeesService {
    @Resource
    private EmployeesMapper employeesMapper;
    @Override
    public Employees getEmployees(Employees employees) {
        Employees newEmployees = employeesMapper.getEmployees(employees);
        return newEmployees;
    }
    @Override
    public List<Employees> lowerList(Employees employees) {
        return employeesMapper.lowerList(employees);
    }
    @Override
    public int deleteEmployees(Employees employees) {
        return employeesMapper.deleteEmployees(employees);
    }
    @Override
    public int addEmployees(Employees employees) {
        return employeesMapper.addEmployees(employees);
    }
    @Override
    public String existEmployeeCode(Employees employees) {
        return JSON.toJSONString(employeesMapper.existEmployeeCode(employees));
    }
    @Override
    public String existEmployeeLoginName(Employees employees) {
        return JSON.toJSONString(employeesMapper.existEmployeeLoginName(employees));
    }
    @Override
    @Transactional
    public int alterEmployees(Employees employees) {
        return employeesMapper.alterEmployees(employees);
    }
    @Override
    public List<Employees> employeeList(Integer begin, Integer end, Employees employees) {
        Map<String, Object> map = new HashMap<>();
        map.put("begin", begin);
        map.put("end", end);
        map.put("employee", employees);
        return employeesMapper.employeeList(map);
    }
    @Override
    public int count(Employees employees) {
        return employeesMapper.count(employees);
    }
}

部门Service层代码：

package com.manager.service.dept;
import com.manager.pojo.Dept;
import java.util.List;
public interface DeptService {
    List<Dept> deptAll();
}

部门ServiceImpl代码：

package com.manager.service.dept;
import com.manager.mapper.DeptMapper;
import com.manager.pojo.Dept;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Service
public class DeptServiceImpl  implements DeptService {
    @Resource
    private DeptMapper deptMapper;
    @Override
    public List<Dept> deptAll() {
        return deptMapper.deptAll();
    }
}

角色Service层代码：

package com.manager.service.role;
import com.manager.pojo.Role;
import java.util.List;
public interface RoleService {
    List<Role> roleList(Role role,Integer begin,Integer end);
    int count(Role role);
    Role getRole(Role role);
    List<Role> roleAll();
    int modify(Role role);
    int delRole(Role role);
    int addRole(Role role);
    int validationRole(Role role);
}

角色ServiceImpl代码：

package com.manager.service.role;
import com.manager.mapper.RoleMapper;
import com.manager.pojo.Role;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Service
public class RoleServiceImpl implements RoleService {
    @Resource
    private RoleMapper roleMapper;
    @Override
    public List<Role> roleList(Role role,Integer begin,Integer end) {
        Map<String,Object> map = new HashMap<String,Object>();
        map.put("role",role);
        map.put("begin",begin);
        map.put("end",end);
        return roleMapper.roleList(map);
    }
    @Override
    public int count(Role role) {
        return roleMapper.count(role);
    }
    @Override
    public Role getRole(Role role) {
        return roleMapper.getRole(role);
    }
    @Override
    public List<Role> roleAll() {
        return roleMapper.roleAll();
    }
    @Override
    @Transactional
    public int modify(Role role) {
        return roleMapper.modify(role);
    }
    @Override
    @Transactional
    public int delRole(Role role) {
        return roleMapper.delRole(role);
    }
    @Override
    public int addRole(Role role) {
        return roleMapper.addRole(role);
    }
    @Override
    public int validationRole(Role role) {
        return roleMapper.validationRole(role);
    }
}

员工Controller控制层代码：

package com.manager.control.employees;
import com.alibaba.fastjson.JSON;
import com.manager.pojo.Dept;
import com.manager.pojo.Employees;
import com.manager.pojo.Role;
import com.manager.service.dept.DeptService;
import com.manager.service.role.RoleService;
import com.manager.service.users.EmployeesService;
import com.manager.util.MD5Util;
import com.manager.util.PageUtil;
import com.manager.util.PwdUtil;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import javax.annotation.Resource;
import javax.servlet.http.HttpSession;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@Controller
public class EmployeesContorller {
    @Resource
    private EmployeesService employeesService;
    @Resource
    private DeptService deptService;
    @Resource
    private RoleService roleService;
    @RequestMapping(value = "/login", method = RequestMethod.POST)
    @ResponseBody
    public Object loginajax(HttpSession session, Employees employees) {
        Map<String, String> map = new HashMap<>();
        Employees employee = employeesService.getEmployees(employees);
        if (employee != null) {
            String pwd = MD5Util.EncoderByMd5(employees.getE_Pwd());
            if (pwd.equals(employee.getE_Pwd())) {
                session.setAttribute("loginEmployee", employee);//登陆成功保存会话
                employee.setE_LastLoginTime(new Date());
                employeesService.alterEmployees(employee);
            } else {
                map.put("msg", "false");
            }
        } else {
            map.put("msg", "null");
        }
        return map;
    }
    @RequestMapping("/login.html")
    public String login() {
        return "login";
    }
    @RequestMapping("/userOut")
    public String userOut(HttpSession session) {
        session.invalidate();
        return "login";
    }
    @RequestMapping(value = "/modifyEmployees")
    @ResponseBody
    public Object modifyEmployees(Employees employees) {
        int i = employeesService.alterEmployees(employees);
        if (i == 1) {
            return "true";
        } else {
            return "false";
        }
    }
    @RequestMapping("/JumpEmpAdd")
    public String jumpEmpAdd(Model model,Employees employees) {
        List<Dept> depts = deptService.deptAll();
        List<Role> roles = roleService.roleAll();
        List<Employees> employee = employeesService.employeeList(1,99,employees);
        model.addAttribute("depts",depts);
        model.addAttribute("roles",roles);
        model.addAttribute("employees",employee);
        return "sysemployeeAdd";
    }
    @RequestMapping("/AddEmployees")
    @ResponseBody
    public Object addEmployees(Employees employees,HttpSession session) {
        employees.setE_CreateTime(new Date());
        employees.setE_LastLoginTime(new Date());
        employees.setE_ModifyTime(new Date());
        employees.setE_ModifyId((Employees) session.getAttribute("loginEmployee"));
        int i = employeesService.addEmployees(employees);
        if (i == 1) {
            return "true";
        } else {
            return "false";
        }
    }
    @RequestMapping("/DeleteEmployees")
    @ResponseBody
    public Object deleteEmployee(Employees employees) {
        int i = employeesService.deleteEmployees(employees);
        if (i == 1) {
            return "true";
        } else {
            return "false";
        }
    }
    @RequestMapping(value = "modifyPwd", method = RequestMethod.POST)
    @ResponseBody
    public Object modifyPwd(HttpSession session, PwdUtil pwd) {
        Map<String, String> map = new HashMap<>();
        int result = 0;
        Employees employees = employeesService.getEmployees(new Employees(pwd.getLoginName()));
        if (employees.getE_Pwd().equals(MD5Util.EncoderByMd5(pwd.getOldPwd()))) {
            if (pwd.getNewPwd().equals(pwd.getConfirmNewPwd())) {
                employees.setE_Pwd(MD5Util.EncoderByMd5(pwd.getConfirmNewPwd()));
                result = employeesService.alterEmployees(employees);
                if (result == 1) {
                    session.invalidate();
                    map.put("msg", "true");
                } else {
                    map.put("msg", "false");
                }
            } else {
                map.put("msg", "Don't match");
            }
        } else {
            map.put("msg", "error");
        }
        return map;
    }
    @RequestMapping("/getEmployee")
    public ModelAndView getEmployee(HttpSession session) {
        ModelAndView mv = new ModelAndView();
        Employees employee = (Employees) session.getAttribute("loginEmployee");
        Employees newEmployee = employeesService.getEmployees(employee);
        mv.addObject("newEmployee", newEmployee);
        mv.setViewName("syspersonalInfo");
        return mv;
    }
    @RequestMapping(value = "/employeeList", method = RequestMethod.POST)
    @ResponseBody
    public Object employeeList(@RequestParam(name = "draw", required = false, defaultValue = "0") int draw,
                               @RequestParam(name = "start", required = false, defaultValue = "0") int start,
                               @RequestParam(name = "length", required = false, defaultValue = "0") int length,
                               Employees employees) {
        PageUtil<Employees> pageUtil = new PageUtil<>();
        List<Employees> employeesList = employeesService.employeeList(start, length, employees);
        int count = employeesService.count(employees);
        pageUtil.setData(employeesList);
        pageUtil.setDraw(draw);
        pageUtil.setRecordsTotal(count);
        pageUtil.setRecordsFiltered(count);
        return pageUtil;
    }
    @RequestMapping("/getEmployee/{id}/{str}")
    public ModelAndView getEmployee(@PathVariable Integer id, @PathVariable String str) {
        ModelAndView mv = new ModelAndView();
        Employees employee = new Employees(id);
        Employees newEmployee = employeesService.getEmployees(employee);
        List<Dept> depts = deptService.deptAll();
        mv.addObject("newEmployee", newEmployee);
        mv.addObject("depts", depts);
        if (str.equals("get")) {
            mv.setViewName("sysemployeeInfo");
        } else {
            mv.setViewName("sysemployeemodify");
        }
        return mv;
    }
    @RequestMapping("/ExistCode")
    @ResponseBody
    public Object existCode(Employees employees){
        return JSON.toJSONString(employeesService.existEmployeeCode(employees));
    }
    @RequestMapping("/ExistLoginName")
    @ResponseBody
    public Object existLoginName(Employees employees){
        return JSON.toJSONString(employeesService.existEmployeeLoginName(employees));
    }
}

部门Controller控制层代码：

package com.manager.control.dept;
import com.manager.pojo.Dept;
import com.manager.service.dept.DeptService;
import com.manager.util.PageUtil;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import javax.annotation.Resource;
import java.util.List;
@Controller
public class DeptContorller {
    @Resource
    private DeptService deptService;
    @RequestMapping(value = "/deptAll",method = RequestMethod.POST)
    @ResponseBody
    public Object deptAll(){
        List<Dept> depts = deptService.deptAll();
        return depts;
    }
}

角色Controller控制层代码：

package com.manager.control.role;
import com.manager.pojo.Dept;
import com.manager.pojo.Employees;
import com.manager.pojo.Role;
import com.manager.service.dept.DeptService;
import com.manager.service.role.RoleService;
import com.manager.util.PageUtil;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.servlet.ModelAndView;
import javax.annotation.Resource;
import javax.servlet.http.HttpSession;
import java.util.Date;
import java.util.List;
@Controller
public class RoleController {
    @Resource
    private RoleService roleService;
    @Resource
    private DeptService deptService;
    @RequestMapping(value = "/roleList")
    @ResponseBody
    public Object roleList(@RequestParam(name = "draw",required = false,defaultValue = "0")int draw,
                           @RequestParam(name = "start",required = false,defaultValue = "0")int start,
                           @RequestParam(name = "length",required = false,defaultValue = "0")int length,
                           Role role){
        PageUtil<Role> pageUtil = new PageUtil<Role>();
        int count = roleService.count(role);
        List<Role> roles = roleService.roleList(role,start,length);
        pageUtil.setData(roles);
        pageUtil.setDraw(draw);
        pageUtil.setRecordsFiltered(count);
        pageUtil.setRecordsTotal(count);
        return pageUtil;
    }
    @RequestMapping("/getRole/{id}/{str}")
    public ModelAndView getRole(@PathVariable("id")Integer id, @PathVariable("str")String str){
        ModelAndView mv = new ModelAndView();
        mv.setViewName("sysroleInfo");
        List<Dept> depts = null;
        Role role = new Role(id);
        Role newRole = roleService.getRole(role);
        if(str.equals("modify")){
            depts = deptService.deptAll();
            mv.setViewName("sysrolemodify");
        }
        mv.addObject("newRole",newRole);
        mv.addObject("depts",depts);
        return mv;
    }
    @RequestMapping(value = "/modifyRole",method = RequestMethod.POST)
    @ResponseBody
    public Object modifyRole(HttpSession session,Role role){
        role.setR_ModifyTime(new Date());
        Employees employees = (Employees) session.getAttribute("loginEmployee");
        role.setR_ModifyId(employees);
        int modify = roleService.modify(role);
        if(modify==1){
            return "true";
        }
        return "false";
    }
    @RequestMapping(value = "/delRole",method = RequestMethod.POST)
    @ResponseBody
    public Object delRole(Role role){
        int i = roleService.delRole(role);
        if(i==1){
            return "true";
        }
        return "false";
    }
    @RequestMapping(value = "/addRole",method = RequestMethod.POST)
    @ResponseBody
    public Object addRole(HttpSession session,Role role){
        role.setR_ModifyTime(new Date());
        role.setR_ModifyId((Employees) session.getAttribute("loginEmployee"));
        int i = roleService.addRole(role);
        if(i==1){
            return "true";
        }
        return "false";
    }
    @RequestMapping(value = "/validationRole",method = RequestMethod.POST)
    @ResponseBody
    public Object validationRole(Role role){
        int i = roleService.validationRole(role);
        if(i==1){
            return "true";
        }
        return "false";
    }
}