如何从 go-sqlite3 查询中获取计数值？

Question

我正在使用go-sqlite3来检索具有特定值的列的行数：

query := "select count(notebook) from pages where notebook="

result, err := db.Query(fmt.Sprint(query, id))

Whereid传递给运行查询的函数。

如何从中检索计数值result？

Answer 1

这应该有效：// Output will be stored here.var output stringid := "1234" // Prepare your queryquery, err := db.Prepare("select count(notebook) from pages where notebook = ?")if err != nil {    fmt.Printf("%s", err)}defer query.Close()// Execute query using 'id' and place value into 'output'err = query.QueryRow(id).Scan(&output)// Catch errorsswitch {case err == sql.ErrNoRows:        fmt.Printf("No notebook with that ID.")case err != nil:        fmt.Printf("%s", err)default:        fmt.Printf("Counted %s notebooks\n", output)}