pagedstatement.java

来自「本项目是基于展示新闻的一款产品。在本系统中用户可以自定义栏目及新闻分类 发布新」· Java 代码 · 共 89 行

/**
 * Copyright: Copyright (c) 2004 Handson
 * Description: �̳�pagable�ӿ�
 * Title: ConnectionFactory.java
 * @author Administrator
 * Create Time: ����10:05:30
 * @Version:1.0
 */
package cn.handson.model.service.dao.page;

import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.sql.RowSet;

import cn.handson.model.connection.ConnectionFactory;
import cn.handson.model.service.dao.page.Pagable;
import cn.handson.model.service.dao.page.PageInfo;


public abstract class PagedStatement implements Pagable {
	
	
	
	protected ConnectionFactory connProvider;
	 /**
	 * @return the connProvider
	 */
	public ConnectionFactory getConnProvider() {
		return connProvider;
	}

	/**
	 * @param connProvider the connProvider to set
	 */
	public void setConnProvider(ConnectionFactory connProvider) {
		this.connProvider = connProvider;
	}

 /**
 * Description: 
 * @param sql
 * @param pageNo
 * @param pageSize
 */
public abstract void initStatement(String sql, int pageNo, int pageSize); 
 /**
  * Query one page data.
  * @return ResutSet object that contains records of page.
  * @throws SQLException if any database exception occurs.
  */
 public abstract RowSet executeQuery() throws SQLException;
 /**
  * Close PreparedStatement & Connection
  * @throws SQLException if any database exception coccurs.
  */
 public void close() throws SQLException{

 }
  /**
  * Query one page data.
  * @return RowSet object that contains records of page.The RowSet can be used
  * without Database Connection actived.
  * @throws SQLException if any databas exception occurs.
  */
 public RowSet getPagedRowSet() throws SQLException{
   throw new java.lang.UnsupportedOperationException();
 }
 /**
  * Generats the sql that search one page data from database.
  * @param sql Original sql.
  * @param startIndex the start position.
  * @param size the amount of records we want to get.
  * @return the sql that can be used to get one page data.
  */
 protected abstract String initQuerySql(String sql, long startIndex, int size);
 /**
  * Populates ResultSet object to RowSet object.
  */
 protected abstract RowSet populate( ResultSet rs ) throws SQLException;

 public abstract PageInfo getPageInfo();
}