2.1 Introduction to JDBC

2.1 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.