go 使用 gorm 操作mysql数据库

首先下载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(&notValue)
	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
}

 

更多请查看：https://www.tizi365.com/archives/6.html