當我使用調試器時，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}
2 回答
元芳怎么了
TA貢獻1798條經驗 獲得超7個贊
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 調用
- 2 回答
- 0 關注
- 88 瀏覽
添加回答
舉報
0/150
提交
取消