Go语言中操作MySQL数据库的方法

row:= conn.QueryRow(`select * from user where userName = "wyj"`)

var name,pwd string

row.Scan(&name,&pwd)

beego.Info(name,"------",pwd)

data ,err :=conn.Query("SELECT name from user")

    var userName string

    if err == nil{

        for data.Next(){

            data.Scan(&userName)

            beego.Info(userName)

        }

    }

//连接数据库

conn,err := sql.Open("mysql","root:123456@tcp(127.0.0.1:3306)/testtest?charset=utf8")

    if err != nil{

        beego.Info("链接失败")

    }

    defer conn.Close()

//建表

    res ,err:= conn.Exec("create table user(userName VARCHAR(40),passwd VARCHAR(40))")

    beego.Info("create table result=",res,err)

//插入数据

    res,err =conn.Exec("insert user(userName,passwd) values(?,?)","itcast","heima")

    beego.Info(res,err)

//单行查询

    row:= conn.QueryRow(`select * from user where userName = "wyj"`)

    var name,pwd string

    row.Scan(&name,&pwd)

    beego.Info(name,"------",pwd)

//多行查询

    data ,err :=conn.Query("SELECT userName from user")

    var userName string

    if err == nil{

        for data.Next(){

            data.Scan(&userName)

            beego.Error(userName)

        }

    }