hsqlselectsql.java

来自「羽量级数据持久层开发框架」· Java 代码 · 共 37 行

package org.speedframework.sql.hsql;

import org.speedframework.entity.Pagination;
import org.speedframework.sql.AbstractSelectSQL;

/**
 * Class HSQLSelectSQL
 * 
 * @author <a href="mailto:[e-mail]"> lizf </a>
 * @version $Revision:1.0.0, $Date: 2007-11-1 上午08:24:26 $
 */
public class HSQLSelectSQL extends AbstractSelectSQL {

	public String getLimitSQL(String sql) {
		StringBuffer stringBuffer = new StringBuffer(10);
		stringBuffer.append("select limit ? ? * from (");
		stringBuffer.append(sql);
		stringBuffer.append(" )");

		return stringBuffer.toString();
	}

	public Object[] getQueryLimitParam(Object[] params, Pagination pagination) {
		int length = params.length;
		Object[] new_param = new Object[length + 2];

		new_param[0] = new Integer((pagination.getPage() - 1)
				* pagination.getCount());
		new_param[1] = new Integer(pagination.getCount() * pagination.getPage());
		for (int j = 2; j < new_param.length; j++) {
			new_param[j] = params[j - 2];
		}
		return new_param;

	}
}