cn.vonce.sql.bean.Select Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of vonce-sqlbean-core Show documentation
Show all versions of vonce-sqlbean-core Show documentation
This is the core project of Sqlbean.
package cn.vonce.sql.bean;
import cn.vonce.sql.enumerate.JoinType;
import cn.vonce.sql.enumerate.SqlLogic;
import cn.vonce.sql.enumerate.SqlOperator;
import cn.vonce.sql.enumerate.SqlSort;
import cn.vonce.sql.helper.SqlHelper;
import com.google.common.collect.LinkedListMultimap;
import com.google.common.collect.ListMultimap;
import java.io.*;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
/**
* 查询
*
* @author Jovi
* @version 1.0
* @email [email protected]
* @date 2017年8月18日上午9:00:19
*/
public class Select extends SpecialCondition implements Serializable {
private static final long serialVersionUID = 1L;
private boolean useDistinct = false;//默认不去重复
private List columnList = new ArrayList<>();//查询的列字段数组
private List joinList = new ArrayList<>();//表连接的表数组
private List groupByList = new ArrayList<>();//分组
private List orderByList = new ArrayList<>();//排序
private Page page = null;
private String having = null;
private Object[] havingArgs = null;
private ListMultimap havingMap = LinkedListMultimap.create();//having条件包含的逻辑
private String[] filterFields = null;//需要过滤的列字段
/**
* 获取useDistinct是否过滤重复
*
* @return
*/
public boolean isUseDistinct() {
return useDistinct;
}
/**
* 设置useDistinct是否过滤重复
*
* @param useDistinct 是否过滤
*/
public void setUseDistinct(boolean useDistinct) {
this.useDistinct = useDistinct;
}
/**
* 获取column sql 内容
*
* @return
*/
public List getColumnList() {
return columnList;
}
/**
* 设置column list
*
* @param columnList
*/
public void setColumnList(List columnList) {
this.columnList.addAll(columnList);
}
/**
* 设置column
*
* @param columnNames
*/
public void setColumn(String... columnNames) {
for (String columnName : columnNames) {
this.columnList.add(new Column(columnName));
}
}
/**
* 设置column
*
* @param columns
*/
public void setColumn(Column... columns) {
if (columns == null || columns.length == 0) {
return;
}
this.columnList.addAll(Arrays.asList(columns));
}
/**
* 添加column列字段
*
* @param column
* @return
*/
public Select column(Column column) {
this.columnList.add(column);
return this;
}
/**
* 添加column列字段
*
* @param columnName
* @return
*/
public Select column(String columnName) {
return column("", "", columnName, "");
}
/**
* 添加column列字段
*
* @param columnName 列列字段名
* @param columnAlias 别名
* @return
*/
public Select column(String columnName, String columnAlias) {
return column("", "", columnName, columnAlias);
}
/**
* 添加column列字段
*
* @param select 子Sql
* @param columnAlias 别名
* @return
*/
public Select column(Select select, String columnAlias) {
return column(SqlHelper.buildSelectSql(select), columnAlias);
}
/**
* 添加column列字段
*
* @param column
* @return
*/
public Select column(Column column, String columnAlias) {
return column(column.getSchema(), column.getTableAlias(), column.name(), columnAlias);
}
/**
* 添加column列字段
*
* @param schema schema
* @param tableAlias 表别名
* @param columnName 列列字段名
* @param columnAlias 别名
* @return
*/
public Select column(String schema, String tableAlias, String columnName, String columnAlias) {
columnList.add(new Column(schema, tableAlias, columnName, columnAlias));
return this;
}
/**
* 获取表连接
*/
public List getJoin() {
return joinList;
}
/**
* 添加表连接
*
* @param table 关联的表名
* @param tableKeyword 关联的表关键列字段
* @param mainKeyword 主表关键列字段
*/
public Select join(String table, String tableKeyword, String mainKeyword) {
return join(JoinType.INNER_JOIN, "", table, table, tableKeyword, mainKeyword);
}
/**
* 添加表连接
*
* @param joinType 连接类型
* @param table 关联的表名
* @param tableKeyword 关联的表关键列字段
* @param mainKeyword 主表关键列字段
*/
public Select join(JoinType joinType, String table, String tableKeyword, String mainKeyword) {
return join(joinType, "", table, table, tableKeyword, mainKeyword);
}
/**
* 添加表连接
*
* @param table 关联的表名
* @param tableKeyword 关联的表关键列字段
* @param mainKeyword 主表关键列字段
*/
public Select join(String schema, String table, String tableAlias, String tableKeyword, String mainKeyword) {
return join(JoinType.INNER_JOIN, schema, table, tableAlias, tableKeyword, mainKeyword);
}
/**
* 添加表连接
*
* @param joinType 连接类型
* @param schema schema
* @param table 关联的表名
* @param tableKeyword 关联的表关键列字段
* @param mainKeyword 主表关键列字段
*/
public Select join(JoinType joinType, String schema, String table, String tableAlias, String tableKeyword, String mainKeyword) {
joinList.add(new Join(joinType, schema, table, tableAlias, tableKeyword, mainKeyword));
return this;
}
/**
* 获取groupBy分组列字段
*
* @return
*/
public List getGroupBy() {
return groupByList;
}
/**
* 添加groupBy分组
*
* @param columNname 列字段名
* @return
*/
public Select groupBy(String columNname) {
return groupBy("", "", columNname);
}
/**
* 添加groupBy分组
*
* @param column 列字段信息
* @return
*/
public Select groupBy(Column column) {
return groupBy(column.getSchema(), column.getTableAlias(), column.name());
}
/**
* 添加groupBy分组
*
* @param tableAlias 表别名
* @param columNname 列字段名
* @return
*/
public Select groupBy(String schema, String tableAlias, String columNname) {
groupByList.add(new Group(schema, tableAlias, columNname));
return this;
}
/**
* 获取where sql 内容
*
* @return
*/
public String getHaving() {
return having;
}
/**
* 设置having sql 内容
*
* @param having
*/
public void setHaving(String having) {
this.having = having;
}
/**
* 设置having sql 内容
*
* @param having
* @param args
*/
public void setHaving(String having, Object... args) {
this.having = having;
this.havingArgs = args;
}
/**
* 获取Having
*
* @return
*/
public Object[] getHavingArgs() {
return havingArgs;
}
/**
* 设置Having
*
* @param havingArgs
*/
public void setHavingArgs(Object[] havingArgs) {
this.havingArgs = havingArgs;
}
/**
* 获取having条件值映射
*
* @return
*/
public ListMultimap getHavingMap() {
return havingMap;
}
/**
* 获取orderBy排序列字段
*
* @return
*/
public List getOrderBy() {
return orderByList;
}
/**
* 添加列字段排序
*
* @param columNname 列字段名
* @param sqlSort 排序方式
*/
public Select orderBy(String columNname, SqlSort sqlSort) {
return orderBy("", "", columNname, sqlSort);
}
/**
* 添加列字段排序
*
* @param column 列字段信息
* @param sqlSort 排序方式
* @return
*/
public Select orderBy(Column column, SqlSort sqlSort) {
return orderBy(column.getSchema(), column.getTableAlias(), column.name(), sqlSort);
}
/**
* 添加列字段排序
*
* @param schema schema
* @param tableAlias 表别名
* @param columNname 列字段名
* @param sqlSort 排序方式
* @return
*/
public Select orderBy(String schema, String tableAlias, String columNname, SqlSort sqlSort) {
orderByList.add(new Order(schema, tableAlias, columNname, sqlSort));
return this;
}
/**
* 添加列字段排序
*
* @param orders 排序
* @return
*/
public Select orderBy(Order[] orders) {
if (orders != null && orders.length > 0) {
orderByList.addAll(Arrays.asList(orders));
}
return this;
}
/**
* 设置分页参数
*
* @param pagenum 当前页(第一页从0开始)
* @param pagesize 每页显示数量
*/
public void setPage(Integer pagenum, Integer pagesize) {
this.page = new Page(pagenum, pagesize);
}
/**
* 设置分页参数(SqlServer专用)
*
* @param idName 主键的名称
* @param pagenum 当前页(第一页从0开始)
* @param pagesize 每页显示数量
*/
public void setPage(String idName, Integer pagenum, Integer pagesize) {
this.page = new Page(idName, pagenum, pagesize);
}
/**
* 获取分页参数
*
* @return
*/
public Page getPage() {
return this.page;
}
/**
* 添加having条件
*
* @param field 列字段
* @param value 列字段值
* @return
*/
public Select having(String field, Object value) {
return having(field, value, SqlOperator.EQUAL_TO);
}
/**
* 添加having条件
*
* @param column 列字段信息
* @param value 列字段值
* @return
*/
public Select having(Column column, Object value) {
return having(SqlLogic.AND, column.getSchema(), column.getTableAlias(), column.name(), value, SqlOperator.EQUAL_TO);
}
/**
* 添加having条件
*
* @param field 列字段
* @param value 列字段值
* @param sqlOperator 操作符
* @return
*/
public Select having(String field, Object value, SqlOperator sqlOperator) {
return having(SqlLogic.AND, "", "", field, value, sqlOperator);
}
/**
* @param sqlLogic 该条件与下一条件之间的逻辑关系
* @param tableAlias 表别名
* @param field 列字段
* @param value 列字段值
* @return
*/
public Select having(SqlLogic sqlLogic, String tableAlias, String field, Object value) {
return having(sqlLogic, "", tableAlias, field, value, SqlOperator.EQUAL_TO);
}
/**
* 添加having条件
*
* @param tableAlias 表别名
* @param field 列字段
* @param value 列字段值
* @param sqlOperator 操作符
* @return
*/
public Select having(String tableAlias, String field, Object value, SqlOperator sqlOperator) {
return having(SqlLogic.AND, "", tableAlias, field, value, sqlOperator);
}
/**
* 添加having条件
*
* @param column 列字段信息
* @param value 列字段值
* @param sqlOperator 操作符
* @return
*/
public Select having(Column column, Object value, SqlOperator sqlOperator) {
return having(SqlLogic.AND, column.getSchema(), column.getTableAlias(), column.name(), value, sqlOperator);
}
/**
* 添加having条件
*
* @param sqlLogic 该条件与下一条件之间的逻辑关系
* @param column 列字段信息
* @param value 列字段值
* @param sqlOperator 操作符
* @return
*/
public Select having(SqlLogic sqlLogic, Column column, Object value, SqlOperator sqlOperator) {
return having(sqlLogic, column.getSchema(), column.getTableAlias(), column.name(), value, sqlOperator);
}
/**
* 添加having条件
*
* @param sqlLogic 该条件与下一条件之间的逻辑关系
* @param schema schema
* @param tableAlias 表别名
* @param field 列字段
* @param value 列字段值
* @param sqlOperator 操作符
* @return
*/
public Select having(SqlLogic sqlLogic, String schema, String tableAlias, String field, Object value, SqlOperator sqlOperator) {
havingMap.put(tableAlias + field, new ConditionInfo(sqlLogic, schema, tableAlias, field, value, sqlOperator));
return this;
}
/**
* 获取过滤的列字段
*
* @return
*/
public String[] getFilterFields() {
return filterFields;
}
/**
* 设置过滤的列字段
*
* @param filterField
*/
public void setFilterFields(String... filterField) {
this.filterFields = filterField;
}
/**
* 复制对象
*
* @return
* @throws IOException
* @throws ClassNotFoundException
*/
public Object copy() throws IOException, ClassNotFoundException {
ByteArrayOutputStream bos = new ByteArrayOutputStream();
ObjectOutputStream oos = new ObjectOutputStream(bos);
oos.writeObject(this);
ObjectInputStream ois = new ObjectInputStream(new ByteArrayInputStream(bos.toByteArray()));
return ois.readObject();
}
} © 2015 - 2025 Weber Informatics LLC | Privacy Policy