Import csv file to populate data in a table in Netbeans

Question

I am very new to Java and Netbeans.I am trying to populate my table created in my database with data but the csv file contains about 1000 odd entries.Is there a way in which i can just import the data to their columns.

Any help would be appreciated.

To start with, use OpenCSV to parse your data. After that, it depends on your database and what software package you intend to use to write into it — fge, Apr 08 '14 at 22:44

score 0 · Accepted Answer · edited May 23 '17 at 10:30

I am assuming that you are using JavaDB that comes bundled with Netbeans (to be more accurate: it's included with the JDK).

You can use the import table command: SYSCS_UTIL.SYSCS_IMPORT_TABLE.
Check: https://db.apache.org/derby/docs/10.1/ref/rrefimportproc.html.

As an example:

go here: http://www.andrewpatton.com/countrylist.html and download Country List downloadable as CSV.
create a table which you can name COUNTRY and as columns the names in the first line of the downloaded csv file. First column name: SortOrder should be the primary key. Add the rest columns as VarChar columns with size 100. Do the same for the rest but be careful not to mess with the order of the columns as you cannot change it later. What I mean is that the order of the columns that you create in your table, should follow the order of the columns in the csv file. For example "Sort Order" should be created first, then create,"Common Name", then "Formal Name" ....

add columns

then remove the first line from the csv file (the column names)
execute the following command CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'COUNTRY','c:\countrylist.csv',',','"',null,0);
select the table that you created , right click it and click View data.

Thats it !

If you are using MySQL check:

Thanks for the reply...but when i try to execute the command i am getting an error "PROCEDURE syscs_util.SYSCS_IMPORT_TABLE does not exist" — user3330378, Apr 09 '14 at 23:43
How do you execute the command? I do it like: right click on the COUNTRY table of JavaDB and click "Execute Command..." — zlinks, Apr 10 '14 at 08:58
I am using netbeans 8 and JDk 1.8.0 and i executed the command in the same manner as you did. — user3330378, Apr 10 '14 at 15:30

Import csv file to populate data in a table in Netbeans

1 Answers1