拼装getTotalCount的sql

v1.3

package testsql;

/**
 * Created by dinghw on 2015/5/4.
 *
 * @desc 优化了第一版包含group by查询效率低的问题
 * 此类只支持特定的场景使用，
 * 并且存在写法上的要求：group by 后的参数必须不能存在空格，并且最后一个参数后需要保留一个空格，
 * 例：group by t.app_id,t.channel_id  (channel_id后必须得有空格)
 * <p/>
 * v1.3 修复group by  后面存在order by时sql拼接错误
 * 修复两层select查询 sql拼接错误
 */
public class SqlUtil {
  
    private static final String SELECT = "SELECT ";
    private static final String FROM = " FROM ";
    private static final String WHERE = " WHERE ";
    private static final String GROUP = " GROUP BY ";
    private static final String ORDER = " ORDER BY ";
    private static final String AS = "\\) AS ";

    public static StringBuffer getCountSql(String sql) throws Exception {