go连接mysql
package main
import (
"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!