package main import ( "database/sql" "fmt" _ "github.com/mutecomm/go-sqlcipher/v4" "log" ) type Users struct { ID int Name string table string } func main() { db := "C:\\Users\\zm\\Desktop\\Duplicati-server.sqlite" key := "Duplicati_Key_42" dbname := fmt.Sprintf("%s?_pragma_key=x'%s'&_pragma_cipher_page_size=4096", db, key) dba, _ := sql.Open("sqlite3", dbname) querySql := `SELECT ID, NAME FROM Backup;` rows, err := dba.Query(querySql) if err != nil { log.Fatal(err) } defer rows.Close() var users []Users = make([]Users, 0) for rows.Next() { var u Users rows.Scan(&u.table, &u.Name) users = append(users, u) } fmt.Println(users) } 报错如下:
https://shimo.im/files/m5kv9dWORBuxrxqX/ 「Duplicati-server.sqlite」,可复制链接后用石墨文档 App 或小程序打开