1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283 |
- package services
- import (
- "fmt"
- ywtcenter "hello/models/ywtcenter"
- "github.com/astaxie/beego/orm"
- )
- // list 查询
- func QueryList() {
- var j, i int64
- orm.Debug = true
- o := orm.NewOrm()
- o.Using("default") // 默认使用 default,你可以指定为其他数据库
- var users []ywtcenter.MgAdmin
- num, err := o.Raw("SELECT account, id, nick_name, user_id FROM mg_admin WHERE state = ?", 1).QueryRows(&users)
- // fmt.Println(users)
- if err == nil {
- fmt.Println("user nums: ", num)
- }
- i = num
- for j = 0; j < i; j++ {
- // fmt.Printf("Element[%d] = %d, %s, %d\n", j, users[j].Id, users[j].NickName, users[j].UserId)
- }
- }
- // 根据ID查找一个记录
- func FindOneById(id int) ywtcenter.MgAdmin {
- orm.Debug = true
- o := orm.NewOrm()
- o.Using("default") // 默认使用 default,你可以指定为其他数据库
- mgAdmin := ywtcenter.MgAdmin{Id: int16(id)}
- err := o.Read(&mgAdmin)
- if err == orm.ErrNoRows {
- fmt.Println("查询不到")
- } else if err == orm.ErrMissPK {
- fmt.Println("找不到主键")
- } else {
- // fmt.Println(mgAdmin.Id, mgAdmin.NickName)
- }
- return mgAdmin
- }
- // 方式1: 根据ID修改userId
- func UpdateUserId1(id, userId int) ywtcenter.MgAdmin {
- o := orm.NewOrm()
- o.Using("default")
- mgAdmin := ywtcenter.MgAdmin{Id: int16(id)}
- if o.Read(&mgAdmin) == nil {
- mgAdmin.UserId = int16(userId)
- if num, err := o.Update(&mgAdmin); err == nil {
- fmt.Println(num)
- }
- }
- return mgAdmin
- }
- /**
- * 方式2: 根据ID修改userId
- */
- func UpdateUserId2(id, userId int) {
- o := orm.NewOrm()
- o.Using("default")
- num, err := o.QueryTable("mg_admin").Filter("id", "1").Update(orm.Params{
- "user_id": int16(userId),
- })
- fmt.Printf("Affected Num: %s, %s", num, err)
- }
- // 删除对象
- func DeleteMgAdminById(id int) {
- o := orm.NewOrm()
- o.Using("default")
- if num, err := o.Delete(&ywtcenter.MgAdmin{Id: int16(id)}); err == nil {
- fmt.Println(num)
- }
- }
|