golang调用sqlite数据库

// sqlitedaemon project main.go

// go get github.com/mattn/go-sqlite3
package main

import (
    "database/sql"
    "fmt"
    "log"

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

func checkErr(err error) {
    if err != nil {
        log.Fatal(err)
    }
}

type Users struct {
    UserId int
    Uname string
    Uage string
}

func main() {
    db, err := sql.Open("sqlite3", "./userinfo.db")
    checkErr(err)
    defer db.Close()

    sql := `create table users (userId integer, uname text,uage integer);`
    db.Exec(sql)
    sql = `insert into users(userId,uname,uage) values(1,'Mike',23);`
    db.Exec(sql)
    sql = `insert into users(userId,uname,uage) values(2,'John',34);`
    db.Exec(sql)
    rows, err := db.Query("select * from users")
    checkErr(err)
    defer rows.Close()
    var users []Users = make([]Users, 0)
    for rows.Next() {
        var u Users
        rows.Scan(&u.UserId, &u.Uname, &u.Uage)
        users = append(users, u)
    }
    fmt.Println(users)
}