Go gorm的简单操作

下载:

go get -u github.com/jinzhu/gorm

　　

 

简单代码：

package main

import (
	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mysql"
	"fmt"
)

type Admin struct {
	gorm.Model
	Name string `gorm:"type:varchar(100);index:name"`
	Age int
	Gender string
}

func main() {
	db,err := gorm.Open("mysql","user:password@(localhost)/db?charset=utf8mb4&parseTime=true&loc=Local")
	if err !=nil{
		panic(err)
	}
	defer db.Close()
	//自动迁移
	db.AutoMigrate(&Admin{})
	//
	a1 := Admin{Name: "test",Age: 12,Gender: "v"}
	a2 := Admin{Name: "test2",Age: 20,Gender: "n"}
	//创建记录
	db.Create(&a1)
	db.Create(&a2)

	//查询
	var u = new(Admin)
	db.Find(u)
	fmt.Println(u.Name,u.Gender,u.Age)

	var ua Admin
	db.Find(&ua,"name=?","test")
	fmt.Println(ua.Name,ua.Age)
//	更新

	db.Model(&ua).Update("age",30)

//	删除
	db.Delete(&ua)

}