blocks|key|3086248|text|只需阅读它，然后使用带有完整sql文件的prepared语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086249|(如果我没记错的话)|3086250|ADD:你也可以在";"上读取和拆分，然后在一个循环中执行它们。不要忘记注释，并再次添加";"|offset|length|style|BOLD|CODE|3086251|entityMap^0|0|0|0|4|9|3|18|3|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@$F|P|G|Q|H|I]|$F|R|G|S|H|J]|$F|T|G|U|H|J]]|9|@]|A|$]]|$1|K|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|L|$]]

Just read it and then use the preparedstatement with the full sql-file in it.

(If I remember good)

ADD: You can also read and split on <code>";"</code> and than execute them all in a loop.
Do not forget the comments and add again the <code>";"</code>

blocks|key|3086255|text|您可以使用BufferedReader逐行读取脚本，并将每一行都附加到StringBuilder，这样脚本就会变成一个大字符串。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3086256|然后，您可以使用JDBC创建Statement对象并调用statement.execute(stringBuilder.toString())。|3086257|entityMap^0|5|E|Z|D|0|E|9|S|17|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|I|$]]

You can read the script line per line with a <code>BufferedReader</code> and append every line to a <code>StringBuilder</code> so that the script becomes one large string.

Then you can create a <code>Statement</code> object using JDBC and call <code>statement.execute(stringBuilder.toString())</code>.

blocks|key|3299467|text|这个链接可能会帮到你：http://pastebin.com/f10584951。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3299468|粘贴在下面，供后人使用：|3299469|/*
+*+Slightly+modified+version+of+the+com.ibatis.common.jdbc.ScriptRunner+class
+*+from+the+iBATIS+Apache+project.+Only+removed+dependency+on+Resource+class
+*+and+a+constructor
+*/
/*
+*++Copyright+2004+Clinton+Begin
+*
+*++Licensed+under+the+Apache+License,+Version+2.0+(the+"License");
+*++you+may+not+use+this+file+except+in+compliance+with+the+License.
+*++You+may+obtain+a+copy+of+the+License+at
+*
+*++++++http://www.apache.org/licenses/LICENSE-2.0
+*
+*++Unless+required+by+applicable+law+or+agreed+to+in+writing,+software
+*++distributed+under+the+License+is+distributed+on+an+"AS+IS"+BASIS,
+*++WITHOUT+WARRANTIES+OR+CONDITIONS+OF+ANY+KIND,+either+express+or+implied.
+*++See+the+License+for+the+specific+language+governing+permissions+and
+*++limitations+under+the+License.
+*/

import+java.io.IOException;
import+java.io.LineNumberReader;
import+java.io.PrintWriter;
import+java.io.Reader;
import+java.sql.*;

