top.wboost.common.boost.handler.AbstractSqlBoostHandler Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of common-boost Show documentation

There is a newer version: 4.0.1

package top.wboost.common.boost.handler;

import top.wboost.common.sql.manager.DefaultSqlWildCardManager;
import top.wboost.common.sql.warp.DefaultSqlWarp;
import top.wboost.common.util.JdbcBuilder;
import top.wboost.common.utils.web.utils.ConvertUtil;
import top.wboost.common.utils.web.utils.SpringBeanUtil;

import javax.sql.DataSource;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

@SuppressWarnings("unchecked")
public abstract class AbstractSqlBoostHandler extends AbstractBoostHandler {

    private DefaultSqlWildCardManager sqlWildCardManager = new DefaultSqlWildCardManager(new DefaultSqlWarp());

    private JdbcBuilder.JdbcExecutor jdbcExecutor = JdbcBuilder.createExecutors(SpringBeanUtil.getBean(DataSource.class));
    /**
     * 执行sql语句
     * @param sql 要执行的sql语句
     * @return
     */
    protected List executeSql(Map replaceMap, String sql) {
        String executeSql = replaceSql(replaceMap, sql);
        log.debug("execute sql : {}", executeSql);
        try {
            return jdbcExecutor.findModeResult(executeSql);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    /**
     * 执行并组装sql语句
     * @param sql 要执行的sql语句
     * @param fieldsName 组装名
     * @return
     */
    protected List> executeSql(Map replaceMap, String sql, String[] fieldsName) {
        return ConvertUtil.parseObjToMap((List