import org.apache.tools.ant.Project;
import org.apache.tools.ant.taskdefs.SQLExec;
String linkStr = "jdbc:"+dbaddress+":3306/"+dbname+"?useUnicode=true&characterEncoding=UTF-8";
SQLExec sqlExec = new SQLExec();
sqlExec.setEncoding("UTF-8");
sqlExec.setDriver("com.mysql.jdbc.Driver");
sqlExec.setUrl(linkStr);
sqlExec.setUserid(dbusername);
sqlExec.setPassword(dbpassword);
sqlExec.setSrc(new File(sqlPath)); //sqlPath = SQL文件的路径
sqlExec.setProject(new Project());
sqlExec.execute();
注意:使用此方法进行sql导入实现时,需要将sqlPath指定的SQL文件中的注释全部去掉,否则导入时会报错。