Get current working directory

2. JDBC Flow

JDBC helps you to write Java applications that manage these three programming activities:

1. 
   Connect to a data source, like a database
   
2. 
   Send queries and update statements to the database
   
3. 
   Retrieve and process the results received from the database in answer to your query
   

3. JDBC API

The JDBC API is comprised of two packages:

• 
  java.sql
  
• 
  javax.sql
  

We automatically get both packages when you download the Java Platform Standard Edition (Java SE) 8.
JDBC API consists of two parts – the first part is the JDBC API to be used by the application programmers. The second part is the low-level API to connect to a database server(JDBC Driver).

1. 
   The first part of JDBC API is part of standard java packages in java.sql package. We use java.sql package API for accessing and processing data stored in a data source (usually a relational database) using the Java programming language.
   
2. 
   For the second part is the JDBC driver(there are four different types of JDBC drivers) A JDBC driver is a set of Java classes that implement the JDBC interfaces, targeting a specific database. The JDBC interfaces come with standard Java, but the implementation of these interfaces is specific to the database you need to connect to. Such an implementation is called a JDBC driver.
   

Key Classes and Interfaces

• 
  JDBC Connection Interface
  

• 
  JDBC Statement Interface
  

• 
  JDBC PreparedStatement Interface
  

• 
  JDBC CallableStatement Interface
  

• 
  JDBC ResultSet Interface with Examples
  

• 
  JDBC ResultSetMetaData Interface
  

• 
  JDBC DatabaseMetaData Interface
  

•