From the example called ProcessTransaction.jsp that you developed today, write a program that uses the RowSet class to retrieve the information from a transaction_details table. Close the database connection after retrieving the ResultSet data and use the RowSet class to access the data.
2:
Write a program extending exercise 1 that uses the batch update feature of JDBC. Insert dummy data into the transaction_details table for this. Do this using the Statement and PreparedStatement objects. How would you do this for a Callable statement object? Now extend the same example to execute a Select statement and select all the data that you just inserted. What is the result? Why?