package main
import (
"encoding/json"
"fmt"
"gorm.io/driver/mysql"
"gorm.io/gorm"
)
type User struct {
gorm.Model
Name string
Age string
}
func main() {
db, err := gorm.Open(mysql.New(mysql.Config{
DSN: "root:@tcp(127.0.0.1:3306)/test2?charset=utf8mb4&parseTime=True&loc=Local", // 账号密码地址端口 // 根据当前 MySQL 版本自动配置
}), &gorm.Config{
// ...gorm配置
})
if err != nil {
panic("failed to connect database")
}
fmt.Println("连接数据库成功")
var user []User
// AND
db.Where("name = ? AND age >= ?", "我无法到达遥远的你", "90").Find(&user)
// SELECT * FROM users WHERE name = 'jinzhu' AND age >= 22;
// 打印查询的结果
fmt.Println("result: ", user)
Info_of_Zhang3, err := json.Marshal(user)
if err == nil {
fmt.Println("我是json格式", string(Info_of_Zhang3))
} else {
fmt.Println(err)
return
}
}
结果
