云数据库 GAUSSDB-使用Go驱动操作密态数据库:执行密态等值查询加密表相关的语句

时间：2024-11-13 10:04:59

云数据库 GAUSSDB

执行密态等值查询加密表相关的语句

// 定义加密表
_, err = db.Exec("CREATE TABLE creditcard_info (id_number int, name varchar(50) encrypted with (column_encryption_key = ImgCEK1, encryption_type = DETERMINISTIC), credit_card varchar(19) encrypted with (column_encryption_key = ImgCEK1, encryption_type = DETERMINISTIC));")
// 插入数据
_, err = db.Exec("INSERT INTO creditcard_info VALUES (1,'joe','6217986500001288393'), (2,'mike','6217986500001722485'), (3,'joe','6315892300001244581');");
var var1 int
var var2 string
var var3 string
// 查询数据
rows, err := db.Query("select * from creditcard_info where name = 'joe';")
defer rows.Close()
// 逐行打印
for rows.Next() {
    err = rows.Scan(&var1, &var2, &var3)
    if err != nil {
        log.Fatal(err)
    } else {
        fmt.Printf("var1:%v, var2:%v, var3:%v\n", var1, var2, var3)
    }
}

上一篇：云数据库 GAUSSDB-使用Go驱动操作密态数据库:执行加密表的预编译SQL语句

下一篇：云数据库 GAUSSDB-使用Go驱动操作密态数据库:执行加密表的预编译SQL语句