LearningPatterns: Your Global Source for Java Training, Mentoring, and Consulting
Home | About LearningPatterns | Our Services | Contact Us | Printer Friendly Link

Courseware for License:

JDBC - Java Database Connectivity

Course ID: JDBC

JDBC is a Java technology for accessing SQL databases.  It is a core part of J2EE, and it works with every major database product.  This hands-on course covers all the details that you will need to use JDBC to access the information in your databases using Java.  It also talks about real world issues in using JDBC.

All labs can be done with the Eclipse IDE or a simple editor, and the lab instructions include detailed directions on both environments.

Course Information

Duration: 1 day

Hands-on: 50% hands-on, 50% lecture

Supported Platforms:

Skills Gained:

Course Details:

Introduction

  • Relational Database and JDBC Overview
    • Overview, Table Relationships, Web Based Data Access, JDBC Characteristics
  • JDBC Architecture, JDBC API Overview
    • DriverManager, JDBC Drivers
    • Naming databases with JDBC URLs
  • Connecting to a database
    • Connection interface, Establishing a connection
  • DataBaseMetaData
  • Handling Database Exceptions

Data Access

  • DAO – Data Access Objects, O-R Mapping, Value Objects
  • Processing Database Data
    • Executing statements, precompiled statements and stored procedures
    • Processing ResultSets,
    • Dealing with Null data
    • Updating, inserting, retrieving data
    • Controlling Transactions
  • JDBC Driver Types
  • DataSource
    • J2EE and DataSource
    • Using JNDI
  • Connection Pooling
    • Overview, Usage, Advantages, Statement Pooling

 

Advanced Topics

  • Other Database Access Technologies
    • SQLJ, O-R Mapping Tools, JDO (Java Data Objects), EJB Entity Beans
  • Advanced JDBC Features
    • Batch Updates, Srollable Result Sets, Rowsets, User Defined Types, BLOBS, CLOB
LearningPatterns Inc. | http://www.LearningPatterns.com | tel:212.487.9064 | e-mail:
Copyright © 2009 LearningPatterns Inc. All rights reserved. LearningPatterns is a trademark of LearningPatterns Inc. Java, and all Java-based trademarks are registered trademarks of Sun Microsystems in the U.S. and other countries. JBoss is a registered trademark of Red Hat, Inc. in the U.S. and other countries. IBM and Rational are registered trademarks of IBM Corp. in the U.S. and other countries. All other products and company names mentioned here may be trademarks of their respective owners.