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;
import org.aoju.bus.core.exception.InternalException;
import org.aoju.bus.mapper.builder.EntityBuilder;
import org.aoju.bus.mapper.builder.MapperBuilder;
import org.aoju.bus.mapper.builder.MapperTemplate;
import org.aoju.bus.mapper.builder.SqlBuilder;
import org.aoju.bus.mapper.entity.EntityColumn;
import org.apache.ibatis.mapping.MappedStatement;
import java.util.Set;
/**
* 通过 ids 字符串的各种操作
* ids 如 "1,2,3"
*
* @author Kimi Liu
* @since Java 17+
*/
public class IdsProvider extends MapperTemplate {
public IdsProvider(Class> mapperClass, MapperBuilder mapperBuilder) {
super(mapperClass, mapperBuilder);
}
/**
* 根据主键字符串进行删除,类中只有存在一个带有@Id注解的字段
*
* @param ms MappedStatement
* @return the string
*/
public String deleteByIds(MappedStatement ms) {
final Class> entityClass = getEntityClass(ms);
StringBuilder sql = new StringBuilder();
sql.append(SqlBuilder.deleteFromTable(entityClass, tableName(entityClass)));
Set columnList = EntityBuilder.getPKColumns(entityClass);
if (columnList.size() == 1) {
EntityColumn column = columnList.iterator().next();
sql.append(" where ");
sql.append(column.getColumn());
sql.append(" in (${_parameter})");
} else {
throw new InternalException("继承 deleteByIds 方法的实体类[" + entityClass.getName() + "]中必须只有一个带有 @Id 注解的字段");
}
return sql.toString();
}
/**
* 根据主键字符串进行查询,类中只有存在一个带有@Id注解的字段
*
* @param ms MappedStatement
* @return the string
*/
public String selectByIds(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)));
Set columnList = EntityBuilder.getPKColumns(entityClass);
if (columnList.size() == 1) {
EntityColumn column = columnList.iterator().next();
sql.append(" where ");
sql.append(column.getColumn());
sql.append(" in (${_parameter})");
} else {
throw new InternalException("继承 selectByIds 方法的实体类[" + entityClass.getName() + "]中必须只有一个带有 @Id 注解的字段");
}
return sql.toString();
}
}