Hello everyone I need some help with a sql statement I have a arrayList with 30 words inside it. I then want to get the first 10 words from that arraylist, and Insert them into a column name called FIRSTNAME. then i want to get the next 10 elements (10 to 20), and put them in a column name called LastNames. Then i want to do the same with the last 10 words from the arraylist, and put them in a column name called MiddleName. Is it possible to do this with one preparedStatement? thanks ben
U first collect your Name, Middle Name and Last Name in 3 string variables by running a for loop. Then use preparedStatement according to the JDBC syntax and in prepareStatement pass these strings as input parameters.
Previous Topic
