go查询mysql数据集 单条 多条 例子

数据结构

type MyDevice struct {
	DevId int `json:"d_id"`
	UserId int `json:"e_user_id"`
	EId int `json:"e_id"`
	NickName string `json:"n_name"`
}

查询多条

// import "fmt"
// import _ "github.com/go-sql-driver/mysql"	
// import "encoding/json"
	results, err := db.Query("select d_id,e_user_id,n_name,e_id from user_device limit 3")
    if err != nil {
        panic(err.Error()) 
    }	

    for results.Next() {
        var Device MyDevice
        err = results.Scan(&Device.DevId, &Device.UserId, &Device.NickName,&Device.EId)
        if err != nil {
            panic(err.Error()) 
        }
	    out, err := json.Marshal(Device)
	    if err != nil {
	        panic (err)
	    }        
        fmt.Println(string(out))
    }

查询单条记录

	var Device MyDevice
	InputId := 2259347
	err = db.QueryRow("select dev_id,e_user_id,n_name,eid from user_device where eseeid= ? ",InputEseeId).Scan(&Device.DevId, &Device.UserId, &Device.NickName,&Device.EId)
    if err != nil {
        panic(err.Error()) 
    }	

    out, err := json.Marshal(Device)
    if err != nil {
        panic (err)
    }
    fmt.Println(string(out))