# 初始化 TeacherController ``` @DeleteMapping("{id}") ? @CrossOrigin("*") public void delete(@PathVariable Long id) { } ``` * ? 映射`delete`方法。 # SQL刪除 TeacherController ``` @DeleteMapping("{id}") @CrossOrigin("*") public void delete(@PathVariable Long id) { String sql = String.format( "delete from `teacher` where id = %s", id); ? this.jdbcTemplate.update(sql); } ``` * ? 格式化刪除語句 # 測試 新建`HTTP Request` ``` DELETE http://localhost:8080/Teacher/1 ``` 運行測試： ``` DELETE http://localhost:8080/Teacher/1 HTTP/1.1 200 Content-Length: 0 Date: Mon, 28 Oct 2019 03:12:40 GMT <Response body is empty> Response code: 200; Time: 593ms; Content length: 0 bytes ``` 打開數據表，查看ID為1的記錄是否已刪除  # 集成測試  # 參考文檔 | 名稱 | 鏈接 | 預計學習時長(分） | | --- | --- | --- | [https://www.runoob.com/mysql/mysql-delete-query.html](https://www.runoob.com/mysql/mysql-delete-query.html)