mysqlquery.java

EasyDBO是一个超轻量级对象-关系映射（Object/Relation Mapping

package com.easyjf.dbo.sql;

import java.util.*;

import com.easyjf.dbo.*;

/**
 * 
 * <p>
 * Title: MySQL查询方言实现
 * </p>
 * 
 * <p>
 * Description:
 * </p>
 * 
 * <p>
 * Copyright: Copyright (c) 2006
 * </p>
 * 
 * <p>
 * Company: EasyJF开源团队-EasyDBO项目组
 * </p>
 * 
 * @author piginzoo、大峡、clyyu
 * @version 1.0
 */

public class MySqlQuery extends AbstractSqlQuery {
	

	public String getTopSql(String sql, int number) {
		StringBuffer s = new StringBuffer(sql);
		if (sql == null) {
			return "";
		}
		if (sql.toLowerCase().indexOf(" limit ") < 0) {
			s.append(" limit " + number);
		}

		return s.toString();
	}


	/**
	 * todo:待实现 获取分页SQL
	 * 
	 * @param sql
	 *            String SQL语句
	 * @param first
	 *            int 开始行
	 * @param max
	 *            int 页面显示行数
	 * @return String
	 */
	public String getTopSql(String sql, int first, int max) {
		StringBuffer s = new StringBuffer(sql);
		if (sql == null) {
			return "";
		}
		if (sql.toLowerCase().indexOf(" limit ") < 0) {
			//s.append(" limit " +(first-1<0?first:first-1)+","+max);
			s.append(" limit " +(first)+","+max);
		}
		return s.toString();
	}

	
}