devxlogo

September 5, 2007

Execute a SQL Statement with Variable Parameters

When you need to execute the same SQL statement (in general an UPDATE) multiple times with different parameter values you can use the PrepareStatement method like this: Connection conn=null;PreparedStatement pst=null;String[]

It All Adds Up

while ago I responded to a newsgroup post in which the poster had a table of inventory changes containing start and end dates, as well as the amount that was