Gorm-安装和配置

go get gorm.io/gorm

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

dsn := "user:password@tcp(127.0.0.1:3306)/database_name?charset=utf8mb4&parseTime=True&loc=Local"
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
if err != nil {
    panic(err)
}

package main

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

type User struct {
    gorm.Model
    Name  string
    Email string
}

func main() {
    // 连接MySQL数据库
    dsn := "user:password@tcp(127.0.0.1:3306)/gorm_demo?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        panic(err)
    }

    // 自动迁移数据表
    err = db.AutoMigrate(&User{})
    if err != nil {
        panic(err)
    }

    // 创建用户
    user := User{Name: "Alice", Email: "alice@example.com"}
    db.Create(&user)

    // 查询用户
    var result User
    db.First(&result, user.ID)
    fmt.Println(result.Name)
    fmt.Println(result.Email)

    // 更新用户
    db.Model(&user).Update("Name", "Bob")

    // 删除用户
    db.Delete(&user)
}