go 链接mysql select

1、下载MySQL驱动

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

• 或者下载源码放到GOPATH中，下载地址：https://github.com/go-sql-driver/mysql

 

 代码开始

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

func main(){
	fmt.Println("fasfds")
	db()
}

func db() {
    //建立链接
    conn,err := sql.Open("mysql","root:mysql@tcp(localhost:3306)/ecshop")
    if err != nil {
        log.Fatal("Open Connection failed:", err.Error())
    }
    defer conn.Close()
    rows,err := conn.Query("select * from ecs_admin")
    for rows.Next() {
        var user_id int

        var user_name string

        err := rows.Scan(&user_id, &user_name)

        checkErr(err)

        fmt.Println(user_id)
        fmt.Println(user_name)

    }
}

func checkErr(err error){
	if err!=nil{
		panic(err)
	}
}