如何批量测试Mybatis项目中的Sql是否正确详解

AutoTestMapper autoTestMapper = new AutoTestMapper(\"存放Mapper全路径名\");
autoTestMapper.openSqlSession(sqlSessionFactory);

 public AutoTestMapper(String path) throws IOException, ClassNotFoundException {
 String mapperContent = getFileContent(path);
 String pathPattern = \"import [a-z,A-Z,/.]+;\";
 String[] pathArr = matchMethod(pathPattern, mapperContent).split(\";\");
 for (int i = 0; i < pathArr.length; i++) {
 pathArr[i] = pathArr[i].replaceAll(\"import \", \"\");
 Class cls = Class.forName(pathArr[i]);
 if (!cls.isInterface()) {
 TYPE_ARRAY.add(cls);
 }
 }
 //获得全路径名的前缀
 String packPattern = \"package [a-z,A-Z,/.]+;\";
 String[] packPathArr = matchMethod(packPattern, mapperContent).split(\";\");
 String packPath = packPathArr[0].replaceAll(\"package \", \"\").replaceAll(\";\", \"\");
 this.PACK_PATH = packPath;
 }

 List<Map<Class,  >> list = new ArrayList<>();
 List<String> invokeSuccess = new ArrayList<>();
 List<String> invokeFail = new ArrayList<>();
 for (String fileName : FILE_NAME) {
 Class cls = Class.forName(PACK_PATH + \".\" + fileName);
 //添加Mapper
 if (!sqlSessionFactory.getConfiguration().hasMapper(cls)){
 sqlSessionFactory.getConfiguration().addMapper(cls);
 }
 //获得Mapper
   mapper = sqlSessionFactory.openSession().getMapper(cls);
 //反射执行Mapper的方法
 Map<String, List<String>> resultMap = autoTestInvoke(cls, mapper);
 invokeSuccess.addAll(resultMap.get(SUCCESS_FLG));
 invokeFail.addAll(resultMap.get(FAIL_FLG));
 }

 	private Map<String, List<String>> autoTestInvoke(Class c,   o)
 {
 Method[] declaredMethods = c.getDeclaredMethods();
 String fileName = c.getName().substring(c.getName().lastIndexOf(\".\"));
 List<String> invokeSuccess = new ArrayList<>();
 List<String> invokeFail = new ArrayList<>();
 Map<String, List<String>> resultMap = new HashMap<>();
 //给参数赋初始值
 for (Method method : declaredMethods) {
 List< > list = new ArrayList<>();
 for (Class cls : method.getParameterTypes()) {
   par = new  ();
 if (TYPE_ARRAY.contains(cls)) {
  if (cls.equals(String.class)) {
  par = \"1\";
  } else {
  try {
  par = cls.newInstance();
  assignment(cls, par);
  } catch (InstantiationException e) {
  if (cls.isPrimitive()) {
  cls = primitiveClazz.get(cls.getName());
  }
  try {
  par = cls.getDeclaredConstructor(String.class).newInstance(\"1\");

  }catch (NoSuchMethodException e1){
  System.out.println(cls.getName()+e);
  }
  }
  }
 }else if (\"java.util.Map\".equals(cls.getName())){
  par = getMapData(c.getName()+\".\"+method.getName());
 }
 list.add(par);
 }
 try {
 method.invoke(o, list.toArray());
 invokeSuccess.add(\"Success: \" + fileName + \".\" + method.getName());
 } catch (Exception e) {
 invokeFail.add(\"Error:\" + method.getName() + \" Error Info:\" + e);
 }
 }
 resultMap.put(SUCCESS_FLG, invokeSuccess);
 resultMap.put(FAIL_FLG, invokeFail);
 return resultMap;
 }

<dependency>
 <groupId>com.github.modouxiansheng</groupId>
 <artifactId>convenientUtil</artifactId>
 <version>1.3-release</version>
</dependency>

compile \'com.github.modouxiansheng:convenientUtil:1.1-release\'

<!DOCTYPE configuration
 PUBLIC \"-//mybatis.org//DTD Config 3.0//EN\"
 \"http://mybatis.org/dtd/mybatis-3-config.dtd\">
<configuration>
 <environments default=\"dev\">
 <environment id=\"dev\">
 <transactionManager type=\"JDBC\"></transactionManager>
 <dataSource type=\"UNPOOLED\">
 <property name=\"driver\" value=\"\"/>
 <property name=\"url\" value=\"\"/>
 <property name=\"username\" value=\"\"/>
 <property name=\"password\" value=\"\"/>
 </dataSource>
 </environment>
 </environments>
</configuration>

Reader resourceAsReader = Resources.getResourceAsReader(\"mybatis-config. \");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsReader);
resourceAsReader.close();
AutoTestMapper autoTestMapper = new AutoTestMapper(\"想要测试的Mapper文件夹全路径名\");
autoTestMapper.openSqlSession(sqlSessionFactory);