首先下载gorm包:
安装MySQL驱动:go get github.com/go-sql-driver/mysql
安装gorm包:go get github.com/jinzhu/gorm
package main
import (
"fmt"
"github.com/jinzhu/gorm"
_ "github.com/jinzhu/gorm/dialects/mysql"//这个一定要引入哦!!
"time"
)
//返回datatime
func dateTime()(formatTimeStr string){
NowTimeZone := time.FixedZone("CST", 8*3600) //东八区,返回时区指针
formatTimeStr =time.Now().In(NowTimeZone).Format("2006-01-02 15:04:05") //2020-04-28 23:27:50
return formatTimeStr
}
type Animal struct {
Id uint32
Name string `gorm:"default:''"`
Password string `gorm:"default:''"`
Create_time string ``
}
func main() {
db,errDb:=gorm.Open("mysql","root:yourpassword@(127.0.0.1)/test?charset=utf8mb4&loc=Local")
if errDb!=nil{
fmt.Println(errDb)
}
defer db.Close()//用完之后关闭数据库连接
db.LogMode(true)//开启sql debug 模式
//SELECT * FROM `animals` WHERE (id>0 and id<999) ORDER BY id desc LIMIT 2 OFFSET 1
var owls[] Animal
db.Where("id>? and id<?",0,999).Order("id desc").Offset(2).Limit(2).Find(&owls)
fmt.Println(owls)
//获取条数
total:=0
db.Model(&Animal{}).Count(&total)
fmt.Println(total)
//插入数据1
var animal = Animal{Password: "123456", Name: "monkey",Create_time: dateTime()}
db.Create(&animal)
//插入数据2 结构体这种的表名称是结构体名后面+s
insErr := db.Create(&Animal{Password: "123", Name: "boy",Create_time: dateTime()}).Error
fmt.Println(insErr)
//插入数据3 指定表名称:animals
insErr3 := db.Table("animals").Create(&Animal{Name:"吴亦凡",Create_time:dateTime()}).Error
fmt.Println(insErr3)
animal2 := &Animal{}//获取结构体
//查询数据1 SELECT * FROM `animals` WHERE (Id=1)
db.Where("Id=?",1).Find(animal2)//结果集存放在animal这个struct里面
fmt.Println(animal2,animal2.Id,animal2.Name,animal2.Create_time)
var infos[] Animal//定义一个数组来接收多条结果
db.Where("Id in (?)", []uint32{1, 2,3}).Find(&infos)
fmt.Println(infos)
fmt.Println(len(infos))//结果条数
var notValue[] Animal
db.Where("id=?",3).Find(¬Value)
if len(notValue)==0{
fmt.Println("没有查询到数据!")
}else{
fmt.Println(notValue)
}
//http://gorm.book.jasperxu.com/crud.html#q
//https://gorm.io/zh_CN/docs/create.html
}