go 连接 mysql框架_Gin 框架mysql的连接搭建

Gin框架中mysql的连接

安装驱动

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

安装Gorm

go get -u github.com/jinzhu/gorm

package main

import (

"fmt"

"github.com/gin-gonic/gin"

_ "github.com/go-sql-driver/mysql"

"github.com/jinzhu/gorm"

"net/http"

"time"

)

type User struct {

gorm.Model

Name string `gorm:"type:varchar(20);not null"`

Telephone string `gorm:"varchar(20);not null;unique"`

Password string `gorm:"size:255;not null"`

}

//项目初始化

func main() {

db := InitDB()

defer db.Close() //延时关闭

r := gin.Default()

//r.Run()

panic(r.Run()) // listen and serve on 0.0.0.0:8080 (for windows "localhost:8080")

}

//数据库连接

func InitDB() *gorm.DB {

driverName := "mysql"

host := "127.0.0.1"

port := "3306"

database := "blog"

username := "root"

password := "islot"

charset := "utf8"

args := fmt.Sprintf("%s:%s@tcp(%s:%s)/%s?charset=%s&parseTime=true",

username,

password,

host,

port,

database,

charset,

)

db, err := gorm.Open(driverName, args)

//db, err := gorm.Open("mysql", "user:islot@/blog?charset=utf8&parseTime=True&loc=Local")

if err != nil {

panic("failed to connect database,err:" + err.Error())

}

//自动创建数据表

db.AutoMigrate(&User{})

return db

}

标签：github,err,db,mysql,Gin,com,gorm,搭建

来源： https://www.cnblogs.com/zhaoyingjie/p/13854120.html