Golang database/sql.Rows type example

package database/sql

Rows is the result of a query. Its cursor starts before the first row of the result set. Use Next to advance through the rows:

Golang database/sql.Rows type usage example

 var (
  id int
  username string
 )

 rows, err := db.Query("select id, username from accounts where id = ?", 1)
 if err != nil {
  log.Fatal(err)
 }
 defer rows.Close()
 for rows.Next() {
  err := rows.Scan(&id, &name)
  if err != nil {
 log.Fatal(err)
  }
  log.Println(id, name)
 }
 err = rows.Err()
 if err != nil {
  log.Fatal(err)
 }

Reference :

http://golang.org/pkg/database/sql/#Rows

Advertisement