SqlForamt，sql組裝工具類

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @author: we[email protected]
 * @version: v1.0
 * @description: cn.kuwo.added.service.ui
 * @date:2023/2/20
 */
public class SqlForamt {

    private static final String sqlFormat = "select %s from %s where 1=1 %s %s %s %s %s";

    private StringBuffer columns = new StringBuffer();

    private StringBuffer table = new StringBuffer();

    private StringBuffer condition = new StringBuffer();

    private StringBuffer groupBy = new StringBuffer();

    private StringBuffer orderBy = new StringBuffer();

    private StringBuffer limit = new StringBuffer();

    private StringBuffer ext = new StringBuffer();

    public String getSQL(){
        return String.format(sqlFormat, columns, table, condition, ext, groupBy, orderBy, limit);
    }

    public SqlForamt setTable(String tableName) {
        table.append(" ").append(tableName).append(" ");
        return this;
    }

    public SqlForamt setColumns(List<String> columnNames) {
        Boolean first = true;
        for (String columnName : columnNames) {
            if (!first) {
                condition.append(",");
            }
            columns.append(" ").append(columnName).append(",");
            first = false;
        }
        return this;
    }

    public SqlForamt setWhereExtSql(String value) {
        ext.append(value);
        return this;
    }

    public SqlForamt setWhereEqualSQL(String column, String value) {
        condition.append(" and ").append(column).append(" = ").append(value);
        return this;
    }

    public SqlForamt setWhereGreaterSQL(String column, String value) {
        condition.append(" and ").append(column).append(" > ").append(value);
        return this;
    }

    public SqlForamt setWhereLessSQL(String column, String value) {
        condition.append(" and ").append(column).append(" < ").append(value);
        return this;
    }

    public SqlForamt setWhereInSQL(String column, List<String> value) {
        condition.append(" and ").append(column).append(" in ").append(" ( ");
        Boolean first = true;
        for (Object o : value) {
            if (!first) {
                condition.append(",");
            }
            condition.append("'").append(o).append("'");
            first = false;
        }
        condition.append(" ) ");
        return this;
    }

    public SqlForamt setGroupBySQL(String column){
        orderBy.append(" group by ").append(column).append(" ");
        return this;
    }

    public SqlForamt setOrderBySQL(String column, String condition){
        orderBy.append(" ").append(column).append(" ").append(condition);
        return this;
    }

    public SqlForamt setLimitSQL(Integer offset, Integer size){
        orderBy.append(" limit ").append(offset).append(",").append(size);
        return this;
    }

    public static List<Map<String, Object>> converListMap(List<String> columns, List<Object> values) {
        List<Map<String, Object>> list = new ArrayList<>();
        if (columns == null || columns.isEmpty() || values == null || values.isEmpty()) {
            return list;
        }
        if (columns.size() != values.size()) {
            return list;
        }
        for (Object valueobj : values) {
            Map<String, Object> map = new HashMap<>();
            Object[] valuearr = (Object[]) valueobj;
            for (int i = 0; i < valuearr.length; i++) {
                map.put(columns.get(i), valuearr[i]);
            }
            list.add(map);
        }
        return list;
    }

    public static Map<String, Object> converMap(List<String> columns, List<Object> values) {
        if (columns == null || columns.isEmpty() || values == null || values.isEmpty()) {
            return new HashMap<>();
        }
        if (columns.size() != values.size()) {
            return new HashMap<>();
        }
        for (Object valueobj : values) {
            Map<String, Object> map = new HashMap<>();
            Object[] valuearr = (Object[]) valueobj;
            for (int i = 0; i < valuearr.length; i++) {
                map.put(columns.get(i), valuearr[i]);
            }
            return map;
        }
        return new HashMap<>();
    }

}