按钮功能的实现

按钮功能的实现

• controller

//人员模块表现实现类
@WebServlet(
        name = "PersonnelController",
        urlPatterns = "/personnel.do",
        loadOnStartup = 0
)
public class PersonnelController extends HttpServlet {
    //表现层中获取逻辑层实现类
    private PersonnelService personnelService = PersonnelFactory.getPersonnelService();

    //定义Servlet运行方法, 接收客户端请求, 返回服务器响应
    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //当前页面
        int current = 1;

        //list.jsp获得的页面和Java的连接
        String currentStr = request.getParameter("current");
        if (Validator.isNotEmpty(currentStr) && Validator.isInteger(currentStr)) {
            current = Integer.parseInt(currentStr);
        }

        //每页条数
        int size = 10;
        //起始条数
        int start = (current - 1) * size;

        //封装查询参数
        Map<String, Object> params = new HashMap<>();
        params.put("start", start);
        params.put("size", size);

        //查询数据库总条数
        long count = personnelService.queryByCount(params);

        //最大页数
        int max = (int) Math.ceil(count * 1.0 / size);

        //1.查询人员列表 queryByPage:分页查询
        List<Personnel> list = personnelService.queryByPage(params);
        //2.写入请求作用域
        request.setAttribute("list", list);
        request.setAttribute("current", current);
        request.setAttribute("max", max);
        request.setAttribute("count", count);
        request.setAttribute("start", start);
        request.setAttribute("size", size);
        //3.分发器跳转页面
        request.getRequestDispatcher("/view/personnel/list.jsp").forward(request, response);
    }

• service

//人员模块逻辑层接口
public interface PersonnelService {
    //查询条数
    long queryByCount(Map<String, Object> params);
}

//人员模块逻辑层实现类
public class PersonnelServiceImpl implements PersonnelService {
    //逻辑层中获取数据层实现类
    private PersonnelDao personnelDao = PersonnelFactory.getPersonnelDao();
    //查询条数
    @Override
    public long queryByCount(Map<String, Object> params) {
        return personnelDao.queryByCount(params);
    }
}

• dao

//人员数据层接口
public interface PersonnelDao {
    //查询条数
    long queryByCount(Map<String, Object> params);
}

//人员模块数据层实现类
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 long queryByCount(Map<String, Object> params) {
        //查询数据库
        SqlSession session = MybatisUtils.openSession();
        //selectOne:返回一行
        long count = session.selectOne("personnel.queryByCount", params);
        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">

    <!--查询总条数-->
    <select id="queryByCount" resultType="Long">
        select count(1)
        from rms_personnel
    </select>
</mapper>