• // 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)
  • }