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

     1  package main
     2  
     3  import (
     4  	"fmt"
     5  
     6  	"github.com/gogf/gf/crypto/gaes"
     7  	"github.com/gogf/gf/database/gdb"
     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:    "123456",
    17  		Name:    "test",
    18  		Type:    "mysql",
    19  		Role:    "master",
    20  		Charset: "utf8",
    21  	})
    22  	db, err := gdb.New()
    23  	if err != nil {
    24  		panic(err)
    25  	}
    26  
    27  	key := "0123456789123456"
    28  
    29  	name := "john"
    30  	encryptedName, err := gaes.Encrypt([]byte(name), []byte(key))
    31  	if err != nil {
    32  		fmt.Println(err)
    33  	}
    34  
    35  	// 写入
    36  	r, err := db.Table("user").Data(g.Map{
    37  		"uid":  1,
    38  		"name": encryptedName,
    39  	}).Save()
    40  	if err != nil {
    41  		fmt.Println(err)
    42  	}
    43  	fmt.Println(r.RowsAffected())
    44  
    45  	// 查询
    46  	one, err := db.Table("user").Where("name=?", encryptedName).One()
    47  	if err != nil {
    48  		fmt.Println(err)
    49  	}
    50  	fmt.Println(one.ToMap())
    51  }