网上有个GetOne的函数,只能掉出单个数据,但是对于新手,很多类型都分不清 再写一个调所有数据的好麻烦,所以直接贴出代码
func GetOne(rows *sql.Rows) []string {
if rows == nil {
return nil
}
cols, err := rows.Columns()
rawResult := make([][]byte, len(cols))
result := make([]string, len(cols))
dest := make([]interface{}, len(cols))
for i, _ := range rawResult {
dest[i] = &rawResult[i]
}
if rows.Next() {
err = rows.Scan(dest...)
for i, raw := range rawResult {
if raw == nil {
result[i] = ""
} else {
result[i] = string(raw)
}
}
} else {
return nil
}
_=err
return result
}
type s1 map[string]string //make
type s2 [] s1
func GetAll(rows *sql.Rows) s2 {
if rows == nil {
return nil
}
co