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
| package db
|
| import "strconv"
|
| // 根据dbtablepersons表id查询目标档案年龄
| func QueryAgeById(id string) (int, error) {
| var db = DB
| var age string
| err := db.Table("person").
| Select("age").
| Where("id = ?", id).
| Scan(&age).Error
| if err != nil {
| return 0, err
| }
|
| return strconv.Atoi(age)
| }
|
| // 查询人物年龄
| func GetAgeById(id string) (int, error) {
| var db = DB
| // 查询数据
| var age string
| if err := db.Table("person").
| Select("age").
| Where("id = ?", id).
| Find(&age).Error; err != nil {
| return 0, err
| }
|
| return strconv.Atoi(age)
| }
|
| // 查询人物身份证号
| func GetIdCardById(id string) string {
| var db = DB
| // 查询数据
| var idCard string
| db.Table("person").
| Select("id_card").
| Where("id = ?", id).
| Find(&idCard)
|
| return idCard
| }
|
|
