Java and programmatically importing a csv into an SQLite3 table
In Java how do I programmatic开发者_StackOverflow中文版ally import a csv
text file into a table of an SQLite3
database? Can this even be done with SQLite3
's .import
, for example IMPORT myFile myTable
?
I guess you cannot execute the 'import' statement through JDBC, what you can do is to either use command line through Runtime.exec or just parse a .csv file within your application, create your sql commands dynamically for each csv line and execute them with JDBC execute().
精彩评论