(w http.ResponseWriter, req *http.Request)
| 113 | } |
| 114 | |
| 115 | func del(w http.ResponseWriter, req *http.Request) { |
| 116 | stmt, err := db.Prepare(`DELETE FROM customer WHERE name="Jimmy";`) |
| 117 | check(err) |
| 118 | defer stmt.Close() |
| 119 | |
| 120 | r, err := stmt.Exec() |
| 121 | check(err) |
| 122 | |
| 123 | n, err := r.RowsAffected() |
| 124 | check(err) |
| 125 | |
| 126 | fmt.Fprintln(w, "DELETED RECORD", n) |
| 127 | } |
| 128 | |
| 129 | func drop(w http.ResponseWriter, req *http.Request) { |
| 130 | stmt, err := db.Prepare(`DROP TABLE customer;`) |