[TOC] # 用戶和訂單,一對多 創建表 ~~~ // 創建表 type User struct { Id int //默認主鍵自增,如果想改的話就 `orm:pk auto` Name string `orm:"size(100)"` User_order []*User_order `orm:"reverse(many)"` //一對多,多個訂單 } //訂單表 type User_order struct { Id int Order_data string `orm:size(100)` User *User `orm:"rel(fk)"` //反向一對多 } func init() { // set default database orm.RegisterDataBase("default", "mysql", "app:app@tcp(127.0.0.1:3306)/app?charset=utf8", 30) // 注冊表,注冊多個 orm.RegisterModel(new(User), new(User_order)) // 創建表 orm.RunSyncdb("default", true, true) } ~~~ 數據插入 ~~~ func insertorder() { o := orm.NewOrm() order := models.User_order{} //order屬性賦值 order.Order_data = "this is order" //id為1的user user := models.User{Id: 1} //order的用戶等于user的引用 order.User = &user //把order添加進去,返回插入的主鍵 id, err := o.Insert (&order) if err != nil { beego.Info("insert error") return } beego.Info("insert success, id = ", id) } func main() { //調用下數據庫方法 insertorder() beego.Run() } ~~~ TODO ~~~ func queryOrder() { var orders []*models.User_order o := orm.NewOrm() //查表 qs := o.QueryTable("User_order") //指定條件查詢所有 res, err := qs.Filter("user__id", 1).All(&orders) beego.Info("返回: ", res) if err != nil { beego.Info("錯誤: ", err) return } for _, order := range orders{ beego.Info("數據: ", order) } } func main() { //調用下數據庫方法 queryOrder() beego.Run() } ~~~