(w http.ResponseWriter, req *http.Request)
| 99 | } |
| 100 | |
| 101 | func update(w http.ResponseWriter, req *http.Request) { |
| 102 | stmt, err := db.Prepare(`UPDATE customer SET name="Jimmy" WHERE name="James";`) |
| 103 | check(err) |
| 104 | defer stmt.Close() |
| 105 | |
| 106 | r, err := stmt.Exec() |
| 107 | check(err) |
| 108 | |
| 109 | n, err := r.RowsAffected() |
| 110 | check(err) |
| 111 | |
| 112 | fmt.Fprintln(w, "UPDATED RECORD", n) |
| 113 | } |
| 114 | |
| 115 | func del(w http.ResponseWriter, req *http.Request) { |
| 116 | stmt, err := db.Prepare(`DELETE FROM customer WHERE name="Jimmy";`) |