Introduction to JDBC

- JDBC API is a Java API that can access any kind of tabular data.

- Especially data stored in a Relational Database

- JDBC works with Java on a variety of platforms. such as :
    1) Windows,
    2) Mac OS, and
    3) various versions of UNIX

- JDBC stands for Java Database Connectivity.

- Which is a standard Java API for database-independent connectivity.

- Between the Java programming language and a wide range of databases.


- The JDBC library includes APIs for each of the tasks commonly associated with database usage:
    1) Making a connection to a database,
    2) Creating SQL or MySQL statements,
    3) Executing that SQL or MySQL queries in the database,
    4) Viewing & Modifying the resulting records


- JDBC is a specification that provides a complete set of interfaces.

- that allows for portable access to an underlying database.

- Java can be used to write different types of executables, such as:
    1) Java Applications,
    2) Java Applets,
    3) Java Servlets,
    4) Java ServerPages (JSPs),
    5) Enterprise JavaBeans (EJBs)


- All of these different executables are able to use a JDBC driver.

- JDBC driver used to access a database.

- And take advantage of the stored data.

- JDBC provides the same capabilities as ODBC.

- Allowing Java programs to contain database-independent code.