gorm-01

package main

/*
orm
object relation mapping 对象关系映射
*/
import (
	"fmt"

	"github.com/jinzhu/gorm"
	_ "github.com/jinzhu/gorm/dialects/mysql"
)

type UserInfo struct {
	ID     int
	Name   string
	Gender string
	Hobby  string
}

func main() {
	// 创建连接
	db, err := gorm.Open("mysql", "root:111111@(127.0.0.1)/db1?charset=utf8")
	if err != nil {
		panic(err)
	}
	// 延迟关闭
	defer db.Close()

	// 自动映射  struct->table
	db.AutoMigrate(&UserInfo{})

	// 创建
	u1 := UserInfo{2, "lsc", "男", "lol"}
	db.Create(&u1)

	// 查询
	var u UserInfo
	db.First(&u)
	fmt.Printf("u:%#v\n", u)

	// 更新
	db.Model(&u).Update("hobby", "cf")

	// 删除
	db.Delete(&u)
}