github.com/gogf/gf@v1.16.9/.example/database/gdb/mysql/gdb_json_xml.go (about)

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  
     6  	"github.com/gogf/gf/database/gdb"
     7  	"github.com/gogf/gf/encoding/gparser"
     8  	"github.com/gogf/gf/frame/g"
     9  )
    10  
    11  func main() {
    12  	gdb.AddDefaultConfigNode(gdb.ConfigNode{
    13  		Host:    "127.0.0.1",
    14  		Port:    "3306",
    15  		User:    "root",
    16  		Pass:    "12345678",
    17  		Name:    "test",
    18  		Type:    "mysql",
    19  		Role:    "master",
    20  		Charset: "utf8",
    21  	})
    22  	db := g.DB()
    23  	one, err := db.Table("user").Where("id=?", 1).One()
    24  	if err != nil {
    25  		panic(err)
    26  	}
    27  
    28  	// 使用内置方法转换为json/xml
    29  	fmt.Println(one.ToJson())
    30  	fmt.Println(one.ToXml())
    31  
    32  	// 自定义方法方法转换为json/xml
    33  	jsonContent, _ := gparser.VarToJson(one.ToMap())
    34  	fmt.Println(string(jsonContent))
    35  	xmlContent, _ := gparser.VarToXml(one.ToMap())
    36  	fmt.Println(string(xmlContent))
    37  }