快速入门：使用Go语言操作SQLite数据库

go-sqlite3

go get

go get github.com/mattn/go-sqlite3

go-sqlite3

$GOPATH/src

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/mattn/go-sqlite3" // 导入但不直接使用，触发其init函数
    "log"
)

func main() {
    db, err := sql.Open("sqlite3", "mydatabase.db")
    if err != nil {
        log.Fatal(err)
    }
    defer db.Close()

    fmt.Println("Successfully connected to SQLite!")
}

_ "github.com/mattn/go-sqlite3"

_

init

users

id

name

statement, err := db.Prepare("CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)")
if err != nil {
    log.Fatal(err)
}
statement.Exec()

statement, err = db.Prepare("INSERT INTO users (name) VALUES (?)")
if err != nil {
    log.Fatal(err)
}
statement.Exec("Alice")

rows, err := db.Query("SELECT id, name FROM users")
if err != nil {
    log.Fatal(err)
}
defer rows.Close()

for rows.Next() {
    var id int
    var name string
    err = rows.Scan(&id, &name)
    if err != nil {
        log.Fatal(err)
    }
    fmt.Println(id, name)
}

users

id

name

sql

sql.NullString

sql.NullInt64

users

email

type User struct {
    ID    int
    Name  string
    Email sql.NullString
}

rows.Scan

sql.NullString

sql.NullString

Valid

var user User
err = rows.Scan(&user.ID, &user.Name, &user.Email)
if user.Email.Valid {
    fmt.Println("Email:", user.Email.String)
} else {
    fmt.Println("Email is NULL")
}

db.Begin()

tx.Commit()

tx.Rollback()

tx, err := db.Begin()
if err != nil {
    log.Fatal(err)
}

statement, err := tx.Prepare("INSERT INTO users (name) VALUES (?)")
if err != nil {
    tx.Rollback() // 发生错误，回滚事务
    log.Fatal(err)
}
defer statement.Close()

_, err = statement.Exec("Bob")
if err != nil {
    tx.Rollback()
    log.Fatal(err)
}

err = tx.Commit() // 提交事务
if err != nil {
    log.Fatal(err)
}

tx.Rollback()

statement, err = db.Prepare("INSERT INTO users (name) VALUES (?)")
if err != nil {
    log.Fatal(err)
}
statement.Exec("Alice")

?

statement.Exec()