操作方法
<delete id="DeleteStuDent" parameterClass="String"> BEGIN DELETE FROM Student where StuID=#StuID#; DELETE FROM Score where ScoreID=#ScoreID#; DELETE FROM Class where ClassID=#ClassID#; DELETE FROM Teacher where TeacherID=#TeacherID#; END; </delete>
<update id="UpdateStudent" parameterClass="StudentEntity"> BEGIN UPDATE Student SET StuName=#StuName#,StuAge=#StuAge# WHERE StuID=#StuID#; UPDATE Score SET StuState=2 where StuID=#StuID#; ; UPDATE Class SET ClaState =2 where StuID=#StuID#; ; UPDATE Teacher SET TeacherState =2 where StuID=#StuID#; ; END; </update>
一个方法 通过begin end 语句块吧同时执行的SQL语句包含起来，同时以分号隔开即可