SSM整合开发办公系统核心模块二（部门管理功能实现）

部门管理

1. 实体类
2. dao接口与映射文件
3. biz接口与其实现类
4. 控制器
5. 页面

实体类

部门

public class Department {
    private String sn;
    private String name;
    private String address;
    //set和get
}

员工

public class Employee {
    private String sn;

    private String password;

    private String name;

    private String departmentSn;

    private String post;
    
    //get和set
}

处理记录

//处理记录
public class DealRecord {
    private Integer id;

    private Integer claimVoucherId;

    private String dealSn;

    @DateTimeFormat(pattern = "yyyy-MM-dd hh:mm")
    private Date dealTime;

    private String dealWay;

    private String dealResult;

    private String comment;

    //get和set
}

报销单

//报销单
public class ClaimVoucher {
    private Integer id;

    private String cause;

    private String createSn;
    @DateTimeFormat(pattern = "yyyy-MM-dd hh:mm")
    private Date createTime;

    private String nextDealSn;

    private Double totalAmount;

    private String status;

    //get和set
}

报销单明细

public class ClaimVoucherItem {
    private Integer id;

    private Integer claimVoucherId;

    private String item;

    private Double amount;

    private String comment;

    //set和get
}

dao接口与映射文件

DepartmentDao

package com.imooc.oa.dao;

import com.imooc.oa.entity.Department;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository("departmentDao")
public interface DepartmentDao {
    void insert(Department department);
    void update(Department department);
    void delete(String sn);
    Department select(String sn);
    List<Department> selectAll();
}

resources/com.imooc.oa.dao/DepartmentDao.xml

<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.4//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.imooc.oa.dao.DepartmentDao">

    <resultMap id="department" type="Department">
        <id property="sn" column="sn" javaType="String"/>
        <result property="name" column="name" javaType="String"/>
        <result property="address" column="address" javaType="String"/>
    </resultMap>


    <insert id="insert" parameterType="Department">
        insert into department values(#{sn},#{name},#{address})
    </insert>

    <update id="update" parameterType="Department">
        update department set name=#{name},address=#{address} where sn=#{sn}
    </update>

    <delete id="delete" parameterType="String">
        delete from department where sn=#{sn}
    </delete>

    <select id="select" parameterType="String" resultMap="department">
        select * from department where sn=#{sn}
    </select>

    <select id="selectAll" resultMap="department">
        select * from department
    </select>

</mapper>

oa_biz中com.imooc.oa.biz/DepartmentBiz.java

package com.imooc.oa.biz;

import com.imooc.oa.entity.Department;

import java.util.List;

public interface DepartmentBiz {
    void add(Department department);
    void edit(Department department);
    void remove(String sn);
    Department get(String sn);
    List<Department> getAll();
}

实现类DepartmentBizImpl

package com.imooc.oa.biz.impl;

import com.imooc.oa.biz.DepartmentBiz;
import com.imooc.oa.dao.DepartmentDao;
import com.imooc.oa.entity.Department;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("departmentBiz")
public class DepartmentBizImpl implements DepartmentBiz {
    @Autowired
    private DepartmentDao departmentDao;

    public void add(Department department) {
        departmentDao.insert(department);
    }

    public void edit(Department department) {
        departmentDao.update(department);
    }

    public void remove(String sn) {
        departmentDao.delete(sn);
    }

    public Department get(String sn) {
        return departmentDao.select(sn);
    }

    public List<Department> getAll() {
        retur