golang连接mysql数据库进行查询

 1 package main
 2 
 3 import (
 4     "database/sql"
 5     "fmt"
 6     _ "github.com/go-sql-driver/mysql"
 7 )
 8 
 9 func main() {
10     db, err := sql.Open("mysql", "root:1234567890@/test?charset=utf8")
11     CheckErr(err)
12     rows, err := db.Query("select * from users")
13     CheckErr(err)
14     for rows.Next() {
15         var id int
16         var nick string
17         err = rows.Scan(&id, &nick)
18         CheckErr(err)
19         fmt.Println(id)
20         fmt.Println(nick)
21     }
22     db.Close()
23 }
24 
25 func CheckErr(err error) {
26     if err != nil {
27         panic(err)
28     }
29 }