pers.clare.hisql.page.PostgreSQLPaginationMode 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.page;

import pers.clare.hisql.exception.HiSqlException;
import pers.clare.hisql.util.ConnectionUtil;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;

@SuppressWarnings("unused")
public class PostgreSQLPaginationMode implements PaginationMode {
    public void appendPaginationSQL(
            StringBuilder sql
            , Pagination pagination
    ) {
        appendSortSQL(sql, pagination.getSorts());
        sql.append(" limit ")
                .append(pagination.getSize())
                .append(',')
                .append(pagination.getSize() * pagination.getPage());
    }

    @Override
    public long getVirtualTotal(
            Pagination pagination
            , Connection connection
            , String sql
            , Object[] parameters
    ) throws SQLException {
        String totalSql = "explain select count(*) from(" + sql + ")t";
        ResultSet rs = ConnectionUtil.query(connection, totalSql, parameters);
        if (rs.next()) {
            return rs.getLong("rows");
        } else {
            throw new HiSqlException(String.format("query total error.(%s)", totalSql));
        }
    }
}