Question

用JAVA如何实现执行SQL脚本文件

如题，怎么能执行脚本这样的文件而不是一条一条的~

Answer 1

import java.sql.*;
private Connection conn=null;
private PreparedStatement pst=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:%%1",%%2,%%3);
pst=conn.prepareStatement(<SQL>);
pst.addBatch();
pst.executeBatch();
//pst.execute();
} catch (SQLException e){
e.printStackTrace();
}
finally{
try {
pst.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
读取文件
import java.io.*;
FileReader fr=null;
BufferedReader reader=null;
try {
fr = new FileReader(%%1);
reader = new BufferedReader(fr);
String line;
while ((line = reader.readLine()) != null) {
// line
}
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
reader.close();
fr.close();
} catch (IOException e) {}
}