i have a program to read the content of an excel file to my-sql db. i have 40 columns in excel and i created a table of 40 fields. and i want to import the data from excel into corresponding table filed.
My doubt is, is there any better way to write preparedStatement than the following;
con.prepareStatement("insert into insurance.bank_stmnt_ds values(?,?,?,...,?(40 times))");