Exercises

1:

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?



Sams Teach Yourself BEA WebLogic Server 7. 0 in 21 Days
Sams Teach Yourself BEA WebLogic Server 7.0 in 21 Days
ISBN: 0672324334
EAN: 2147483647
Year: 2002
Pages: 339

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net