blocks|key|1305635|text|真的没有办法做到这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1305636|您可以通过Runtime.exec(String[])运行mysql命令行客户端，并在决定使用此选项时读取this+article。|offset|length|1305637|或者尝试使用ibatis中的ScriptRunner+(com.ibatis.common.jdbc.ScriptRunner)。但是仅仅为了运行一个脚本而包含整个库是有点愚蠢的。|1305638|entityMap|0|LINK|mutability|MUTABLE|url|http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html|1|http://ibatis.apache.org/^0|0|1H|C|0|0|6|6|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

There isn't really a way to do this.

You could either run the mysql command line client via Runtime.exec(String[]) and read <a href="http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html" rel="nofollow noreferrer">this article</a> when you decide for this option

Or try using the ScriptRunner (com.ibatis.common.jdbc.ScriptRunner) from <a href="http://ibatis.apache.org/" rel="nofollow noreferrer">ibatis</a>. But it's a bit stupid to include a whole library just to run a script.

blocks|key|1305693|text|好的。你可以在这里在你的项目中使用这个类(由于文件长度的原因，发布在pastebin上)。但请记住保留apache许可证信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1305694|JDBC+ScriptRunner|offset|length|1305695|它是对iBatis+ScriptRunner的抄袭，删除了依赖项。|1305696|您可以像这样使用它|1305697|Connection+con+=+....
ScriptRunner+runner+=+new+ScriptRunner(con,+[booleanAutoCommit],+[booleanStopOnerror]);
runner.runScript(new+BufferedReader(new+FileReader("test.sql")));|code-block|syntax|javascript|1305698|就这样!|1305699|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/BenoitDuffez/ScriptRunner^0|0|0|H|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|F|3|G|5|6|7|13|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|14|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

Ok. You can use this class here (posted on pastebin because of file length) in your project. But remember to keep the apache license info.

<a href="https://github.com/BenoitDuffez/ScriptRunner" rel="noreferrer">JDBC ScriptRunner</a>

It's ripoff of the iBatis ScriptRunner with dependencies removed.

You can use it like this 

<pre><code>Connection con = ....
ScriptRunner runner = new ScriptRunner(con, [booleanAutoCommit], [booleanStopOnerror]);
runner.runScript(new BufferedReader(new FileReader("test.sql")));
</code></pre>

That's it!

blocks|key|1520766|text|@Pantelis+Sopasakis|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1520767|在GitHub上略微修改的版本：https://gist.github.com/831762/|offset|length|1520768|在那里更容易跟踪修改。|1520769|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/831762/^0|0|G|V|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

@Pantelis Sopasakis

Slightly modified version on GitHub: <a href="https://gist.github.com/831762/" rel="noreferrer">https://gist.github.com/831762/</a>

Its easier to track modifications there.

blocks|key|1305804|text|我对此做了很多研究，找到了一个很好的util+from+spring。我认为使用SimpleJdbcTestUtils.executeSqlScript(...)实际上是最好的解决方案，因为它更易于维护和测试。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1305805|编辑：SimpleJdbcTestUtils已弃用。您应该使用JdbcTestUtils。已更新链接。|1305806|entityMap|0|LINK|mutability|MUTABLE|url|http://static.springsource.org/spring/docs/3.1.x/javadoc-api/org/springframework/test/jdbc/JdbcTestUtils.html#executeSqlScript%2528org.springframework.jdbc.core.JdbcTemplate,%2520org.springframework.core.io.Resource,%2520boolean%2529^0|14|15|I|G|0|0|3|J|V|D|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@$9|S|A|T|1|U]]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]|$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

I did a lot of research on this and found a good <a href="http://static.springsource.org/spring/docs/3.1.x/javadoc-api/org/springframework/test/jdbc/JdbcTestUtils.html#executeSqlScript%28org.springframework.jdbc.core.JdbcTemplate,%20org.springframework.core.io.Resource,%20boolean%29" rel="noreferrer">util from spring</a>. I think using <code>SimpleJdbcTestUtils.executeSqlScript(...)</code> is actually the best solution, as it is more maintained and tested. 

Edit: <code>SimpleJdbcTestUtils</code> is deprecated. You should use <code>JdbcTestUtils</code>. Updated the link.

blocks|key|1305891|text|Spring+Framework的ResourceDatabasePopulator可能会有所帮助。正如您所说的，您正在使用MySQL和JDBC，让我们假设您已经准备好了一个由MySQL支持的DataSource实例。此外，让我们假设您的MySQL脚本文件是类路径可定位的。假设您使用的是WAR布局，并且脚本文件位于目录src/main/webapp/resources/mysql-scripts/...或src/test/resources/mysql-scripts/...中。然后，您可以使用ResourceDatabasePopulator执行如下所示的脚本：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1305892|import+org.springframework.jdbc.datasource.init.ResourceDatabasePopulator;
import+javax.sql.DataSource;

DataSource+dataSource+=+getYourMySQLDriverBackedDataSource();

ResourceDatabasePopulator+rdp+=+new+ResourceDatabasePopulator();++++
rdp.addScript(new+ClassPathResource(
++++++++++++++++++++++++"mysql-scripts/firstScript.sql"));
rdp.addScript(new+ClassPathResource(
++++++++++++++++++++++++"mysql-scripts/secondScript.sql"));

