piątek, 19 lutego 2016

Upload CSV file to Web application Server and Database

Here are usefull sites that I have found that describe how to
load CSV file into table in database.


http://www.tutorialspoint.com/jsp/jsp_file_uploading.htm :
This simple turorial describes how to load file into application server.



https://sourceforge.net/p/opencsv/source/ci/master/tree/examples/

This is library that makes reading CSV file easy. U can easily load your data file
into memory as data structure that is easy to handle.


https://dzone.com/articles/fully-dynamic-classes-with-asm

Here is example how to use Struts 2 to load CSV file into table.

Honestly it looks difficult to me, but it have additional options that helps you handle this process without unexpected errors.

http://examples.javacodegeeks.com/enterprise-java/spring/mvc/spring-mvc-file-upload-example/













Here is standard model to do task of loading CSV file into table or server first.


If you have very old technology like Struts 1.2 and you want to pass file in jsp
into Application form you must be aware of special tags that Struts 1.2 uses:

http://people.apache.org/~germuska/struts-taglib/docs/tlddoc/html/tld-summary.html