1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
sql="insert into USER.TABLE_NAME(CHAMPS1,CHAMPS2,CHAMPS3,CHAMPS4) values (?,?,?,?)";
statement = cn.prepareStatement(sql);
ArrayList cellsContent=(ArrayList)xls[0];
for(int j=0;j<cellsContent.size();j++)
{ /*if(j!=7 && j!=8 && j!=9 && j!=11)
sql+=(standard + "('" + String.valueOf(((ArrayList)(xls[0])).get(j)) + "' , '" + ((ArrayList)(xls[1])).get(j) + "' , '" + ((ArrayList)(xls[2])).get(j)+"' , '" + String.valueOf(((ArrayList)(xls[3])).get(j))+"')");*/
//sql+=standard + " ('"+((ArrayList)(xls[0])).get(j)+"','"+((ArrayList)(xls[2])).get(j)+"','"+((ArrayList)(xls[0])).get(j)+"','"+((ArrayList)(xls[0])).get(j)+"')";
statement.setString(1,String.valueOf(((ArrayList)(xls[0])).get(j))); //'"+((ArrayList)(xls[0])).get(j)+"','"+((ArrayList)(xls[2])).get(j)+"','"+((ArrayList)(xls[0])).get(j)+"','"+((ArrayList)(xls[0])).get(j)+"')
statement.setString(2,String.valueOf(((ArrayList)(xls[1])).get(j)));
statement.setString(3,String.valueOf(((ArrayList)(xls[2])).get(j)));
statement.setString(4,String.valueOf(((ArrayList)(xls[3])).get(j)));
// get the resultset
statement.executeQuery();
} |
Partager