在Student.xml中添加如下代碼:
<delete id="deleteStudentById" parameterClass="int">
delete
from student
where id=#id#
</delete>
在junit中進行測試:
1 @Test
2 public void deleteStudent() throws Exception{//根據Id刪除學生
3 Reader reader=Resources.getResourceAsReader("SqlMapConfig.xml");//讀取總配置文件
4 SqlMapClient sqlmapclient=SqlMapClientBuilder.buildSqlMapClient(reader);//創建SqlMapClient來操作數據庫
5 reader.close();
6 sqlmapclient.delete("deleteStudentById",5);//調用我們寫在xml中的sql語句
7 }
查看數據庫,已成功刪除: