ibatis spring struts 简易分页显示，功能简单

下面为查询所显示的分页，关键技术在：1、只从数据库读取指定数量的数据

                                                    2、点击下一页时，能够保存条件，用同样的条件进行查询显示

                                                    3、日期在前台的显示

1、返回的对象类的DTO为

MatchMedicineDto.java

package com.yihaodian.pis.dto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.yihaodian.pis.util.DateFormatUtil;

public class MatchMedicineDto {
	/** 存储的ID */
	private Integer id ;
	/** 一号店商品编号 */
    private Integer productId;
    
    /** 一号店商品名 */
    private String productCname;
    
    /** 一号店商品编码 */
    private String productCode = null;

    /** 目标商品名 */
    private String name;
    
    /** 目标商品URL */
    private String pageUrl;
    
    /** 一号店分类id */
    private Integer categoryId = null;
    
    private String categoryName;
          
    private Integer siteId;
    /** 目标网站 名 */
    private String siteName;
	
    /** 匹配时间 */
    private Date matchTime;
    
    private String matchTimeStr;
    
    /**标志是1一号店还是2药网的信息 */
    private Integer ownSiteId = 1;
    
    private String condition;

    private Integer currentPage=1;
	private Integer iDisplayStart = 0;
	private Integer iDisplayLength = 20;
	private Integer pageCount;
	
	private List<Integer> catIdsIn;
	//将这个实体类里的几个属性变为一个字符串数组
//	public String[] toArray(int indexNum) {
//		String[] ret = new String[7];
//		
//		ret[0] = "<input type=\"checkbox\"  name=\"matchId\" onclick=\"chooseMatch()\" value=\""+productId+"\"/>" ;
//		ret[1] = "<a href=\"http://www.111.com.cn/product/"+((productId/10)%10000000)*10000000+"\">"+productCname+"</a>" ;
//		ret[2] = ""+productCode;
//		ret[3] = ""+categoryName;
//		ret[4] = siteName;
//		ret[5] = "<a href=\""+pageUrl+"\" target=\"_blank\">"+name+"</a>";
//		ret[5] =  DateFormatUtil.getDate(matchTime, "yyyy-MM-dd");
//		
//		return ret;
//	}

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public Integer getProductId() {
		return productId;
	}

	public void setProductId(Integer productId) {
		this.productId = productId;
	}

	public String getProductCname() {
		return productCname;
	}

	public void setProductCname(String productCname) {
		this.productCname = productCname;
	}

	public String getProductCode() {
		return productCode;
	}

	public void setProductCode(String productCode) {
		this.productCode = productCode;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getPageUrl() {
		return pageUrl;
	}

	public void setPageUrl(String pageUrl) {
		this.pageUrl = pageUrl;
	}

	public Integer getCategoryId() {
		return categoryId;
	}

	public void setCategoryId(Integer categoryId) {
		this.categoryId = categoryId;
	}

	public String getCategoryName() {
		return categoryName;
	}

	public void setCategoryName(String categoryName) {
		this.categoryName = categoryName;
	}

	public Integer getSiteId() {
		return siteId;
	}

	public void setSiteId(Integer siteId) {
		this.siteId = siteId;
	}

	public String getSiteName() {
		return siteName;
	}

	public void setSiteName(String siteName) {
		this.siteName = siteName;
	}

	public Date getMatchTime() {
		return matchTime;
	}

	public void setMatchTime(Date matchTime) {
		this.matchTime = matchTime;
	}

	public Integer getCurrentPage() {
		return currentPage;
	}

	public void setCurrentPage(Integer currentPage) {
		this.currentPage = currentPage;
	}

	public Integer getiDisplayStart() {
		return iDisplayStart;
	}

	public void setiDisplayStart(Integer iDisplayStart) {
		this.iDisplayStart = iDisplayStart;
	}

	public Integer getiDisplayLength() {
		return iDisplayLength;
	}

	public void setiDisplayLength(Integer iDisplayLength) {
		this.iDisplayLength = iDisplayLength;
	}

	public Integer getPageCount() {
		return pageCount;
	}

	public void setPageCount(Integer pageCount) {
		this.pageCount = pageCount;
	}

	public String getCondition() {
		return ownSiteId+","+productCode+","+siteId+","+categoryId;
	}

	public void setCondition(String condition) {
		this.condition = condition;
	}

	public Integer getOwnSiteId() {
		return ownSiteId;
	}

	public void setOwnSiteId(Integer ownSiteId) {
		this.ownSiteId = ownSiteId;
	}

	public List<Integer> getCatIdsIn() {
		return catIdsIn;
	}

	public void setCatIdsIn(List<Integer> catIdsIn) {
		this.catIdsIn = catIdsIn;
	}

	public String getMatchTimeStr() {
		java.text.DateFormat   format=new   java.text.SimpleDateFormat( "yyyy-MM-dd hh:mm:ss");
		String   dateString=format.format(matchTime);
		return dateString;
	}

	public void setMatchTimeStr(String matchTimeStr) {
		this.matchTimeStr = matchTimeStr;
	}
	
}

