| | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.alibaba.fastjson.JSONPath; |
| | | import com.java110.common.cache.ServiceSqlCache; |
| | | import com.java110.common.constant.CommonConstant; |
| | | import com.java110.common.constant.ResponseConstant; |
| | | import com.java110.common.exception.BusinessException; |
| | | import com.java110.utils.cache.ServiceSqlCache; |
| | | import com.java110.utils.constant.CommonConstant; |
| | | import com.java110.utils.constant.ResponseConstant; |
| | | import com.java110.utils.exception.BusinessException; |
| | | import com.java110.core.factory.DataTransactionFactory; |
| | | import com.java110.common.log.LoggerEngine; |
| | | import com.java110.common.util.Assert; |
| | | import com.java110.common.util.StringUtil; |
| | | import com.java110.utils.log.LoggerEngine; |
| | | import com.java110.utils.util.Assert; |
| | | import com.java110.utils.util.StringUtil; |
| | | import com.java110.service.context.DataQuery; |
| | | import com.java110.entity.service.ServiceSql; |
| | | import com.java110.service.dao.IQueryServiceDAO; |
| | |
| | | |
| | | String currentSql = sqlObj.getString(dataQuery.getTemplateKey()); |
| | | //处理 if 判断 |
| | | logger.debug("dealSqlIf开始处理sql中的<if>节点 " + currentSql + " 入参:" + params.toJSONString()); |
| | | currentSql = dealSqlIf(currentSql, params); |
| | | logger.debug("dealSqlIf处理完成sql中的<if>节点 " + currentSql + " 入参:" + params.toJSONString()); |
| | | |
| | | |
| | | String[] sqls = currentSql.split("#"); |
| | | String currentSqlNew = ""; |
| | |
| | | |
| | | String[] oSqls = oldSql.split("</if>"); |
| | | for (String oSql : oSqls) { |
| | | logger.debug("处理if 节点,当前处理的oSql=" + oSql + "总的oSqls = " + oSqls); |
| | | if(StringUtil.isNullOrNone(oSql) || !oSql.contains("<if")){ |
| | | continue; |
| | | } |
| | | if (!oSql.startsWith("<if")) { |
| | | newSql.append(oSql.substring(0, oSql.indexOf("<if"))); |
| | | } |
| | |
| | | newSql.append(root.getText()); |
| | | } |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | return newSql.toString(); |
| | | return newSql.toString().replace(">", ">").replace("<", "<"); |
| | | |
| | | } |
| | | |