pers.clare.hisql.service.SQLStoreNextService Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of hi-sql Show documentation
Have fun using SQL
The newest version!
package pers.clare.hisql.service;

import pers.clare.hisql.exception.HiSqlException;
import pers.clare.hisql.page.Next;
import pers.clare.hisql.page.Pagination;
import pers.clare.hisql.page.Sort;
import pers.clare.hisql.store.SQLCrudStore;
import pers.clare.hisql.store.SQLStore;
import pers.clare.hisql.util.ConnectionUtil;
import pers.clare.hisql.util.ResultSetUtil;

import java.sql.Connection;
import java.util.List;


@SuppressWarnings("unused")
public abstract class SQLStoreNextService extends SQLStoreQueryService {

    public  Next next(
            SQLStore sqlStore
            , String sql
            , Object... parameters
    ) {
        return doNext(sqlStore, sql, null, parameters);
    }

    public  Next next(
            SQLStore sqlStore
            , String sql
            , Sort sort
            , Object... parameters
    ) {
        return doNext(sqlStore, sql, toPagination(sort), parameters);
    }

    public  Next next(
            SQLStore sqlStore
            , String sql
            , Pagination pagination
            , Object... parameters
    ) {
        return doNext(sqlStore, sql, pagination, parameters);
    }

    public  Next next(
            SQLCrudStore sqlStore
            , Pagination pagination
            , Object... parameters
    ) {
        return doNext(sqlStore, sqlStore.getSelect(), pagination, parameters);
    }

    private  Next doNext(
            SQLStore sqlStore
            , String sql
            , Pagination pagination
            , Object... parameters
    ) {
        pagination = getPagination(pagination);
        if (pagination.getSize() == 0) return Next.empty(pagination);
        String executeSql = buildPaginationSQL(pagination, sql);
        Connection connection = null;
        try {
            connection = getConnection();
            List list = ResultSetUtil.toInstances(ConnectionUtil.query(connection, executeSql, parameters), sqlStore);
            return toNext(pagination, list);
        } catch (HiSqlException e) {
            throw e;
        } catch (Exception e) {
            throw new HiSqlException(executeSql, e);
        } finally {
            closeConnection(connection);
        }
    }
}