大数据正式39

我会带着你远行 2022-06-02 06:16 168阅读 0赞

# 大数据正式39 #

### 国际物汇通商贸项目 》 系统管理 ###

*  一睹为快 -![qialKDZ.png][]
 *  流程
    
     *  ![NMx1SY0.png][]

### 国际物汇通商贸项目 》 系统管理 》 部门管理 ###

*  一睹为快
    
     *  ![P4msTk5.png][]
 *  流程
    
     *  ![ycPVVLn.png][]

### 国际物汇通商贸项目 》 系统管理 》 用户管理 ###

*  一睹为快
    
     *  ![rrOzqqG.png][]
 *  流程
    
     *  ![ICaKPim.png][]

### 国际物汇通商贸项目 》 系统管理 》 角色管理 ###

*  一睹为快
    
     *  ![ON9TH9f.png][]
 *  流程
    
     *  ![WKetXDa.png][]

# 以部门管理为例介绍 #

*  控制层【部分展示】
    
    #  #
    
        package com.peng.controller;
        
        import java.util.List;
        
        import org.springframework.beans.factory.annotation.Autowired;
        import org.springframework.beans.factory.annotation.Qualifier;
        import org.springframework.stereotype.Controller;
        import org.springframework.ui.Model;
        import org.springframework.web.bind.annotation.RequestMapping;
        import org.springframework.web.bind.annotation.RequestParam;
        
        import com.peng.pojo.Dept;
        import com.peng.service.DeptService;
        
        @Controller(value = "deptServlet")
        @RequestMapping(value = "/sysadmin/dept")
        public class DeptController {
            @Autowired
            @Qualifier(value = "deptService")
            private DeptService deptService;
        
            @RequestMapping("/list")
            public String findAllAction(Model model) {
                List<Dept> deptList = deptService.findAll();
                model.addAttribute("deptList", deptList);
                return "/sysadmin/dept/jDeptList";
            }
        
            // 点击“启用”按钮，实现禁用按钮--批量操作--非必传参数
            @RequestMapping("/stop")
            public String stop(@RequestParam(name = "deptId", required = false) String[] deptIds) {
                if (deptIds != null) {
                    deptService.changeState(0, deptIds);
                }
                return "redirect:/sysadmin/dept/list";
            }
        
            // 点击“禁用”按钮，实现启用按钮--批量操作--非必传参数
            @RequestMapping("/start")
            public String start(@RequestParam(name = "deptId", required = false) String[] deptIds) {
                if (deptIds != null) {
                    deptService.changeState(1, deptIds);
                }
                return "redirect:/sysadmin/dept/list";
            }
        
            // 点击“删除”按钮--批量操作--非必传参数
            @RequestMapping("/delete")
            public String delete(@RequestParam(name = "deptId", required = false) String[] deptIds) {
                if (deptIds != null) {
                    deptService.deleteDeptByIds(deptIds);
                }
                return "redirect:/sysadmin/dept/list";
            }
        
            // 点击“新增”按钮--增加部门
            @RequestMapping("/tocreate")
            public String tocreate(Model model) {
                List<Dept> deptList = deptService.findAll();
                model.addAttribute("deptList", deptList);
                return "/sysadmin/dept/jDeptCreate";
            }
        
            // 点击“增加”按钮--保存部门
            @RequestMapping("/save")
            public String save(Model model, Dept dept) {
                try {
                    deptService.saveDept(dept);
                    return "redirect:/sysadmin/dept/list";
                } catch (Exception e) {
                    List<Dept> deptList = deptService.findAll();
                    model.addAttribute("deptList", deptList);
                    model.addAttribute("save_error", "新增失败,可能是部门编号重复了！");
                    return "/sysadmin/dept/jDeptCreate";
                }
            }
        
            // 点击“修改”按钮
            @RequestMapping("/toupdate")
            public String toUpdate(Model model, @RequestParam(name = "deptId", required = false) String[] deptIds) {
                String deptId = deptIds != null ? deptIds[0] : null;// 只获取第一个
                if (deptId == null || "".equals(deptId)) {
                    model.addAttribute("error_up", "请选择一个部门");
                    List<Dept> deptList = deptService.findAll();
                    model.addAttribute("deptList", deptList);
                    return "/sysadmin/dept/jDeptList";
                }
                Dept dept = deptService.findOneById(deptId);
                List<Dept> deptList = deptService.findAll();
                model.addAttribute("deptList", deptList);
                model.addAttribute("dept", dept);
                return "/sysadmin/dept/jDeptUpdate";
            }
        
            // 点击“修改”按钮--保存部门
            @RequestMapping("/update")
            public String update(Model model, Dept dept) {
                try {
                    System.out.println(dept);
                    deptService.updateDept(dept);
                    return "redirect:/sysadmin/dept/list";
                } catch (Exception e) {
                    List<Dept> deptList = deptService.findAll();
                    model.addAttribute("deptList", deptList);
                    model.addAttribute("update_error", "更新失败,走神了！");
                    model.addAttribute("deptList", deptList);
                    model.addAttribute("dept", dept);
                    return "/sysadmin/dept/jDeptUpdate";
                }
            }
        
            // 点击“查看”按钮
            @RequestMapping("/toview")
            public String showView(Model model, @RequestParam(name = "deptId", required = false) String[] deptIds) {
                String deptId = deptIds != null ? deptIds[0] : null;// 只获取第一个
                if (deptId == null || "".equals(deptId)) {
                    model.addAttribute("error_up", "请选择一个部门");
                    List<Dept> deptList = deptService.findAll();
                    model.addAttribute("deptList", deptList);
                    return "/sysadmin/dept/jDeptList";
                }
                Dept dept = deptService.findOneById(deptId);
                List<Dept> deptList = deptService.findAll();
                model.addAttribute("deptList", deptList);
                model.addAttribute("dept", dept);
                return "/sysadmin/dept/jDeptView";
            }
        
        }
 *  service层【部分展示】
    
    #  #
    
        package com.peng.service;
        
        import java.util.List;
        
        import com.peng.pojo.Dept;
        
        public interface DeptService {
            /**
             * 查询所有的部门
             * 
             * @return
             */
            List<Dept> findAll();
        
            /**
             * 批量删除dept
             * 
             * @param deptIds
             */
            void deleteDeptByIds(String[] deptIds);
        
            /**
             * 批量更改状态
             * 
             * @param state
             * @param deptIds
             */
            void changeState(int state, String[] deptIds);
        
            /**
             * 保存dept
             * 
             * @param dept
             */
            void saveDept(Dept dept);
        
            /**
             * 通过id查询dept
             * 
             * @param deptId
             * @return
             */
            Dept findOneById(String deptId);
        
            /**
             * 更新部门
             * 
             * @param dept
             */
            void updateDept(Dept dept);
        
        }
    
    #  #
    
        package com.peng.service;
        
        import java.util.List;
        
        import org.springframework.beans.factory.annotation.Autowired;
        import org.springframework.beans.factory.annotation.Qualifier;
        import org.springframework.stereotype.Service;
        
        import com.peng.mapper.DeptMapper;
        import com.peng.pojo.Dept;
        
        @Service(value = "deptService")
        public class DeptServiceImpl implements DeptService {
        
            // 注入dao层对象
            @Autowired
            @Qualifier(value = "deptMapper")
            private DeptMapper deptMapper;
        
            public List<Dept> findAll() {
                return deptMapper.findAll();
            }
        
            @Override
            public void deleteDeptByIds(String[] deptIds) {
                deptMapper.deleteDeptByIds(deptIds);
        
            }
        
            @Override
            public void changeState(int state, String[] deptIds) {
                deptMapper.changeState(state, deptIds);
        
            }
        
            @Override
            public void saveDept(Dept dept) {
                deptMapper.saveDept(dept);
        
            }
        
            @Override
            public Dept findOneById(String deptId) {
                return deptMapper.findOneById(deptId);
            }
        
            @Override
            public void updateDept(Dept dept) {
                deptMapper.updateDept(dept);
            }
        
        }
 *  dao层
    
    #  #
    
        package com.peng.mapper;
        
        import java.util.List;
        
        import org.apache.ibatis.annotations.Param;
        
        import com.peng.pojo.Dept;
        
        public interface DeptMapper {
            /**
             * 查询所有部门
             */
            public List<Dept> findAll();
        
            /**
             * 通过id更改状态
             * 
             * @param state
             * @param id
             */
            public void changeState(@Param("state") int state, @Param("deptIds") String[] deptIds);
        
            /**
             * 批量删除dept
             * 
             * @param deptIds
             */
            public void deleteDeptByIds(String[] deptIds);
        
            /**
             * 保存dept
             * 
             * @param dept
             */
            public void saveDept(Dept dept);
        
            /**
             * 通过dept_id查询dept
             * 
             * @param deptId
             * @return
             */
            public Dept findOneById(String deptId);
        
            /**
             * 更新dept
             * 
             * @param dept
             */
            public void updateDept(Dept dept);
        }
 *  dao层对应的mapper文件
    
    #  #
    
        <?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.peng.mapper.DeptMapper">
            
            <resultMap type="Dept" id="deptRM" autoMapping="true">
                <id column="dept_id" property="deptId"></id>
                <association property="parentDept" javaType="Dept">
                    <id column="pId" property="deptId"></id>
                    <result column="pName" property="deptName"></result>
                </association>
            </resultMap>
            <select id="findAll" resultMap="deptRM">
                SELECT * FROM
                dept_p d
                LEFT JOIN
                (SELECT dept_id pId,dept_name pName FROM dept_p) p
                ON d.parent_id =
                p.pId
            </select>
        
            
            <update id="changeState">
                update dept_p set state=#{state} where dept_id in
                <foreach collection="deptIds" item="id" open="(" close=")"
                    separator=",">#{id}
                </foreach>
            </update>
        
            
            <delete id="deleteDeptByIds">
                delete from dept_p where dept_id in
                <foreach collection="array" item="id" open="(" close=")"
                    separator=",">#{id}
                </foreach>
            </delete>
            
            <insert id="saveDept">
                insert into dept_p
                (dept_id,dept_name,parent_id,state)
                values(#{deptId},#{deptName},#{parentDept.deptId},#{state});
            </insert>
            
            <select id="findOneById" resultMap="deptRM">
                SELECT * FROM
                ( SELECT * FROM
                dept_p d
                LEFT JOIN
                (SELECT dept_id pId,dept_name pName
                FROM dept_p) p
                ON
                d.parent_id =
                p.pId ) temp
                WHERE temp.dept_id=#{deptId}
            </select>
            
            <update id="updateDept">
                update dept_p
                <set>
                    <if test="deptName!=null">dept_name=#{deptName},</if>
                    <if test="parentDept.deptId!=null">dept_id=#{deptId},</if>
                    <if test="state!=null">state=#{state}</if>
                </set>
                where dept_id=#{deptId}
            </update>
        </mapper>
 *  数据库设计
    
     *  ![Spklmy4.png][]
 *  pojo
    
    #  #
    
        package com.peng.pojo;
        
        public class Dept extends BaseEntity {
            private String deptId;
            private Dept parentDept;// 上级部门
            private String deptName;
            private Integer state;
        
            public String getDeptId() {
                return deptId;
            }
        
            public void setDeptId(String deptId) {
                this.deptId = deptId;
            }
        
            public Dept getParentDept() {
                return parentDept;
            }
        
            public void setParentDept(Dept parentDept) {
                this.parentDept = parentDept;
            }
        
            public String getdeptName() {
                return deptName;
            }
        
            public void setdeptName(String deptName) {
                this.deptName = deptName;
            }
        
            public Integer getState() {
                return state;
            }
        
            public void setState(Integer state) {
                this.state = state;
            }
        
            @Override
            public String toString() {
                return "Dept [deptId=" + deptId + ", parentDept=" + parentDept + ", deptName=" + deptName + ", state=" + state
                        + "]";
            }
        
        }

[qialKDZ.png]: https://i.imgur.com/qialKDZ.png
[NMx1SY0.png]: https://i.imgur.com/NMx1SY0.png
[P4msTk5.png]: https://i.imgur.com/P4msTk5.png
[ycPVVLn.png]: https://i.imgur.com/ycPVVLn.png
[rrOzqqG.png]: https://i.imgur.com/rrOzqqG.png
[ICaKPim.png]: https://i.imgur.com/ICaKPim.png
[ON9TH9f.png]: https://i.imgur.com/ON9TH9f.png
[WKetXDa.png]: https://i.imgur.com/WKetXDa.png
[Spklmy4.png]: https://i.imgur.com/Spklmy4.png