/**
+*+Tool+to+run+database+scripts
+*/
public+class+ScriptRunner+{

++++private+static+final+String+DEFAULT_DELIMITER+=+";";

++++private+Connection+connection;

++++private+boolean+stopOnError;
++++private+boolean+autoCommit;

++++private+PrintWriter+logWriter+=+new+PrintWriter(System.out);
++++private+PrintWriter+errorLogWriter+=+new+PrintWriter(System.err);

++++private+String+delimiter+=+DEFAULT_DELIMITER;
++++private+boolean+fullLineDelimiter+=+false;

++++/**
+++++*+Default+constructor
+++++*/
++++public+ScriptRunner(Connection+connection,+boolean+autoCommit,
++++++++++++boolean+stopOnError)+{
++++++++this.connection+=+connection;
++++++++this.autoCommit+=+autoCommit;
++++++++this.stopOnError+=+stopOnError;
++++}

++++public+void+setDelimiter(String+delimiter,+boolean+fullLineDelimiter)+{
++++++++this.delimiter+=+delimiter;
++++++++this.fullLineDelimiter+=+fullLineDelimiter;
++++}

++++/**
+++++*+Setter+for+logWriter+property
+++++*
+++++*+@param+logWriter
+++++*++++++++++++-+the+new+value+of+the+logWriter+property
+++++*/
++++public+void+setLogWriter(PrintWriter+logWriter)+{
++++++++this.logWriter+=+logWriter;
++++}

++++/**
+++++*+Setter+for+errorLogWriter+property
+++++*
+++++*+@param+errorLogWriter
+++++*++++++++++++-+the+new+value+of+the+errorLogWriter+property
+++++*/
++++public+void+setErrorLogWriter(PrintWriter+errorLogWriter)+{
++++++++this.errorLogWriter+=+errorLogWriter;
++++}

++++/**
+++++*+Runs+an+SQL+script+(read+in+using+the+Reader+parameter)
+++++*
+++++*+@param+reader
+++++*++++++++++++-+the+source+of+the+script
+++++*/
++++public+void+runScript(Reader+reader)+throws+IOException,+SQLException+{
++++++++try+{
++++++++++++boolean+originalAutoCommit+=+connection.getAutoCommit();
++++++++++++try+{
++++++++++++++++if+(originalAutoCommit+!=+this.autoCommit)+{
++++++++++++++++++++connection.setAutoCommit(this.autoCommit);
++++++++++++++++}
++++++++++++++++runScript(connection,+reader);
++++++++++++}+finally+{
++++++++++++++++connection.setAutoCommit(originalAutoCommit);
++++++++++++}
++++++++}+catch+(IOException+e)+{
++++++++++++throw+e;
++++++++}+catch+(SQLException+e)+{
++++++++++++throw+e;
++++++++}+catch+(Exception+e)+{
++++++++++++throw+new+RuntimeException("Error+running+script.++Cause:+"+%2B+e,+e);
++++++++}
++++}

++++/**
+++++*+Runs+an+SQL+script+(read+in+using+the+Reader+parameter)+using+the
+++++*+connection+passed+in
+++++*
+++++*+@param+conn
+++++*++++++++++++-+the+connection+to+use+for+the+script
+++++*+@param+reader
+++++*++++++++++++-+the+source+of+the+script
+++++*+@throws+SQLException
+++++*+++++++++++++if+any+SQL+errors+occur
+++++*+@throws+IOException
+++++*+++++++++++++if+there+is+an+error+reading+from+the+Reader
+++++*/
++++private+void+runScript(Connection+conn,+Reader+reader)+throws+IOException,
++++++++++++SQLException+{
++++++++StringBuffer+command+=+null;
++++++++try+{
++++++++++++LineNumberReader+lineReader+=+new+LineNumberReader(reader);
++++++++++++String+line+=+null;
++++++++++++while+((line+=+lineReader.readLine())+!=+null)+{
++++++++++++++++if+(command+==+null)+{
++++++++++++++++++++command+=+new+StringBuffer();
++++++++++++++++}
++++++++++++++++String+trimmedLine+=+line.trim();
++++++++++++++++if+(trimmedLine.startsWith("--"))+{
++++++++++++++++++++println(trimmedLine);
++++++++++++++++}+else+if+(trimmedLine.length()+<+1
++++++++++++++++++++++++%7C%7C+trimmedLine.startsWith("//"))+{
++++++++++++++++++++//+Do+nothing
++++++++++++++++}+else+if+(trimmedLine.length()+<+1
++++++++++++++++++++++++%7C%7C+trimmedLine.startsWith("--"))+{
++++++++++++++++++++//+Do+nothing
++++++++++++++++}+else+if+(!fullLineDelimiter
++++++++++++++++++++++++&&+trimmedLine.endsWith(getDelimiter())
++++++++++++++++++++++++%7C%7C+fullLineDelimiter
++++++++++++++++++++++++&&+trimmedLine.equals(getDelimiter()))+{
++++++++++++++++++++command.append(line.substring(0,+line
++++++++++++++++++++++++++++.lastIndexOf(getDelimiter())));
++++++++++++++++++++command.append("+");
++++++++++++++++++++Statement+statement+=+conn.createStatement();

++++++++++++++++++++println(command);

++++++++++++++++++++boolean+hasResults+=+false;
++++++++++++++++++++if+(stopOnError)+{
++++++++++++++++++++++++hasResults+=+statement.execute(command.toString());
++++++++++++++++++++}+else+{
++++++++++++++++++++++++try+{
++++++++++++++++++++++++++++statement.execute(command.toString());
++++++++++++++++++++++++}+catch+(SQLException+e)+{
++++++++++++++++++++++++++++e.fillInStackTrace();
++++++++++++++++++++++++++++printlnError("Error+executing:+"+%2B+command);
++++++++++++++++++++++++++++printlnError(e);
++++++++++++++++++++++++}
++++++++++++++++++++}

++++++++++++++++++++if+(autoCommit+&&+!conn.getAutoCommit())+{
++++++++++++++++++++++++conn.commit();
++++++++++++++++++++}

++++++++++++++++++++ResultSet+rs+=+statement.getResultSet();
++++++++++++++++++++if+(hasResults+&&+rs+!=+null)+{
++++++++++++++++++++++++ResultSetMetaData+md+=+rs.getMetaData();
++++++++++++++++++++++++int+cols+=+md.getColumnCount();
++++++++++++++++++++++++for+(int+i+=+0;+i+<+cols;+i%2B%2B)+{
++++++++++++++++++++++++++++String+name+=+md.getColumnLabel(i);
++++++++++++++++++++++++++++print(name+%2B+"\t");
++++++++++++++++++++++++}
++++++++++++++++++++++++println("");
++++++++++++++++++++++++while+(rs.next())+{
++++++++++++++++++++++++++++for+(int+i+=+0;+i+<+cols;+i%2B%2B)+{
++++++++++++++++++++++++++++++++String+value+=+rs.getString(i);
++++++++++++++++++++++++++++++++print(value+%2B+"\t");
++++++++++++++++++++++++++++}
++++++++++++++++++++++++++++println("");
++++++++++++++++++++++++}
++++++++++++++++++++}

++++++++++++++++++++command+=+null;
++++++++++++++++++++try+{
++++++++++++++++++++++++statement.close();
++++++++++++++++++++}+catch+(Exception+e)+{
++++++++++++++++++++++++//+Ignore+to+workaround+a+bug+in+Jakarta+DBCP
++++++++++++++++++++}
++++++++++++++++++++Thread.yield();
++++++++++++++++}+else+{
++++++++++++++++++++command.append(line);
++++++++++++++++++++command.append("+");
++++++++++++++++}
++++++++++++}
++++++++++++if+(!autoCommit)+{
++++++++++++++++conn.commit();
++++++++++++}
++++++++}+catch+(SQLException+e)+{
++++++++++++e.fillInStackTrace();
++++++++++++printlnError("Error+executing:+"+%2B+command);
++++++++++++printlnError(e);
++++++++++++throw+e;
++++++++}+catch+(IOException+e)+{
++++++++++++e.fillInStackTrace();
++++++++++++printlnError("Error+executing:+"+%2B+command);
++++++++++++printlnError(e);
++++++++++++throw+e;
++++++++}+finally+{
++++++++++++conn.rollback();
++++++++++++flush();
++++++++}
++++}

++++private+String+getDelimiter()+{
++++++++return+delimiter;
++++}

++++private+void+print(Object+o)+{
++++++++if+(logWriter+!=+null)+{
++++++++++++System.out.print(o);
++++++++}
++++}

++++private+void+println(Object+o)+{
++++++++if+(logWriter+!=+null)+{
++++++++++++logWriter.println(o);
++++++++}
++++}

++++private+void+printlnError(Object+o)+{
++++++++if+(errorLogWriter+!=+null)+{
++++++++++++errorLogWriter.println(o);
++++++++}
++++}

++++private+void+flush()+{
++++++++if+(logWriter+!=+null)+{
++++++++++++logWriter.flush();
++++++++}
++++++++if+(errorLogWriter+!=+null)+{
++++++++++++errorLogWriter.flush();
++++++++}
++++}
}|code-block|syntax|javascript|3299470|entityMap|0|LINK|mutability|MUTABLE|url|http://pastebin.com/f10584951^0|B|T|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

