but as I need some field extra in history_grocery and some missing from grocery
it this case what i should do???
some values are come using ajax and js in view(jsp page)like quantity and total_amount....
Joined: Feb 22, 2011
you can actually pass all the values which are coming from view to the SQL statement. If you need to select one field from another table and other 10 values coming from view then your SELECT part of INSERT statement would look like SELECT ?,?,?........., col1, col2 FROM table where ....
You would set the values which you retrieved from the view using statement.set... methods.
subject: how can we use where clause with insert query using preparedStatement?