从行中获取sql行

Question

我如何在 Go*sql.Rows中使用一种解析（扫描）方法？*sql.Row

解析（扫描）方法使用一个代码解析一行

...

row := r.stmOne.QueryRow(id)

rows, err := r.stmOther.Query(ids, params)

parseRow(row, &item)

for rows.Next(){

    parseRows(rows, &item)

}

...

func parseRows(row *sql.Rows, item *typeItem) error {

    err := row.Scan(....) /// same

}

func parseRow(row *sql.Row, item *typeItem) error {

    err := row.Scan(....) /// same

}

Answer 1

type RowScanner interface {    Scan(dest ...interface{}) error}func scanRowIntoItem(row RowScanner, item *typeItem) error {    err := row.Scan(...)}row := r.stmOne.QueryRow(id)rows, err := r.stmOther.Query(ids, params)scanRowIntoItem(row, &item)for rows.Next(){    scanRowIntoItem(rows, &item)}