- package main
- import (
- "database/sql"
- "fmt"
- _ "github.com/go-sql-driver/mysql"
- )
- func main() {
- db, err := sql.Open("mysql", "root:test@tcp(127.0.0.1:3306)/jx?charset=utf8")
- CheckErr(err)
- row, err := db.Query("select name,password from admin")
- CheckErr(err)
- for row.Next() {
- var name string
- var password string
- err = row.Scan(&name, &password)
- CheckErr(err)
- fmt.Println(name + "--" + password)
- }
- db.Close()
- }
- func CheckErr(err error) {
- if err != nil {
- panic(err)
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/2601201614491.html
来源: http://www.codesnippet.cn/detail/2601201614491.html