|
programming & internet technologies
Java Database Access Using JDBC
Java has become the language of choice for many enterprise application
developers. Because Sun Microsystems recognizes the importance of data access
and manipulation to business applications, they developed the Java Database
Connectivity (JDBC) API to allow for secure, robust, and portable
enterprise-level data access. Similar to Microsoft's Open Database Connectivity
(ODBC), JDBC is an open API that enables cross-vendor data access. However, JDBC
is much more Object-Oriented in nature, as it was developed specifically for use
with Java. The new JDBC 3.0 contains powerful enhancements over the previous
versions of the API. For instance, it allows developers to access data from flat
files, as well as from databases. In addition, version 3.0 introduces robust
mechanisms for doing batch updates, creating transaction savepoints, and
implementing distributed transactions.
This 3-day hands-on class will introduce developers to all these topics, as
well as addressing more advanced topics, such as transactional programming and
performance, JavaBeans, and design patterns. The class includes many hands-on
exercises, and students will come away with the ability to successfully access,
update, and manipulate data in both client- and server-side Java applications.
Furthermore, they will have learned the information necessary to making
important design decisions concerning performance trade-offs.
Who Should Attend
The workshop material is aimed at developers who will be writing data-centric
applications using the Java Platform.
Prerequisites
Students should have strong Java programming experience and should be
familiar with the basics of relational databases and SQL.
Workshop
Objectives:
- Connect to databases and execute SQL commands.
- Manipulate data result sets.
- Map Java data types to their JDBC counterparts and vice versa.
- Use transactions to support business logic.
- Discover database objects and their properties at runtime using database
metadata.
- Improve applications with common design patterns.
- Optimize data access performance.
- Interact with Enterprise JavaBeans (EJBs).
To request a comprehensive
curriculum outline click... HERE.
Last updated on
April 30, 2008
|