介绍golang gorm操作mysql及gorm基本用法

go get github.com/jinzhu/gorm

go get github.com/go-sql-driver/mysql

packae main

import (

 "github.com/jinzhu/gorm"

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

 "fmt"

)

func main() {

 db, err := gorm.Open("mysql",

 "root:root@/test?charset=utf8&parseTime=True&loc=Local")

 if err != nil {

  fmt.Println(err)

  return

 }else {

  fmt.Println("connection succedssed")

 }

 defer db.Close()

type User struct {

 ID  int   `gorm:"primary_key"`

 Name string   `gorm:"not_null"`

}

func add() {

 user := &User{Name:"zhangsan"}

 db.Create(user)

}

user := &User{ID:1}

db.delete(user)

user := &User{ID:1}

db.Model(user).update("Name","lisi")

// query all

var users []User

db.Find(&users)

fmt.Println(users)

// query one

user := new (User)

db.First(user,1)

fmt.Println(user)

db.HasTable(User{})

db.CreateTable(User{})