人员单条删除功能

人员单条删除功能

• controller

   //单条删除
    protected void remove(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.收集参数
        String id = request.getParameter("id");
        //2.调用逻辑层删除方法,id强转为int类型
        if (Validator.isInteger(id)) {
            personnelService.delete(Integer.parseInt(id));
        }
        //3.返回响应(删除完后查询语句,所以返回此页面),重定向跳转页面
        response.sendRedirect(request.getContextPath() + "/personnel.do");
    }

• service

//人员模块逻辑层接口
public interface PersonnelService {
    //单条删除
    int delete(int id);
}

//人员模块逻辑层实现类
public class PersonnelServiceImpl implements PersonnelService {
    //逻辑层中获取数据层实现类
    private PersonnelDao personnelDao = PersonnelFactory.getPersonnelDao();
    @Override
    //单条删除
    public int delete(int id) {
        return personnelDao.delete(id);
    }
}

• dao

//人员数据层接口
public interface PersonnelDao {
    //单条删除
    int delete(int id);
}

//人员模块数据层实现类
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 delete(int id) {
        //查询数据库,true:自动提交,如果没有则删除失败
        SqlSession session = MybatisUtils.openSession(true);
        int count = session.delete("personnel.delete", id);
        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">
    <!--单条删除-->
    <delete id="delete" parameterType="int">
        delete
        from rms_personnel
        where id = #{id}
    </delete>
</mapper>