MySQL

Python - 使用mysql-connector-python

首先，确保安装了mysql-connector-python库：

pip install mysql-connector-python

然后，使用以下代码连接到MySQL数据库：

import mysql.connector

config = {
   
    'user': 'your_username',
    'password': 'your_password',
    'host': 'your_host',
    'database': 'your_database',
    'raise_on_warnings': True
}

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()
    print("Successfully connected to the database.")
    # 执行查询等操作...
except mysql.connector.Error as err:
    print(f"Error: {err}")

Java - 使用JDBC

首先，添加MySQL JDBC驱动依赖到你的项目中。

使用Maven，添加以下依赖到pom.xml：

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.23</version>
</dependency>

然后，使用以下代码连接到MySQL数据库：

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

public class Main {
   
    public static void main(String[] args) {
   
        String url = "jdbc:mysql://your_host:3306/your_database";
        String user = "your_username";
        String password = "your_password";

        try {
   
            Connection conn = DriverManager.getConnection(url, user, password);
            System.out.println("Successfully connected to the database.");
            // 执行查询等操作...
        } catch (SQLException e) {
   
            System.out.println("Error: " + e.getMessage());
        }
    }
}

PHP - 使用mysqli

<?php
$servername = "your_host";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

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

// 检查连接
if ($conn->connect_error) {
   
    die("Connection failed: " . $conn->connect_error);
}
echo "Successfully connected to the database.";
// 执行查询等操作...
?>

Node.js - 使用mysql

首先，确保安装了mysql库：

npm install mysql

然后，使用以下代码连接到MySQL数据库：

const mysql = require('mysql');

const connection = mysql.createConnection({
   
  host: 'your_host',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect(error => {
   
  if (error) {
   
    return console.log('Error connecting to the database: ' + error.message);
  }
  console.log('Successfully connected to the database.');
  // 执行查询等操作...
});

C# - 使用MySql.Data

首先，确保安装了MySql.Data库：

dotnet add package MySql.Data

然后，使用以下代码连接到MySQL数据库：

using System;
using MySql.Data.MySqlClient;

class Program
{
   
    static void Main()
    {
   
        string connectionString = "server=your_host;user=your_username;password=your_password;database=your_database;";

        using (var connection = new MySqlConnection(connectionString))
        {
   
            try
            {
   
                connection.Open();
                Console.WriteLine("Successfully connected to the database.");
                // 执行查询等操作...
            }
            catch (MySqlException ex)
            {
   
                Console.WriteLine(ex.Message);
            }
        }
    }
}

请注意，上述代码示例中的your_username、your_password、your_host和your_database