JDBC stands for Java Database Connectivity. JDBC is a Java API that allows you to interact with databases from Java programs such as executing SQL statements, retrieving results, and managing database connections.
JDBC offers a standardized way for Java applications to connect to and interact with various database systems including MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, and others.
With JDBC, you can write database-independent code, allowing you to switch between different database systems without making significant application code changes.
Section 1. Getting started with JDBC #
This section helps you get started with JDBC by understanding what JDBC is, how to create a new database, and how to connect to the database from a Java application using JDBC.
- What is JDBC – learn about JDBC & JDBC drivers.
- Creating a new database – show you how to create a new database, create a new user, and grant all database privileges to the user in the MariaDB server.
- Connecting to the database server – guide you on connecting to the MariaDB server from a Java program using JDBC.
Section 2. Performing common database operations #
- Creating a table – show you how to create a new table in the database using the
Statementobject. - Insert rows into a table – Learn how to insert a row into a table using the
PreparedStatementobject. - Batch Processing – show you how to perform multiple SQL statements as a batch to improve the performance.
- Updating data – guide you on how to update data in a table.
- Selecting data – learn to retrieve data from a table and iterate over the result set using the ResultSet object.
- Deleting data – delete one or more rows from a table.
Section 3. JDBC Transactions #
- JDBC Transaction – show you how to perform a database transaction using JDBC.
Was this helpful?
Thank you for your feedback!