参考文章:
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)
}
}
