java复制mysql表数据_java 复制表到另一个数据库，如何实现，求思路

java将SQL文件导入到数据库：

代码如下：

[java] view plaincopy

private static File file = new File("E:\\data\\tulufan.sql");

private static InputStreamReader fileReader;

static {

try {

if (!file.exists()) {

file.createNewFile();

}

fileReader = new InputStreamReader(new FileInputStream(file),

"UTF-8");

} catch (Exception e) {

e.printStackTrace();

}

}

public void readSQLFile() {

BufferedReader bufferedReader = new BufferedReader(fileReader);

try {

StringBuilder sBuilder = new StringBuilder("");

String str = bufferedReader.readLine();

while (str != null) {

// 去掉一些注释，和一些没用的字符

if (!str.startsWith("#") && !str.startsWith("/*"