This link might help you out: <a href="http://pastebin.com/f10584951" rel="noreferrer">http://pastebin.com/f10584951</a>.

Pasted below for posterity:

<pre><code>/*
 * Slightly modified version of the com.ibatis.common.jdbc.ScriptRunner class
 * from the iBATIS Apache project. Only removed dependency on Resource class
 * and a constructor
 */
/*
 * Copyright 2004 Clinton Begin
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import java.io.IOException;
import java.io.LineNumberReader;
import java.io.PrintWriter;
import java.io.Reader;
import java.sql.*;

/**
 * Tool to run database scripts
 */
public class ScriptRunner {

 private static final String DEFAULT_DELIMITER = ";";

 private Connection connection;

 private boolean stopOnError;
 private boolean autoCommit;

 private PrintWriter logWriter = new PrintWriter(System.out);
 private PrintWriter errorLogWriter = new PrintWriter(System.err);

 private String delimiter = DEFAULT_DELIMITER;
 private boolean fullLineDelimiter = false;

 /**
 * Default constructor
 */
 public ScriptRunner(Connection connection, boolean autoCommit,
 boolean stopOnError) {
 this.connection = connection;
 this.autoCommit = autoCommit;
 this.stopOnError = stopOnError;
 }

 public void setDelimiter(String delimiter, boolean fullLineDelimiter) {
 this.delimiter = delimiter;
 this.fullLineDelimiter = fullLineDelimiter;
 }

