c连接到mysql数据库代码

import mysql.connector

# 创建数据库连接
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')

# 创建游标对象
cursor = cnx.cursor()

# 执行SQL查询
query = "SELECT * FROM your_table"
cursor.execute(query)

# 获取查询结果
for (column1, column2) in cursor:
    print(column1, column2)

# 关闭游标和数据库连接
cursor.close()
cnx.close()

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

public class Main {
    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        try {
            // 加载数据库驱动
            Class.forName("com.mysql.jdbc.Driver");

            // 创建数据库连接
            conn = DriverManager.getConnection("jdbc:mysql://your_host:your_port/your_database",
                    "your_username", "your_password");

            // 创建Statement对象
            stmt = conn.createStatement();

            // 执行SQL查询
            String sql = "SELECT * FROM your_table";
            rs = stmt.executeQuery(sql);

            // 处理查询结果
            while (rs.next()) {
                String column1 = rs.getString("column1");
                String column2 = rs.getString("column2");
                System.out.println(column1 + " " + column2);
            }
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            // 关闭ResultSet、Statement和Connection
            try {
                if (rs != null) rs.close();
                if (stmt != null) stmt.close();
                if (conn != null) conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

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

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

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

// 执行SQL查询
$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

// 处理查询结果
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "column1: " . $row["column1"]. " - column2: " . $row["column2"]. "<br>";
    }
} else {
    echo "0 结果";
}

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