mysql数据库数据连接方法

import java.sql.*;

public class MySqlConnectionExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "root";
        String password = "mypassword";

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

            // 执行数据库操作

            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="mypassword",
  database="mydatabase"
)

# 执行数据库操作

mydb.close()

<?php
$servername = "localhost";
$username = "root";
$password = "mypassword";
$dbname = "mydatabase";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 执行数据库操作

$conn->close();
?>