用UTF-8加密Golang中的字符串以放入postgres

package main

import (
    "crypto/aes"
    "crypto/cipher"
    "encoding/base64"
    "fmt"
)

func encryptString(key, plaintext string) (string, error) {
    block, err := aes.NewCipher([]byte(key))
    if err != nil {
        return "", err
    }

    // 使用AES加密算法的CBC模式
    ciphertext := make([]byte, aes.BlockSize+len(plaintext))
    iv := ciphertext[:aes.BlockSize]
    if _, err := rand.Read(iv); err != nil {
        return "", err
    }

    mode := cipher.NewCBCEncrypter(block, iv)
    mode.CryptBlocks(ciphertext[aes.BlockSize:], []byte(plaintext))

    // 使用base64编码将加密后的数据转换为字符串
    return base64.StdEncoding.EncodeToString(ciphertext), nil
}

func main() {
    key := "0123456789abcdef" // 密钥，长度为16字节
    plaintext := "Hello, World!"

    ciphertext, err := encryptString(key, plaintext)
    if err != nil {
        fmt.Println("Encryption error:", err)
        return
    }

    fmt.Println("Ciphertext:", ciphertext)
}

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/lib/pq"
)

func main() {
    db, err := sql.Open("postgres", "user=your_user password=your_password dbname=your_db sslmode=disable")
    if err != nil {
        fmt.Println("Database connection error:", err)
        return
    }
    defer db.Close()

    ciphertext := "encrypted_string" // 加密后的字符串

    _, err = db.Exec("INSERT INTO your_table (encrypted_column) VALUES ($1)", ciphertext)
    if err != nil {
        fmt.Println("Insert error:", err)
        return
    }

    fmt.Println("Insert successful")
}