<div class="image-550">
<img src="https://cdn.kahimyang.com/resources-24/java-mysql.avif" alt="MySQL with Java" loading="lazy" />
</div>
<h4>
Prerequisites
</h4>
<ol class="k-list">
<li>
<b>Java Development Kit (JDK)</b>: Ensure you have JDK installed. You can download it from the official Oracle website.
</li>
<li>
<b>MySQL/MariaDB</b>: Install MySQL or MariaDB on your system.
</li>
<li>
<b>JDBC Driver</b>: Download the MySQL Connector/J JDBC driver from the official MySQL website.
</li>
</ol>
<h4>
Setting Up the Project
</h4>
<p>
Create a New Java Project: Set up a new Java project in your preferred IDE (e.g., IntelliJ IDEA, Eclipse, NetBeans).
</p>
<p>
Add the MySQL Connector/J JDBC Driver: Add the MySQL Connector/J JAR file to your project's classpath. This enables your Java application to interact with the MySQL/MariaDB database.
</p>
<h4>
Database Table
</h4>
<p>
Let's assume we have a simple table users on testdb database, with a structure created as follows:
</p>
<pre style="font-size: 90%;">
<code class="language-sql normalize-whitespace line-numbers" >
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);
</code>
</pre>


Performing CRUD Operations in MySQL/MariaDB using Java JDBC