mysql中如何用代码创建数据库连接

import mysql.connector

# 创建数据库连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword"
)

# 输出数据库连接状态
print(mydb)

# 关闭数据库连接
mydb.close()

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

public class Main {
    public static void main(String[] args) {
        // JDBC驱动名及数据库URL
        String JDBC_DRIVER = "com.mysql.cj.jdbc.Driver";
        String DB_URL = "jdbc:mysql://localhost/";

        // 数据库的用户名与密码
        String USER = "yourusername";
        String PASS = "yourpassword";

        Connection conn = null;

        try {
            // 注册驱动
            Class.forName(JDBC_DRIVER);

            // 打开连接
            conn = DriverManager.getConnection(DB_URL, USER, PASS);

            // 输出连接状态
            System.out.println(conn);

            // 关闭连接
            conn.close();
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
    }
}