Gorm-数据库连接池管理示例

package main

import (
    "fmt"
    "time"

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

type User struct {
    ID   uint
    Name string
}

func main() {
    dsn := "user:password@tcp(host:port)/database"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{
        MaxIdleConns:      10,
        MaxOpenConns:      100,
        ConnMaxLifetime:   time.Hour,
        PrepareStmt:       true,
        SkipDefaultTransaction: true,
    })
    if err != nil {
        panic(err)
    }
    defer db.Close()

    // 创建表
    db.AutoMigrate(&User{})

    // 插入数据
    user1 := User{Name: "Alice"}
    db.Create(&user1)
    user2 := User{Name: "Bob"}
    db.Create(&user2)

    // 查询数据
    var users []User
    db.Find(&users)
    fmt.Println(users)
}