O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

View Transaction Log

The transaction log contains records for each ticket that has been purchased. The transaction log can be displayed if you want to see what purchases were made at the theater or if you need to refund a ticket (see Figure 11-18).

Figure 11-18. Transaction log

The routine that populates this screen with data is called pShowTransactions(). This method retrieves all of the purchase transactions and displays them in a table on the screen.

 ResultSet rs = s.executeQuery( "SELECT * FROM TRANSACTIONS WHERE TX_TYPE = 'PURCHASE'"); while (rs.next()) { String txNo = rs.getString("TX_NO"); String txType = rs.getString("TX_TYPE"); String ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required