How to connect Java to a Database?

Question

Aryan Kumar · Answer

To connect Java to a database, you can use the JDBC (Java Database Connectivity) API. The JDBC API provides a standard way for Java programs to connect to and interact with databases.
To connect Java to a database, you need to:
Install the JDBC driver for the database you want to connect to.Create a connection object.Create a statement object.Execute a query or update statement.Process the results of the query or update statement.Close the connection object.
Here is an example of how to connect Java to a MySQL database:
import java.sql.*;
public class JDBCExample {
    public static void main(String[] args) throws SQLException {
        // Load the MySQL JDBC driver.
        Class.forName("com.mysql.jdbc.Driver");
        // Create a connection to the database.
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "password";
        Connection connection = DriverManager.getConnection(url, username, password);
        // Create a statement object.
        Statement statement = connection.createStatement();
        // Execute a query.
        String query = "SELECT * FROM users";
        ResultSet resultSet = statement.executeQuery(query);
        // Process the results of the query.
        while (resultSet.next()) {
            System.out.println(resultSet.getString("username"));
        }
        // Close the connection object.
        connection.close();
    }
}
In this example, we first load the MySQL JDBC driver. Then, we create a connection to the database using the
DriverManager.getConnection() method. Next, we create a statement object. Then, we execute a query using the
statement.executeQuery() method. Finally, we close the connection object.

forum

How to connect Java to a Database?

Revati S Misra

Can you answer this question?

1 Answers

Liked By