sortandlimitcriteria.java

来自「OR Mapping工具」· Java 代码 · 共 45 行

/*
 * Created on Nov 18, 2004
 *
 */
package org.ephman.abra.database;

/**
 *  Sort and limit criteria for Postgresql 
 */
public class SortAndLimitCriteria extends SortCriteria {

	private int limit = 0;
	
	public SortAndLimitCriteria() {
		super();			
	}
	
	public SortAndLimitCriteria (SortCriteria sorter, int limit) {
		super ();
		if (sorter != null) {
			super.sortExpressions = sorter.getSortExpressions();
			super.tableAlias = sorter.tableAlias;
		}
		this.limit = limit;
	}

	public SortAndLimitCriteria(String column, boolean ascending, int limit) {
		super(column, ascending);
		this.limit = limit;
	}

	/*
	 * For Postgresql we have syntax:
	 * 
	 * 	select ..... where .... order by ... limit <n>
	 */
	public String toString() {
		String result = super.toString();
		if (limit > 0) {
			result += " limit " + limit;
		}
		return result;
	}
}