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

时间：2025-02-12 15:05:23

云数据库 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 intvar var2 stringvar 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-文件组织结构