All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • goja.core.db.Dao Maven / Gradle / Ivy

    The newest version!
    package goja.core.db;

import com.google.common.base.Preconditions;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;

import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Model;
import com.jfinal.plugin.activerecord.Page;
import com.jfinal.plugin.activerecord.Record;
import com.jfinal.plugin.activerecord.Table;
import com.jfinal.plugin.activerecord.TableMapping;
import goja.core.StringPool;
import goja.core.dto.PageDto;
import goja.core.libs.Freemarkers;
import goja.core.sqlinxml.SqlKit;
import goja.core.sqlinxml.node.SqlNode;

import java.io.Serializable;
import java.util.List;
import java.util.Map;
import java.util.Set;

import org.apache.commons.lang3.StringUtils;
import org.apache.commons.lang3.tuple.Pair;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

/**
 * 
     数据Dao处理 
    
 *
 * @author sog
 * @version 1.0
 * @since JDK 1.6
 */
public abstract class Dao {
    private static final Logger logger = LoggerFactory.getLogger(Dao.class);

    /**
     * 获取SQL，动态SQL
     *
     * @param sqlId xml文件中的sql id
     * @param param xml sql中的变量map
     * @return 返回处理对象, key为 sql, value为参数
     */
    public static Pair> dynamicSql(String sqlId, Map param) {
        String sqlTemplete = SqlKit.sql(sqlId);

        if (null == sqlTemplete || sqlTemplete.isEmpty()) {
            logger.error("sql语句不存在：sql id是" + sqlId);
            return null;
        }

        if (param == null) {
            param = Maps.newHashMap();
        }

        String sql = Freemarkers.render(sqlTemplete, param);

        List params = Lists.newArrayList();

        Set keySet = param.keySet();
        for (String key : keySet) {
            if (param.get(key) == null) {
                break;
            }

            Object paramValue = param.get(key);

            final String placeChar = StringPool.HASH + key + StringPool.HASH;
            if (StringUtils.containsIgnoreCase(sql, placeChar)) {
                sql = StringUtils.replace(sql, placeChar, StringPool.QUESTION_MARK);
                params.add(paramValue);
            }
        }
        return Pair.of(sql.replaceAll("[\\s]{2,}", " "), params);
    }

    /**
     * According to the default primary key id is for the new data and entity.
     *
     * @param m   model
     * @param  Generic entity references
     * @return If for the new form of return true.
     */
    public static  boolean isNew(M m) {
        final Table table = TableMapping.me().getTable(m.getClass());
        final String[] pks = table.getPrimaryKey();
        return isNew(m, pks[0]);
    }

    /**
     * Query the database record set.
     *
     * @param sqlSelect SqlNode Select
     * @return query result.
     * @see SqlSelect
     * @see FindBy
     */
    public static List findBy(SqlSelect sqlSelect) {
        Preconditions.checkNotNull(sqlSelect, "The Query SqlNode is must be not null.");
        return Db.find(sqlSelect.toString(), sqlSelect.getParams().toArray());
    }

    /**
     * Query a data record.
     *
     * @param sqlSelect SqlNode Select
     * @return query result.
     * @see SqlSelect
     * @see FindBy
     */
    public static Record findOne(SqlSelect sqlSelect) {
        Preconditions.checkNotNull(sqlSelect, "The Query SqlNode is must be not null.");
        return Db.findFirst(sqlSelect.toString(), sqlSelect.getParams().toArray());
    }

    /**
     * 根据多个数据通过主键批量删除数据
     *
     * @param ids        要删除的数据值数组
     * @param modelClass 对应的Model的Class
     * @return 是否删除成功
     */
    public static  boolean deleteByIds(Serializable[] ids, Class modelClass) {
        final Table table = TableMapping.me().getTable(modelClass);
        final String[] primaryKey = table.getPrimaryKey();
        if (primaryKey == null || primaryKey.length < 1 || ids == null) {
            throw new IllegalArgumentException("需要删除的表数据主键不存在，无法删除!");
        }
        // 暂时支持单主键的，多主键的后续在说吧。
        final String question_mark =
                StringUtils.repeat(StringPool.QUESTION_MARK, StringPool.COMMA, ids.length);
        String deleteSql = "DELETE FROM "
                + table.getName()
                + " WHERE "
                + primaryKey[0]
                + " IN ("
                + question_mark
                + ")";
        return Db.update(deleteSql, ids) >= 0;
    }

    /**
     * According to the primary key and entity determine whether for the new entity.
     *
     * @param m         Database model.
     * @param pk_column PK Column.
     * @param        Generic entity references.
     * @return If for the new form of return true.
     */
    public static  boolean isNew(M m, String pk_column) {
        final Object val = m.get(pk_column);
        return val == null || val instanceof Number && ((Number) val).intValue() <= 0;
    }

    /**
     * Paging retrieve, default sorted by id, you need to specify the datatables request parameters.
     *
     * @param sqlPaginatePrefix 分页搜索前缀
     * @param pageDto           required parameter.
     * @return Paging data.
     */
    public static Page paginate(String sqlPaginatePrefix,
                                        PageDto pageDto) {
        SqlNode sqlNode = SqlKit.sqlNode(sqlPaginatePrefix + ".paginate");
        Preconditions.checkNotNull(sqlNode, "[" + sqlPaginatePrefix + ".paginate]分页Sql不存在,无法执行分页");
        String where = sqlNode.whereSql;
        int pageSize = pageDto.pageSize;
        int p = pageDto.page;
        int start = ((p - 1) * pageSize) + 1;
        final List params = pageDto.params;
        final List query_params = pageDto.query_params;
        if ((params.isEmpty()) && (query_params.isEmpty())) {
            return Db.paginate(start, pageSize, sqlNode.selectSql, where);
        } else {

            if (!params.isEmpty()) {
                where += (sqlNode.condition ? StringPool.SPACE : " WHERE 1=1 ");
            }
            for (RequestParam param : pageDto.params) {
                where += param.toSql();
            }
            return Db.paginate(start, pageSize, sqlNode.selectSql, where, query_params.toArray());
        }
    }

    /**
     * generating oracle paginate SQL.
     *
     * @param sql sql.
     * @return paginate sql.
     */
    public static String oraclePaginateSql(String sql) {
        return String.format(
                "SELECT * FROM (SELECT goja_ptbs.*,ROWNUM num FROM (%s) goja_ptbs WHERE ROWNUM <= ? ) WHERE num >= ?",
                sql);
    }
}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy