go连接mysql

go连接mysql

package mainimport (    "database/sql"    "fmt"    _ "github.com/go-sql-driver/mysql")func main() {    db, err := sql.Open("mysql", "root:***@tcp(127.0.0.1:3200)/server_conf?charset=utf8")    if err != nil {        fmt.Printf("connect mysql failed! [%s]", err)        return    } else {        fmt.Println("connect mysql ok!")    }    rows, err := db.Query("SELECT d_id, d_dname FROM domain")    if err != nil {        fmt.Printf("select failed! [%s]", err)        return    }    var mapDomain map[string]int    mapDomain = make(map[string]int)    for rows.Next() {        var d_id int        var d_dname string        rows.Columns()        err = rows.Scan(&d_id, &d_dname)        if err != nil {            fmt.Printf("Get domain info failed! [%s]", err)        }        mapDomain[d_dname] = d_id    }    // 遍历所有的KEY    for k, v := range mapDomain {        fmt.Println(k, v)    }    // 查找指定KEY    if v, ok := mapDomain["www.test2.com"]; ok {        fmt.Println(v)    } else {        fmt.Println("Key Not Found")    }}

输出:
connect mysql ok!