gu.sql2java.PageQueryOffsetFetchImpl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sql2java-manager Show documentation

sql2java manager class package for accessing database

There is a newer version: 5.2.0

package gu.sql2java;

import com.google.common.base.Strings;

class PageQueryOffsetFetchImpl implements IPageQueryWrap {

	public PageQueryOffsetFetchImpl() {
	}

	@Override
	public String wrap(String sql, int startRow, int numRows) {
        if(!Strings.isNullOrEmpty(sql) && numRows > 0){
			return sql + " OFFSET " + (startRow -1)  + " ROWS FETCH NEXT " + numRows + " ROWS ONLY";
    	}
		return null;
	}

}