• Home
• com.talanlabs
• component-mybatis-rsql
• 1.0.4
• source code
• OracleHandler.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.OracleHandler Maven / Gradle / Ivy

package com.talanlabs.mybatis.rsql.database;

import com.talanlabs.component.IComponent;
import com.talanlabs.component.factory.ComponentDescriptor;
import com.talanlabs.component.factory.ComponentFactory;
import com.talanlabs.entity.annotation.Entity;
import com.talanlabs.mybatis.component.helper.ComponentMyBatisHelper;
import com.talanlabs.mybatis.rsql.engine.EngineContext;
import com.talanlabs.mybatis.rsql.statement.IPageStatementFactory;
import com.talanlabs.mybatis.rsql.statement.Request;

import java.util.Map;

public class OracleHandler implements IPageStatementFactory {

    @Override
    public  String buildPageSql(Class componentClass, String sqlFromWhereOrderBy, Request.Rows rows, Map additionalParameters, EngineContext context) {
        ComponentDescriptor cd = ComponentFactory.getInstance().getDescriptor(componentClass);
        Entity entity = ComponentMyBatisHelper.getEntityAnnotation(cd);

        long first = rows.offset + 1;
        long last = rows.offset + 1 + rows.limit;

        String firstParam = context.getNewParamName();
        String lastParam = context.getNewParamName();
        additionalParameters.put(firstParam, first);
        additionalParameters.put(lastParam, last);

        return "SELECT i.rn, t.* " + "FROM (SELECT i.* " + "FROM (SELECT i.*, ROWNUM AS rn " + "FROM (SELECT ROWID AS a_rowid " + sqlFromWhereOrderBy + ") i " + "WHERE ROWNUM <= #{" + lastParam
                + ",javaType=long} " + ") i " + "WHERE rn >= #{" + firstParam + ",javaType=long} " + ") i " + ", " + entity.name() + " t " + "WHERE i.a_rowid = t.ROWID " + "ORDER BY rn";
    }
}