JSON ???? gjson ????? ?? json.Unmarshal ??? ???? MySQL ??????? ??? ? ????. gjson ?????? JSON ??? ?? ???? ?? ??? ??? ????, json.Unmarshal ???? JSON ???? ?????? ?? ?? ?? ???? ?????. ? ?? ?? SQL ?? ???? ?? ??? ???? ???? ??????? ???? ???.

JSON ???? Golang? ??????? ???? ??

??
Golang??? JSON ???? ??????? ???? ?? ???? ?????. ? ????? MySQL? ?? ????? ???? ??????? ???? JSON ???? ???? ??? ??? ???? ??? ? ?? ?? ??? ?????.

gjson ????? ??
gjson ?????? JSON ???? ?? ???? ???? ? ?? ???? Golang ??????. JSON ???? ? ? ????? ?? Go ??? ??? ?? ???? ?? ??? ?????.

package main

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

func main() {
    db, err := sql.Open("mysql", "user:password@tcp(localhost:3306)/database")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    jsonData := `{
        "name": "John Doe",
        "age": 30,
        "address": {
            "street": "Main Street",
            "city": "New York"
        }
    }`

    values := []interface{}{}

    // 解析 JSON 字段
    name := gjson.Get(jsonData, "name").String()
    age := gjson.Get(jsonData, "age").Int()
    address := gjson.Get(jsonData, "address").String()

    values = append(values, name, age, address)

    // 準備 SQL 語句
    stmt, err := db.Prepare("INSERT INTO users (name, age, address) VALUES (?, ?, ?)")
    if err != nil {
        panic(err)
    }

    // 執(zhí)行插入操作
    _, err = stmt.Exec(values...)
    if err != nil {
        panic(err)
    }

    fmt.Println("JSON data saved to database successfully")
}

json.Unmarshal ??
json.Unmarshal ??? Golang ?? ?????? ???? JSON ???? Go ??? ?????? ? ?????. ? ????? ? ?? ????? ?? ?? ???? ?????.

? ??? JSON ???? Golang? ??????? ???? ??? ??????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!