The Java™ Tutorials – Oracle Java Documentation – Trail: JDBC (TM) Database Access
(https://docs.oracle.com/javase/tutorial/jdbc/index.html)
The JDBC™ API was designed to keep simple things simple. This means that the JDBC makes everyday database tasks easy. This trail walks you through examples of using JDBC to execute common SQL statements, and perform other objectives common to database applications.
This trail is divided into these lessons:
JDBC Introduction Lists JDBC features, describes JDBC Architecture and reviews SQL commands and Relational Database concepts.
JDBC Basics covers the JDBC API, which is included in the Java™ SE 6 release.
By the end of the first lesson, you will know how to use the basic JDBC API to create tables, insert values into them, query the tables, retrieve the results of the queries, and update the tables. In this process, you will learn how to use simple statements and prepared statements, and you will see an example of a stored procedure. You will also learn how to perform transactions and how to catch exceptions and warnings.
JDBC Interview Questions (http://www.developersbook.com/jdbc/interview-questions/jdbc-interview-questions-faqs.php)
- What is the JDBC?
Java Database Connectivity (JDBC) is a standard Java API to interact with relational databases form Java. JDBC has set of classes and interfaces which can use from Java application and talk to database without learning RDBMS details and using Database Specific JDBC Drivers.
etc.
Java JDBC Tutorial – Part 0: Overview
(https://www.youtube.com/watch?v=8-iQDUl10vM)
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
Java JDBC Tutorial – Part 1: Connect to MySQL database with Java
(https://www.youtube.com/watch?v=2i4t-SL1VsU)
In this tutorial, you will learn how to connect to a MySQL database with Java.
Download source code from
http://www.luv2code.com/2014/03/21/co…
Java JDBC Tutorial – Part 2: Insert Data into a MySQL Database
(https://www.youtube.com/watch?v=Q4T7jg0Lv4E)
In this tutorial, you will learn how to use Java JDBC to insert data into a MySQL database.
Download source code from
http://www.luv2code.com/2014/03/21/ja…
Java JDBC Tutorial – Part 3: Updating Data in a MySQL Database
(https://www.youtube.com/watch?v=vwNmYVipzeA)
In this tutorial, you will learn how to update data in a MySQL database using Java JDBC.
Download Source Code: http://www.luv2code.com/?p=746
Java JDBC Tutorial – Part 4: Deleting Data from a MySQL Database
(https://www.youtube.com/watch?v=_KuFESrNgsQ)
In this video tutorial, you will learn how to delete data from a MySQL database using Java JDBC.
Download the source code from here:
http://www.luv2code.com/?p=758
Java JDBC Tutorial – Part 5: Prepared Statements
(https://www.youtube.com/watch?v=gU3DLOsw0Eg)
Download Java Source Code: http://www.luv2code.com/jdbc-prepared…
In this video tutorial we will learn how to use Prepared Statements.
What are Prepared Statements
Create a Prepared Statement
Setting Parameter Values
Reusing a Prepared Statement
Java JDBC Tutorial – Part 6.1: Calling MySQL Stored Procedures with Java
(https://www.youtube.com/watch?v=_2sJls8rnBU)
In this video we will learn how to call MySQL Stored Procedures with Java.
Java JDBC Tutorial – Part 6.2: Calling MySQL Stored Procedures with Java
(https://www.youtube.com/watch?v=MtIYkYcsoJY)
Download Java Source Code: http://www.luv2code.com/?p=1019,
In this video tutorial we will learn how to call MySQL Stored Procedures with Java. This video covers INOUT parameters.
Java JDBC Tutorial – Part 6.3: Calling MySQL Stored Procedures with Java
(https://www.youtube.com/watch?v=W8N_vy-ublo)
In this video tutorial we will learn how to call MySQL Stored Procedures with Java. This video covers OUT parameters.
Java JDBC Tutorial – Part 6.4: Calling MySQL Stored Procedures with Java
(https://www.youtube.com/watch?v=0oRUoQYnqG0)
In this video tutorial we will learn how to call MySQL Stored Procedures with Java. This video covers stored procedures that return result sets.
Java JDBC Tutorial – Part 7: JDBC Transactions with MySQL
(https://www.youtube.com/watch?v=X6BiTCQTFDk)
In this video tutorial we will learn how to use JDBC transactions with MySQL.
Java JDBC Tutorial – Part 8: JDBC Database MetaData with MySQL
(https://www.youtube.com/watch?v=kxdwYWGiD80)
In this video tutorial we will learn how to retrieve JDBC database metadata with MySQL.
(https://www.youtube.com/watch?v=JyMkANs3vhI)
Download Java Source Code: http://www.luv2code.com/?p=1049,
In this video tutorial we will learn how to retrieve JDBC result set metadata with MySQL.
Java JDBC Tutorial – Part 10: BLOB – Reading and Writing BLOB with MySQL
(https://www.youtube.com/watch?v=hqHyCZkon34)
Download Java Source Code: http://www.luv2code.com/?p=1057
In this video tutorial we will learn how to use JDBC to read and write BLOB with MySQL.
Java JDBC Tutorial – Part 11: CLOB – Reading and Writing CLOB with MySQL
(https://www.youtube.com/watch?v=cd9zPkIl3gQ)
Download Java Source Code: http://www.luv2code.com/?p=1095,
In this video tutorial we will learn how to use JDBC to read and write CLOB with MySQL.
Java JDBC Tutorial – Part 12.1: Connect Java Swing GUI to a MySQL Database – Overview
(https://www.youtube.com/watch?v=3C1h5eWyKoE)
Download Java Source Code: http://www.luv2code.com/?p=1101,
In this video tutorial we will learn how to connect a Java GUI to a MySQL database.
Java JDBC Tutorial – Part 12.2: Connect Java Swing GUI to a MySQL Database – Create the DAO
(https://www.youtube.com/watch?v=LXcbU0g3yd0)
Download Java Source Code: http://www.luv2code.com/?p=1101,
In this video tutorial we will learn how to connect a Java GUI to a MySQL database.
Java JDBC Tutorial – Part 12.3: Connect Java Swing GUI to a MySQL Database – Design the GUI
(https://www.youtube.com/watch?v=w_Ji5CEr8hc)
In this video tutorial we will learn how to connect a Java GUI to a MySQL database.
Java JDBC Tutorial – Part 12.4: Connect Java Swing GUI to a MySQL Database – GUI Event Handling
(https://www.youtube.com/watch?v=mpbta8HFfFQ)
Download Java Source Code: http://www.luv2code.com/?p=1101
In this video tutorial we will learn how to connect a Java GUI to a MySQL database.
Java JDBC Tutorial – Part 12.5: Connect Java Swing GUI to a MySQL Database – Populate GUI
(https://www.youtube.com/watch?v=haFsZJbTX5s)
Download Java Source Code: http://www.luv2code.com/?p=1101,
In this video tutorial we will learn how to connect a Java GUI to a MySQL database.
Java JDBC Tutorial – Part 12.6: Connect Java Swing GUI to a MySQL Database – Create a Form to Add
(https://www.youtube.com/watch?v=ak2Z8Kmd_bk)
In this video we will learn how to to connect a Java GUI to a MySQL database. We will create a form to add data into the database.
Java JDBC Tutorial – Part 12.7: Connect Java Swing GUI to MySQL – Update Database
(https://www.youtube.com/watch?v=EkJEdeSNM4E)
Download Java Source Code: http://www.luv2code.com/jdbc-update-e…
In this video we will learn how to to connect a Java GUI to a MySQL database. We will update an existing employee in the database.
Java JDBC Tutorial – Part 12.8: Connect Java Swing GUI to MySQL – Delete an Employee with MySQL
(https://www.youtube.com/watch?v=815PwYKyVAQ)
Download Java Source Code: http://www.luv2code.com/jdbc-delete-e…
In this video we will learn how to connect a Java GUI to a MySQL database. We will delete an employee from the database.
Java JDBC Tutorial – Part 12.9: Connect Java Swing GUI to MySQL – Creating Link Tables
(https://www.youtube.com/watch?v=mGJHp4zeBUU)
Download Java Source Code: http://www.luv2code.com/jdbc-link-tables
In this video we will learn how to connect a Java GUI to a MySQL database. We will link database tables to keep track of an employee’s audit history.
Java JDBC Tutorial – Part 12.10: Connect Java Swing GUI to MySQL – Checking User Passwords
(https://www.youtube.com/watch?v=SrYtgUGhu-k)
Download Java Source Code: http://www.luv2code.com/jdbc-check-pa…
In this video we will learn how to connect a Java GUI to a MySQL database. We will add support to check a user’s password during login.
Note: All initial passwords are set to: java
Java JDBC Tutorial – Part 13: Reading Database Connection Info from a Properties file with MySQL
(https://www.youtube.com/watch?v=-LrmzNDPVx8)
Download Java Source Code: http://www.luv2code.com/?p=1140
In this video tutorial, we will learn how to connect to a database using a configuration file. In particular, we will read database configuration information from a properties file using java.util.Properties
Java – JDBC Databases – Setting Up Your Development Environment and INTRO – 1 of 3
(https://www.youtube.com/watch?v=kxi-H7359LA&list=PL28D4CB13F443964B&index=71)
Java – JDBC Databases – Setting Up Your Development Environment and INTRO – 1 of 3
Java – JDBC Databases – SQL – 2 of 3
(https://www.youtube.com/watch?v=HEVP5u9MXWw)
Java – JDBC Databases – SQL – 2 of 3. Connecting to an Access and SQL Database. DSN and DSN-less connections.
Java – JDBC Databases – GUI and SQL Statements – 3 of 3
(https://www.youtube.com/watch?v=Of4LRHOZoII)
Java – JDBC Databases – GUI and SQL Statements – 3 of 3
Java Video Tutorial 34 – Java and Databases
(https://www.youtube.com/watch?v=Em-AhbqVe48)
Get the Code & Installation Instructions: http://goo.gl/aoZMr
In this part of the Java Video Tutorial I show you how to setup Java JDBC in Eclipse.
I then cover how to connect to a MySQL database, query it and get the results of a query. We also look at the Exceptions you’ll need and much more.
Java Video Tutorial 35 – Solving Java Errors
(https://www.youtube.com/watch?v=eiaWMJt1qhE&list=PLE7E8B7F4856C9B19&index=35)
Get the Code: http://goo.gl/U352w
One of you guys asked me to do a tutorial on Fixing Java Errors. I thought it was a good idea, so here I’ll show you over 30 common Java errors.
Sometimes it is hard to figure out what Cannot be Resolved, Syntax Error on Token, or Method is not Visible mean. But, after watching this video you should better understand.
Also, you’ll learn how to get Eclipse to help you fix Java errors.
Java Video Tutorial 36 – JTables and MySQL
(https://www.youtube.com/watch?v=wFgeUC5dw_4&list=PLE7E8B7F4856C9B19&index=39)
Get Everything: http://goo.gl/jlFC8
I show you how to display database query results from my Sabermetrics Tutorial into a Java JTable.
I then cover most everything about Java JTables. How to display data in a JTable, change fonts, change row height , sort, align and much more.
Java Video Tutorial 37 – JTables and MySQL 2
(https://www.youtube.com/watch?v=mSbFrQfgq7A&list=PLE7E8B7F4856C9B19&index=40)
Get Code and Database: http://goo.gl/RZQ7D
In this part of my Java Video Tutorial, I continue showing how to use JTables with MySQL. You’ll learn how to pull information from a database, add a row, delete a row, convert a String into a SQL Date and much more.