JDBC Technology Code Samples

Print-friendly Version

JDBC Technology is an API that lets you invoke SQL commands to create database tables, access the data stored in a table, and create and manage distributed transaction. The J2SE 1.4 and all versions of the J2EE platforms provide these APIs. Prior to J2SE 1.4, you have to download the javax.sql package for distributed transactions separately.

• BatchUpdate.java updates the database with a list of items using the PreparedStatement and CallableStatement classes. For supporting information see The Java Tutorial: JDBC Basics
  
  
• CreateCoffees.java creates a table named COFFEES with 5 fields. For supporting information see The Java Tutorial: JDBC Basics
  
  
• DukeBakery.java creates the GUI and sets up a database connection and information storage and retrieval for a bakery application written with the Java 2 platform APIs. For supporting information see Duke's Bakery - A JDBC Order Entry Prototype - Part 1: JDBC Basics
  
  
• enchilada.jar contains all the files for the Duke's Bakery example application prototyped in DukeBakery.java. Shift-click to download. For supporting information see Duke's Bakery, Part II - A JDBC Order Entry Prototype - Continued
  
  
• MetaTest.java connects to a database and displays information about the database and driver used to make the connection. For supporting information see New to Java Programming Supplement, June 2002.
  
  
• OutputApplet.java is an applet version of the coffee application. For supporting information see The Java Tutorial: JDBC Basics
  
  
• TransactionPairs.java shows how to back out a transaction that posts to two different columns in the same table. For supporting information see The Java Tutorial: JDBC Basics