go 使用 gorm 操作mysql数据库

爱被打了一巴掌 2023-03-13 03:40 31阅读 0赞

首先下载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][https_www.tizi365.com_archives_6.html]

[https_www.tizi365.com_archives_6.html]: https://www.tizi365.com/archives/6.html