(w http.ResponseWriter, req *http.Request)
| 86 | } |
| 87 | |
| 88 | func read(w http.ResponseWriter, req *http.Request) { |
| 89 | rows, err := db.Query(`SELECT * FROM customer;`) |
| 90 | check(err) |
| 91 | defer rows.Close() |
| 92 | |
| 93 | var name string |
| 94 | for rows.Next() { |
| 95 | err = rows.Scan(&name) |
| 96 | check(err) |
| 97 | fmt.Fprintln(w, "RETRIEVED RECORD:", name) |
| 98 | } |
| 99 | } |
| 100 | |
| 101 | func update(w http.ResponseWriter, req *http.Request) { |
| 102 | stmt, err := db.Prepare(`UPDATE customer SET name="Jimmy" WHERE name="James";`) |