当下载go语言数据库驱动时出现如下错误:
E:\Go\src\beegodemo>go get github.com/go-sql-driver/mysql
can't load package: package github.com/go-sql-driver/mysql: no Go files in E:\Go\src\github.com\go-sql-driv
er\mysql
我们去https://github.com/go-sql-driver/mysql查看问题:
然后重新下载
下载完成后,自动生成文件:
下载驱动成功!
测试代码:
import (
"database/sql"
"github.com/astaxie/beego"
_"github.com/go-sql-driver/mysql"
)
type MysqlController struct {
beego.Controller
}
//1.打开数据库
//2.操作数据库
//3.管理数据库
func (this *MysqlController)ShowMysql() {
//1.打开数据库
//1.驱动名称
//2.连接字符串 mysql -uroot -p123456
conn,err:=sql.Open("mysql","root:123456@tcp(127.0.0.1:3306)/class1?charset=utf8")
if err!=nil{
beego.Info("连接错误",err)
return
}
//3.关闭数据库
defer conn.Close()
//2操作数据库
_,err=conn.Exec("create table userInfo(id int,name varchar(11)) ")
if err !=nil{
beego.Info("创建表错误",err)
return
}
this.Ctx.WriteString("创建表成功!")
}