Advanced JDBC Techniques for Java Programmers training

JDBC Training Outline

• Re-Introducing JDBC
• Review of JDBC architecture
• Review of JDBC driver types
• Discussion of evolution of JDBC from version 1.0 through 2.0 and 3.0
• Database concepts review
• Relational database terminology
• SELECT, INSERT, UPDATE, and DELETE statements
• Transactions, logging, isolation, and concurrency
• Key JDBC classes and the java.sql package
• DriverManager and DataSource
• Connection
• Statement, PreparedStatement, and CallableStatement
• ResultSet
• Extra features supported by the javax.sql package
• Rowsets
• Application development activities using the basic JDBC concepts
• Building an interface for selecting records
• Building a data-drilldown example
• Building interfaces for inserting, updating, and deleting records
• Connecting to databases
• Selecting and installing a database driver
• Connecting to the database via a network address
• Connecting to the database based on information supplied by JNDI (the Java Naming and Directory Interface)
• Using the java.sql.DataSource class
• Increasing performance with connection pooling
• Opening and closing the connection
• Handling ClassNotFoundException and SQLException
• Working with a database connection
• Controlling transaction behavior
• Using getWarning and clearWarnings to retrieve, respond to, and clear warnings
• Creating statements, prepared statements, and callable statements
• Retrieving and using database metadata
• Ad-Hoc SQL queries with Statement and PreparedStatement
• Creating a Statement object
• Executing a SQL statement
• Using executeQuery() for statements that return a ResultSet
• Using executeUpdate() for statements that change the database and don't return a ResultSet
• Receiving a ResultSet as the result of a query
• Iterating through and retrieving results
• Moving the cursor within the ResultSet
• Establishing when you are at the beginning or end of the ResultSet
• Creating a PreparedStatement object
• Setting PreparedStatement parameters
• Executing the PreparedStatement
• Additional techniques for working with ResultSets
• Navigating the cursor forward, backward, and arbitrarily within a ResultSet
• Using updateable ResultSets
• Batch updating of ResultSets
• More in-depth
• Obtaining ResultSetMetaData
• What you can/can't find out via ResultSetMetaData
• Obtaining column data types, names, labels, and display sizes
• Obtaining the column count
• Additional useful applications for the ResultSetMetaData
• JDBC transactions
• Understanding ACID (atomicity, consistency, isolation, and durability)
• Turning the committing of transactions on or off
• Committing and rolling back transactions
• Overview of distributed transactions in Java EE
• JDBC design patterns
• Overview of client tier, presentation tier, business tier, and resource tier patterns
• The data access object pattern
• The value object pattern
• The model-view-controller pattern
• Conclusion