beego orm基础简单的增删改查操作

文章摘自我的个人博客: 网页地址

插入

import (
	"beetest/models"
	"fmt"
	"github.com/beego/beego/v2/client/orm"
	beego "github.com/beego/beego/v2/server/web"
)
func (c *Register) Post() {
	o := orm.NewOrm()
	user := models.User{Name: "王丰", PassWord: "111111", UserName: "wdf"}

	_, err := o.Insert(&user)
	if err != nil {
		fmt.Println("插入失败")
	}
}

查询

func (c *Login) Post() {
	c.Data["title"] = "登录post"
	c.TplName = "login.html"

	o := orm.NewOrm()
	user := models.User{}
	user.Id = 1
	err := o.Read(&user)
	//非主键
	//err := o.Read(&user,"Name")
	
	if err != nil {
		fmt.Println("查询失败")
		c.Data["title"] = "查询失败"
	} else {
		fmt.Println("查询成功",user)
		c.Data["title"] = user.Name
	}
}

更新

//方式一
o := orm.NewOrm()

user := models.User{Id: 1}

err := o.Read(&user)

if err == nil {
	user.Name = "王王丰"
	_, err1 := o.Update(&user)
	if err1 == nil {
		fmt.Println("更新成功")
		c.Data["title"] = "更新成功"
	} else {
		c.Data["title"] = "更新失败"
	}
} else {
	c.Data["title"] = "查询失败 "
}

删除

o := orm.NewOrm()
user := models.User{Id: 1}

_, err := o.Delete(&user)
if err == nil {
	fmt.Println("删除成功")
}