首页 > 数据库技术 > 详细

go连接mysql

时间:2018-10-04 01:15:46      阅读:190      评论:0      收藏:0      [点我收藏+]
package main

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db,err := sql.Open("mysql","root:1234@tcp(127.0.0.1:3306)/oa?charset=utf8");
    if err != nil{
        fmt.Printf("connect mysql fail ! [%s]",err)
    }else{
        fmt.Println("connect to mysql success")
    }

    rows,err := db.Query("select id,username from user_info");
    if err != nil{
        fmt.Printf("select fail [%s]",err)
    }

    var mapUser map[string]int
    mapUser = make(map[string]int)

    for rows.Next(){
        var id int
        var username string
        rows.Columns()
        err := rows.Scan(&id,&username)
        if err != nil{
            fmt.Printf("get user info error [%s]",err)
        }
        mapUser[username] = id
    }

    for k,v := range mapUser{
        fmt.Println(k,v);
    }


}

 

go连接mysql

原文:https://www.cnblogs.com/senlinyang/p/9740157.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!