All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.centit.support.database.utils.QueryAndParams Maven / Gradle / Ivy

Go to download

数据库操作通用方法和函数，从以前的util包中分离出来，并且整合了部分sys-module中的函数

The newest version!
package com.centit.support.database.utils;

import com.centit.support.compiler.Lexer;

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

public class QueryAndParams {
    public String queryStmt;
    public Object[] params;

    public QueryAndParams() {
        this.queryStmt = null;
        this.params = null;
    }

    public QueryAndParams(String shql) {
        this.queryStmt = shql;
        this.params = null;
    }

    public QueryAndParams(String shql, final Object[] values) {
        this.queryStmt = shql;
        this.params = values;
    }

    public static QueryAndParams creepArrayParamForInQuery(String sql, Object[] sqlParams) {

        StringBuilder sqlb = new StringBuilder();
        List params = new ArrayList<>();
        Lexer lex = new Lexer(sql, Lexer.LANG_TYPE_SQL);

        int prePos = 0;
        int paramInd = -1;
        String aWord = lex.getAWord();
        while (aWord != null && !"".equals(aWord)) {
            if ("?".equals(aWord)) {
                paramInd++;
                int curPos = lex.getCurrPos();
                if (curPos - 1 > prePos)
                    sqlb.append(sql.substring(prePos, curPos - 1));

                Object obj = null;
                if (sqlParams != null && paramInd < sqlParams.length)
                    obj = sqlParams[paramInd];

                if (obj == null) {
                    params.add(null);
                    sqlb.append("?");
                } else if (obj instanceof Collection) {
                    int n = 0;
                    for (Object po : (Collection) obj) {
                        if (n > 0)
                            sqlb.append(",");
                        sqlb.append("?");
                        params.add(po);
                        n++;
                    }
                } else if (obj instanceof Object[]) {
                    int n = 0;
                    for (Object po : (Object[]) obj) {
                        if (n > 0)
                            sqlb.append(",");
                        sqlb.append("?");
                        params.add(po);
                        n++;
                    }
                } else {
                    params.add(obj);
                    sqlb.append("?");
                }
                prePos = lex.getCurrPos();
            }

            aWord = lex.getAWord();
        }
        sqlb.append(sql.substring(prePos));

        return new QueryAndParams(sqlb.toString(), params.toArray());
    }

    public static QueryAndParams createFromQueryAndNamedParams(String sql, Map namedParams) {

        StringBuilder sqlb = new StringBuilder();
        List params = new ArrayList<>(namedParams.size() + 5);
        Lexer lex = new Lexer(sql, Lexer.LANG_TYPE_SQL);

        int prePos = 0;
        String aWord = lex.getAWord();
        while (aWord != null && !"".equals(aWord)) {
            if (":".equals(aWord)) {

                int curPos = lex.getCurrPos();
                if (curPos - 1 > prePos)
                    sqlb.append(sql.substring(prePos, curPos - 1));

                aWord = lex.getAWord();
                if (aWord == null || "".equals(aWord))
                    break;
                Object obj = namedParams.get(aWord);
                if (obj == null) {
                    params.add(null);
                    sqlb.append("?");
                } else if (obj instanceof Collection) {
                    int n = 0;
                    for (Object po : (Collection) obj) {
                        if (n > 0)
                            sqlb.append(",");
                        sqlb.append("?");
                        params.add(po);
                        n++;
                    }
                } else if (obj instanceof Object[]) {
                    int n = 0;
                    for (Object po : (Object[]) obj) {
                        if (n > 0)
                            sqlb.append(",");
                        sqlb.append("?");
                        params.add(po);
                        n++;
                    }
                } else {
                    params.add(obj);
                    sqlb.append("?");
                }
                prePos = lex.getCurrPos();
            }

            aWord = lex.getAWord();
        }
        sqlb.append(sql.substring(prePos));

        return new QueryAndParams(sqlb.toString(), params.toArray());
    }

    public static QueryAndParams creepArrayParamForInQuery(QueryAndParams queryParam) {
        return creepArrayParamForInQuery(
            queryParam.getQuery(), queryParam.getParams());
    }

    public static QueryAndParams createFromQueryAndNamedParams(QueryAndNamedParams namedParamQuery) {
        return createFromQueryAndNamedParams(
            namedParamQuery.getQuery(), namedParamQuery.getParams());
    }

    @Deprecated
    public String getSql() {
        return queryStmt;
    }

    @Deprecated
    public void setSql(String hql) {
        this.queryStmt = hql;
    }

    public String getQuery() {
        return queryStmt;
    }

    public void setQuery(String hql) {
        this.queryStmt = hql;
    }

    @Deprecated
    public String getHql() {
        return queryStmt;
    }

    @Deprecated
    public void setHql(String hql) {
        this.queryStmt = hql;
    }

    public Object[] getParams() {
        return params;
    }

    public Object getParam(int index) {
        if (params == null)
            return null;
        if (index >= params.length)
            return null;
        return params[index];
    }
}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy