package com.cwp.utils;
import org.apache.commons.lang3.StringUtils;
import org.apache.ibatis.datasource.pooled.PooledDataSource;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.mapping.ParameterMapping;
import org.apache.ibatis.mapping.ParameterMode;
import org.apache.ibatis.reflection.MetaObject;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.transaction.jdbc.JdbcTransactionFactory;
import org.apache.ibatis.type.TypeHandlerRegistry;
import java.text.SimpleDateFormat;
import java.util.*;
public class MybatisXmlUtils {
public static SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMdd");
public static void main(String[] args) {
HashMap paramMap = new HashMap();
paramMap.put("id","ad");
paramMap.put("name","name1");
paramMap.put("createPer","createPer1");
paramMap.put("receivedPer","receivedPer1");
paramMap.put("triggerCondition","triggerCondition1");
ArrayList userIdList=new ArrayList();
userIdList.add(1);
userIdList.add(2);
userIdList.add(3);
paramMap.put("userIdList",userIdList);;
String sql = MybatisXmlUtils.getRealSql("demoPage",paramMap);
System.out.println("最终的sql:"+sql);
/*String alarmPage2 = MybatisXmlUtils.getRealSql("demoPage2",paramMap);
System.out.println(alarmPage2+":"+alarmPage2);*/
}
public static String getRealSql(String sqlId, Map map) {
Environment environment = new Environment("development", new JdbcTransactionFactory(), new PooledDataSource());
//通过底层开发者模式的environment创建configuration对象
Configuration configuration = new Configuration(environment);
//加入mapper接口类映射器,并注册别名
//TODO 可以加入多个dao类别。如果业务量大起来,可以使用数组去遍历路径下的接口类
/*configuration.getTypeAliasRegistry().registerAlias("DemoMapper", DemoMapper.class);
configuration.addMapper(DemoMapper.class);*/
configuration.addMappers("cn.getech.data.service.utils");
//绑定里面的sql, 并且把写的map参数也传给sql
BoundSql boundSql = configuration.getMappedStatement(sqlId).getBoundSql(map);
String sql = boundSql.getSql();
System.out.println("去掉mybatis标签的sql:"+sql);
if (StringUtils.isEmpty(sql)) {
return "";
}
//美化Sql
sql.replaceAll("[\\s\n]+", " ");
// 填充占位符, 把传参填进去,使用#{}、${} 一样的方式
Object parameterObject = boundSql.getParameterObject();
//参数映射列表,有入的(in) 有出的(O),后面只遍历传入的参数,并且把传入的参数赋值成我们代码里的值
List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();
TypeHandlerRegistry typeHandlerRegistry = configuration.getTypeHandlerRegistry();
ArrayList<String> parmeters = new ArrayList<String>();
if (parameterMappings != null) {
MetaObject metaObject = parameterObject == null ? null : configuration.newMetaObject(parameterObject);
for (int i = 0; i < parameterMappings.size(); i++) {
ParameterMapping parameterMapping = parameterMappings.get(i);
if (parameterMapping.getMode() != ParameterMode.OUT) {
//参数值
Object value;
String propertyName = parameterMapping.getProperty();
//获取参数名称
if (boundSql.hasAdditionalParameter(propertyName)) {
//获取参数值
value = boundSql.getAdditionalParameter(propertyName);
} else if (parameterObject == null) {
value = null;
} else if (typeHandlerRegistry.hasTypeHandler(parameterObject.getClass())) {
//如果是单个值则直接赋值
value = parameterObject;
} else {
value = metaObject == null ? null : metaObject.getValue(propertyName);
}
//由于传参类型多种多样,数值型的直接把value的值传参进去即可,如果是字符串的、日期的,要在前后加上单引号‘’,才能到sql里判读语句里使用
if (value instanceof Number) {
parmeters.add(String.valueOf(value));
} else {
StringBuilder builder = new StringBuilder();
builder.append("'");
if (value instanceof Date) {
builder.append(simpleDateFormat.format((Date) value));
} else if (value instanceof String) {
builder.append(value);
}
builder.append("'");
parmeters.add(builder.toString());
}
}
}
}
//sql里的东西处理完了,都返回给我们声明list容器里了,接下来要用我们一开始获取到绑定的sql 来替换赋值,把真正 传参赋值的sql返回给计算引擎,spark或者flink
for (String value : parmeters) {
/*
把占位符问号 逐个 从第一位去替换我们list里获取到的值。如果对ArrayList数组的顺序不放心,可以换成LinkList去实现,不需要考虑性能问题
毕竟最多10来个参数,如果你写sql还要传入上千个的参数,那么就得好好反思,是不是要改成代码去实现了。
*/
sql = sql.replaceFirst("\\?", value);
}
return sql;
}
}
mybatis xml解析工具类
于 2021-12-05 17:02:48 首次发布