github.com/d4l3k/go@v0.0.0-20151015000803-65fc379daeda/src/database/sql/example_test.go (about)

     1  // Copyright 2013 The Go Authors. All rights reserved.
     2  // Use of this source code is governed by a BSD-style
     3  // license that can be found in the LICENSE file.
     4  
     5  package sql_test
     6  
     7  import (
     8  	"database/sql"
     9  	"fmt"
    10  	"log"
    11  )
    12  
    13  var db *sql.DB
    14  
    15  func ExampleDB_Query() {
    16  	age := 27
    17  	rows, err := db.Query("SELECT name FROM users WHERE age=?", age)
    18  	if err != nil {
    19  		log.Fatal(err)
    20  	}
    21  	defer rows.Close()
    22  	for rows.Next() {
    23  		var name string
    24  		if err := rows.Scan(&name); err != nil {
    25  			log.Fatal(err)
    26  		}
    27  		fmt.Printf("%s is %d\n", name, age)
    28  	}
    29  	if err := rows.Err(); err != nil {
    30  		log.Fatal(err)
    31  	}
    32  }
    33  
    34  func ExampleDB_QueryRow() {
    35  	id := 123
    36  	var username string
    37  	err := db.QueryRow("SELECT username FROM users WHERE id=?", id).Scan(&username)
    38  	switch {
    39  	case err == sql.ErrNoRows:
    40  		log.Printf("No user with that ID.")
    41  	case err != nil:
    42  		log.Fatal(err)
    43  	default:
    44  		fmt.Printf("Username is %s\n", username)
    45  	}
    46  }