```go // *sql.Rows 转换为 []map[string]interface{}类型 func rows2maps(rows *sql.Rows) (res []map[string]interface{}) { defer rows.Close() cols, _ := rows.Columns() cache := make([]interface{}, len(cols)) // 为每一列初始化一个指针 for index, _ := range cache { var a interface{} cache[index] = &a } for rows.Next() { rows.Scan(cache...) row := make(map[string]interface{}) for i, val := range cache { // 处理数据类型 v := *val.(*interface{}) switch v.(type) { case []uint8: v = string(v.([]uint8)) case nil: v = "" } row[cols[i]] = v } res = append(res, row) } return res } ```
有疑问加站长微信联系（非本文作者）
