AdminService.go 1.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. package services
  2. import (
  3. "fmt"
  4. ywtcenter "hello/models/ywtcenter"
  5. "github.com/astaxie/beego/orm"
  6. )
  7. // list 查询
  8. func QueryList() {
  9. var j, i int64
  10. orm.Debug = true
  11. o := orm.NewOrm()
  12. o.Using("default") // 默认使用 default,你可以指定为其他数据库
  13. var users []ywtcenter.MgAdmin
  14. num, err := o.Raw("SELECT account, id, nick_name, user_id FROM mg_admin WHERE state = ?", 1).QueryRows(&users)
  15. // fmt.Println(users)
  16. if err == nil {
  17. fmt.Println("user nums: ", num)
  18. }
  19. i = num
  20. for j = 0; j < i; j++ {
  21. // fmt.Printf("Element[%d] = %d, %s, %d\n", j, users[j].Id, users[j].NickName, users[j].UserId)
  22. }
  23. }
  24. // 根据ID查找一个记录
  25. func FindOneById(id int) ywtcenter.MgAdmin {
  26. orm.Debug = true
  27. o := orm.NewOrm()
  28. o.Using("default") // 默认使用 default,你可以指定为其他数据库
  29. mgAdmin := ywtcenter.MgAdmin{Id: int16(id)}
  30. err := o.Read(&mgAdmin)
  31. if err == orm.ErrNoRows {
  32. fmt.Println("查询不到")
  33. } else if err == orm.ErrMissPK {
  34. fmt.Println("找不到主键")
  35. } else {
  36. // fmt.Println(mgAdmin.Id, mgAdmin.NickName)
  37. }
  38. return mgAdmin
  39. }
  40. // 方式1: 根据ID修改userId
  41. func UpdateUserId1(id, userId int) ywtcenter.MgAdmin {
  42. o := orm.NewOrm()
  43. o.Using("default")
  44. mgAdmin := ywtcenter.MgAdmin{Id: int16(id)}
  45. if o.Read(&mgAdmin) == nil {
  46. mgAdmin.UserId = int16(userId)
  47. if num, err := o.Update(&mgAdmin); err == nil {
  48. fmt.Println(num)
  49. }
  50. }
  51. return mgAdmin
  52. }
  53. /**
  54. * 方式2: 根据ID修改userId
  55. */
  56. func UpdateUserId2(id, userId int) {
  57. o := orm.NewOrm()
  58. o.Using("default")
  59. num, err := o.QueryTable("mg_admin").Filter("id", "1").Update(orm.Params{
  60. "user_id": int16(userId),
  61. })
  62. fmt.Printf("Affected Num: %s, %s", num, err)
  63. }
  64. // 删除对象
  65. func DeleteMgAdminById(id int) {
  66. o := orm.NewOrm()
  67. o.Using("default")
  68. if num, err := o.Delete(&ywtcenter.MgAdmin{Id: int16(id)}); err == nil {
  69. fmt.Println(num)
  70. }
  71. }