c 如何链接mysql数据库

pip install mysql-connector-python

npm install mysql

import mysql.connector

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

try:
    cnx = mysql.connector.connect(**config)
    cursor = cnx.cursor()
    # 执行SQL语句
    cursor.execute("SELECT * FROM your_table")
    for row in cursor:
        print(row)
except mysql.connector.Error as err:
    print(f"Something went wrong: {err}")
finally:
    cursor.close()
    cnx.close()

const mysql = require('mysql');

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

connection.connect(err => {
    if (err) throw err;
    console.log('Connected to the MySQL server.');
    const sql = 'SELECT * FROM your_table';
    connection.query(sql, (err, result) => {
        if (err) throw err;
        console.log(result);
        connection.end();
    });
});

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

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

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement();
             ResultSet rs = stmt.executeQuery("SELECT * FROM your_table")) {

            while (rs.next()) {
                // 处理结果集
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}