go使用gorm连接mysql

package main

import (
	"fmt"
	"gorm.io/driver/mysql"
	"gorm.io/gorm"
)

type Company struct {
	Name        string
	Code        string
	credit_code string
}

func main() {
	UserName := "xxx"
	PassWord := "xxxx"
	Host := "127.0.0.1"
	Prot := "3306"
	Db := "xxxxxx"
	// 连接MySQL数据库
	dsn := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=utf8mb4&parseTime=True&loc=Local", UserName, PassWord, Host, Prot, Db)
	fmt.Println(dsn)
	db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{})
	if err != nil {
		panic(err.Error())
	}
	sqlDB, err := db.DB()
	if err != nil {
		panic(err.Error())
	}
	defer sqlDB.Close()

	// 查询记录
	var companys []*Company
	db.Table("company").Where("`code`='陕西省'").Find(&companys)
	fmt.Println("查询记录成功:【%d】", len(companys)) // 455211

}