mysql多个数据库运行脚本_多个数据库执行同一个sql的小脚本 - 原创

packagesqlRun;importjava.io.FileReader;importjava.io.IOException;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.util.List;importjava.util.Map;importcom.ibatis.common.jdbc.ScriptRunner;public classMysqlOperation {public static voidmain(String[] args) {

actionSql();

}

@SuppressWarnings("rawtypes")public static voidactionSql(){

List dataSourceList =ReadSqlXml.xml();for(Map map : dataSourceList){

Connection conn=null;try{

Class.forName((String) map.get("driver"));

String url= (String) map.get("url");

String username= (String) map.get("userName");

String password= (String) map.get("password");

conn= DriverManager.getConnection(url,username,password); //循环获取每一个数据的连接

ScriptRunner runner= new ScriptRunner(conn, fa