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.
/*********************************************************************************
* *
* The MIT License (MIT) *
* *
* Copyright (c) 2015-2022 aoju.org mybatis.io and other contributors. *
* *
* Permission is hereby granted, free of charge, to any person obtaining a copy *
* of this software and associated documentation files (the "Software"), to deal *
* in the Software without restriction, including without limitation the rights *
* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell *
* copies of the Software, and to permit persons to whom the Software is *
* furnished to do so, subject to the following conditions: *
* *
* The above copyright notice and this permission notice shall be included in *
* all copies or substantial portions of the Software. *
* *
* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR *
* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, *
* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE *
* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER *
* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, *
* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN *
* THE SOFTWARE. *
* *
********************************************************************************/
package org.aoju.bus.mapper.provider.base;
import org.aoju.bus.mapper.builder.MapperBuilder;
import org.aoju.bus.mapper.builder.MapperTemplate;
import org.aoju.bus.mapper.builder.SqlBuilder;
import org.apache.ibatis.mapping.MappedStatement;
/**
* BaseSelectProvider实现类，基础方法实现类
*
* @author Kimi Liu
* @since Java 17+
*/
public class BaseSelectProvider extends MapperTemplate {
public BaseSelectProvider(Class mapperClass, MapperBuilder mapperBuilder) {
super(mapperClass, mapperBuilder);
}
/**
* 查询
*
* @param ms MappedStatement
* @return the string
*/
public String selectOne(MappedStatement ms) {
Class entityClass = getEntityClass(ms);
// 修改返回值类型为实体类型
setResultType(ms, entityClass);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.selectAllColumns(entityClass));
sql.append(SqlBuilder.fromTable(entityClass, tableName(entityClass)));
sql.append(SqlBuilder.whereAllIfColumns(entityClass, isNotEmpty()));
return sql.toString();
}
/**
* 查询
*
* @param ms MappedStatement
* @return the string
*/
public String select(MappedStatement ms) {
Class entityClass = getEntityClass(ms);
// 修改返回值类型为实体类型
setResultType(ms, entityClass);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.selectAllColumns(entityClass));
sql.append(SqlBuilder.fromTable(entityClass, tableName(entityClass)));
sql.append(SqlBuilder.whereAllIfColumns(entityClass, isNotEmpty()));
sql.append(SqlBuilder.orderByDefault(entityClass));
return sql.toString();
}
/**
* 查询
*
* @param ms MappedStatement
* @return the string
*/
public String selectByRowBounds(MappedStatement ms) {
return select(ms);
}
/**
* 根据主键进行查询
*
* @param ms MappedStatement
* @return the string
*/
public String selectByPrimaryKey(MappedStatement ms) {
final Class entityClass = getEntityClass(ms);
// 将返回值修改为实体类型
setResultType(ms, entityClass);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.selectAllColumns(entityClass));
sql.append(SqlBuilder.fromTable(entityClass, tableName(entityClass)));
sql.append(SqlBuilder.wherePKColumns(entityClass));
return sql.toString();
}
/**
* 查询总数
*
* @param ms MappedStatement
* @return the string
*/
public String selectCount(MappedStatement ms) {
Class entityClass = getEntityClass(ms);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.selectCount(entityClass));
sql.append(SqlBuilder.fromTable(entityClass, tableName(entityClass)));
sql.append(SqlBuilder.whereAllIfColumns(entityClass, isNotEmpty()));
return sql.toString();
}
/**
* 根据主键查询总数
*
* @param ms MappedStatement
* @return the string
*/
public String existsWithPrimaryKey(MappedStatement ms) {
Class entityClass = getEntityClass(ms);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.selectCountExists(entityClass));
sql.append(SqlBuilder.fromTable(entityClass, tableName(entityClass)));
sql.append(SqlBuilder.wherePKColumns(entityClass));
return sql.toString();
}
/**
* 查询全部结果
*
* @param ms MappedStatement
* @return the string
*/
public String selectAll(MappedStatement ms) {
final Class entityClass = getEntityClass(ms);
// 修改返回值类型为实体类型
setResultType(ms, entityClass);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.selectAllColumns(entityClass));
sql.append(SqlBuilder.fromTable(entityClass, tableName(entityClass)));
// 逻辑删除的未删除查询条件
sql.append("");
sql.append(SqlBuilder.whereLogicDelete(entityClass, false));
sql.append("");
sql.append(SqlBuilder.orderByDefault(entityClass));
return sql.toString();
}
}
