【SaaS - Export项目】14 - RBAC权限 - 单表用户User的CRUD

╰+攻爆jí腚メ 2022-12-19 00:56 95阅读 0赞

### 文章目录 ###

*   *  用户模块User
     *   *  1. export\_domain子工程User用户（员工）类
         *  2. export\_system\_service子工程编写测试类测试用户的CRUD
         *  3. export\_system\_service子工程的service接口和实现类
         *  4. export\_dao子工程写dao接口及其映射
         *  5. export\_web\_manager子工程编写controller
         *  6. export\_web\_manager子工程编写jsp页面

## 用户模块User ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0_size_16_color_FFFFFF_t_70_pic_center]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0_size_16_color_FFFFFF_t_70_pic_center 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0_size_16_color_FFFFFF_t_70_pic_center 2]

### 1. export\_domain子工程User用户（员工）类 ###

//用户表
    public class User { 
        private String userId;
        //所在部门
        private String deptId;
        private String email;
        private String userName;
        private String station;
        private String password;
        private long state;
        private String companyId;
        private String companyName;
        private String deptName;
        private String managerId;
        private String gender;
        private String telephone;
        private String birthday;
        private int degree;
        private double salary;
        private String joinDate;
        private long orderNo;
        private String createBy;
        private String createDempt;
        private Date createTime;
        private String updateBy;
        private Date updateTime;
        private String remark;
    }

### 2. export\_system\_service子工程编写测试类测试用户的CRUD ###

`TestUserService`

@RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration("classpath*:spring/applicationContext-*.xml")
    public class TestUserService { 
        //记录日志
        private static final Logger l = LoggerFactory.getLogger(TestUserService.class);
    
    
        @Autowired
        IUserService iUserService;
    
        //测试通过公司id查询所有公司用户，分页显示
        @Test
        public void test01(){ 
            String companyId="1";
            //作为一个公司用户的管理员，只能查自己公司的员工。分页显示当前第一页，每页3条数据
            PageInfo<User>  pi= iUserService.findByPage(1,3,companyId);
            l.info("pi = "+pi);
        }
    
        //测试新增一个用户
        @Test
        public void test02(){ 
            User user = new User();
            user.setUserName("新增用户addUser");
            user.setDeptId(UUID.randomUUID().toString());
            user.setDeptId("1");
            user.setCompanyId("1");
            iUserService.saveUser(user);
            l.info("增加User --- : " + user);
        }
    
        //更新用户信息
        @Test
        public void test03(){ 
            String userId="899676f8-9de7-4ae0-93f3-61869dc9fedb";
            User user =  iUserService.findUserById(userId);
            l.info("test03 更新 user = "+user);
            //修改
            user.setUserName("update User 更新");
            //保存
            iUserService.updateUser(user);
        }
    
        //测试删除
        @Test
        public void test04(){ 
            //
            //删除业务，就是根据指定的id，删除数据库中的记录
            String userId="899676f8-9de7-4ae0-93f3-61869dc9fedb";
            //删除
            boolean flag = iUserService.deleteUser(userId);
            l.info(flag+"");
    
        }
    
        //通过公司查找所有的用户（员工）
        @Test
        public void test05(){ 
            //A公司管理员，只能查A公司用户或者员工
            String companyId="1";
            List<User> list = iUserService.findAllUsers(companyId);
            l.info("公司的所有userList = "+list);
        }
    }

### 3. export\_system\_service子工程的service接口和实现类 ###

`IUserService`

//user业务接口
    public interface IUserService { 
        //分页显示用户信息
        PageInfo<User> findByPage(int curr, int pageSize, String companyId);
    
        void saveUser(User user);
    
        User findUserById(String userId);
    
        void updateUser(User user);
    
        boolean deleteUser(String userId);
    
        List<User> findAllUsers(String companyId);
    }

`UserServiceImpl`

@Service
    public class UserServiceImpl implements IUserService { 
    
        @Autowired
        IUserDao iUserDao;
    
        @Override
        public PageInfo<User> findByPage(int curr, int pageSize, String companyId) { 
            //设置分页参数
            PageHelper.startPage(curr,pageSize);
            //调用全查，查找所有的用户（根据公司id）
            List<User> list = iUserDao.findAll(companyId);
            //包装成PageInfo
            PageInfo<User> pi = new PageInfo<>(list);
            return pi;
        }
    
        @Override
        public User findUserById(String userId) { 
            return iUserDao.findById(userId);
        }
    
        @Override
        public boolean deleteUser(String userId) { 
            iUserDao.deleteById(userId);
            return true;
        }
    
        @Override
        public List<User> findAllUsers(String companyId) { 
            return iUserDao.findAll(companyId);
        }
    
        @Override
        public void saveUser(User user) { 
            String uuid= UUID.randomUUID().toString();
            user.setUserId(uuid);
            iUserDao.save(user);
        }
        @Override
        public void updateUser(User user) { 
            iUserDao.update(user);
        }
    }

