C/C++ week
Save up to 80 % on our C and C++ e-learning courses. Only this week!
Get up to 80 % extra points for free! More info

Databases in Java - JDBC

Learn programming database applications in Java using JDBC in this online course. It works with the MySQL and SQLite databases.

Introduction to databases in Java

Lesson 1

Introduction to databases in Java

In this tutorial we'll introduce ways to work with databases in Java via JDBC and JPA. We'll explain relational databases, ACID, wrappers, and ORM.
Written by David Capka
FreeUnrated Show description
Databases in Java JDBC - Printing data and parameters

Lesson 2

Databases in Java JDBC - Printing data and parameters

We'll connect MySQL JDBC Connector to the project and program our first Java application printing data from a MySQL database with SQL injections sanitized.
Written by David Capka
FreeUnrated Show description
Databases in Java JDBC - INSERT, UPDATE, DELETE, and COUNT

Lesson 3

Databases in Java JDBC - INSERT, UPDATE, DELETE, and COUNT

In this tutorial, we'll learn INSERT, UPDATE, and DELETE basic database operations in Java JDBC and determine the number of rows in a table using COUNT.
Written by David Capka
FreeUnrated Show description
Programming a Database Wrapper in Java - Preparation

Lesson 4

Programming a Database Wrapper in Java - Preparation

In this article, we'll prepare a MySQL database to test our Java wrapper, which we'll create in the next episodes and we'll explain its advantages.
Written by David Capka
FreeUnrated Show description
Database Wrapper in Java - Creating the Query class

Lesson 5

Database Wrapper in Java - Creating the Query class

In this tutorial, we'll start programming our wrapper in Java. We'll create a Query class that will represent a generated SQL query and test it.
Written by David Capka
FreeUnrated Show description
Programming a Database Wrapper in Java - The Database class

Lesson 6

Programming a Database Wrapper in Java - The Database class

In this Java tutorial, we'll program the Database class that will use the Query class from the previous lesson. We'll create a database wrapper over JDBC.
Written by David Capka
FreeUnrated Show description
Finishing a Database Wrapper in Java

Lesson 7

Finishing a Database Wrapper in Java

In this last tutorial, we'll complete our wrapper, test it and eventually improve it by adding new methods. Java source code included.
Written by David Capka
FreeUnrated Show description


 

Activities (4)