• Home
• com.talanlabs
• component-mybatis-rsql
• 1.0.4
• source code
• StandardHandler.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.talanlabs.mybatis.rsql.database.StandardHandler Maven / Gradle / Ivy

package com.talanlabs.mybatis.rsql.database;

import com.talanlabs.component.IComponent;
import com.talanlabs.mybatis.rsql.engine.EngineContext;
import com.talanlabs.mybatis.rsql.statement.IPageStatementFactory;
import com.talanlabs.mybatis.rsql.statement.Request;
import org.apache.commons.lang3.StringUtils;

import java.util.Map;

public class StandardHandler implements IPageStatementFactory {

    @Override
    public  String buildPageSql(Class componentClass, String sqlFromWhereOrderBy, Request.Rows rows, Map additionalParameters, EngineContext context) {
        String sql = "SELECT " + (StringUtils.isNotBlank(context.getDefaultTableName()) ? context.getDefaultTableName() + "." : "") + "* " + sqlFromWhereOrderBy;
        String limitParam = context.getNewParamName();
        String offsetParam = context.getNewParamName();
        additionalParameters.put(limitParam, rows.limit);
        additionalParameters.put(offsetParam, rows.offset);
        sql += " LIMIT #{" + limitParam + ",javaType=long} OFFSET #{" + offsetParam + ",javaType=long}";
        return sql;
    }
}