【脚本】JAVA 执行 阿里QLExpress 动态脚本 demo 基础版 增加项目灵活性

第一步 增加依赖

<!-- https://mvnrepository.com/artifact/com.alibaba/QLExpress --> <dependency> <groupId>com.alibaba</groupId> <artifactId>QLExpress</artifactId> <version>3.3.2</version> </dependency> <dependency> <groupId>org.dromara.hutool</groupId> <artifactId>hutool-all</artifactId> <version>6.0.0-M11</version> </dependency>

方案一

简单demo

语法

如果 (语文+数学+英语>270) 则 '及格' 否则 '不及格' //返回 及格

package com.study.Script.QLExpress.简单demo; import com.guanwei.study.tools.WTools; import com.ql.util.express.DefaultContext; import com.ql.util.express.ExpressRunner; public class QLExpressDemo { public static void main(String[] args) throws Exception { ExpressRunner runner = new ExpressRunner(); DefaultContext<String, Object> context = new DefaultContext<String, Object>(); context.put("a",1); context.put("b",2); context.put("c",3); String express = "(a+b*c-5)x50.11%"; express = WTools.mathUtil.transitionFormula(express); System.out.println(express); Object r = runner.execute(express, context, null, true, false); System.out.println(r); runner.addOperatorWithAlias("如果", "if",null); runner.addOperatorWithAlias("则", "then",null); runner.addOperatorWithAlias("否则", "else",null); runner.addOperatorWithAlias("返回", "return",null); String exp = "如果 (语文+数学+英语>270) 则 '及格' 否则 '不及格'"; context = new DefaultContext<String, Object>(); context.put("语文",30); context.put("数学",2); context.put("英语",3); Object execute = runner.execute(exp, context, null, false, false); System.out.println(execute); } }

工具

package com.guanwei.study.tools; import com.guanwei.study.math.MathUtil; public class WTools { public static MathUtil mathUtil = new MathUtil(); }

工具 解析特殊符号 转换为 QLExpress 能看懂的

package com.guanwei.study.math; import cn.hutool.core.collection.CollUtil; import cn.hutool.core.util.ReUtil; import com.guanwei.study.string.CharUtil; import org.dromara.hutool.core.text.StrUtil; import java.math.BigDecimal; import java.util.ArrayList; import java.util.List; public class MathUtil { /** * 转换符号 公式等 * % + - * / * @param exp * @return */ public String transitionFormula(String exp){ // exp = "＋"; //全角转半角 exp = CharUtil.toDbc(exp); //所有字符转为小写 exp = exp.toLowerCase(); exp = exp .replaceAll("﹢", "+") .replaceAll("十", "+") .replaceAll("┼", "+") .replaceAll("╋", "+") .replaceAll("╬", "+") .replaceAll("﹣", "-") .replaceAll("一", "-") .replaceAll("x", "*") .replaceAll("×", "*") .replaceAll("╳", "*") .replaceAll("х", "*") .replaceAll("·", "*") .replaceAll("÷", "/") .replaceAll("\\{", "(") .replaceAll("}", ")") .replaceAll("\\[", "(") .replaceAll("]", ")") ; //包含百分号 if(exp.contains("%")){ //获取包含百分号的数字 List<String> resultFindAll = ReUtil.findAll("([\\d])*%|(\\d{1,10}).([\\d])*%", exp, 0, new ArrayList<String>()); // List<String> resultFindAll2 = ReUtil.findAll("([\\d+])*%|([\\d+{1,10}]).([\\d+])*%", exp, 0, new ArrayList<String>()); if(CollUtil.isNotEmpty(resultFindAll)){ for (String s : resultFindAll) { s = s.trim(); String replace = s.replace("%", ""); if(StrUtil.isBlank(replace)){ exp = exp.replaceAll(s, "0"); }else{ BigDecimal bigDecimal = new BigDecimal(replace); bigDecimal = bigDecimal.divide(new BigDecimal(100)); exp = exp.replaceAll(s, bigDecimal.toString()); } } } System.out.println(resultFindAll); } return exp; } }