java导入mysql数据库包,通过Java以编程方式导入（mysql）数据库转储

最新推荐文章于 2023-06-04 17:52:45 发布

历史阿牛

最新推荐文章于 2023-06-04 17:52:45 发布

阅读量240

点赞数

文章标签： java导入mysql数据库包

该博客探讨了如何通过Java程序来导入包含INSERT和CREATE TABLE语句的MySQL数据库dump文件。作者引用了在Rails中使用fixtures填充测试数据库的经验，并寻求在Java中类似的方法。解决方案建议使用Runtime类启动一个新进程，执行mysql命令行工具来导入dump.sql文件。

摘要由CSDN通过智能技术生成

How can I import a mysql database dump file (contains insert and create table statements) programmatically through a java program. I need this as the setup phase of a unit test.

Unfortunately this doesn't work:

Connection conn = dbConnectionSource.getConnection();

Statement stmt = conn.createStatement();

stmt.execute(FileUtils.readFileToString(new File("./some-sql-file")));

conn.close();

Thanks,

-A

PS - In Rails, I used fixtures for filling a test database. I made rails rails create the underlying tables through setting the environment to test, anything similar in Java.

解决方案

You could start a new process from java and execute this command if you have access to the mysql executable wherever you are running the import. Something like this:

Runtime rt = Runtime.getRuntime();

Process pr = rt.exec("mysql -p -h ServerName DbName < dump.sql");