Question #1157
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
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
Expert's answer
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.
