top.lingkang.finalsql.sql.FinalPageInterceptor Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of final-sql-core Show documentation

final-sql 一个轻量级数据库ORM框架。

The newest version!

package top.lingkang.finalsql.sql;

import top.lingkang.finalsql.base.SqlInterceptor;
import top.lingkang.finalsql.config.SqlConfig;
import top.lingkang.finalsql.dialect.SqlDialect;
import top.lingkang.finalsql.error.FinalSqlException;
import top.lingkang.finalsql.sql.core.FinalSqlManage;

import java.sql.Connection;

/**
 * @author lingkang
 * Created by 2022/5/22
 * 分页拦截器
 */
public class FinalPageInterceptor implements SqlInterceptor {
    private SqlConfig sqlConfig;
    private FinalSqlManage finalSqlManage;

    public FinalPageInterceptor(SqlConfig sqlConfig, FinalSqlManage finalSqlManage) {
        this.sqlConfig = sqlConfig;
        this.finalSqlManage = finalSqlManage;
    }

    @Override
    public void before(ExSqlEntity sqlEntity, Connection connection) {
        PageInfo pageInfo = finalSqlManage.PAGE_INFO_THREAD_LOCAL.get();
        if (pageInfo != null && pageInfo.isStart()) {
            try {
                SqlDialect sqlDialect = sqlConfig.getSqlDialect();
                ExSqlEntity totalSql = sqlDialect.total(sqlEntity);
                pageInfo.setStart(false);// 防止执行下面的查询时，进入死循环
                Integer totals = finalSqlManage.selectForObject(totalSql.getSql(), Integer.class, totalSql.getParam());
                pageInfo.setTotal(totals);
                finalSqlManage.PAGE_INFO_THREAD_LOCAL.set(pageInfo);
                String s = sqlDialect.rowSql(sqlEntity.getSql(), (pageInfo.getPage() - 1) * pageInfo.getSize(), pageInfo.getSize());
                sqlEntity.setSql(s);
            } catch (Exception e) {
                throw new FinalSqlException("分页处理异常：", e);
            }
        }
    }

    @Override
    public void after(ExSqlEntity sqlEntity, Connection connection, Object result) {

    }
}