 2、MedicineAction.java

在这里得到LIST，以及从数据库读取的起始位置和长度的设置

public class MedicineAction extends StrutsActionAdapter {

	/**
	 * author : 向旗
	 */
	private static final long serialVersionUID = 1L;
	/** 匹配商品列表 */
	private List<MatchMedicineDto> matchMedicineList;
	/** 列表 */
	private MatchProductService matchProductSvc;
	/** 药网目录提取 */
	private MedicineDao medicineDao;	
    /** 产品匹配记录id */
    private int matchId;
    /** 产品匹配记录id集合 */
    private String matchIds;
    
	private MatchProductDao matchProductDao;
	/** 第一级目录 */
	private List<MedicineCategoryDto> firstLevelCate;
	/** 父类的ID值 */
	private Integer parentCategoryId;
	/** 临时存商品编码的信息 */
	 /** 商品抓价业务接口 */
    private CurrentPriceService currentPriceSvc;
    /** 商品历史价格业务接口 */
    private HistoryPriceService historyPriceSvc;
    /** 异常错误信息 */
    private String message;

	private MatchMedicineDto matchMedicineDto = new MatchMedicineDto();
	/** 临时转存搜索条件信息*/
	private MatchMedicineDto mmDto = new MatchMedicineDto();

	private Integer pageNum = 1;
	
	private Integer next = 0 ; 
	
	private String condition;
public String queryMedicineByCode() {
		if (next == 1) {
			String[]conf = condition.split(",");
			mmDto.setOwnSiteId(Integer.parseInt(conf[0]));
			mmDto.setProductCode(conf[1]);
			mmDto.setSiteId(Integer.parseInt(conf[2]));
			if (conf[3].equals(null) || conf[3].equals("null")) {
				mmDto.setCategoryId(null);
			}else{
				mmDto.setCategoryId(Integer.parseInt(conf[3]));
				List<Integer> cl=new ArrayList<Integer>();
				if(medicineDao.getCategoryNameById(mmDto.getCategoryId()).getCategoryIsLeaf()==1)
				{
					cl.add(mmDto.getCategoryId());
				}else{
				List<CategoryDto> categoryList = medicineDao.getCategoryChilds(mmDto.getCategoryId());
				List<CategoryDto> fCategoryList =new ArrayList<CategoryDto>();
				for(int i = 0;i<categoryList.size();i++){
					if(categoryList.get(i).getCategoryIsLeaf()==1)
						fCategoryList.add(categoryList.get(i));
					else
						fCategoryList.addAll(medicineDao.getCategoryChilds(categoryList.get(i).getId()));
				}
				for(int i=0;i<fCategoryList.size();i++){
					cl.add(fCategoryList.get(i).getId());
				}
				}
				mmDto.setCatIdsIn(cl);
			}
			Integer count = matchProductDao.searchMeCountByCode(mmDto);
			mmDto.setPageCount((count+19)/20);
			if (pageNum==0) {
				pageNum = 1;
			}else if (pageNum > ((count+19)/20)) {
				pageNum = ((count+19)/20);
			}
			mmDto.setCurrentPage(pageNum);
			mmDto.setiDisplayStart((mmDto.getCurrentPage()-1)*20);
			matchMedicineList  =  matchProductDao.searchMeByCode(mmDto);
			matchMedicineDto = mmDto;
		}else {
			if (matchMedicineDto.getCategoryId() == 0) {
				matchMedicineDto.setCategoryId(null);
				matchMedicineDto.setCatIdsIn(null);
			}else{
				List<Integer> cl=new ArrayList<Integer>();
				if(medicineDao.getCategoryNameById(matchMedicineDto.getCategoryId()).getCategoryIsLeaf()==1)
				{
					cl.add(matchMedicineDto.getCategoryId());
				}else{
				List<CategoryDto> categoryList = medicineDao.getCategoryChilds(matchMedicineDto.getCategoryId());
				List<CategoryDto> fCategoryList =new ArrayList<CategoryDto>();
				for(int i = 0;i<categoryList.size();i++){
					if(categoryList.get(i).getCategoryIsLeaf()==1)
						fCategoryList.add(categoryList.get(i));
					else
						fCategoryList.addAll(medicineDao.getCategoryChilds(categoryList.get(i).getId()));
				}
				
				for(int i=0;i<fCategoryList.size();i++){
					cl.add(fCategoryList.get(i).getId());
				}
				}
				matchMedicineDto.setCatIdsIn(cl);
			}
			Integer count = matchProductDao.searchMeCountByCode(matchMedicineDto);
			matchMedicineDto.setPageCount((count+19)/20);
			matchMedicineDto.setCurrentPage(pageNum);
			matchMedicineDto.setiDisplayStart((matchMedicineDto.getCurrentPage()-1)*20);
			matchMedicineList  =  matchProductDao.searchMeByCode(matchMedicineDto);
		}
		//下位读取种类名称的代码
		for(int i =0;i<matchMedicineList.size();i++){
			CategoryDto cd = medicineDao.getCategoryNameById(matchMedicineList.get(i).getCategoryId());
			matchMedicineList.get(i).setCategoryName(cd.getCategoryName());
		}
		return "queryMedicineByCode";
	}
}

