优化代码

java110

2022-01-17 d937205d5824dc44ab1567cf6f84fbfa817baa92

 java110-service/src/test/java/com/java110/service/InterpreterTest.java

old mode 100644
new mode 100755
@@ -1,9 +1,16 @@
package com.java110.service;

import bsh.Interpreter;
import com.alibaba.fastjson.JSONObject;
import com.java110.service.smo.impl.QueryServiceSMOImpl;
import junit.framework.Test;
import junit.framework.TestCase;
import junit.framework.TestSuite;
import org.apache.ibatis.ognl.OgnlException;
import org.dom4j.DocumentException;

import java.util.HashMap;
import java.util.Map;

/**
 * Created by wuxw on 2018/4/23.
@@ -45,4 +52,22 @@
        String param = "9,4";
        System.out.println(interpreter.eval("execute("+param+")").toString());
    }


    public void testDealSqlIf() throws OgnlException, DocumentException {

        String oldSql = "select * from s_a a\n" +
                "                  where <if test=\"name != null and name != ''\">\n" +
                "                          a.name = #name#\n" +
                "                      </if>" +
                "                       and a.sex = #name#" +
                "                       <if test=\"id != null and id!= ''\"> and a.id = #id# </if>";

        QueryServiceSMOImpl queryServiceSMO = new QueryServiceSMOImpl();
        JSONObject params = new JSONObject();
        params.put("id","123213");
        params.put("name","123213");

        System.out.println((queryServiceSMO.dealSqlIf(oldSql, params)));
    }
}