Retrieving Data from MySQL Database Using JDBC in Java


In this article, we’ll explore how to retrieve data from a MySQL database using JDBC (Java Database Connectivity) in a Java application. JDBC is a Java API that enables Java programs to interact with databases, making it a fundamental tool for database connectivity in Java applications.

Code Overview:

The provided Java code demonstrates a basic example of retrieving data from a MySQL database. Let’s break down the code and understand each part:

// Import necessary Java SQL-related classes
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Main {
public static void main(String[] args) {
// Database connection parameters
String url = “jdbc:mysql://localhost:3306/your_database”;
String username = “your_username”;
String password = “your_password”;

// SQL query with placeholders for parameters
String sql = SELECT column1, column2, column3, column4 FROM TableName WHERE accountnumber = ?;

// Condition value
int accountNumber = 10;

// Try-with-resources to automatically close resources

try (Connection conn = DriverManager.getConnection(url, username, password);

PreparedStatement pstmt = conn.prepareStatement(sql)) {

// Set the condition parameter
pstmt.setInt(1, accountNumber);

// Execute the query

try (ResultSet rs = pstmt.executeQuery()) {
// Process the result set

while ( {

// Retrieve values from the result set

String column1Value = rs.getString(“column1”);

String column2Value = rs.getString(“column2”);
String column3Value = rs.getString(“column3”);

String column4Value = rs.getString(“column4”);

// Process retrieved values as needed

System.out.println(“column1: ” + column1Value + “, column2: ” + column2Value +

“, column3: ” + column3Value + “, column4: ” + column4Value);

} catch (SQLException e) {

System.out.println(“Error: ” + e.getMessage());


Code Explanation:

  • Database Connection Parameters: Defines the URL, username, and password required for connecting to the MySQL database.
  • SQL Query: Defines the SQL query to retrieve data from the database table TableName based on a specified condition (accountnumber = ?).
  • Condition Value: Specifies the value of the condition parameter (accountNumber).
  • Try-with-resources: Establishes a connection to the database and automatically closes resources (such as connections, statements, and result sets) after use.
  • Setting Condition Parameter: Sets the value of the condition parameter in the prepared statement.
  • Executing Query: Executes the SQL query and retrieves the result set.
  • Processing Result Set: Iterates over the result set and retrieves values from each row, printing them to the console.


In this article, we’ve covered a simple yet essential aspect of database interaction in Java: retrieving data from a MySQL database using JDBC. By understanding and utilizing JDBC, Java developers can seamlessly integrate database operations into their applications, enabling powerful data-driven functionality.

By following the steps outlined in this article, you can effectively retrieve data from a MySQL database using JDBC in your Java applications, facilitating efficient and reliable database connectivity.

Leave a Reply

Your email address will not be published.Required fields are marked *