public static void getSqlScript(String sqlFileName) {
try {
// 建立连接
Connection conn = DriverManager.getConnection(ParameterUtil.surl, ParameterUtil.username, ParameterUtil.spassword);
// 创建ScriptRunner,用于执行SQL脚本
ScriptRunner runner = new ScriptRunner(conn);
runner.setErrorLogWriter(null);
runner.setLogWriter(null);
// 执行SQL脚本
runner.runScript(new InputStreamReader(new FileInputStream(sqlFileName),"utf8"));
// 关闭连接
conn.close()
} catch (IOException | SQLException e) {
e.printStackTrace();
}
}
}
java 执行sql脚本
最新推荐文章于 2023-11-06 14:21:28 发布