mysql如何把struct结构体保存到数据库中

package main

import (
    "database/sql"
    "fmt"

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

type Person struct {
    ID   int
    Name string
    Age  int
}

func main() {
    // 连接数据库
    db, err := sql.Open("mysql", "username:password@tcp(hostname:port)/database")
    if err != nil {
        fmt.Println("数据库连接失败:", err)
        return
    }
    defer db.Close()

    // 创建表
    _, err = db.Exec("CREATE TABLE IF NOT EXISTS persons (id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100), age INT)")
    if err != nil {
        fmt.Println("创建表失败:", err)
        return
    }

    // 插入数据
    person := Person{Name: "John", Age: 25}
    result, err := db.Exec("INSERT INTO persons (name, age) VALUES (?, ?)", person.Name, person.Age)
    if err != nil {
        fmt.Println("插入数据失败:", err)
        return
    }

    // 获取插入数据的自增ID
    id, _ := result.LastInsertId()
    fmt.Println("插入数据成功，ID:", id)
}