一、客户列表
1.分析

2.书写步骤
(1)封装PageBean
public class PageBean {//当前页数private Integer currentPage;//总记录数private Integer totalCount;//每页显示条数private Integer pageSize;//总页数private Integer totalPage;//分页列表数据private List list;public PageBean(Integer currentPage, Integer totalCount, Integer pageSize) {this.totalCount = totalCount; this.pageSize = pageSize; this.currentPage = currentPage; if(this.currentPage == null){//如页面没有指定显示那一页.显示第一页.this.currentPage = 1;
} if(this.pageSize == null){//如果每页显示条数没有指定,默认每页显示3条this.pageSize = 3;
} //计算总页数this.totalPage = (this.totalCount+this.pageSize-1)/this.pageSize; //判断当前页数是否超出范围//不能小于1if(this.currentPage < 1){this.currentPage = 1;
}//不能大于总页数if(this.currentPage > this.totalPage){this.currentPage = this.totalPage;
}
}//计算起始索引public int getStart(){return (this.currentPage-1)*this.pageSize;
} public Integer getCurrentPage() {return currentPage;
}public void setCurrentPage(Integer currentPage) {this.currentPage = currentPage;
}public Integer getTotalCount() {return totalCount;
}public void setTotalCount(Integer totalCount) {this.totalCount = totalCount;
}public Integer getPageSize() {return pageSize;
}public void setPageSize(Integer pageSize) {this.pageSize = pageSize;
}public Integer getTotalPage() {return totalPage;
}public void setTotalPage(Integer totalPage) {this.totalPage = totalPage;
}public List getList() {return list;
}public void setList(List list) {this.list = list;
}
}(2)书写Action
public class CustomerAction extends ActionSupport implements ModelDriven{private Customer customer = new Customer(); private CustomerService cs;private Integer currentPage;private Integer pageSize;public String list() throws Exception {//封装离线查询对象DetachedCriteria dc = DetachedCriteria.forClass(Customer.class);//判断并封装参数if(StringUtils.isNotBlank(customer.getCust_name())){ dc.add(Restrictions.like("cust_name", "%"+customer.getCust_name()+"%")); } //1 调用Service查询分页数据(PageBean)PageBean pb = cs.getPageBean(dc,currentPage,pageSize);//2 将PageBean放入request域,转发到列表页面显示ActionContext.getContext().put("pageBean", pb);return "list"; } @Overridepublic Customer getModel() {return customer; }public void setCs(CustomerService cs) {this.cs = cs; }public Integer getCurrentPage() {return currentPage; }public void setCurrentPage(Integer currentPage) {this.currentPage = currentPage; }public Integer getPageSize() {return pageSize; }public void setPageSize(Integer pageSize) {this.pageSize = pageSize; } }
(3)书写Service
public class CustomerServiceImpl implements CustomerService {private CustomerDao cd;
@Overridepublic PageBean getPageBean(DetachedCriteria dc, Integer currentPage, Integer pageSize) {//1 调用Dao查询总记录数Integer totalCount = cd.getTotalCount(dc);//2 创建PageBean对象PageBean pb = new PageBean(currentPage, totalCount, pageSize);//3 调用Dao查询分页列表数据
List list = cd.getPageList(dc,pb.getStart(),pb.getPageSize());//4 列表数据放入pageBean中.并返回 pb.setList(list);return pb;
}public void setCd(CustomerDao cd) {this.cd = cd;
}
} (4)书写Dao
public class CustomerDaoImpl extends HibernateDaoSupport implements CustomerDao {public Integer getTotalCount(DetachedCriteria dc) {//设置查询的聚合函数,总记录数 dc.setProjection(Projections.rowCount());
List list = (List) getHibernateTemplate().findByCriteria(dc); //清空之前设置的聚合函数dc.setProjection(null); if(list!=null && list.size()>0){
Long count = list.get(0);return count.intValue();
}else{return null;
}
}public List getPageList(DetachedCriteria dc, int start, Integer pageSize) { return (List) getHibernateTemplate().findByCriteria(dc, start, pageSize);
}
} (5)完成struts以及spring的配置
strus.xml添加代码:
/jsp/customer/list.jsp
applicationContext.xml添加代码:
(6)书写前台list.jsp页面
主要通过表单提交隐藏域的数据、jq和ognl表达式来实现。
<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %><%@ taglib prefix="s" uri="/struts-tags" %>客户列表
![]() | ![]() |
|
![]() | ![]() |
二、BaseDao封装
1.抽取BaseDao

2.BaseDao设计思路

3.BaseDao接口书写
public interface BaseDao{//增void save(T t);//删void delete(T t);//删void delete(Serializable id);//改void update(T t);//查 根据id查询 T getById(Serializable id);//查 符合条件的总记录数 Integer getTotalCount(DetachedCriteria dc);//查 查询分页列表数据List getPageList(DetachedCriteria dc,Integer start,Integer pageSize); }
4.BaseDao的实现类
public class BaseDaoImplextends HibernateDaoSupport implements BaseDao {private Class clazz;//用于接收运行期泛型类型 public BaseDaoImpl() {//获得当前类型的带有泛型类型的父类ParameterizedType ptClass = (ParameterizedType) this.getClass().getGenericSuperclass();//获得运行期的泛型类型clazz = (Class) ptClass.getActualTypeArguments()[0]; } @Overridepublic void save(T t) { getHibernateTemplate().save(t); } @Overridepublic void delete(T t) { getHibernateTemplate().delete(t); } @Overridepublic void delete(Serializable id) { T t = this.getById(id);//先取,再删 getHibernateTemplate().delete(t); } @Overridepublic void update(T t) { getHibernateTemplate().update(t); } @Overridepublic T getById(Serializable id) { return (T) getHibernateTemplate().get(clazz, id); } @Overridepublic Integer getTotalCount(DetachedCriteria dc) {//设置查询的聚合函数,总记录数 dc.setProjection(Projections.rowCount()); List list = (List ) getHibernateTemplate().findByCriteria(dc); //清空之前设置的聚合函数dc.setProjection(null); if(list!=null && list.size()>0){ Long count = list.get(0);return count.intValue(); }else{return null; } } @Overridepublic List getPageList(DetachedCriteria dc, Integer start, Integer pageSize) { List list = (List ) getHibernateTemplate().findByCriteria(dc, start, pageSize); return list; } }
5.业务Dao中的应用
public class CustomerDaoImpl extends BaseDaoImplimplements CustomerDao { }














