跳转至编辑页面

最新推荐文章于 2023-03-20 16:09:42 发布

半世晨晓0719

最新推荐文章于 2023-03-20 16:09:42 发布

阅读量212

点赞数

分类专栏： rms 文章标签： java web

本文链接：https://blog.csdn.net/qq_45939736/article/details/127494993

版权

rms 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

跳转至编辑页面

controller

    //跳转至编辑页面
    protected void load(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.收集参数
        String id = request.getParameter("id");
        //2.调用逻辑层
        if (Validator.isInteger(id)) {
            //把查询到的数据放回到请求作用域中
            request.setAttribute("entity", personnelService.queryById(Integer.parseInt(id)));
        }
        //3.返回响应,跳转修改页面
        request.getRequestDispatcher("/view/personnel/update.jsp").forward(request, response);
    }

service

//跳转至编辑页面
Personnel queryById(int id);

  @Override
    //跳转至编辑页面
    public Personnel queryById(int id) {
        return personnelDao.queryById(id);
    }

 //跳转至编辑页面
 Personnel queryById(int id);

    @Override
    //跳转至编辑页面
    public Personnel queryById(int id) {
        //查询数据库
        SqlSession session = MybatisUtils.openSession();
        //selectOne:返回一行
        Personnel personnel = session.selectOne("personnel.queryById", id);
        session.close();
        return personnel;
    }

<?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">

    <!--数据库字段-->
    <sql id="colums">
        id,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
    </sql>

    <!--跳转至编辑页面-->
    <select id="queryById" parameterType="int" resultType="personnel">
        select<include refid="colums"/>from rms_personnel where id=#{id}
    </select>
</mapper>