AO數據訪問

package dao;
?
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;
?
import utils.JdbcUtils;
import utils.PageBean;
import entity.Muli;
?
public class MuliDao {
 // 創建QueryRunner對象
 private QueryRunner qr = JdbcUtils.getQueryRuner();
?
 
 // 查找全部信息列表
 public List<Muli> listMuliAll() {
 String sql = "SELECT * FROM mulihuji ";
 try {
 // 多行數據，封裝成對象的集合
 List<Muli> listmuli = qr.query(sql, new BeanListHandler<Muli>(Muli.class));
 return listmuli;
 } catch (Exception e) {
 throw new RuntimeException(e);
 }
 }
 
 // 分頁顯示全部數據
 public void listMuliAll(PageBean<Muli> pb,Muli muli) throws SQLException {
?
 String countsql = "select count(*) from mulihuji where 1=1";
 String sql = "select * from mulihuji where 1=1";
 
 List<Object> params = new ArrayList<Object>();
 // 添加查詢條件
 String xm = muli.getXm();
 if (xm != null && xm != "") {
 countsql += " and xm like ?";
 sql += " and xm like ?";
 params.add("%" + xm + "%");
 }
 String sfzh = muli.getSfzh();
 if (sfzh != null && sfzh != "") {
 countsql += " and sfzh like ?";
 sql += " and sfzh like ?";
 params.add("%" + sfzh + "%");
 } 
 
 //得到總記錄數 
 Long count = qr.query(countsql, new ScalarHandler<Long>(),params.toArray());
 pb.setTotalCount(count.intValue());
 /*
 * 問題： jsp頁面，如果當前頁為首頁，再點擊上一頁報錯！ 如果當前頁為末頁，再點下一頁顯示有問題！ 解決： 1. 如果當前頁 <= 0;
 * 當前頁設置當前頁為1; 2. 如果當前頁 > 最大頁數； 當前頁設置為最大頁數
 */
 // 判斷
 if (pb.getCurrentPage() <= 0) {
 pb.setCurrentPage(1); // 把當前頁設置為1
 } else if (pb.getCurrentPage() > pb.getTotalPage()) {
 pb.setCurrentPage(pb.getTotalPage()); // 把當前頁設置為最大頁數
 }
?
 // 1. 獲取當前頁： 計算查詢的起始行、返回的行數
 int currentPage = pb.getCurrentPage();
 int index = (currentPage - 1) * pb.getPageCount(); // 查詢的起始行
 int pagecount = pb.getPageCount(); // 每頁的行數
 
 
 sql += " limit ?,?";
 params.add(index);
 params.add(pagecount);
 
 List<Muli> pageData = qr.query(sql, new BeanListHandler<Muli>(Muli.class),params.toArray() ); //獲取一頁的數據
 // 設置到pb對象中
 pb.setPageData(pageData);
 
?
 }
?
 
}
?

Servlet設計

package servlet;
?
import java.io.IOException;
import java.sql.SQLException;
?
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
?
?
import dao.MuliDao;
import entity.Muli;
import utils.PageBean;
?
/**
 * Servlet implementation class QueryListMuliServlet
 */
@WebServlet("/querymuli")
public class QueryListMuliServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;
?
 /**
 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
 */
 
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
 request.setCharacterEncoding("utf-8");
 response.setCharacterEncoding("utf-8");
 String xm = request.getParameter("xm");
 String sfzh = request.getParameter("sfzh");
 //實例化實體類并賦值 
 Muli muli=new Muli();
 muli.setXm(xm);
 muli.setSfzh(sfzh);
 
 //1. 獲取“當前頁”參數； (第一次訪問當前頁為null) 
 String currPage = request.getParameter("currentPage");
 // 判斷
 if (currPage == null || "".equals(currPage.trim())){
 currPage = "1"; // 若第一次訪問，設置當前頁為1;
 }
 // 轉換為整數型
 int currentPage = Integer.parseInt(currPage);
 //實例化pageben類
 PageBean<Muli> pb = new PageBean<Muli>();
 pb.setCurrentPage(currentPage);
 
 try {
 //調用數據訪問的方法，傳遞兩個參數
 MuliDao mulidao = new MuliDao();
 mulidao.listMuliAll(pb,muli);
 
 request.setAttribute("pageBean", pb);
 request.getRequestDispatcher("/querylist.jsp").forward(request, response);
 return;
 
 } catch (SQLException e) {
 e.printStackTrace();
 request.setAttribute("errorMsg", e.getMessage());
 }
 request.getRequestDispatcher("/error.jsp").forward(request, response);
 
 }
?
 /**
 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 */
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 // TODO Auto-generated method stub
 doGet(request, response);
 }
?
}

JSP頁面：分為兩個頁面，1.提交查詢條件，2.返回查詢結果