人员列表添加数据

人员列表添加数据

• controller

 // 添加事件
    protected void add(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.收集参数,返回类型默认String
        String name = request.getParameter("name");
        String unit = request.getParameter("unit");
        String card = request.getParameter("card");
        String grade = request.getParameter("grade");
        String startingDate = request.getParameter("startingDate");
        String state = request.getParameter("state");
        String contract = request.getParameter("contract");
        //补贴，得到多个数组参数
        String[] subsidies = request.getParameterValues("subsidies");
        String reason = request.getParameter("reason");

        //2.封装参数
        Personnel entity = new Personnel();
        entity.setName(name);
        entity.setUnit(unit);
        entity.setCard(card);
        entity.setGrade(Integer.parseInt(grade));
        try {
            entity.setStartingDate(format.parse(startingDate));
        } catch (ParseException e) {
            e.printStackTrace();
        }
        entity.setState(Integer.parseInt(state));
        //合同制
        if (Validator.isNotEmpty(contract)) {
            entity.setContract(Integer.parseInt(contract));
        }
        //补贴
        if (Validator.isNotEmpty(subsidies)) {
            List<String> list = Arrays.asList(subsidies);
            if (list.contains("1")) {
                entity.setVehiclesSubsidies(1);
            }
            if (list.contains("2")) {
                entity.setHeatingSubsidies(1);
            }
            if (list.contains("3")) {
                entity.setPropertySubsidies(1);
            }
            if (list.contains("4")) {
                entity.setHealthInsurance(1);
            }
            if (list.contains("5")) {
                entity.setEndowmentInsurance(1);
            }
            if (list.contains("6")) {
                entity.setPensionUnemployment(1);
            }
            if (list.contains("7")) {
                entity.setOccupationalPension(1);
            }
            if (list.contains("8")) {
                entity.setInjuryFertility(1);
            }
        }
        entity.setReason(reason);
        //3.调用逻辑层添加
        personnelService.insert(entity);
        //4.返回响应(添加完后查询语句,所以返回此页面),重定向跳转页面
        response.sendRedirect(request.getContextPath() + "/personnel.do");
    }

• service

//人员模块逻辑层接口
public interface PersonnelService {
    //新增操作
    int insert(Personnel entity);
}

//人员模块逻辑层实现类
public class PersonnelServiceImpl implements PersonnelService {
    //逻辑层中获取数据层实现类
    private PersonnelDao personnelDao = PersonnelFactory.getPersonnelDao();
    
    @Override
    //添加数据
    public int insert(Personnel entity) {
        return personnelDao.insert(entity);
    }
}

• dao

//人员数据层接口
public interface PersonnelDao {
    //添加数据
    int insert(Personnel entity);
}

//人员模块数据层实现类
public class PersonnelDaoImpl implements PersonnelDao {
    //构造方法
    public PersonnelDaoImpl() {
    }

    //懒汉模式
    private static PersonnelDaoImpl instance = null;

    public static PersonnelDaoImpl getInstance() {
        //双重校验锁:保证不会出现并发
        if (instance == null) {
            synchronized (PersonnelDaoImpl.class) {
                if (instance == null) {
                    instance = new PersonnelDaoImpl();
                }
            }
        }
        return instance;
    }

    @Override
    //添加数据
    public int insert(Personnel entity) {
        //查询数据库,true:自动提交,如果没有则删除失败
        SqlSession session = MybatisUtils.openSession(true);
        int count = session.insert("personnel.insert", entity);
        session.close();
        return count;
    }
}

• 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="personnel">
    <!--添加数据-->
    <insert id="insert" parameterType="personnel">
        insert into rms_personnel(name, unit, card, grade, starting_date, state, contract, vehicles_subsidies,
                                  heating_subsidies, property_subsidies, health_insurance, endowment_insurance,
                                  pension_unemployment, occupational_pension, injury_fertility, reason) value (#{name},#{unit},#{card},#{grade},#{startingDate},#{state},
            #{contract},#{vehiclesSubsidies},#{heatingSubsidies},#{propertySubsidies},#{healthInsurance},#{endowmentInsurance},#{pensionUnemployment},
            #{occupationalPension},#{injuryFertility},#{reason})
    </insert>
</mapper>