These are some snippets of code that explains what I'm talking about:
(Prepared Statement)
AddACategory2 = connection.prepareStatement("INSERT INTO TABLE tbl_CategoryOptions (SKU, Category, Size, Color) VALUES (?), (?), (?), (?)");
(Method using Prep Statement)
private void AddCategory(int a, ArrayList b)
{
try{
AddACategory1.setInt(1, a);
AddACategory2.setInt(1, ???);
}
catch(SQLException se){ se.printStackTrace();}
}
I'm pulling in an Int and 3 Strings sequentially from ArrayList b and I need to place them into AddACategory2.....