Java JDBC Tutorial - Part 0: Overview

---

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?
- Features
- Database Support
- Architecture and API
- Development Process

----

Follow luv2code:

---

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.

---

Video Transcript
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

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.

[snip]

click the Transcript tab for complete transcript.

[cyrusrezai]

This is the best JDBC tutorial that I have ever seen, and I've been developing Java and J2EE for years. Absolutely the best.

[alelignfaris]

The best video about JDBC, it makes clear my years of confusion about JDBC. Thanks a lot

[WLockIV]

This is definitely better than any tutorial teaching people how to make quick Java DB GUIs in NetBeans. Thank you sir.

[abhikpatra]

After watching this tutorial on JDBC ... I decided to buy your Spring course from Udemy... Thanks a lot for putting so much effort to make these amazing tutorials for people like us.

[jesselopez]

These are the best tutorials I have seen!!! Thank you!

[aniljotwani]

Hi, not only I loved the way you covered JDBC overview, but also with the clarity of audio.  It really makes very clear understanding.  I am 52 years old and had pretty good knowledge of programming a decade ago, however, things have changed from top down to OOP.  Trying to make up own Travel Portal on BnB concept for tourist place in India and till last 10 days or so have been able to connect db to Dynamin Web App, have been able to make Servlet to make simple login and registration form and now learning how to handle images.  Thank you for the good quality teaching. Will watch all the videos you uploaded. Thanks once again, and if I get stuck will fall back to you for help. Regards

[shahriarhossain]

Thank you so much for these videos. The way you describe is so much easy to understand.Your videos are really helping me building my career.

[Vinicide]

Very high quality video. Please continue to make more! I luv2code too :D Liked/subbed!

[vaibhavshukla]

The amount of information covered in this 11-minute video is HUGE

[mizech]

You're stuff is awesome and you have got a very enjoyable voice. Gonna recommend your channel to other Java-learners at any opportunity.

[auggiewilliams]

i rally appreciate the effort made to create this video

[TheMoan]

You are a great teacher. I love to see your video. It is very details and clear. Thank you so much!

[pradip]

Hello Chad, This is best JDBC tutorial I ever seen!!! Thanks a lot.

[luislourenco]

Awesome to have this kind of content available. Thank you.

[SilveraStarbreeze]

Subscribed. Exactly what I was looking for! :D Keep up the good work! :D

[mrginn]

Thank you! I'm trying to learn something useful after completing core Java. This seems like a good starting point!

[violetanderson]

Thank you so much for this video. It is very clear and concise. You are an excellent teacher.

[md.hossain]

this is a very very well organized lesson. thank you very very much.

[venkatasailendra]

Thank you so much sir. I am new to java but videos like these made it easy for me.Thank you once again

[LalitKumarKitchenRecipies]

Hei, I come to this video series from your Oracle JDBC tutorial when I saw there is no more videos for Oracle database. As I can see there is no such changes in codes rather than connection format. So I am just asking do I need to follow your all MSQL video series or should I skip any because I am using Oracle database. Waiting for your response.