 /**
 * Setter for logWriter property
 *
 * @param logWriter
 * - the new value of the logWriter property
 */
 public void setLogWriter(PrintWriter logWriter) {
 this.logWriter = logWriter;
 }

 /**
 * Setter for errorLogWriter property
 *
 * @param errorLogWriter
 * - the new value of the errorLogWriter property
 */
 public void setErrorLogWriter(PrintWriter errorLogWriter) {
 this.errorLogWriter = errorLogWriter;
 }

 /**
 * Runs an SQL script (read in using the Reader parameter)
 *
 * @param reader
 * - the source of the script
 */
 public void runScript(Reader reader) throws IOException, SQLException {
 try {
 boolean originalAutoCommit = connection.getAutoCommit();
 try {
 if (originalAutoCommit != this.autoCommit) {
 connection.setAutoCommit(this.autoCommit);
 }
 runScript(connection, reader);
 } finally {
 connection.setAutoCommit(originalAutoCommit);
 }
 } catch (IOException e) {
 throw e;
 } catch (SQLException e) {
 throw e;
 } catch (Exception e) {
 throw new RuntimeException("Error running script. Cause: " + e, e);
 }
 }

 /**
 * Runs an SQL script (read in using the Reader parameter) using the
 * connection passed in
 *
 * @param conn
 * - the connection to use for the script
 * @param reader
 * - the source of the script
 * @throws SQLException
 * if any SQL errors occur
 * @throws IOException
 * if there is an error reading from the Reader
 */
 private void runScript(Connection conn, Reader reader) throws IOException,
 SQLException {
 StringBuffer command = null;
 try {
 LineNumberReader lineReader = new LineNumberReader(reader);
 String line = null;
 while ((line = lineReader.readLine()) != null) {
 if (command == null) {
 command = new StringBuffer();
 }
 String trimmedLine = line.trim();
 if (trimmedLine.startsWith("--")) {
 println(trimmedLine);
 } else if (trimmedLine.length() &lt; 1
 || trimmedLine.startsWith("//")) {
 // Do nothing
 } else if (trimmedLine.length() &lt; 1
 || trimmedLine.startsWith("--")) {
 // Do nothing
 } else if (!fullLineDelimiter
 &amp;&amp; trimmedLine.endsWith(getDelimiter())
 || fullLineDelimiter
 &amp;&amp; trimmedLine.equals(getDelimiter())) {
 command.append(line.substring(0, line
 .lastIndexOf(getDelimiter())));
 command.append(" ");
 Statement statement = conn.createStatement();

 println(command);

 boolean hasResults = false;
 if (stopOnError) {
 hasResults = statement.execute(command.toString());
 } else {
 try {
 statement.execute(command.toString());
 } catch (SQLException e) {
 e.fillInStackTrace();
 printlnError("Error executing: " + command);
 printlnError(e);
 }
 }

 if (autoCommit &amp;&amp; !conn.getAutoCommit()) {
 conn.commit();
 }

 ResultSet rs = statement.getResultSet();
 if (hasResults &amp;&amp; rs != null) {
 ResultSetMetaData md = rs.getMetaData();
 int cols = md.getColumnCount();
 for (int i = 0; i &lt; cols; i++) {
 String name = md.getColumnLabel(i);
 print(name + "\t");
 }
 println("");
 while (rs.next()) {
 for (int i = 0; i &lt; cols; i++) {
 String value = rs.getString(i);
 print(value + "\t");
 }
 println("");
 }
 }

 command = null;
 try {
 statement.close();
 } catch (Exception e) {
 // Ignore to workaround a bug in Jakarta DBCP
 }
 Thread.yield();
 } else {
 command.append(line);
 command.append(" ");
 }
 }
 if (!autoCommit) {
 conn.commit();
 }
 } catch (SQLException e) {
 e.fillInStackTrace();
 printlnError("Error executing: " + command);
 printlnError(e);
 throw e;
 } catch (IOException e) {
 e.fillInStackTrace();
 printlnError("Error executing: " + command);
 printlnError(e);
 throw e;
 } finally {
 conn.rollback();
 flush();
 }
 }

