# 初始化 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://img.kancloud.cn/e8/32/e83201878bd265fcf95b8a22372637ee_553x156.png) # 集成测试 ![](https://img.kancloud.cn/7c/ac/7cacd94201be6c0ce4602325fe8df173_707x369.gif) # 参考文档 | 名称 | 链接 | 预计学习时长(分) | | --- | --- | --- | [https://www.runoob.com/mysql/mysql-delete-query.html](https://www.runoob.com/mysql/mysql-delete-query.html)