 3、页面的相关设置，以及跳转的参数传递

querymedicine.jsp

<table class="display" id="queryResultTbl">
	<thead>
		<tr id="headTitle">
		    <th  style="background-color: #5eaeae" ><input type="checkbox" id="chooseBox" onchange = "chooseAll()"/>&nbsp;&nbsp;&nbsp;&nbsp;全选</th>
			<th  style="background-color: #5eaeae" >药网商品链接</th>
			<th  style="background-color: #5eaeae" >商品编码</th>
			<th  style="background-color: #5eaeae" >药网分类</th>
			<th  style="background-color: #5eaeae" >目标网站</th>
			<th  style="background-color: #5eaeae" >目标商品链接</th>
			<th  style="background-color: #5eaeae" >商品匹配时间</th>
		</tr>
	</thead>
		<tbody id="tobyContent" style="text-align:center">
			<s:iterator value="matchMedicineList" id="matchMedicine" status="coll">
			<tr align="center">
				<td><input type="checkbox"  name="matchId" onclick="chooseMatch()" value="${matchMedicine.id}"/></td>
				<td><a href="http://www.111.com.cn/product/${matchMedicine.productId}">${matchMedicine.name}</a></td>
				<td>${matchMedicine.productCode}</td>
				<td>${matchMedicine.categoryName}</td>
				<td>${matchMedicine.siteName}</td>
				<td><a href="${matchMedicine.pageUrl}" target="_blank">${name}</a></td>
				<td>${matchMedicine.matchTimeStr}</td>
			</tr>
			</s:iterator>
		</tbody>
		<tr><td><div>
<a href="medicineAction_queryMedicineByCode.action?next=1&pageNum=1&condition=${matchMedicineDto.condition}">首页</a>
<a href="medicineAction_queryMedicineByCode.action?next=1&pageNum=${matchMedicineDto.currentPage+1}&condition=${matchMedicineDto.condition}">下一页</a>
<a href="medicineAction_queryMedicineByCode.action?next=1&pageNum=${matchMedicineDto.currentPage-1}&condition=${matchMedicineDto.condition}">上一页</a>
<a href="medicineAction_queryMedicineByCode.action?next=1&pageNum=${matchMedicineDto.pageCount}&condition=${matchMedicineDto.condition}">尾页</a>
<span>总共${matchMedicineDto.pageCount}页</span>
 </div>
</td></tr>
	<tr><td><input type="button" value="删 除" class="button2" onclick="delMatch()" id="delbutton"/></td></tr></table>

 不懂的问QQ526151410