以MySQL為例,先**安裝驅動**
地址:https://github.com/go-sql-driver/mysql
命令:
~~~
go get -u github.com/go-sql-driver/mysql
~~~
**main.go**
> 需要注意的是struct的key首字母需要大寫
~~~
package main
import (
_ "beego_blog/routers"
"fmt"
"github.com/astaxie/beego"
"github.com/astaxie/beego/orm"
_ "github.com/go-sql-driver/mysql"
)
type Article struct {
Id int
Author string
Content string
Create_time int
}
func main() {
orm.Debug = true
orm.RegisterModel(new(Article)) // 注冊模型
orm.RegisterDriver("mysql", orm.DRMySQL) // 注冊數據庫驅動
orm.RegisterDataBase("default", "mysql", "root:root@/test?charset=utf8") // 默認數據庫+用戶名:密碼/數據庫名和字符集
o := orm.NewOrm()
article := Article{Id: 4}
err := o.Read(&article) // 讀取id為4的數據
if err == orm.ErrNoRows {
fmt.Println("查詢不到")
} else if err == orm.ErrMissPK {
fmt.Println("找不到主鍵")
} else {
fmt.Println(article)
}
beego.Run()
}
~~~