sqlserverdialect.java

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

package com.wxd.common.paging;

/**
 * ��ҳ��ѯ����֧��SQLServerʵ�� ��û����SQLServer�н��в��ԣ����ݲ��Խ����е���
 * �ο�hibernate ʵ��
 * @author <a href="mailto:[e-mail]">zhuwei </a>
 * @version 1.0
 */
public class SQLServerDialect implements Dialect {

	public String getLimitString(String querySelect, boolean hasOffset) {
		return "";
	}

	public String getLimitString(String querySelect, int offset, int limit) {
		if (offset > 0)
			throw new UnsupportedOperationException("sql server has no offset");
		else
			return (new StringBuffer(querySelect.length() + 8)).append(
					querySelect).insert(getAfterSelectInsertPoint(querySelect),
					" top " + limit).toString();
	}

	static int getAfterSelectInsertPoint(String sql) {
		int selectIndex = sql.toLowerCase().indexOf("select");
		int selectDistinctIndex = sql.toLowerCase().indexOf("select distinct");
		return selectIndex + (selectDistinctIndex != selectIndex ? 6 : 15);
	}

	public boolean supportsLimit() {
		return true;
	}

	public String getSelectGUIDString() {
		return "select newid()";
	}

	public char closeQuote() {
		return ']';
	}

	public char openQuote() {
		return '[';
	}

}