Sql中同时删除更新多张表的数据

1、<deleteid="DeleteStuDent"parameterClass="String">BEGINDELETEFROMStudentwhereStuID=#StuID#;DELETEFROMScorewhereScoreID=#ScoreID#;DELETEFROMClasswhereClassID=#ClassID#;DELETEFROMTeacherwhereTeacherID=#TeacherID#;END;</delete>

2、<updateid="UpdateStudent"parameterClass="StudentEntity">BEGINUPDATEStudentSETStuName=#StuName#,StuAge=#StuAge#WHEREStuID=#StuID#;UPDATEScoreSETStuState=2whereStuID=#StuID#;;UPDATEClassSETClaState=2whereStuID=#StuID#;;UPDATETeacherSETTeacherState=2whereStuID=#StuID#;;END;</update>

3、一个方法 通过begin end 语句块吧同时执行的SQL语句包含起来，同时以分号隔开即可