如何批量测试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 , object>> 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

object 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, object 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<object> list = new arraylist<>();

for ( class cls : method.getparametertypes()) {

object par = new object();

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.xml" );

sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(resourceasreader);

resourceasreader.close();

autotestmapper autotestmapper = new autotestmapper( "想要测试的mapper文件夹全路径名" );

autotestmapper.opensqlsession(sqlsessionfactory);