Answer to Question #1157 in Java | JSP | JSF for arora

Question

I need to create some java code with JDBC that will load data into corresponding SQL Tables i have this code but im not sure it will actually work

public void importData(Connection conn,String lastname_wd.csv,)
{ Statement stmt; String query; String query2;
try {stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
query = "LOAD DATA INFILE '"+lastname_wd.csv+
"' INTO TABLE well_data (DwellLoc, etc); then excute query

Answer 1

We need to know what errors occur while compiling the program. Submit your code and requirements to the program as an assignment to the control panel and our experts will assist you.