How do I set up a JDBC connection in Java?

How do I set up a JDBC connection in Java?

To set up a JDBC connection in Java, you need to follow these steps: 1. Load the JDBC driver. 2. Establish a connection using DriverManager. 3. Create a Statement or PreparedStatement. 4. Execute your query. 5. Close the connection.

What JDBC driver do I need for MySQL?

For MySQL, you need the MySQL Connector/J driver. You can download it from the MySQL website or include it in your project via Maven.

Can you show me a code example?

Sure! Here's a simple example:

import java.sql.*;

public class JdbcExample {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", "user", "password");
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM mytable");
            while (rs.next()) {
                System.out.println(rs.getString("column_name"));
            }
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

What if I get a connection error?

If you encounter a connection error, check the following: 1. Ensure the database server is running. 2. Verify the connection URL, username, and password. 3. Check if the JDBC driver is correctly included in your project.