首先關于數據庫的配置，放行conf/app.conf里，如下：
~~~
dbuser = root
dbpassword = root
dbname = test
dbcharset = utf8
~~~
然后在models/目錄新建個模型models.go
~~~
package models
import (
"github.com/astaxie/beego/orm"
)
type Article struct {
Id int `orm="auto;pk"`
Author string `orm="size(16)"`
Title string `orm="size(64)"`
Content string
Create_time int64
}
func Init() {
orm.RegisterModel(new(Article))
}
~~~
最后在main.go里導入模型，處理增刪除改增
> models.Init() 注冊模型
beego.AppConfig.String(key) 獲取配置項
~~~
package main
import (
"beego_blog/models"
_ "beego_blog/routers"
"fmt"
"github.com/astaxie/beego"
"github.com/astaxie/beego/orm"
_ "github.com/go-sql-driver/mysql"
"time"
)
func init() {
dbuser := beego.AppConfig.String("dbuser")
dbpassword := beego.AppConfig.String("dbpassword")
dbname := beego.AppConfig.String("dbname")
dbcharset := beego.AppConfig.String("dbcharset")
orm.Debug = true
models.Init()
orm.RegisterDriver("mysql", orm.DRMySQL)
orm.RegisterDataBase("default", "mysql", dbuser+":"+dbpassword+"@/"+dbname+"?charset="+dbcharset)
}
func main() {
o := orm.NewOrm()
o.Using("default")
// 增加
article := models.Article{}
article.Title = "hello go"
article.Author = "zhangsan"
article.Content = "hello bee go"
article.Create_time = time.Now().Unix()
id, err := o.Insert(&article)
if err == nil {
fmt.Println(id)
}
// 刪除
// 查詢
// 更新
beego.Run()
}
~~~
刪除( 根據Id )
~~~
if num, err := o.Delete(&models.Article{Id: 7}); err == nil {
fmt.Println("刪除影響的行數:")
fmt.Println(num)
} else {
fmt.Println("刪除失敗~")
}
~~~
查詢( 根據Id )
~~~
article := models.Article{Id: 8}
err := o.Read(&article)
if err == orm.ErrNoRows {
fmt.Println("查詢不到")
} else if err == orm.ErrMissPK {
fmt.Println("找不到主鍵")
} else {
fmt.Println(article.Id, article.Author)
}
~~~
更新( 根據Id )
~~~
article := models.Article{Id: 8}
if o.Read(&article) == nil {
article.Author = "lisi"
if num, err := o.Update(&article); err == nil {
fmt.Println(num)
} else {
fmt.Println("更新失敗~")
}
}
~~~
