com.obatis.orm.sql.mysql.MysqlCommonMethod Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of obatis-orm Show documentation

obatis-orm, apply database project

The newest version!

package com.obatis.orm.sql.mysql;


import com.obatis.orm.sql.AbstractSqlHandleMethod;

/**
 * @author HuangLongPu
 * 具体 mysql 方法实现
 */
public class MysqlCommonMethod extends AbstractSqlHandleMethod {

	public MysqlCommonMethod() {
		super();
	}

	@Override
	protected String getLikeSql(String expression) {
		return "\"%\"" + expression + "\"%\"";
	}

	@Override
	protected String getLeftLikeSql(String expression) {
		return "\"%\"" + expression;
	}

	@Override
	protected String getRightLikeSql(String expression) {
		return expression + "\"%\"";
	}

	@Override
	protected String appendPageSql(String sql, int pageNumber, int pageSize) {
		if(pageNumber == 0) {
			pageNumber = 1;
		}
		if(pageSize == 0) {
			pageSize = 10;
		}
		return sql + " limit " + getPageLimit(pageNumber, pageSize) + "," + pageSize;
	}

	@Override
	protected String getBatchUpdateDbSql(String sql) {
		return sql;
	}
	
	
}