数据库连接方式代码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 = "password";
        
        try {
            // 加载MySQL JDBC驱动程序
            Class.forName("com.mysql.jdbc.Driver");
            
            // 创建数据库连接
            Connection conn = DriverManager.getConnection(url, username, password);
            
            // 执行数据库操作
            // ...
            
            // 关闭数据库连接
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

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

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 执行数据库操作
// ...

// 关闭数据库连接
$conn->close();
?>

import mysql.connector

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

# 执行数据库操作
# ...

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