 private String getDelimiter() {
 return delimiter;
 }

 private void print(Object o) {
 if (logWriter != null) {
 System.out.print(o);
 }
 }

 private void println(Object o) {
 if (logWriter != null) {
 logWriter.println(o);
 }
 }

 private void printlnError(Object o) {
 if (errorLogWriter != null) {
 errorLogWriter.println(o);
 }
 }

 private void flush() {
 if (logWriter != null) {
 logWriter.flush();
 }
 if (errorLogWriter != null) {
 errorLogWriter.flush();
 }
 }
}
</code></pre>

blocks|key|328672|text|您应该能够将SQL文件解析为语句。一次运行一条语句。如果您知道您的文件由简单的insert/update/delete语句组成，那么可以使用分号作为语句分隔符。在一般情况下，您需要创建特定SQL方言解析器。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328673|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You should be able to parse the SQL file into statements. And run a single statement a time. If you know that your file consists of simple insert/update/delete statements you can use a semicolon as statement delimiter. In common case you have a task to create your specific SQL-dialect parser.

blocks|key|3299516|text|我使用这段代码导入由mysqldump创建的sql语句：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3299517|public+static+void+importSQL(Connection+conn,+InputStream+in)+throws+SQLException
{
++++Scanner+s+=+new+Scanner(in);
++++s.useDelimiter("(;(\r)?\n)%7C(--\n)");
++++Statement+st+=+null;
++++try
++++{
++++++++st+=+conn.createStatement();
++++++++while+(s.hasNext())
++++++++{
++++++++++++String+line+=+s.next();
++++++++++++if+(line.startsWith("/*!")+&&+line.endsWith("*/"))
++++++++++++{
++++++++++++++++int+i+=+line.indexOf('+');
++++++++++++++++line+=+line.substring(i+%2B+1,+line.length()+-+"+*/".length());
++++++++++++}

++++++++++++if+(line.trim().length()+>+0)
++++++++++++{
++++++++++++++++st.execute(line);
++++++++++++}
++++++++}
++++}
++++finally
++++{
++++++++if+(st+!=+null)+st.close();
++++}
}|code-block|syntax|javascript|3299518|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|$]]

I use this bit of code to import sql statements created by mysqldump:

<pre><code>public static void importSQL(Connection conn, InputStream in) throws SQLException
{
 Scanner s = new Scanner(in);
 s.useDelimiter("(;(\r)?\n)|(--\n)");
 Statement st = null;
 try
 {
 st = conn.createStatement();
 while (s.hasNext())
 {
 String line = s.next();
 if (line.startsWith("/*!") &amp;&amp; line.endsWith("*/"))
 {
 int i = line.indexOf(' ');
 line = line.substring(i + 1, line.length() - " */".length());
 }

 if (line.trim().length() &gt; 0)
 {
 st.execute(line);
 }
 }
 }
 finally
 {
 if (st != null) st.close();
 }
}
</code></pre>

