Inserting, Updating and Deleting Data Using JDBC in Java

This JDBC tutorial is going to help you learn how to do basic database operations (CRUD - Create, Retrieve, Update and Delete) using JDBC (Java Database Connectivity) API. These CRUD operations are equivalent to the INSERT, SELECT, UPDATE and DELETE statements in SQL language. Although the target database system is MySQL, the same technique can be applied for other database systems as well because the query syntax used is standard SQL which is supported by all relational database systems.
We will learn how to do insert, query, update and delete database records by writing code to manage records of a table Users in a MySQL database called SimpleDB.