pageiteratorjdbc.java

Java/J2EE框架Jdon-Framework系统的Sample

/**
 * Copyright 2005 Jdon.com
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at

       http://www.apache.org/licenses/LICENSE-2.0

  * Unless required by applicable law or agreed to in writing, software
  * distributed under the License is distributed on an "AS IS" BASIS,
  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  * See the License for the specific language governing permissions and
  * limitations under the License.
  */

package com.jdon.model.query;

import java.sql.*;

import com.jdon.controller.model.PageIterator;

/**
 *  数据库层调用，适用于批量查询
 *
 *
 * <p>Copyright: Jdon.com Copyright (c) 2003</p>
 * <p></p>
 * @author banq
 * @version 1.0
 */
public abstract class PageIteratorJDBC {

  public abstract int fetchDataAllCount(Object key, String sqlquery) throws
      Exception;

  public abstract PageIterator fetchDatas(Object key, String sqlquery,
                                          int start, int count)
      throws Exception;

  public void setSqlKey(Object key, PreparedStatement ps) throws Exception {
    if (key == null)
      return;
    if (key instanceof String) {
      String keyStrs = (String) key;
      if (!keyStrs.equals(""))
        ps.setString(1, keyStrs);
    } else if (key instanceof Integer) {
      ps.setInt(1, ( (Integer) key).intValue());
    }
  }

}