func SelectData(ipaddr string, uid string, pass string, database string, selectStr string)(?) {
//连接数据库
conn, err := sql.Open("odbc", "driver={SQL Server};SERVER="+ipaddr+";UID="+uid+";PWD="+pass+";DATABASE="+database)
defer conn.Close()
rows, err := conn.Query(selectStr)
CheckError(err)
defer rows.Close()
columns, err := rows.Columns()
values := make([]sql.RawBytes, len(columns))
scans := make([]interface{}, len(columns))
for i := range values {
scans[i] = &values[i]
}
var result []map[string]string
for rows.Next() {
_ = rows.Scan(scans...)
each := make(map[string]string)
for i, col := range values {
each[columns[i]] = string(col)
}
result = append(result, each)
}
return result
}
func CheckError(err error) {
if err != nil {
fmt.Println(err)
}
}
这个是查询不定长数据,返回值是result,现在不知道在返回什么类型在(?)处,求大神指导!
用interface{}返回