How to connect to a MySQL database using JDBC?

In Java, JDBC (Java Database Connectivity) can be used to connect to a MySQL database. Here are the steps to connect to a MySQL database: 1. Download and install the MySQL Connector/J driver. You can download the driver for your operating system from the MySQL official website. 2. In your Java project, add the MySQL Connector/J driver (.jar file) to the classpath. 3. Import the JDBC related classes in your Java code.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

4. Use the following code to establish a connection with a MySQL database:

Connection connection = null;
try {
    // 注册驱动程序
    Class.forName("com.mysql.jdbc.Driver");
    
    // 创建连接
    String url = "jdbc:mysql://localhost:3306/database_name";
    String username = "username";
    String password = "password";
    connection = DriverManager.getConnection(url, username, password);
    
    // 连接成功，执行数据库操作
    // ...
} catch (ClassNotFoundException e) {
    System.out.println("无法找到MySQL驱动程序");
    e.printStackTrace();
} catch (SQLException e) {
    System.out.println("无法连接到数据库");
    e.printStackTrace();
} finally {
    // 关闭连接
    if (connection != null) {
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

In the above code, you need to replace `database_name` with the actual database name, and `username` and `password` with the actual database username and password. After a successful connection, various database operations can be performed, such as querying, inserting, updating, etc. These are the basic steps for connecting to a MySQL database, and you can perform the necessary database operations according to your own requirements.