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.mybatiseasy.core.base.Column Maven / Gradle / Ivy
/*
* Copyright (c) 2023, 杭州坦信科技有限公司 (https://www.mybatis-easy.com).
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
*/
package com.mybatiseasy.core.base;
import com.mybatiseasy.core.config.GlobalConfig;
import com.mybatiseasy.core.consts.Sql;
import com.mybatiseasy.core.sqlbuilder.Condition;
import com.mybatiseasy.core.utils.SqlUtil;
import com.mybatiseasy.core.utils.TypeUtil;
import java.util.*;
import java.util.stream.Collectors;
public class Column {
protected List columns;
protected Map parameterMap;
ColumnData column;
public Column() {
this("", "");
}
public Column(String entity, String table) {
this(entity, table, table);
}
public Column(String entity, String table, String tableAlias) {
this.columns = new ArrayList<>();
this.column = new ColumnData();
this.parameterMap = new HashMap<>();
this.column.setEntityName(entity);
this.column.setTableAlias(tableAlias);
this.column.setTable(table);
}
public String getFullTable(){
String fullName = this.column.getTable();
if (TypeUtil.isNotEmpty(this.column.getTableAlias())) fullName += Sql.SPACE + "AS" + Sql.SPACE + SqlUtil.addBackquote(this.column.getTableAlias());
return fullName;
}
public void addColumn(String columnName) {
this.addColumn(columnName, "");
}
public void addColumn(String columnName, String columnAlias) {
ColumnData newColumn = new ColumnData();
newColumn.setColumn(columnName);
if(this.column!= null) {
newColumn.setEntityName(this.column.getEntityName());
newColumn.setTable(this.column.getTable());
if (TypeUtil.isNotEmpty(this.column.getTableAlias())) newColumn.setTableAlias(this.column.getTableAlias());
}
if (TypeUtil.isNotEmpty(columnAlias)) newColumn.setColumnAlias(columnAlias);
if(this.columns.stream().noneMatch(item ->
item.getTable().equals(newColumn.getTable())
&& item.getTableAlias().equals(newColumn.getTableAlias())
&& item.getColumn().equals(newColumn.getColumn()))) {
this.columns.add(newColumn);
}
this.column = newColumn;
}
/**
* 当出现在非 select语句下时，要去除新添加的column,因为此时并不是为了表示select字段。
* 例如：在where语句中，新添加了column,但是该column会出现在select 语句中，所以要删除。
*/
public void removeLastColumn() {
if (this.columns.size() > 0)
this.columns.remove(this.columns.size() - 1);
}
public void columnAlias(String columnAlias) {
int lastIndex = this.columns.size() - 1;
this.column.setColumnAlias(columnAlias);
this.columns.get(lastIndex).setColumnAlias(columnAlias);
}
public List getAllColumns() {
return this.columns.stream().map(this::getFullColumn).collect(Collectors.toList());
}
public ColumnData getColumn() {
return this.column;
}
public String getTableColumn() {
if (TypeUtil.isNotEmpty(this.column.getTableAlias())) return this.column.getTableAlias() + "." + this.column.getColumn();
return this.column.getColumn();
}
public String getFullColumn() {
String fullName = this.getTableColumn();
if (TypeUtil.isNotEmpty(this.column.getColumnAlias())) fullName += Sql.SPACE + "AS" + Sql.SPACE + SqlUtil.addBackquote(this.column.getColumnAlias());
return fullName;
}
public String getTableColumn(ColumnData column) {
if (TypeUtil.isNotEmpty(column.getTableAlias())) return column.getTableAlias() + "." + column.getColumn();
return column.getColumn();
}
public String getFullColumn(ColumnData column) {
String fullName = this.getTableColumn(column);
if(TypeUtil.isNotEmpty(column.getMethod())) fullName = column.getMethod() +"("+ fullName +")";
if (TypeUtil.isNotEmpty(column.getColumnAlias())) fullName += Sql.SPACE + "AS" + Sql.SPACE + SqlUtil.addBackquote(column.getColumnAlias());
return fullName;
}
/**
* 创建值替位符，如:#{value}
* @return String
*/
private String getValueTag(Object value){
String key = SqlUtil.getMapKey(this.column.getColumn());
this.parameterMap.put(key, value);
return "#{"+ key +"}";
}
/**
* 创建值替位符，如:#{value}
* 注意new Integer[]{1,2,3} 而不能是new int[]{1, 2, 3}
* @return String,如：#{column[0]}, #{column[1]}, #{column[2]}
*/
private String getValueTagArray(Object[] array){
String key = SqlUtil.getMapKey(this.column.getColumn());
//如果值为Enum，取得其值
for(int i=0;i 0) {
sb.append(",");
}
sb.append("#{").append(key).append("[");
sb.append(i);
sb.append("]}");
}
return sb.toString();
}
/**
* 创建值替位符，如:#{value}
* @return String,如：#{column[0]}, #{column[1]}, #{column[2]}
*/
private String getValueTagCollection(Collection collection){
String key = SqlUtil.getMapKey(this.column.getColumn());
this.parameterMap.put(key, collection);
Iterator iter = collection.iterator();
Collection newCollection = new ArrayList<>();
while (iter.hasNext()) {
Object item = iter.next();
Object newItem = item;
if (item.getClass().isEnum()) {
newItem = getEnumValue(item);
}
newCollection.add(newItem);
}
StringBuilder sb = new StringBuilder();
for (int i = 0; i < newCollection.size(); i++) {
if (i > 0) {
sb.append(",");
}
sb.append("#{").append(key).append("[");
sb.append(i);
sb.append("]}");
}
return sb.toString();
}
/**
* 取得枚举类型的值
* @param val 枚举
* @return 值
*/
private Object getEnumValue(Object val){
Class clazz = val.getClass();
for (Object enumConstant : clazz.getEnumConstants()) {
if(enumConstant.equals(val)){
return GlobalConfig.getEnumValueMap(clazz).get(enumConstant.toString());
}
}
throw new RuntimeException("can not get the enum type ["+ val +"] of "+clazz);
}
/**
* 比较运算
*
* @param apply 条件判断，是否应用此运算
* @param val 值
* @param symbol 比较符，如: =,<,<=,>,>=,!=
* @return Condition
*/
private Condition compare(boolean apply, Object val, String symbol) {
this.removeLastColumn();
//值为null时，舍弃不参与条件查询
if(val == null) return new Condition();
String nextConditionSql = "";
if (val instanceof Condition) nextConditionSql = ((Condition) val).getSql();
else if (val instanceof Column) {
((Column) val).removeLastColumn();
nextConditionSql = ((Column) val).getFullColumn();
}
else if(val.getClass().isEnum()){
nextConditionSql = getValueTag(getEnumValue(val));
}
else {
nextConditionSql = getValueTag(val.toString());
}
//不应用条件判断时，直接返回空的Condition
if (!apply) return new Condition();
String sql = this.getTableColumn() + Sql.SPACE + symbol + Sql.SPACE + nextConditionSql;
return new Condition(sql, this.parameterMap);
}
/**
* 比较运算
*
* @param apply 条件判断，是否应用此运算
* @param val 值
* @param symbol 比较符，如: =,<,<=,>,>=,!=
* @return Condition
*/
private Condition template(boolean apply, Object val, String symbol, String template) {
this.removeLastColumn();
//值为null时，舍弃不参与条件查询
if(val == null) return new Condition();
String nextConditionSql = "";
if (val instanceof Condition) nextConditionSql = ((Condition) val).getSql();
else if (val instanceof Column) {
((Column) val).removeLastColumn();
nextConditionSql = ((Column) val).getFullColumn();
}
else if(val.getClass().isEnum()){
nextConditionSql = getValueTag(getEnumValue(val));
}
else {
nextConditionSql = getValueTag(val.toString());
}
//不应用条件判断时，直接返回空的Condition
if (!apply) return new Condition();
String sql = this.getTableColumn() + Sql.SPACE + symbol + Sql.SPACE + nextConditionSql;
return new Condition(sql, this.parameterMap);
}
private Condition compare(boolean apply, Object[] array, String symbol) {
this.removeLastColumn();
if (!apply) return new Condition();
String sql = this.getTableColumn() + Sql.SPACE + symbol + Sql.SPACE + "("+ getValueTagArray(array) +")";
return new Condition(sql, this.parameterMap);
}
private Condition compare(boolean apply, Collection collection, String symbol) {
this.removeLastColumn();
if (!apply) return new Condition();
String sql = this.getTableColumn() + Sql.SPACE + symbol + Sql.SPACE + "("+ getValueTagCollection(collection) +")";
return new Condition(sql, this.parameterMap);
}
private Condition compareBetween(boolean apply, Object val1, Object val2) {
this.removeLastColumn();
if (!apply) return new Condition();
String sql = this.getTableColumn() + Sql.SPACE + "BETWEEN" + Sql.SPACE + getValueTag(val1) + Sql.SPACE + "AND" + Sql.SPACE + getValueTag(val2);
return new Condition(sql, this.parameterMap);
}
private String formatLike(String value) {
if (value.startsWith("%") || value.endsWith("%")) return value;
return "%" + value + "%";
}
private String formatLeftLike(String value) {
if (value.startsWith("%")) return value;
return "%" + value;
}
private String formatRightLike(String value) {
if (value.endsWith("%")) return value;
return value + "%";
}
public Condition eq(Object val) {
return compare(true, val, "=");
}
public Condition lt(Object val) {
return compare(true, val, "<");
}
public Condition le(Object val) {
return compare(true, val, "<=");
}
public Condition gt(Object val) {
return compare(true, val, ">");
}
public Condition ge(Object val) {
return compare(true, val, ">=");
}
public Condition ne(Object val) {
return compare(true, val, "!=");
}
public Condition in(Collection collection) {
return compare(true, collection, "IN");
}
public Condition in(Object... array) {
return compare(true, array, "IN");
}
public Condition notIn(Collection collection) {
return compare(true, collection, "NOT IN");
}
public Condition notIn(Object... array) {
return compare(true, array, "NOT IN");
}
public Condition between(Object val1, Object val2) {
return compareBetween(true, val1, val2);
}
public Condition like(Object val) {
return compare(true, formatLike(val.toString().trim()), "LIKE");
}
public Condition notLike(Object val) {
return compare(true, formatLike(val.toString().trim()), "NOT LIKE");
}
public Condition leftLike(Object val) {
return compare(true, formatLeftLike(val.toString().trim()), "LIKE");
}
public Condition likeLeft(Object val) {
return leftLike(val);
}
public Condition rightLike(Object val) {
return compare(true, formatRightLike(val.toString().trim()), "LIKE");
}
public Condition likeRight(Object val) {
return leftLike(val);
}
/**
* @param apply 条件判断是否应用，当为true时应用
* @param val 值
* @return Condition
*/
public Condition eq(boolean apply, Object val) {
return compare(apply, val, "=");
}
public Condition lt(boolean apply, Object val) {
return compare(apply, val, "<");
}
public Condition le(boolean apply, Object val) {
return compare(apply, val, "<=");
}
public Condition gt(boolean apply, Object val) {
return compare(apply, val, ">");
}
public Condition ge(boolean apply, Object val) {
return compare(apply, val, ">=");
}
public Condition ne(boolean apply, Object val) {
return compare(apply, val, "!=");
}
public Condition in(boolean apply, Object[] array) {
return compare(apply, array, "IN");
}
public Condition in(boolean apply, Collection collection) {
return compare(apply, collection, "IN");
}
public Condition notIn(boolean apply, Object[] array) {
return compare(apply, array, "NOT IN");
}
public Condition notIn(boolean apply, Collection collection) {
return compare(apply, collection, "NOT IN");
}
public Condition between(boolean apply, Object val1, Object val2) {
return compareBetween(apply, val1, val2);
}
public Condition like(boolean apply, Object val) {return compare(apply, formatLike(val.toString().trim()), "LIKE");}
public Condition notLike(boolean apply, Object val) { return compare(apply, formatLike(val.toString().trim()), "NOT LIKE");}
public Condition leftLike(boolean apply, Object val) { return compare(apply, formatLeftLike(val.toString().trim()), "LIKE");}
public Condition likeLeft(boolean apply, Object val) {
return leftLike(apply, val);
}
public Condition rightLike(boolean apply, Object val) { return compare(apply, formatRightLike(val.toString().trim()), "LIKE");}
public Condition likeRight(boolean apply, Object val) {
return leftLike(apply, val);
}
protected void setMethod(String method){
int lastIndex = this.columns.size() - 1;
this.column.setMethod(method);
this.columns.get(lastIndex).setMethod(method);
}
}
