SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Understanding JDBC: The Standard Java Interface for Database Connectivity

donkor avatar
donkor
9 diapositives · 221 Views · Oct 04, 2014

JDBC, or Java Database Connectivity, is a standard interface that allows Java applications to connect to relational databases. Defined by Sun Microsystems, JDBC enables developers to implement database drivers while complying with SQL standards. Key features include ease of programming, scrollable and updateable result sets, and performance enhancements through batch updates. With JDBC's API, developers can connect to databases, execute SQL queries, and process results efficiently. Understanding JDBC drivers and classes is essential for leveraging the full potential of database interactions in Java applications.

Understanding JDBC: The Standard Java Interface for Database Connectivity - slide 1
01 / 9Understanding JDBC: The Standard Java Interface for Database Connectivity
1 / 17

Télécharger la présentation

Understanding JDBC: The Standard Java Interface for Database Connectivity
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. JDBC Introduction Section 1

  2. What is JDBC • JDBC (Java Database Connectivity) is a standard Java interface for connecting to relational databases from Java. • The JDBC standard was defined by Sun Microsystems, allowing individual providers to implement and extend the standard with their own JDBC drivers. • JDBC is based on the X/Open SQL Call Level Interface, and complies with the SQL92 Entry Level standard.

  3. JDBC Technology Core Features • Ease of programming - Scrollable result set ability to move a result set's cursor to a specific row. This feature is used by GUI tools and for programmatic updating. • Updateable result set ability to use Java programming language commands rather than SQL.

  4. New data types support performance improvement (ability to manipulate large objects such as BLOB and CLOB without bringing them to the client from the DB server). • Batch updates performance improvement (sending multiple updates to the DB for processing as a batch can be much more efficient than sending update statements separately).

  5. JDBC API • The JDBC API is a Java API for accessing virtually any kind of tabular data. • The JDBC API consists of a series of abstract Java interface to address standard database query requirements: connecting to a particular databases, executing SQL statements, and processing the results of the queries.

  6. JDBC Driver • To use the JDBC API with a particular database management system, you need a JDBC technology-based driver to mediate between JDBC technology and the database.

  7. What Does JDBC Driver do? A JDBC technology-based driver ("JDBC driver") makes it possible to do three things: • Establish a connection with a data source • Send queries and update statements to the data source • Process the results

  8. Primary JDBC Classes • JDBC consists of an object hierarchy, starting with the DriverManager class. • From the DriverManager class, you get Connection objects that point to the particular database. • From the Connection class, you get Statement objects that act as containers for a particular SQL statement execution. • As part of executing a statement, you may get a ResultSet object that describes that results set you got back from a particular SQL SELECT.

  9. JDBC Class Relationships Driver Manager Connection Object Connection Object Connection Object Statement Object Statement Object Statement Object Statement Object ResultSet Object ResultSet Object ResultSet Object