且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从Java程序运行SQL文件脚本

更新时间:2023-10-21 10:15:04

Ibatis提供了

Ibatis provides a ScriptRunner that will help you. Simple code snippets you can refer:

Connection conn=getConnection();//some method to get a Connection
ScriptRunner runner=new ScriptRunner(conn, false, false);
InputStreamReader reader = new InputStreamReader(new FileInputStream("foo.sql"));
runner.runScript(reader);
reader.close();
conn.close();