{已修复} Golang RESTAPI 返回错误数据

Question

当我使用调试器时，metricId返回具有所有值的度量对象0 or null（与输出相同）。我在这里做错了什么？The Database connection works.func GetMetricById(c *gin.Context) {    metricId := c.Param("id")    conn := config.DatabaseConnect()    var obj models.Metric    rows := conn.QueryRow("SELECT * FROM Metric WHERE id = ?", metricId)    err := rows.Scan(&obj.Id, &obj.Sms, &obj.Absence, &obj.Pregnant, &obj.Uwv_notifications, &obj.Wia_dossiers_started, &obj.Employees, &obj.Data_id, &obj.Date, &obj.Type)    if err != nil {        fmt.Println(err.Error())    }    fmt.Println(obj, "Metric Object that is called.")    c.JSON(http.StatusOK, obj)}输出：{    "Id": 0,    "Sms": 0,    "Absence": 0,    "Pregnant": 0,    "Uwv_notifications": 0,    "Wia_dossiers_started": 0,    "Employees": 0,    "Data_id": 0,    "Date": "",    "Type": 0}

Answer 1

func GetMetricsByDataId(c *gin.Context) {

    queryParams := c.Request.URL.Query()

    

    conn := config.DatabaseConnect()

    var metrObject []models.Metric

    rows, _ := conn.Query("SELECT * FROM Metric WHERE data_id = ?", queryParams.Get("data_id"))

    defer rows.Next()

    for rows.Next() {

        var obj models.Metric

        if err := rows.Scan(&obj.Id, &obj.Sms, &obj.Absence, &obj.Pregnant, &obj.Uwv_notifications, &obj.Wia_dossiers_started, &obj.Employees, &obj.Data_id, &obj.Date, &obj.Type); err != nil {

            _ = fmt.Errorf(err.Error())

        }

        metrObject = append(metrObject, obj)

    }

    if err := rows.Err(); err != nil {

        _ = fmt.Errorf(err.Error())

    }

    c.JSON(http.StatusOK, metrObject)

}

像这样它有效

localhost:8082/billing/getmetricbydataid?data_id=150295

通过此 API 调用

Answer 2

我认为解决方案可能是使用metricId := c.Params.ByName("id")而不是metricId := c.Param("id")