dw连接mysql数据库

import mysql.connector

# 建立连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标
mycursor = mydb.cursor()

# 执行SQL查询
mycursor.execute("SELECT * FROM yourtable")

# 获取查询结果
myresult = mycursor.fetchall()

for x in myresult:
  print(x)

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) {
        try {
            // 加载驱动
            Class.forName("com.mysql.cj.jdbc.Driver");

            // 建立连接
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase", "yourusername", "yourpassword");

            // 创建游标
            Statement stmt = conn.createStatement();

            // 执行SQL查询
            ResultSet rs = stmt.executeQuery("SELECT * FROM yourtable");

            // 处理查询结果
            while (rs.next()) {
                System.out.println(rs.getString("columnName"));
            }

            // 关闭连接
            rs.close();
            stmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

SET GLOBAL connect_timeout = 28800; -- 设置全局连接超时时间为8小时

GRANT ALL PRIVILEGES ON yourdatabase.* TO 'yourusername'@'localhost';
FLUSH PRIVILEGES;

try (Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/yourdatabase", "yourusername", "yourpassword")) {
    // 使用连接进行操作
} catch (SQLException e) {
    e.printStackTrace();
}