Golang语言特性解读：数据库操作与ORM框架

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "username:password@tcp(127.0.0.1:3306)/mydatabase")
    if err != nil {
        panic(err.Error())
    }
    defer db.Close()

    rows, err := db.Query("SELECT * FROM users")
    if err != nil {
        panic(err.Error())
    }

    for rows.Next() {
        var id int
        var name string
        err = rows.Scan(&id, &name)
        if err != nil {
            panic(err.Error())
        }
        fmt.Println("ID:", id, "Name:", name)
    }
}

package main

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

type User struct {
    ID   int
    Name string
}

func main() {
    dsn := "username:password@tcp(127.0.0.1:3306)/mydatabase?charset=utf8mb4&parseTime=True&loc=Local"
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
    if err != nil {
        panic("failed to connect database")
    }
    
    // 自动迁移模式
    db.AutoMigrate(&User{})

    // 创建数据
    user := User{Name: "Alice"}
    db.Create(&user)

    // 查询数据
    var result User
    db.First(&result, 1)
    fmt.Println(result)

    // 更新数据
    db.Model(&result).Update("name", "Bob")

    // 删除数据
    db.Delete(&result)
}