需要在终端下载
go get -u github.com/jinzhu/gorm
和
go get gorm.io/driver/mysql
下例为form的增删查改
package main
import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/jinzhu/gorm"
)
type UserInfo struct {
ID uint
Name string
Hobby string
Gender string
}
func main() {
db, err := gorm.Open("mysql", "root:123456@(127.0.0.1:3306)/test?charset=utf8mb4&parseTime=True&loc=Local")
if err!=nil {
fmt.Println("数据库连接失败"+err.Error())
}
//退出程序后关闭数据库连接
defer db.Close()
//自动迁移
db.AutoMigrate(&UserInfo{})
u1:=UserInfo{ID:1, Name: "张三", Gender:"男", Hobby: "篮球",}
u2:=UserInfo{ID:2, Name: "李四", Gender:"女", Hobby: "排球",}
u3:=UserInfo{ID:3, Name: "王五", Gender:"男", Hobby: "足球",}
db.Create(&u1)
db.Create(&u2)
db.Create(&u3)
//查询
var x = new(UserInfo)
db.Last(