Call: 080-42177765

 

JDBC

Print

Overview

Advanced JDBC Techniques for Java Programmers teaches intermediate-level Java developers the JDBC skills they need to build powerful, database-driven applications.

Objectives

  • To teach attendees how to build beginning through advanced database-driven applications using Java and JDBC

JDBC Training Outline

  • Introduction
  • Relational Database and JDBC Overview
    • Overview, Table Relationships, Web Based Data Access, JDBC Characteristics
  • JDBC
    • JDBC architecture
    • JDBC driver types
    • Discussion of evolution of JDBC from version 1.0 through 2.0 and 4.0
  • JDBC API Overview
    • DriverManager, JDBC Drivers
    • Naming databases with JDBC URLs
  • Connecting to a database
    • Connection interface, Establishing a connection
  • 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
  • Other feactures
    • DataSource
      • Java EE and DataSource, Using JNDI
    • Connection Pooling
      • Overview, Usage, Advantages
  • JDBC design patterns
    • Overview of client tier, presentation tier, business tier, and resource tier patterns
    • The data access object pattern
    • The value object pattern

Questions?  Request a call back

upcoming training

Java Developer Required 3-5 years of experience on SpringMVC Framework and WebServices
Two-Days Workshop On SpringMVC FrameWork On This Week-Ends: - 12/08/2017 and 13/08/2017
.  

Staffing Solutions

In a dynamically changing world, extracting the most out of your IT Systems requires capable and experienced IT Professionals. To read more on how i-Noesis can make a difference to your business.  

Read more...

Our Clients

IT Services

IT Consulting

We cover a complete variety of IT Consulting Services, be it web design and development, offshore software development solutions, Staff Outsourcing

Read more

Application Development

The software that suits your specific business needs simply isn’t available on the market.

Read more

Academic/IEEE Projects Development

i-Noesis Solutions offers wide range of academic Final Year IT Projects in all technologies of Computer Science for M.Tech, B.Tech/B.E and MCA. 

Read more

Login