### 4. export\_dao子工程写dao接口及其映射 ###

`IUserDao`

public interface IUserDao { 
        //根据公司id，查找所有用户，按照更新时间排序
        List<User> findAll(String companyId);
        //添加新增一个user
        void save(User user);
        //通过id查找用户
        User findById(String userId);
        //更新user信息
        void update(User user);
        //通过id删除user
        void deleteById(String userId);
    }

`IUserDao.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.xgf.dao.system.user.IUserDao">
    
        
        <resultMap id="userMap" type="user">
            <id column="user_id" property="userId"/>
            <result column="dept_id" property="deptId"/>
            <result column="email" property="email"/>
            <result column="user_name" property="userName"/>
            <result column="station" property="station"/>
            <result column="password" property="password"/>
            <result column="state" property="state"/>
            <result column="company_id" property="companyId"/>
            <result column="company_name" property="companyName"/>
            <result column="dept_name" property="deptName"/>
            <result column="manager_id" property="managerId"/>
            <result column="gender" property="gender"/>
            <result column="telephone" property="telephone"/>
            <result column="birthday" property="birthday"/>
            <result column="degree" property="degree"/>
            <result column="salary" property="salary"/>
            <result column="join_date" property="joinDate"/>
            <result column="order_no" property="orderNo"/>
            <result column="create_by" property="createBy"/>
            <result column="create_dempt" property="createDempt"/>
            <result column="create_time" property="createTime"/>
            <result column="update_by" property="updateBy"/>
            <result column="update_time" property="updateTime"/>
            <result column="remark" property="remark"/>
        </resultMap>
    
        
        <select id="findAll" parameterType="string" resultMap="userMap">
            select * from pe_user where company_id = #{companyId} order by update_time desc
        </select>
    
        
        <insert id="save" parameterType="user">
          insert into pe_user
            (
                user_id          ,
                dept_id          ,
                email            ,
                user_name        ,
                station          ,
                password         ,
                state            ,
                company_id       ,
                company_name     ,
                dept_name        ,
                manager_id       ,
                gender           ,
                telephone        ,
                birthday         ,
                degree           ,
                salary           ,
                join_date        ,
                order_no         ,
                create_by        ,
                create_dempt     ,
                create_time      ,
                update_by        ,
                update_time      ,
                remark
            )
            values(
                #{userId        },
                #{deptId        },
                #{email         },
                #{userName      },
                #{station       },
                #{password      },
                #{state         },
                #{companyId     },
                #{companyName   },
                #{deptName      },
                #{managerId     },
                #{gender        },
                #{telephone     },
                #{birthday      },
                #{degree        },
                #{salary        },
                #{joinDate      },
                #{orderNo       },
                #{createBy      },
                #{createDempt   },
                #{createTime    },
                #{updateBy      },
                #{updateTime    },
                #{remark        }
            )
        </insert>
    
        
        <select id="findById" parameterType="string" resultMap="userMap">
            select * from pe_user where user_id = #{userId}
        </select>
    
        
        <update id="update" parameterType="user">
            update  pe_user set
                    dept_id       =         #{deptId        },
                    email         =         #{email         },
                    user_name     =         #{userName      },
                    station       =         #{station       },
                    password      =         #{password      },
                    state         =         #{state         },
                    company_id    =         #{companyId     },
                    company_name  =         #{companyName   },
                    dept_name     =         #{deptName      },
                    manager_id    =         #{managerId     },
                    gender        =         #{gender        },
                    telephone     =         #{telephone     },
                    birthday      =         #{birthday      },
                    degree        =         #{degree        },
                    salary        =         #{salary        },
                    join_date     =         #{joinDate      },
                    order_no      =         #{orderNo       },
                    create_by     =         #{createBy      },
                    create_dempt  =         #{createDempt   },
                    create_time   =         #{createTime    },
                    update_by     =         #{updateBy      },
                    update_time   =         #{updateTime    },
                    remark        =         #{remark        }
            where user_id   =   #{userId        }
        </update>
    
        
        <delete id="deleteById" parameterType="string">
        delete  from pe_user where user_id = #{userId}
    </delete>
    </mapper>

### 5. export\_web\_manager子工程编写controller ###

`UserController`

@Controller
    @RequestMapping("/system/user")
    public class UserController extends BaseController { 
        private static  final Logger l = LoggerFactory.getLogger(UserController.class);
    
        @Autowired
        IUserService iUserService;
        @Autowired
        IDeptService iDeptService;
    
        @RequestMapping(path="/toList",method ={  RequestMethod.GET, RequestMethod.POST})
        public String toList(@RequestParam(defaultValue = "1") int curr, @RequestParam(defaultValue = "10")int pageSize){ 
            //调查询分页列表的方法
            PageInfo<User> pi = iUserService.findByPage(curr, pageSize,getLoginCompanyId());
            //将pi分页信息发送到jsp页面
            request.setAttribute("pi",pi);
            return "system/user/user-list";
        }
    
    
        // 删除用户
        @RequestMapping(path="/delete",method ={  RequestMethod.GET, RequestMethod.POST})
        @ResponseBody
        public Object delete(String userId){ //参数接收页面js提交过来的userId
            boolean flag = iUserService.deleteUser(userId);
            if(flag){ 
                return Msg.init(200,"删除成功",null);
            }else{ 
                return Msg.init(-200,"删除失败",null);
            }
        }
    
        //增加页面
        @RequestMapping(path="/toAdd",method ={  RequestMethod.GET, RequestMethod.POST})
        public String toAdd(){ 
            //页面上有一个下拉菜单 ，需要查询所有的部门
            List<Dept> depts = iDeptService.findAll(getLoginCompanyId());
            //添加到request
            request.setAttribute("depts",depts);
            return "system/user/user-add";
        }
    
        //添加用户
        @RequestMapping(path="/add",method ={  RequestMethod.GET, RequestMethod.POST})
        public String add(User user){ //接收页面提交过来的表单数据
            l.info("add user="+user);
    
            //用户或者员工属于一家公司，所以公司companyId是必须的
            user.setCompanyId(getLoginCompanyId());
            user.setCompanyName(getLoginCompanyName());
    
            l.info("add user="+user);
    
            iUserService.saveUser(user);
    
            return "redirect:/system/user/toList";
        }
    
        //更新回显
        @RequestMapping(path="/toUpdate",method ={  RequestMethod.GET, RequestMethod.POST})
        public String toUpdate(String userId){ //需要使用参数接收提交的 userId
            l.info("toUpdate userId="+userId);
            //需要根据userId查询当前模块的记录，回显
    
            User user =  iUserService.findUserById(userId);
            l.info("toUpdate user="+user);
            request.setAttribute("user",user);
            //页面上有一个下拉菜单 ，需要查询所有的部门
            List<Dept> depts = iDeptService.findAll(getLoginCompanyId());
            //添加到request
            request.setAttribute("depts",depts);
            return "system/user/user-update";
        }
    
        //更新用户
        @RequestMapping(path = "/update", method = { RequestMethod.GET, RequestMethod.POST})
        public String update(User user) { //需要接收编辑页面提交的表单数据
            l.info("update user=" + user);
            //更新
            iUserService.updateUser(user);
            return "redirect:/system/user/toList";
        }
    
    
    }

### 6. export\_web\_manager子工程编写jsp页面 ###

`user-add.jsp`添加（下拉菜单选中的部门提交后没有名称）

<div class="col-md-4 data">
            <input type="hidden" id="deptName" name="deptName" value="${depts[0].deptName}" >
            <script type="text/javascript"> function selectDepartment() { //获取选中值的中文 var select= $('#select option:selected') //将中文赋值给隐藏的输入框，最后提交到后台 //alert(select.val()) //alert(select.html()) $('#deptName').val(select.html()) } </script>
            <select id="select" class="form-control" onchange="selectDepartment()" name="deptId">
                <c:forEach items="${depts}" var="item">
                    <option value="${item.deptId}">${item.deptName}</option>
                </c:forEach>
            </select>
        </div>

更新`user-update.jsp`的时候对于不需要更新的字段（但是字段必须）要设置隐藏域来向后台提交。

<div class="col-md-4 data">
        <input type="hidden" id="userId" name="userId" value="${user.userId}">
        <input type="hidden" id="deptId" name="deptId" value="${user.deptId}">
        <input type="hidden" id="deptName" name="deptName" value="${user.deptName}">
        <input type="hidden" id="companyId" name="companyId" value="${user.companyId}">
        <input type="hidden" id="companyName" name="companyName" value="${user.companyName}">
        <script type="text/javascript"> function selectDepartment() { //获取选中值的中文 var select= $('#select option:selected') //将中文赋值给隐藏的输入框，最后提交到后台 //alert(select.val()) //alert(select.html()) $('#deptName').val(select.html()) $('#deptId').val(select.val()) } </script>
        <select id="select" class="form-control" onchange="selectDepartment()" >
            <c:forEach items="${depts}" var="item">
                <option <%--当前用户的deptId与查询的部门集合中的元素的deptId相等，则应该选中--%>
                        <c:if test="${user.deptId==item.deptId}" >
                            selected
                        </c:if>
                        value="${item.deptId}">${item.deptName}</option>
            </c:forEach>
        </select>
    </div>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/563bfc0b842f46eda1da7a3510395065.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0_size_16_color_FFFFFF_t_70_pic_center 1]: https://img-blog.csdnimg.cn/20201105150243759.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0,size_16,color_FFFFFF,t_70#pic_center
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0_size_16_color_FFFFFF_t_70_pic_center 2]: https://img-blog.csdnimg.cn/20201105150322878.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwNTQyNTM0,size_16,color_FFFFFF,t_70#pic_center