try+{
++++++++Connection+connection+=+dataSource.getConnection();
++++++++rdp.populate(connection);+//+this+starts+the+script+execution,+in+the+order+as+added
++++}+catch+(SQLException+e)+{
++++++++e.printStackTrace();
++++}|code-block|syntax|javascript|1305893|entityMap^0|H|P|2O|A|4G|17|5O|10|6Y|P|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|L|$]]

Spring Framework's <code>ResourceDatabasePopulator</code> may help. As you said you're using MySQL and JDBC, let's assume you have a MySQL-backed <code>DataSource</code> instance ready. Further, let's assume your MySQL script files are classpath-locatable. Let's assume you are using WAR layout and the script files are located in a directory <code>src/main/webapp/resources/mysql-scripts/...</code> or <code>src/test/resources/mysql-scripts/...</code>. Then you can use <code>ResourceDatabasePopulator</code> to execute SQL scripts like this:

<pre><code>import org.springframework.jdbc.datasource.init.ResourceDatabasePopulator;
import javax.sql.DataSource;

DataSource dataSource = getYourMySQLDriverBackedDataSource();

ResourceDatabasePopulator rdp = new ResourceDatabasePopulator(); 
rdp.addScript(new ClassPathResource(
 "mysql-scripts/firstScript.sql"));
rdp.addScript(new ClassPathResource(
 "mysql-scripts/secondScript.sql"));

try {
 Connection connection = dataSource.getConnection();
 rdp.populate(connection); // this starts the script execution, in the order as added
 } catch (SQLException e) {
 e.printStackTrace();
 }
</code></pre>

blocks|key|1305962|text|对于由';‘分割的简单sql脚本，您可以使用这个简单的函数。它删除注释并逐个运行语句|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1305963|++static+void+executeScript(Connection+conn,+InputStream+in)
++++throws+SQLException
++{
++++Scanner+s+=+new+Scanner(in);
++++s.useDelimiter("/\\*[\\s\\S]*?\\*/%7C--[%5E\\r\\n]*%7C;");

++++Statement+st+=+null;

++++try
++++{
++++++st+=+conn.createStatement();

++++++while+(s.hasNext())
++++++{
++++++++String+line+=+s.next().trim();

++++++++if+(!line.isEmpty())
++++++++++st.execute(line);
++++++}
++++}
++++finally
++++{
++++++if+(st+!=+null)
++++++++st.close();
++++}
++}|code-block|syntax|javascript|1305964|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For simple sql script splitted by ';' you can use this simple function.
It remove comments and run statements one by one

<pre><code> static void executeScript(Connection conn, InputStream in)
 throws SQLException
 {
 Scanner s = new Scanner(in);
 s.useDelimiter("/\\*[\\s\\S]*?\\*/|--[^\\r\\n]*|;");

 Statement st = null;

 try
 {
 st = conn.createStatement();

 while (s.hasNext())
 {
 String line = s.next().trim();

 if (!line.isEmpty())
 st.execute(line);
 }
 }
 finally
 {
 if (st != null)
 st.close();
 }
 }
</code></pre>

blocks|key|1521030|text|你能用这个吗：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1521031|public+static+void+executeSQL(File+f,+Connection+c)+throws+Exception+{
++++BufferedReader+br+=+new+BufferedReader(new+FileReader(f));
++++String+sql+=+"",+line;
++++while+((line+=+br.readLine())+!=+null)+sql+%2B=+(line%2B"\n");
++++c.prepareCall(sql).execute(sql);
}|code-block|syntax|javascript|1521032|此函数用于获取SQL文件和数据库连接。然后，它使用java.io中的BufferedReader逐行读取文件。|1521033|最后，执行读取的语句。|1521034|Java+8%2B版本：|1521035|public+static+void+executeSQL(Path+p,+Connection+c)+throws+Exception+{
++++List<String>+lines+=+Files.readAllLines(p);
++++String+s+=+String.join("\n",+lines.toArray(new+String[0]));
++++c.prepareCall(s).execute(s);
}|1521036|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Can you use this:

<pre><code>public static void executeSQL(File f, Connection c) throws Exception {
 BufferedReader br = new BufferedReader(new FileReader(f));
 String sql = "", line;
 while ((line = br.readLine()) != null) sql += (line+"\n");
 c.prepareCall(sql).execute(sql);
}
</code></pre>

This function gets SQL file and DB connection.
Then it reads the file line-by-line using BufferedReader from java.io. 
And, finally, executes the read statements.

Java 8+ version:

<pre><code>public static void executeSQL(Path p, Connection c) throws Exception {
 List&lt;String&gt; lines = Files.readAllLines(p);
 String s = String.join("\n", lines.toArray(new String[0]));
 c.prepareCall(s).execute(s);
}
</code></pre>

I am starting to use MySQL with JDBC.

<pre><code>Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql:///x", "x", "x");
stmt = conn.createStatement();
stmt.execute( "CREATE TABLE amigos" +
 "("+
 "id int AUTO_INCREMENT not null,"+
 "nombre char(20) not null,"+
 "primary key(id)" +
 ")");
</code></pre>

I have 3-4 tables to create and this doesn't look good.

Is there a way to run a .sql script from MySQL JDBC?

Running a .sql script using MySQL with JDBC

Spring Framework

数据库

GitHub

MySQL

Java

我开始在JDBC中使用MySQL。Class.forName("com.mysql.jdbc.Driver");conn = DriverManager.getConnection("jdbc:mysql:///x", "x", "x");stmt = conn.createStatement();stmt.execu...

问使用MySQL和JDBC运行.sql脚本
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用MySQL和JDBC运行.sql脚本EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用MySQL和JDBC运行.sql脚本
EN