go get -u github.com/go-sql-driver/mysql

package main

import (
    "database/sql"
    "fmt"
    "log"

    _ "github.com/go-sql-driver/mysql"
)

func main() {
    // 连接数据库
    db, err := sql.Open("mysql", "username:password@tcp(127.0.0.1:3306)/dbname?charset=utf8mb4&parseTime=True&loc=Local")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()

    // 测试连接
    err = db.Ping()
    if err != nil {
        log.Fatal(err)
    }
    fmt.Println("Connected to MySQL database!")
}

db.SetMaxOpenConns(25)    // 最大连接数
db.SetMaxIdleConns(5)     // 最大空闲连接数
db.SetConnMaxLifetime(5 * time.Minute) // 连接最大存活时间


  query := `
      CREATE TABLE IF NOT EXISTS users (
          id INT AUTO_INCREMENT PRIMARY KEY,
          username VARCHAR(50) NOT NULL,
          email VARCHAR(100) NOT NULL,
          created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
      )`
  _, err := db.Exec(query)
  if err != nil {
      log.Fatal(err)
  }


  query := "INSERT INTO users (username, email) VALUES (?, ?)"


  result, err := db.Exec(query, "john_doe", "john@example.com")
  if err != nil {
      log.Fatal(err)
  }


  id, err := result.LastInsertId()
  if err != nil {
      log.Fatal(err)
  }

  query := "UPDATE users SET email = ? WHERE username = ?"


  result, err := db.Exec(query, "new_email@example.com", "john_doe")
  if err != nil {
      log.Fatal(err)
  }


  rowsAffected, err := result.RowsAffected()
  if err != nil {
      log.Fatal(err)
  }

  query := "DELETE FROM users WHERE username = ?"


  result, err := db.Exec(query, "john_doe")
  if err != nil {
      log.Fatal(err)
  }


  rowsAffected, err := result.RowsAffected()
  if err != nil {
      log.Fatal(err)
  }

go get -u gorm.io/gorm
go get -u gorm.io/driver/mysql

dsn := "user:password@tcp(host:port)/dbname?charset=utf8mb4&parseTime=True&loc=Local"

package main

import (
    "gorm.io/driver/mysql"
    "gorm.io/gorm"
)

func main() {
    dsn := "root:yourpassword@tcp(127.0.0.1:3306)/yourdb?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        panic("failed to connect database")
    }

    // 使用db对象进行数据库操作...
}

type User struct {
    gorm.Model
    Name  string
    Email string `gorm:"unique"`
    Age   int
}

// 自动迁移模式
err = db.AutoMigrate(&User{})
if err != nil {
    panic("failed to migrate database")
}

// 创建单个用户
user := User{Name: "张三", Email: "zhangsan@example.com", Age: 25}
result := db.Create(&user)
if result.Error != nil {
    panic(result.Error)
}

// 批量创建
users := []User{
    {Name: "李四", Email: "lisi@example.com", Age: 30},
    {Name: "王五", Email: "wangwu@example.com", Age: 28},
}
db.Create(&users)

// 查询单个用户
var user User
db.First(&user, 1) // 通过主键查询
db.First(&user, "name = ?", "张三") // 通过条件查询

// 查询多个用户
var users []User
db.Find(&users) // 查询所有用户
db.Where("age > ?", 25).Find(&users) // 条件查询

// 更新单个字段
db.Model(&user).Update("name", "张三新名字")

// 更新多个字段
db.Model(&user).Updates(User{Name: "张三新名字", Age: 26})

// 条件更新
db.Model(&User{}).Where("age < ?", 30).Update("age", gorm.Expr("age + ?", 1))

// 删除单个记录
db.Delete(&user)

// 条件删除
db.Where("name = ?", "李四").Delete(&User{})

// 软删除（如果模型包含gorm.Model）
db.Delete(&user) // 只会设置deleted_at字段