-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmain.go
More file actions
83 lines (76 loc) · 1.83 KB
/
main.go
File metadata and controls
83 lines (76 loc) · 1.83 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
package main
import (
"context"
"fmt"
"gorm/model"
"gorm/query"
"log"
"gorm.io/driver/mysql"
"gorm.io/gorm"
)
func main() {
dsn := "root:123456@tcp(127.0.0.1:3307)/edu.mall?charset=utf8mb4&parseTime=true&loc=Local"
db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
if err != nil {
log.Fatal("数据库连接失败：", err)
}
q := query.Use(db)
ctx := context.Background()
userDAD := q.User
//1.创建用户
newUser := &model.User{
Name: "张三",
Age: 25,
Email: "zhangsan@163.com",
}
err = userDAD.WithContext(ctx).Create(newUser)
if err != nil {
log.Fatal("创建用户失败：", err)
}
fmt.Println("创建用户成功：", newUser)
////2.查询用户
////2.1 根据ID查询
//user, err := userDAD.WithContext(ctx).Where(q.User.ID.Eq(newUser.ID)).First()
//if err != nil {
// log.Fatal("查询用户失败：", err)
//}
//fmt.Printf("查询结果：%+v\n", user)
//
////2.2 条件查询
//users, err := userDAD.WithContext(ctx).
// Where(q.User.Age.Gte(20), q.User.Name.Like("%张%")).
// Find()
//if err != nil {
// log.Fatal("条件查询失败：", err)
//}
//fmt.Printf("查询到{%d}个用户", len(users))
//
////3.更新用户
//_, err = userDAD.WithContext(ctx).
// Where(q.User.ID.Eq(newUser.ID)).
// Update(q.User.Age, 26)
//if err != nil {
// log.Fatal("更新用户年龄失败：", err)
//}
//fmt.Println("更新用户年龄成功")
//
//// 多字段更新
//_, err = userDAD.WithContext(ctx).
// Where(q.User.ID.Eq(newUser.ID)).
// Updates(model.User{
// Name: "张三丰",
// Age: 27,
// })
//if err != nil {
// log.Fatal("多字段更新失败:", err)
//}
//
////4.删除用户
//_, err = userDAD.WithContext(ctx).
// Where(q.User.ID.Eq(newUser.ID)).
// Delete()
//if err != nil {
// log.Fatal("删除用户失败：", err)
//}
//fmt.Println("删除用户成功")
}