Java Tutorial 91 - Java Database Connectivity (JDBC) 1/7 ~ 7/7

JDBC 1-7 MySQL / MariaDB from the NetBeans IDE

In this tutorial, I will show you how to install XAMPP 7.4.6 for the NetBeans IDE 11.3 on Windows 10 x64. Then I will demonstrate how to work with MariaDB or MySQL in NetBeans IDE.

JDBC 2-7 Connecting to a MySQL / MariaDB Database

In this tutorial, I will show you how to develop database applications using SQL and Java for MariaDB or MySQL in NetBeans IDE.

JDBC 3-7 Running an SQL Script

In this tutorial, I will show you how to develop database applications using SQL and Java for MySQL in NetBeans IDE.

JDBC 4-7 Connecting to a MariaDB Database

In this tutorial, I will show you how to develop database applications using SQL and Java for MariaDB instead of MySQL in the NetBeans IDE.

JDBC 5-7 PreparedStatement

In this tutorial, I will show you how to use PreparedStatement. A PreparedStatement interface enables you to create parameterized SQL statements. The PreparedStatement interface is used to execute a precompiled SQL statement with or without parameters. It is efficient for repeated executions.

JDBC 6-7 Transactions

In this tutorial, I will show you how to use transactions. There are times when you do not want one statement to take effect unless another one completes. When a connection is created, it is in auto-commit mode. This means that each SQL statement is treated as a transaction and is automatically committed right after it is executed. After the auto-commit mode is disabled, no SQL statements are committed until you call the method commit explicitly.

JDBC 7-7 Batch Processing

In this tutorial, I will show you how to use batch updates. When you want to group a set of statements (INSERT, UPDATE or DELETE) and execute them at once this mechanism is known as a batch update. After adding the required SQL statements using the addBatch() method, you can execute a batch using the executeBatch() method of the Statement interface. You may process batch updates inside transactions. In this way, you can execute the batch of SQL statements then commit or rollback the transactions.