人员列表修改数据

修改数据

• controller

//修改数据
protected void update(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.收集参数,返回类型默认String
        String id = request.getParameter("id");
        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 vehiclesSubsidies = request.getParameter("vehiclesSubsidies");
        String heatingSubsidies = request.getParameter("heatingSubsidies");
        String propertySubsidies = request.getParameter("propertySubsidies");
        String healthInsurance = request.getParameter("healthInsurance");
        String endowmentInsurance = request.getParameter("endowmentInsurance");
        String pensionUnemployment = request.getParameter("pensionUnemployment");
        String occupationalPension = request.getParameter("occupationalPension");
        String injuryFertility = request.getParameter("injuryFertility");
        String reason = request.getParameter("reason");

        //2.封装参数
        Personnel entity = new Personnel();
        entity.setId(Integer.parseInt(id));
        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.isInteger(vehiclesSubsidies) && "1".equals(vehiclesSubsidies)) {
            entity.setVehiclesSubsidies(1);
        }
        //供暖补贴
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(heatingSubsidies)) {
            entity.setHeatingSubsidies(1);
        }
        //物业补贴
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(propertySubsidies)) {
            entity.setPropertySubsidies(1);
        }
        //医疗保险
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(healthInsurance)) {
            entity.setHealthInsurance(1);
        }
        //养老保险
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(endowmentInsurance)) {
            entity.setEndowmentInsurance(1);
        }
        //养老失业
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(pensionUnemployment)) {
            entity.setPensionUnemployment(1);
        }
        //职业年金
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(occupationalPension)) {
            entity.setOccupationalPension(1);
        }
        //工伤生育
        if (Validator.isInteger(vehiclesSubsidies) && "1".equals(injuryFertility)) {
            entity.setInjuryFertility(1);
        }
        entity.setReason(reason);
        //3.调用逻辑层添加
        personnelService.update(entity);
        //4.返回响应
        response.sendRedirect(request.getContextPath() + "/personnel.do");
    }

• service

 //修改数据
 int update(Personnel entity);

 @Override
    //修改数据
    public int update(Personnel entity) {
        return personnelDao.update(entity);
    }

• dao

 //修改数据
 int update(Personnel entity);

     @Override
    //修改数据
    public int update(Personnel entity) {
        SqlSession session = MybatisUtils.openSession(true);
        int count = session.update("personnel.update", entity);
        session.close();
        return count;
    }

• xml

  <!--修改数据-->
    <update id="update" parameterType="personnel">
        update rms_personnel
        set name=#{name},
            unit=#{unit},
            card=#{card},
            grade=#{grade},
            starting_date=#{startingDate},
            state=#{state},
            contract=#{contract},
            vehicles_subsidies=#{vehiclesSubsidies},
            heating_subsidies=#{heatingSubsidies},
            property_subsidies=#{propertySubsidies},
            health_insurance=#{healthInsurance},
            endowment_insurance=#{endowmentInsurance},
            pension_unemployment=#{pensionUnemployment},
            occupational_pension=#{occupationalPension},
            injury_fertility=#{injuryFertility},
            reason=#{reason}
        where id = #{id}
    </update>