for (string[] array : checkstore1) { (string element : array) { string sql5 = "update product set " + "pro_store = '" + element + "'" + "," + "where pro_id = '" + array + "'"; stmt.executeupdate(sql5); } }
any suggestions on how correct code helpful, thanks!
"where pro_id = '" + array + "'";
you should check if want use array
here.you sql where pro_id = '[ljava.lang.string;@72ffb'
i think should change array string value.
Comments
Post a Comment