hsqldialect.java

jsf+spring+ibatis 的一个程序,主要用来介绍JSF程序.

package com.wxd.common.paging;
/**
 * ��ҳ��ѯ����֧��HSQLʵ��  ��û����HSQL�н��в��ԣ����ݲ��Խ����е��� 
 * �ο�hibernate ʵ��  
 * @author <a href="mailto:[e-mail]">zhuwei </a>
 * @version 1.0
 */
public class HSQLDialect implements Dialect {

	public String getLimitString(String sql, boolean hasOffset) {
		return (new StringBuffer(sql.length() + 10)).append(sql).insert(
				sql.toLowerCase().indexOf("select") + 6,
				hasOffset ? " limit ? ?" : " top ?").toString();
	}

	public String getLimitString(String querySelect, int offset, int limit) {
		return "";
	}

	public String[] getCreateSequenceStrings(String sequenceName) {
		return (new String[] {
				"create table dual_" + sequenceName + " (zero integer)",
				"insert into dual_" + sequenceName + " values (0)",
				"create sequence " + sequenceName + " start with 1" });
	}

	public String[] getDropSequenceStrings(String sequenceName) {
		return (new String[] {
				"drop table dual_" + sequenceName + " if exists",
				"drop sequence " + sequenceName });
	}

	public String getSequenceNextValString(String sequenceName) {
		return "select next value for " + sequenceName + " from dual_"
				+ sequenceName;
	}

	public boolean supportsSequences() {
		return true;
	}

	public String getQuerySequencesString() {
		return "select sequence_name from system_sequences";
	}
	
	public boolean supportsLimit() {
		return true;
	}

}