go build error“NEXT undefined”(键入*"database/sql".Rows没有字段或方法NEXT)

Question

我想在go中的行中使用NEXT，但我在rows.NEXT中收到警告，它说NEXT未定义(键入*“数据库/sql”.Rows没有字段或方法NEXT)

     func FetchViewDO() (shipment_admin.ShipmentViewDetailDOGroup, error) {
            var obj ShipmentDOBaseModel
            var objg ShipmentDOGroup
            var arrobj []ShipmentDOBaseModel
            var res shipment_admin.ShipmentViewDetailDOGroup
        
            var db *sql.DB
        
            con := db
            sqlStatement := `SELECT s.status_id,sdog.*,sdo.shipment_id,sdo.external_id,sdo.client_code
        FROM shipment_delivery_order sdo
        LEFT JOIN shipment_delivery_order_group sdog ON sdog.shipment_child_id = sdo.shipment_id
        LEFT JOIN shipment s ON s.shipment_id = sdo.shipment_id`
        
            rows, err := con.Query(sqlStatement)
            defer rows.Close()
        
            if err != nil {
                return res, err
            }
        
            for rows.NEXT() {
                err = rows.Scan(&objg.ShipmentParentID, &objg.CreatedAt, &objg.ShipmentChildID)
                if err != nil {
                    return res, err
                }
            }
            res.Status = http.StatusOK
            res.Message = "Success"
            res.Data = arrobj
        
            return res, nil
        
        }

Answer 1

没有名为NEXT的方法，但有一个名为Next的方法，我认为它是您问题的答案，请记住Go区分大小写