Front-end week Get free points
Get up to 40 % extra points for free! More info
Save up to 80 % on HTML & CSS + JavaScript e-learning! Only this week!

Databases in Java - JDBC

The section contains tutorials for programming database applications in Java using JDBC. It works with the MySQL and SQLite databases.

Lessons

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.
FreeUnratedWritten by David Capka
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.
FreeUnratedWritten by David Capka
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.
FreeUnratedWritten by David Capka
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.
FreeUnratedWritten by David Capka
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.
FreeUnratedWritten by David Capka
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.
FreeUnratedWritten by David Capka
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.
FreeUnratedWritten by David Capka


 

Activities (1)