将数据库查询结果转换为Go中的Map：实用指南

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql" // 替换为你使用的数据库驱动
)

func QueryToMap(db *sql.DB, query string) ([]map[string]interface{}, error) {
    rows, err := db.Query(query)
    if err != nil {
        return nil, err
    }
    defer rows.Close()

    columns, err := rows.Columns()
    if err != nil {
        return nil, err
    }

    result := []map[string]interface{}{}
    for rows.Next() {
        values := make([]interface{}, len(columns))
        valuePtrs := make([]interface{}, len(columns))
        for i := range columns {
            valuePtrs[i] = &values[i]
        }

        err := rows.Scan(valuePtrs...)
        if err != nil {
            return nil, err
        }

        row := make(map[string]interface{})
        for i, col := range columns {
            val := values[i]
            // 处理不同类型的数据库返回值
            b, ok := val.([]byte)
            if ok {
                row[col] = string(b) // 将 []byte 转换为 string
            } else {
                row[col] = val
            }
        }
        result = append(result, row)
    }

    return result, nil
}

func main() {
    db, err := sql.Open("mysql", "user:password@tcp(localhost:3306)/database") // 替换为你的数据库连接信息
    if err != nil {
        panic(err)
    }
    defer db.Close()

    query := "SELECT id, name, age FROM users" // 替换为你的查询语句
    data, err := QueryToMap(db, query)
    if err != nil {
        panic(err)
    }

    fmt.Println(data)
}

import (
    "fmt"
    _ "github.com/go-sql-driver/mysql" // 替换为你使用的数据库驱动
    "github.com/jmoiron/sqlx"
)

func main() {
    db, err := sqlx.Open("mysql", "user:password@tcp(localhost:3306)/database") // 替换为你的数据库连接信息
    if err != nil {
        panic(err)
    }
    defer db.Close()

    query := "SELECT id, name, age FROM users" // 替换为你的查询语句
    var result []map[string]interface{}
    err = db.Select(&result, query)
    if err != nil {
        panic(err)
    }

    fmt.Println(result)
}