package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
)
type Tag struct {
ID int `json:"id"`
Name string `json:"name"`
}
func main() {
var recList = []Tag{}
db, err := sql.Open("mysql", "root:linuxer@tcp(127.0.0.1:3306)/study")
if err != nil {
panic(err.Error())
}
defer db.Close()
results, err := db.Query("SELECT id, name FROM t")
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
fmt.Println(results)
for results.Next() {
var tag Tag
// for each row, scan the result into our tag composite object
err = results.Scan(&tag.ID, &tag.Name)
recList = append(recList, tag)
if err != nil {
panic(err.Error()) // proper error handling instead of panic in your app
}
fmt.Println(recList)
}
}
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10972173/viewspace-2915547/ ，如需转载，请注明出处，否则将追究法律责任。
