• Home
• com.bladejava
• blade-jdbc-core
• 0.0.41-RELEASE
• source code
• MySQLDialect.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.blade.jdbc.dialect.MySQLDialect Maven / Gradle / Ivy

package com.blade.jdbc.dialect;

import com.blade.jdbc.page.PageRow;

/**
 * @author biezhi
 * @date 2017/12/19
 */
public class MySQLDialect implements Dialect {

    @Override
    public String getPagingSql(String sql, PageRow pageRow) {
        StringBuilder sqlBuilder = new StringBuilder(sql.length() + 14);
        sqlBuilder.append(sql);
        if (pageRow.getOffset() == 0) {
            sqlBuilder.append(" LIMIT ");
            sqlBuilder.append(pageRow.getLimit());
        } else {
            sqlBuilder.append(" LIMIT ");
            sqlBuilder.append(pageRow.getOffset());
            sqlBuilder.append(",");
            sqlBuilder.append(pageRow.getLimit());
        }
        return sqlBuilder.toString();
    }

}