需要下載sqlite3環(huán)境：

go get github.com/mattn/go-sqlite3

"github.com/mattn/go-sqlite3"

go操作sqlite3的示例代碼：

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/mattn/go-sqlite3"
	"log"
)

const (
	dbDriverName = "sqlite3"
	dbname       = "./data.db"
)

type user struct {
	Username string
	Age      int
	Job      string
	Hobby    string
}

//封裝一個(gè)處理error的函數(shù)，處理程序中的 err，
//有err的地方直接調(diào)用這個(gè)函數(shù)就可以了
func checkErr(e error) bool {
	if e != nil {
		log.Fatal(e)
		return true
	}
	return false
}

//創(chuàng)建數(shù)據(jù)表的函數(shù)
func createTable(db *sql.DB) error {
	sql := `create table if not exists "users" (
		"id" integer primary key autoincrement,
		"username" text not null,
		"age" integer not null,
		"job" text,
		"hobby" text
	)`
	_, err := db.Exec(sql)
	return err
}

//########插入數(shù)據(jù)#########
func insertData(db *sql.DB, u user) error {
	sql := `insert into users (username, age, job, hobby) values(?,?,?,?)`
	stmt, err := db.Prepare(sql)
	if err != nil {
		return err
	}
	_, err = stmt.Exec(u.Username, u.Age, u.Job, u.Hobby)
	return err
}

//#########查詢數(shù)據(jù)并且返回切片列表########

//查詢所有數(shù)據(jù)
func queryDataAll(db *sql.DB) (listusers []user, e error) {
	sql := `select * from users`
	stmt, err := db.Prepare(sql)
	if err != nil {
		return nil, err
	}
	rows, err := stmt.Query()
	if err != nil {
		return nil, err
	}
	var result = make([]user, 0)
	for rows.Next() {
		var username, job, hobby string
		var age, id int
		rows.Scan(&id, &username, &age, &job, &hobby)
		result = append(result, user{username, age, job, hobby})
	}
	return result, nil
}

//查詢帶有條件的數(shù)據(jù)函數(shù)
func queryData(db *sql.DB, name string) (listusers []user, e error) {
	//sql := `select * from users `
	sql := `select * from users where username=?`
	stmt, err := db.Prepare(sql)
	if err != nil {
		return nil, err
	}
	rows, err := stmt.Query(name)
	if err != nil {
		return nil, err
	}
	var result = make([]user, 0)
	for rows.Next() {
		var username, job, hobby string
		var age, id int
		rows.Scan(&id, &username, &age, &job, &hobby)
		result = append(result, user{username, age, job, hobby})
	}
	return result, nil
}

//########刪除數(shù)據(jù)#########

func delByID(db *sql.DB, id int) (bool, error) {
	sql := `delete from users where id=?`
	stmt, err := db.Prepare(sql)
	if err != nil {
		return false, err
	}
	res, err := stmt.Exec(id)
	if err != nil {
		return false, err
	}
	_, err = res.RowsAffected()
	if err != nil {
		return false, err
	}
	return true, nil
}

func editdata(db *sql.DB, u user, editid int) (bool, error) {
	//sql := `update users set username=? age=? job=? hobby=? where id=?`
	sql := `update users set username=? where id=?`
	stmt, err := db.Prepare(sql)
	if err != nil {
		return false, err
	}
	res, err := stmt.Exec(u.Username, editid)
	if err != nil {
		return false, err
	}
	_, err = res.RowsAffected()
	if err != nil {
		return false, err
	}
	return true, nil
}

func editdata_bak(db *sql.DB, u user, editid int) (bool, error) {
	//sql := `update users set username=? age=? job=? hobby=? where id=?`
	sql := `update users set username=? age=? job=? hobby=? where id=?`
	stmt, err := db.Prepare(sql)
	if err != nil {
		return false, err
	}
	res, err := stmt.Exec(u.Username, u.Age, u.Job, u.Hobby, editid)
	if err != nil {
		return false, err
	}
	_, err = res.RowsAffected()
	if err != nil {
		return false, err
	}
	return true, nil
}

//#################
//######主函數(shù)###########

func main() {

	//初始sqlite3數(shù)據(jù)庫文件
	db, err := sql.Open(dbDriverName, dbname)
	if checkErr(err) {
		return
	}
	//#################
	調(diào)用創(chuàng)建數(shù)據(jù)表的語句
	//err = createTable(db)
	//if checkErr(err) {
	//	return
	//}

	#######插入數(shù)據(jù)的方式##########
	//user1 := user{
	//	Username: "tom",
	//	Age:      50,
	//	Job:      "manager",
	//	Hobby:    "跑步，跳繩，編程",
	//}

	插入數(shù)據(jù)的方式：
	//err = insertData(db, user{"jerry", 51, "醫(yī)藥開發(fā)", "運(yùn)動(dòng)，學(xué)習(xí)"})
	//err = insertData(db, user1)
	//if checkErr(err) {
	//	return
	//}
	//#################
	//查詢所有學(xué)生數(shù)據(jù)
	resall, err := queryDataAll(db)

	if checkErr(err) {
		return
	}

	fmt.Println(len(resall)) //結(jié)果中幾個(gè)學(xué)生信息的長度
	fmt.Println("======查詢?nèi)繑?shù)據(jù)的結(jié)果===========")
	for _, val := range resall {
		fmt.Println(val)
	}

	/*
			查詢結(jié)果：
		======查詢?nèi)繑?shù)據(jù)的結(jié)果===========
			{tom 50 manager 跑步，跳繩，編程}
			{jerry 51 醫(yī)藥開發(fā) 運(yùn)動(dòng)，學(xué)習(xí)}
			{tom 50 manager 跑步，跳繩，編程}
			=======過濾條件的查詢=========
	*/

	fmt.Println("=======過濾條件的查詢=========")

	//查詢帶有過濾條件的數(shù)據(jù)
	resnames, err := queryData(db, "tom")
	if checkErr(err) {
		return
	}

	fmt.Println(len(resnames)) //結(jié)果中幾個(gè)學(xué)生信息的長度
	fmt.Println("=======過濾名字的結(jié)果：==========")
	for _, val := range resnames {
		fmt.Println(val)
	}

	/*
		=======過濾名字的結(jié)果：==========
		{tom 50 manager 跑步，跳繩，編程}
		{tom 50 manager 跑步，跳繩，編程}

	*/

	//#####刪除指定的id的編號(hào)############
	//r, err := delByID(db, 1)
	//if checkErr(err) {
	//	return
	//}
	//if r {
	//	fmt.Println("刪除數(shù)據(jù)成功！")
	//	//fmt.Println("delete row success")
	//}

	//########更新數(shù)據(jù)#########
	//更新數(shù)據(jù)內(nèi)容信息
	//創(chuàng)建一個(gè)更新對(duì)象
	useredit := user{
		Username: "tomupdate",
		Age:      49,
		Job:      "manager--pm",
		Hobby:    "跑步，跳繩，編程",
	}

	b, err := editdata(db, useredit, 2)
	if checkErr(err) {
		return
	}
	if b {
		fmt.Println("更新數(shù)據(jù)成功")
	}

	//#################

	//#################

}