com.bixuebihui.jdbc.IReaderService Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of c-dbtools Show documentation

a fast small database connection pool and a active record flavor mini framework

There is a newer version: 1.15.3.3

package com.bixuebihui.jdbc;

import java.sql.SQLException;
import java.util.Collection;

/**
 * 配合使用完成分页读取数据库表
 *
 * @author xingwx
 * @param   返回类型
 * @version $Id: $Id
 */
public interface IReaderService {

    /**
     * select.
     *
     * @param whereClause a {@link java.lang.String} object.
     * @param params parameters for prepared statement
     * @param orderBy     a {@link java.lang.String} object.
     * @param rowStart    a int.
     * @param rowEnd      a int.
     * @return a {@link java.util.Collection} object.
     * @throws java.sql.SQLException if any.
     */
    Collection select(String whereClause, Object[] params, String orderBy, int rowStart, int rowEnd) throws SQLException;

    /**
     * count.
     *
     * @param whereClause a {@link java.lang.String} object.
     * @return a int.
     * @throws java.sql.SQLException if any.
     */
    int count(String whereClause) throws SQLException;
    int countWhere(String whereClause, Object[] params) throws SQLException;


}