com.eshore.jdbc.impl.OraclePagination Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of simpleJdbc Show documentation

simpleJdbc

There is a newer version: 2.0.2

package com.eshore.jdbc.impl;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

import com.eshore.jdbc.api.IPagination;

/**
 * Pagination for oracle
 * @author eric
 *
 */
public class OraclePagination implements IPagination {

	
	@Override
	public String fixSQl(String sql, int page, int pageSize) {
		if (pageSize < 1)pageSize = 10;
		if (page < 1)page = 1;
		int begin = (page - 1) * pageSize;
		StringBuilder sb = new StringBuilder();
		sb.append("SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (");
		sb.append(sql);
		sb.append(") A WHERE ROWNUM <= ").append(begin+pageSize).append (" ) WHERE RN >=").append(begin);
		return sb.toString();
	}
	
	@Override
	public String fixCountSQL(String sql) {
		return "select count(1) from (" +removeOrderBy(sql) + ") a";
	}

	@Override
	public int extract(int row, int page, int pageSize) {
		return VALUE;
	}
	
	Pattern p=Pattern.compile(".*(ORDER +BY).*");
	private String removeOrderBy(String sql) {
		String sql2=sql.toUpperCase();
		Matcher m = p.matcher(sql2);
		if(m.matches()) {
			String or=m.group(1);
			 sql =sql.substring(0,sql2.indexOf(or));
		}
		return sql;
	}
}