基于JFinal框架与Vue+Element的简洁后台管理系统设计源码

package cn.bigchin.spark.app.model; import cn.bigchin.spark.Spark; import cn.bigchin.spark.app.config.ThreadVariable; import cn.bigchin.spark.expand.db.dialect.Logic; import cn.bigchin.spark.expand.db.dialect.SparkDialect; import cn.bigchin.spark.expand.safe.JsoupFilter; import cn.bigchin.spark.kit.ArrayKit; import cn.bigchin.spark.kit.NumberKit; import com.jfinal.kit.Kv; import com.jfinal.kit.StrKit; import com.jfinal.plugin.activerecord.*; import com.jfinal.plugin.activerecord.cache.ICache; import java.util.Date; import java.util.List; import java.util.Map; /** * TODO: * * @author 一川死水（yichuan95@126.com） * on 2024/6/12 下午1:44 */ public class SparkModel<M extends SparkModel> extends Model<M> { public final static SparkModelConfig modelConfig = Spark.config(SparkModelConfig.class); /** * TODO:快捷创建条件对象 * * @param <M> * @return */ public static <M extends SparkModel<M>> M cond() { return (M) new SparkModel(); } public Table table(){ return _getTable(); } /** * TODO:查询返回的列 * * @param columns * @return */ public M loadColumns(String columns) { if (_getTable().hasColumnLabel(columns)) { columns = String.format("%s.%s",_getTable().getName(), columns); } this.put(Logic.SET_KEY_COLUMNS, columns); return (M) this; } /** * TODO:查询返回的列 * * @param columns * @return */ public M loadColumnArray(String... columns) { StringBuffer sb = new StringBuffer(); for (int i = 0; i < columns.length; i++) { if (_getTable().hasColumnLabel(columns[i])) { sb.append(_getTable().getName()).append("."); } sb.append(columns[i]); if (columns.length > i + 1) { sb.append(","); } } this.put(Logic.SET_KEY_COLUMNS, sb.toString()); return (M) this; } /** * TODO:获取返回列 * * @return */ public String loadColumns() { String columns = get(Logic.SET_KEY_COLUMNS); if (StrKit.isBlank(columns)) { return "*"; } else { return columns.trim(); } } /** * TODO:查询逻辑 * * @param name * @param logic * @return M **/ public M condition(String name, String logic) { this.put(Logic.SET_KEY_COND + name, logic); return (M) this; } /** * TODO:获取查询逻辑 * * @param name * @return java.lang.String **/ public String condition(String name) { return this.get(Logic.SET_KEY_COND + name); } public M groupBy(String column) { this.put(Logic.SET_KEY_GROUP_BY, column); return (M) this; } public String groupBy() { String groupBy = get(Logic.SET_KEY_GROUP_BY); return StrKit.isBlank(groupBy) ? "" : groupBy; } /** * TODO:查询排序 * * @param orderBy * @return */ public M orderBy(String orderBy) { this.put(Logic.SET_KEY_ORDER_BY, orderBy); return (M) this; } /** * TODO:查询排序 * * @param orderBy * @return */ public M orderByAsc(String orderBy) { this.put(Logic.SET_KEY_ORDER_BY, String.format("%s asc",orderBy)); return (M) this; } /** * TODO:查询排序 * * @param orderBy * @return */ public M orderByDesc(String orderBy) { this.put(Logic.SET_KEY_ORDER_BY, String.format("%s desc",orderBy)); return (M) this; } /** * TODO:查询排序 * * @return */ public String orderBy() { String orderBy = get(Logic.SET_KEY_ORDER_BY); return StrKit.isBlank(orderBy) ? "" : orderBy; } public M auth(String key, String content) { Kv kv = auth(); this.put(Logic.SET_KEY_AUTH, kv.set(key, content)); return (M) this; } public Kv auth() { Kv kv = this.get(Logic.SET_KEY_AUTH); if (kv == null) { kv = Kv.create(); } return kv; } /** * TODO:查询limit * * @param limit * @return */ public M limit(String limit) { this.put(Logic.SET_KEY_LIMIT, limit); return (M) this; } /** * TODO:查询limit * * @return */ public String limit() { String limit = get(Logic.SET_KEY_LIMIT); return StrKit.isBlank(limit) ? "" : limit; } public SqlPara sqlPara() { return _getDialect().query(_getTable(), this); } /** * TODO:数据源类型 * * @return */ public SparkDialect _getDialect() { Config config = _getConfig(); return (SparkDialect) config.getDialect(); } /** * TODO:获取缓存 * * @return */ public ICache _getCache() { return this._getConfig().getCache(); } /** * TODO:获取表的缓存空间 * * @param * @return * @author 王剑洪 on 2019/12/26 13:55 **/ public String _getCacheName() { return String.format("%s:%s",_getConfig().getName(), _getTable().getName()); } /** * TODO:获取缓存key * * @param sql * @param paras * @return * @author 王剑洪 on 2019/12/26 13:55 **/ public String buildCacheKey(String sql, Object... paras) { String key = "sql:" + sql; String cond = ""; if (paras != null && paras.length > 0) { for (int i = 0; i < paras.length; i++) { cond += paras[i]; if (i < paras.length - 1) { cond += ","; } } } key = key.replaceAll("\n", "") .replaceAll("\t", " ") .replaceAll(" +", " "); return String.format("%s:[%s]",key, cond); } /** * TODO:移除缓存 * * @param res * @return */ public boolean removeAllCache(boolean res) { /**日志类缓存不处理*/ String tableName = _getTable().getName(); if (res && (!tableName.startsWith("log") && !tableName.endsWith("log"))) { Spark.getCache().removeAll(_getCacheName()); } return res; } /** * TODO:过滤html标签的字段 * * @param * @return * @author 王剑洪 on 2019/12/26 13:43 **/ @Override protected void filter(int filterBy) { if (StrKit.notBlank(modelConfig.getFilterHtml())) { String[] columnNameArray = ArrayKit.toStrArray(modelConfig.getFilterHtml()); for (String name : columnNameArray) { if (_getTable().hasColumnLabel(name)) { if (get(name) != null) { set(name, JsoupFilter.getText(get(name))); } } } } } @Override public boolean save() { remove(modelConfig.getCt(), modelConfig.getCm(), modelConfig.getUm(), modelConfig.getUt()); if (_getTable().hasColumnLabel(modelConfig.getDel())) { if (get(modelConfig.getDel()) == null) { setDel(false); } } if (_getTable().hasColumnLabel(modelConfig.getDel())) { set(modelConfig.getDel(), false); } if (_getTable().hasColumnLabel(modelConfig.getCt())) { set(modelConfig.getCt(), new Date()); } if (_getTable().hasColumnLabel(modelConfig.getCm())) { set(modelConfig.getCm(), ThreadVariable.me().get(modelConfig.getCm())); } if (_getTable().hasColumnLabel(modelConfig.getSort())) { Integer sort = getInt(modelConfig.getSort()); sort = NumberKit.isScope(sort, 1, 99999) ? sort : 1; set(modelConfig.getSort