Once you use the apache project's fileupload class you can just use a simple filereader to read through the file record by record and use the split(String regex) method from the String class to split the data into a string array. Then loop through array and write the sql statements to update your database.
On 5/23/06, Juan Jose Garcia Lau <[EMAIL PROTECTED]> wrote:
If you want to upload files, take a look at http://jakarta.apache.org/commons/fileupload/ Cheers, Juan -----Original Message----- From: Christopher Molnar [mailto:[EMAIL PROTECTED] Sent: Martes, 23 de Mayo de 2006 10:17 a.m. To: Tomcat Users List Subject: Question on csv import using browser into MySQL database Hello, I need to ask a question from any of the java experts out there. Can anyone suggest or share a code segment that allows a web user to upload a csv file and then parse it on the server end with the end goal of it going into a mysql table? I have searched everything I can think to search but can't find anything. Thanks, -Chris --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This message contains information from Banco Cuscatlan Guatemala, which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please disregard it. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- Marc Farrow