java中ibatis2直接执行my sql脚本

原来ibatis2中，其实还可以有ScriptRunner类直接运行mysql中的脚本了（其实不限于mysql的脚本），马上来看代码：

String aSQLScriptFilePath = "/script.sql";
 
		
		Class.forName("com.mysql.jdbc.Driver");
		Connection con = DriverManager.getConnection(
			"jdbc:mysql://localhost:3306/database", "username", "password");
		Statement stmt = null;
 
		try {
			
			ScriptRunner sr = new ScriptRunner(con, false, false);
 
		
			Reader reader = new BufferedReader(
                               new FileReader(aSQLScriptFilePath));
 
			
			sr.runScript(reader);
 
		} catch (Exception e) {
			System.err.println("Failed to Execute" + aSQLScriptFilePath
					+ " The error is " + e.getMessage());
		}

评论

2 楼 jackyrong 2013-01-19  

也就普通的my sql的什么建表等语句了

1 楼 hamber 2013-01-18  

怎么不把script.sql给贴出来呢？