Golang框架如何连接到MySQL数据库？

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

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

func main() {
    dsn := "user:password@tcp(127.0.0.1:3306)/dbname"
    db, err := sql.Open("mysql", dsn)
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()
    
    // 使用db连接执行查询和修改操作...
}

rows, err := db.Query("SELECT name, age FROM people")
if err != nil {
    // 处理错误
}
for rows.Next() {
    var name string
    var age int
    if err := rows.Scan(&name, &age); err != nil {
        // 处理错误
    }
    fmt.Println(name, age)
}
rows.Close()

_, err := db.Exec("INSERT INTO people (name, age) VALUES (?, ?)", "John", 30)
if err != nil {
    // 处理错误
}

_, err := db.Exec("UPDATE people SET age = ? WHERE name = ?", 31, "John")
if err != nil {
    // 处理错误
}

_, err := db.Exec("DELETE FROM people WHERE name = ?", "John")
if err != nil {
    // 处理错误
}