DO YOU KNOW ABOUT JDBC?
Java JDBC is a java API to connect and perform question with the database. JDBC API uses jdbc motorists to talk with the database.
What is JDBC? JDBC appears for Java Database Connection, which is a standard Java API for database-independent connection between the Java development language and a variety of databases.
JDBC
The JDBC collection includes APIs for the duties mentioned below that are affliated with details resource utilization.
1. Making an organization to a details resource. 2. Creating SQL or MySQL claims. 3. Performing SQL or MySQL concerns in the database. 4. Watching & Changing the causing records.
Fundamentally,
JDBC is a requirements that provides a complete set of connections that allows for convenient option a details resource. Java can be used to write various types of executables, such as
Java Applications
Java Applets
Java Servlets
Java ServerPages (JSPs)
Business JavaBeans (EJBs).
All
of these different executables are able to use a JDBC motorists to accessibility a databases, and take advantage of the saved details.
JDBC
gives the same capabilities as ODBC, enabling Java programs to contain database-independent code.
PRE-REQUISITE Before
going further, you need to have a good knowledge of the following two topics −
Primary JAVA Programming SQL or MySQL Database
JDBC Architecture The JDBC API allows both two-tier and three-tier managing models for details resource accessibility but in general, JDBC Framework comprises of two levels −
JDBC API: This provides the application-to-JDBC Administrator connection.
JDBC Car owner API: This allows the JDBC Manager-to-Driver Connection.
COMMON JDBC COMPONENTS The JDBC API provides the following connections and sessions − DriverManager Driver Connection Statement ResultSet SQLException
COMMON JDBC COMPONENTS
THE JDBC 4.0 PACKAGES The
Java.sql and javax.sql are the main provides for JDBC 4.0. This is the latest JDBC version at the time of writing this guide. It provides the main programs of training for getting your web resources.
The
new features in these provides include of changes in the following areas −
Automatic details resource car owner running. Exception managing developments. Enhanced BLOB/CLOB performance. Connection and announcement interface developments. National character set support. SQL ROWID access. SQL 2003 XML details type support. Annotations.
You
can Learn JDBC and know more about Java Database by going through our Java Database tutorial.
THE JDBC 4.0 PACKAGES
THANKYOU