pom.xml
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>geostack</groupId> <artifactId>sql-exec</artifactId> <version>1.0-SNAPSHOT</version> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.16</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.6</version> </dependency> </dependencies> </project>
Exec.java
importorg.apache.ibatis.jdbc.ScriptRunner; importjava.io.File; importjava.io.FileReader; importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.SQLException; public classExec { private static final String driver = "com.mysql.jdbc.Driver"; private static final String url = "jdbc:mysql://localhost:3306/userinfo"; private static final String username = "gfstack"; private static final String password = "gfstack"; private static final File file = new File("C:\IDEA_WS\OperationCenter_develop_WS\OperationCenter\resource\config\sql\userinfo.sql"); public static void main(String[] args) throwsSQLException, ClassNotFoundException { mybatisExec(); } private static void mybatisExec() throwsClassNotFoundException, SQLException { Class.forName(driver); Connection conn =DriverManager.getConnection(url, username, password); ScriptRunner runner = newScriptRunner(conn); try{ runner.setStopOnError(true); runner.runScript(newFileReader(file)); } catch(Exception e) { e.printStackTrace(); } conn.close(); } }