blocks|key|3086329|text|另一个选项是不支持注释，这对于Apache+Derby的AmaterasERD+DDL导出非常有用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3086330|public+void+executeSqlScript(Connection+conn,+File+inputFile)+{

++++//+Delimiter
++++String+delimiter+=+";";

++++//+Create+scanner
++++Scanner+scanner;
++++try+{
++++++++scanner+=+new+Scanner(inputFile).useDelimiter(delimiter);
++++}+catch+(FileNotFoundException+e1)+{
++++++++e1.printStackTrace();
++++++++return;
++++}

++++//+Loop+through+the+SQL+file+statements+
++++Statement+currentStatement+=+null;
++++while(scanner.hasNext())+{

++++++++//+Get+statement+
++++++++String+rawStatement+=+scanner.next()+%2B+delimiter;
++++++++try+{
++++++++++++//+Execute+statement
++++++++++++currentStatement+=+conn.createStatement();
++++++++++++currentStatement.execute(rawStatement);
++++++++}+catch+(SQLException+e)+{
++++++++++++e.printStackTrace();
++++++++}+finally+{
++++++++++++//+Release+resources
++++++++++++if+(currentStatement+!=+null)+{
++++++++++++++++try+{
++++++++++++++++++++currentStatement.close();
++++++++++++++++}+catch+(SQLException+e)+{
++++++++++++++++++++e.printStackTrace();
++++++++++++++++}
++++++++++++}
++++++++++++currentStatement+=+null;
++++++++}
++++}
scanner.close();
}|code-block|syntax|javascript|3086331|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|$]]

Another option, this DOESN'T support comments, very useful with AmaterasERD DDL export for Apache Derby:

<pre><code>public void executeSqlScript(Connection conn, File inputFile) {

 // Delimiter
 String delimiter = ";";

 // Create scanner
 Scanner scanner;
 try {
 scanner = new Scanner(inputFile).useDelimiter(delimiter);
 } catch (FileNotFoundException e1) {
 e1.printStackTrace();
 return;
 }

 // Loop through the SQL file statements 
 Statement currentStatement = null;
 while(scanner.hasNext()) {

 // Get statement 
 String rawStatement = scanner.next() + delimiter;
 try {
 // Execute statement
 currentStatement = conn.createStatement();
 currentStatement.execute(rawStatement);
 } catch (SQLException e) {
 e.printStackTrace();
 } finally {
 // Release resources
 if (currentStatement != null) {
 try {
 currentStatement.close();
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
 currentStatement = null;
 }
 }
scanner.close();
}
</code></pre>

blocks|key|328694|text|我在尝试执行创建SQL数据库的SQL脚本时也遇到了同样的问题。我到处用谷歌搜索，发现了一个最初由克林顿·贝京编写的Java类，它支持注释(参见http://pastebin.com/P14HsYAG)。我稍微修改了文件以适应触发器，在触发器中必须将默认分隔符更改为不同的分隔符。我使用过那个版本的ScriptRunner+(参见http://pastebin.com/sb4bMbVv)。由于(开源和免费的)+SQLScriptRunner类是一个绝对必要的实用程序，所以最好能从开发人员那里得到更多的输入，并且希望我们很快就能有一个更稳定的版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|328695|entityMap|0|LINK|mutability|MUTABLE|url|http://pastebin.com/P14HsYAG|1|http://pastebin.com/sb4bMbVv^0|1Z|S|0|4K|S|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

I had the same problem trying to execute an SQL script that creates an SQL database. Googling here and there I found a Java class initially written by Clinton Begin which supports comments (see <a href="http://pastebin.com/P14HsYAG" rel="nofollow">http://pastebin.com/P14HsYAG</a>). I modified slightly the file to cater for triggers where one has to change the default DELIMITER to something different. I've used that version ScriptRunner (see <a href="http://pastebin.com/sb4bMbVv" rel="nofollow">http://pastebin.com/sb4bMbVv</a>). Since an (open source and free) SQLScriptRunner class is an absolutely necessary utility, it would be good to have some more input from developers and hopefully we'll have soon a more stable version of it.

<blockquote>
 Possible Duplicate: 
 <a href="https://stackoverflow.com/questions/1044194/running-a-sql-script-using-mysql-with-jdbc">Running a .sql script using MySQL with JDBC</a> 
</blockquote>



I have an SQL script file which contains 40-50 SQL statements. Is it possible to run this script file using JDBC?

How to execute .sql script file using JDBC

SQL数据库

数据库

Java

 可能重复：我有一个SQL脚本文件，其中包含40-50个SQL语句。是否可以使用JDBC运行此脚本文件？

问如何使用JDBC执行.sql脚本文件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用JDBC执行.sql脚本文件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用JDBC执行.sql脚本文件
EN