0

Hi, i'm working on migrating csv data into MySQL using jsp.

I would like to know if the sql statement shown below can be used in jsp and where i can get examples on the codes.

String sql3 = "LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE test FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'";

Please do help. Thank u =)

3
Contributors
7
Replies
8
Views
6 Years
Discussion Span
Last Post by peter_budo
0

hi. Thank you but i have yet to solve my issue.i appreciate your help.Thanks again.

-1

Hi, yes i did read it.As my project require me to use jsp i don't have much choice.i try using HSSF to import excel to MySQL. I'm still trying to figure it out.

0

I do not believe you are limited to only JSP. You just do not want to say truth that you do not know how to approach this problem, like for start using servlet instead of butchering JSP

0

Yes, it is clear that i do not know how to tackle the issue as i'm new to the web languages. I'm still learning.

0

It is nice that you trying things on your own but in this case you better learn walking before you try to run. Get some good book like Head First Servlets & JSP which gives you good staring point and then try to tackle this sort of problem

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.