package models

// model 在一个里面写.多个表

import (
    _ "github.com/go-sql-driver/mysql"
    "github.com/astaxie/beego/orm"
    "time"
)

//表的设计

//定义一个结构体
type User struct {
    Id int
    Name string
    PassWord string
    //Pass_Word
}

type Article struct {
    Id int `orm:"pk;auto"`
    ArtiName string `orm:"size(20)"`
    Atime time.Time `orm:"auto_now"`
    Acount int `orm:"default(0);null"`
    Acontent string `orm:"size(500)"`
    Aimg string  `orm:"size(100)"`
}

func init() {
    //ORM操作数据库

    orm.RegisterDriver("mysql", orm.DRMySQL)

    //获取连接对象
    // ("%s:%s@tcp(%s:%s)/%s?charset=utf8", dbUser, dbPass, dbHost, dbPort, dbName)
    //orm.RegisterDataBase("default", "mysql", "root:123456@tcp(127.0.0.1:3306)/bifen?charset=utf8")
    orm.RegisterDataBase("default", "mysql", "root:123456@tcp(127.0.0.1:3306)/bifen?charset=utf8")

    //创建表
    orm.RegisterModel(new(User), new(Article))

    //生成表
    //自动创建表 参数二为是否开启创建表   参数三是否更新表
    orm.RunSyncdb("default",true,true)
    //操作表

    // 设置为 UTC 时间
    orm.DefaultTimeLoc = time.UTC

}
Copy

package controllers

import (
    "github.com/astaxie/beego"
    "github.com/astaxie/beego/orm"
)

type MainController struct {
    beego.Controller
}

func (c *MainController) Get() {
    c.Data["Website"] = "beego.me"
    c.Data["Email"] = "astaxie@gmail.com"
    c.TplName = "test.html"
}

func(c*MainController)Post(){
    c.Data["data"] = "上海一期最棒"
    c.TplName = "test.html"
}

func(c*MainController)ShowGet() {
    //获取ORM对象
    o := orm.NewOrm()
    c.Data["data"] = "上海"
    c.TplName = "test.html"
}
Copy

package routers

import (
    "bobo/controllers"
    "github.com/astaxie/beego"
)

func init() {
    beego.Router("/", &controllers.MainController{},"get:ShowGet;post:Post")
}
Copy