且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从hibernate + spring应用程序将csv文件导入到mysql中?

更新时间:2022-05-27 22:05:09

以完全回答你的问题,但Hibernate的本地查询工具可以让你加载一个文件。

Not sure I have enough information to fully answer your question, but Hibernate's Native Query facilities might let you load a file that way.

session.createSQLQuery("LOAD DATA INFILE :filename INTO TABLE testtable (text,price)").setString("filename", "/path/to/MyFile.csv").executeUpdate();