5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8
View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS
Closed-Captioning and English subtitles available.
In this video tutorial, we will present an overview of Java JDBC. We discuss the following topics:
- What is JDBC?
- Database Support
- Architecture and API
- Development Process
Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week.
Questions or problems? Post them in the comments section below.
Want to suggest a video? Leave a comment below. I'm always looking for new video ideas.
Let me know what video you'd like for me to create.
Time - 00:00
In this video, I will provide an overview of Java JDBC. We will cover the following topics. What is JDBC? We'll also discuss the features of JDBC in terms of SQL statements. Then we'll see the databases that are supported. Next, we will cover the architecture and API of JDBC. Finally, we will walk through the development process for executing a simple query.
Time - 00:32
JDBC allows a Java application to connect to a relational database. The major databases are supported such as Oracle, Microsoft SQL Server, DB2 and many others. The database can be located on the same local machine as in the application. It can also be located in a network in a remote location. The database can also be deplored in the Cloud. No worries, JDBC can still give you to a connection to the database regardless of the location.
Time - 01:08
The main feature of JDBC is that it is a standard API. You develop your application code to the JDBC API and you can connected to various databases. There's no need to develop code for different databases. That's the main advantage of JDBC. JDBC is a call level interface that supports ANSI SQL 2003. When you provide SQL statements to the JDBC driver, it simply passes the SQL to the database. You can make use of SQL to perform select, insert, update and delete.
Time - 01:43
You can also build complex SQL series queries with inner and outer joins. You can also make calls to store procedures on the database. As you can see, JDBC does not place any limitations on your SQL development. You are free to leverage ANSI SQL 2003 to meet your application requirements.
Time - 02:04
Here's a nice graphic of the databases that are supported by JDBC. As you can see, there's support for Oracle, My SQL, Informix, DB2, SQL Server, Sybase, PostgreS and many others. Note, this is not an exhaustive list. You can simply visit the URL here to see a complete list of databases.
Time - 02:26
The JDBC architecture includes a key component which is the JDBC driver. The JDBC driver provides the critical link between your Java application and the database. The driver converts the standard JDBC API calls to low level calls for your specific database. There are multiple JDBC driver implementations. Your database vendor normally provides the JDBC driver. Simply visit the database vendor's website and search for the words JDBC driver. The vendors will provide the link to download the driver along with supporting documentation on how to connect to the database.
Time - 03:06
Another key player is the driver manager. The driver manager helps connect and app to the database based on a database connection stream. The current version of JDBC is version 4.0. with this latest version, the driver manager will automatically load JDBC drivers that are in the application's classpath. No additional work is required by the developer.
Time - 03:36
Most JDBC drivers are now JDBC 4.0 compliant. However, there are Legacy JDBC 3.0 drivers that have to be specifically loaded with Java code. That Java code is class.forname and the actual driver name. The JDBC API is defined in two packages. java.sql and javax.sql. The key classes in the API are driver manager, connection, statement, results set and data source.
Time - 04:16
Great. We've covered a lot of the theory, a lot of the key concepts and classes. Now, let's walk through an actual development process for a simple query. The process is, step one, we'll get a connection to a database. Then in step two, we'll actually create a statement object. Then step three, we'll execute a SQL query. Then finally in step four, we'll process the results set.
click the Transcript tab for complete transcript.