package main
import("fmt""github.com/jinzhu/gorm"_"github.com/jinzhu/gorm/dialects/mysql")type User struct{
Id int
Name string
Age int
Addr string
Pic string
Sex string}funcmain(){//用户名:密码@tcp(ip:port)/数据库?charset=utf-8&parseTime=True&loc=Local
db, err := gorm.Open("mysql","root:abc123456@tcp(localhost:3306)/gorm_project?charset=utf8&parseTime=True&loc=Local")if err !=nil{
fmt.Println("Connect Mysql Error")panic(err)}defer db.Close()//关闭连接// 自动迁移
db.AutoMigrate(&User{})}
数据库表单条数据的CRUD操作
package main
import("fmt""github.com/jinzhu/gorm"_"github.com/jinzhu/gorm/dialects/mysql")type User struct{
Id int
Name string
Age int
Addr string
Pic string
Sex string}funcmain(){//用户名:密码@tcp(ip:port)/数据库?charset=utf-8&parseTime=True&loc=Local
db, err := gorm.Open("mysql","root:abc123456@tcp(localhost:3306)/gorm_project?charset=utf8&parseTime=True&loc=Local")if err !=nil{
fmt.Println("Connect Mysql Error")panic(err)}defer db.Close()//关闭连接// 增加数据
db.Create(&User{Name:"wwzz", Age:20, Addr:"北京市", Pic:"/static/image/xxx.png", Sex:"Male"})// 数据查询var user User
// db.First(&user, 1) //这个1默认为ID// fmt.Println(user)
db.First(&user,"name=?","wwzz")//根据name去查询
fmt.Println(user)// 数据更新
db.Model(&user).Update("age",50)//将user的age更新为20
db.Model(&user).Update("addr","上海市")//将user的addr更新为上海市// 删除数据
db.Delete(&user)}