Go语言使用sqlite

参考文章:
https://github.com/jmeubank/tdm-gcc/releases

Window需要安装：http://tdm-gcc.tdragon.net/download

下载地址2：https://github.com/jmeubank/tdm-gcc/releases

//MYSQL需要引入 _ "github.com/go-sql-driver/mysql"
执行安装：

go get -u github.com/mattn/go-sqlite3

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

创建数据库，创建表

//打开数据库，如果不存在，则创建
    db, err := sql.Open("sqlite3", "./test.db")
    checkErr(err)

    //创建表
    sql_table := `
    CREATE TABLE IF NOT EXISTS userinfo(
        uid INTEGER PRIMARY KEY AUTOINCREMENT,
        username VARCHAR(64) NULL,
        departname VARCHAR(64) NULL,
        created DATE NULL
    );
    `
    db.Exec(sql_table)

执行Sql语句

stmt, err := db.Prepare("INSERT INTO userinfo(username, departname, created) values(?,?,?)")
    checkErr(err)
    res, err := stmt.Exec("wangshubo", "国务院", "2017-04-21")
    checkErr(err)

查询sql语句

rows, err := db.Query("SELECT * FROM userinfo")
    checkErr(err)
    var uid int
    var username string
    var department string
    var created time.Time

    for rows.Next() {
        err = rows.Scan(&uid, &username, &department, &created)
        checkErr(err)
        fmt.Println(uid)
        fmt.Println(username)
        fmt.Println(department)
        fmt.Println(created)
    }
rows.Close()

异常处理

func checkErr(err error) {
    if err != nil {
        panic(err)
    }
}