home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Database application programming with JDBC

Intended for

Application developers, technical analysts and database administrators who are involved in the development of Java applications that access relational databases.

Background

The participants should have experience (at least 3 months) with Java programming (see course Java programming) and be familiar with at least basic SQL (see course SQL fundamentals).

Training method

Lecture and hands-on exercises. The participants will work with Java applications accessing IBM DB2, Oracle, MySQL or other relational databases.

Course leader

Sandy Schillebeeckx, Guido Indesteege.

Duration

1 day.

Schedule

datelanguageplacepriceremarks
27/02/2012 Leuven470 EUR
11/05/2012NWoerden470 EUR
14/06/2012ELeuven470 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

Nowadays, Java is a well-accepted programming language within enterprises. Therefore, it is needed to access existing or new relational databases from these Java applications. Although most application developers make their programs in an IDE (Integrated Development Environment), having a basic knowledge on how databases are accessed from Java code is a must. This course provides the foundations on how data can be stored into and retrieved from relational databases using JDBC (Java Data Base Connectivity).

Main topics

  • Overview of JDBC:
  • JDBC vs ODBC • different types of JDBC drivers • two-tier vs. three-tier vs. n-tier
  • Using JDBC: the basics
  • Connecting to the database
  • Preparing and executing SQL select statements
  • Processing the result: handling multiple rows • exception handling
  • parameterized queries
  • Non-select statements
  • More JDBC:
  • Scrollable result sets • rowsets
  • Advanced topics: transactions • locking • JNDI
  • Metadata
  • Calling stored procedures
  • Java persistence frameworks
  • Object relational mapping
  • Persistence mechanisms