Java 中执行动态表达式语句前中后缀Ognl、SpEL、Groovy、Jexl3

<!-- https: //mvnrepository测试数据/artifact/ognl/ognl -->

<dependency>

     <groupId>ognl</groupId>

     <artifactId>ognl</artifactId>

     <version> 3.2 . 18 </version>

</dependency>

MemberAccess memberAccess = new AbstractMemberAccess() {

     @Override

     public boolean isAccessible(Map context, Object target, Member member, String propertyName) {

         int modifiers = member.getModifiers();

         return Modifier.isPublic(modifiers);

     }

};

OgnlContext context = (OgnlContext) Ognl.createDefaultContext( this ,

     memberAccess,

     new DefaultClassResolver(),

     new DefaultTypeConverter());

context.put( "verifyStatus" , 1 );

Object expression = Ognl.parseExpression( "#verifyStatus == 1" );

boolean result =( boolean ) Ognl.getValue(expression, context, context.getRoot());

Assert.assertTrue(result);

ExpressionParser parser = new SpelExpressionParser();

Expression expression = parser.parseExpression( "#verifyStatus == 1" );

EvaluationContext context = new StandardEvaluationContext();

context.setVariable( "verifyStatus" , 1 );

boolean result = ( boolean ) expression.getValue(context);

Assert.assertTrue(result);

<!-- https: //mvnrepository测试数据/artifact/org.apache测试数据mons/commons-jexl3 -->

<dependency>

     <groupId>org.apache测试数据mons</groupId>

     <artifactId>commons-jexl3</artifactId>

     <version> 3.1 </version>

</dependency>

JexlEngine jexl = new JexlBuilder().create();

JexlContext jc = new MapContext();

jc.set( "verifyStatus" , 1 );

JexlExpression expression = jexl.createExpression( "verifyStatus == 1" );

boolean result = ( boolean ) expression.evaluate(jc);

Assert.assertTrue(result);

<!-- https: //mvnrepository测试数据/artifact/org.codehaus.groovy/groovy -->

<dependency>

     <groupId>org.codehaus.groovy</groupId>

     <artifactId>groovy</artifactId>

     <version> 2.5 . 6 </version>

</dependency>

Binding binding = new Binding();

binding.setVariable( "verifyStatus" , 1 );

GroovyShell shell = new GroovyShell(binding);

boolean result = ( boolean ) shell.evaluate( "verifyStatus == 1" );

Assert.assertTrue(result);

<select id= "getList"

     resultMap= "UserBaseMap"

     parameterType= "com.xx.Param" >

     select

         id, invite_code, phone, name

     from user

     where status = 1

     < if test= "_parameter != null" >

         < if test= "inviteCode !=null and inviteCode !='' " >

             and invite_code = #{inviteCode}

         </ if >

     </ if >

</select>

select id, invite_code, phone, name

from user

where status = 1

@if (:inviteCode != null ) { and invite_code = :inviteCode }

List<String> results = StringUtil.matches(sql, "@if([\\s\\S]*?)}" );

String text = "@if(:inviteCode != null) { and invite_code = :inviteCode }" ;

List<String> sqlFragment = StringUtil.matches(text, "\\(([\\s\\S]*?)\\)|\\{([\\s\\S]*?)\\}" );

List<String> sqlFragmentParam = StringUtil.matches( ":inviteCode != null" , "\\?\\d+(\\.[A-Za-z]+)?|:[A-Za-z0-9]+(\\.[A-Za-z]+)?" );

JexlEngine jexl = new JexlBuilder().create();

JexlContext jc = new MapContext();

jc.set( ":inviteCode" , "ddddsdfa" );

JexlExpression expression = jexl.createExpression(sqlExp);

boolean needAppendSQL = ( boolean ) expression.evaluate(jc);

@Test

public void testSQL() {

   String sql = "select id, invite_code, phone, name \n"

   + "from user \n"

   + "where status = 1 \n"

   + "@if(:inviteCode != null) { and invite_code = :inviteCode }" ;

   Map<String, Object> params = new HashMap<String, Object>();

params.put( "inviteCode" , "dd" );

   System.out.println(parseJexl(sql, params));

}

public String parseJexl(String jexlSql, Map<String, Object> params) {

   // 判断是否包含 @if

   List<String> results = StringUtil.matches(jexlSql, "@if([\\s\\S]*?)}" );

   if (results.isEmpty()) {

       return jexlSql;

   }

   JexlEngine jexl = new JexlBuilder().create();

   JexlContext jc = new MapContext();

   for (String e : results) {

     List<String> sqlFragment = StringUtil.matches(e, "\\(([\\s\\S]*?)\\)|\\{([\\s\\S]*?)\\}" );

     String sqlExp = sqlFragment.get( 0 ).trim().substring( 1 , sqlFragment.get( 0 ).length() - 1 );

     List<String> sqlFragmentParam = StringUtil.matches(sqlExp, "\\?\\d+(\\.[A-Za-z]+)?|:[A-Za-z0-9]+(\\.[A-Za-z]+)?" );

     for (String param : sqlFragmentParam) {

       String newSQLExp = "_" + param.substring( 1 );

       sqlExp = sqlExp.replace(param, newSQLExp);

       jc.set(newSQLExp, params.get(param.substring( 1 )));

     }

     JexlExpression expression = jexl.createExpression(sqlExp);

     Boolean needAppendSQL = (Boolean) expression.evaluate(jc);

     if (needAppendSQL) {

       jexlSql = jexlSql.replace(e, sqlFragment.get( 1 ).trim().substring( 1 , sqlFragment.get( 1 ).length() - 1 ));

     } else {

       jexlSql = jexlSql.replace(e, "" );

     }

   }

   return jexlSql;

}