部门删除分析
(1)尝试删除指定id的部门数据 (2)如果当前部门没有给其他部门作上级,则可以删除成功,否则删除失败 》1 判断是否有没有给其他部门作上级 》2 再删除
# 判断 记录数== 0 是可删除的
select count ( * ) from pe_dept where parent_id= #{ deptId}
delete from pe_dept where dept_id= #{ deptId}
部门删除后台
TestDeptService
@Test
public void test06 ( ) {
String deptId= "100" ;
boolean result= service. deleteDeptById ( deptId) ;
l. info ( "test06 result=" + result) ;
}
IDeptService
boolean deleteDeptById ( String deptId) ;
DeptServiceImpl
@Override
public boolean deleteDeptById ( String deptId) {
int count= dao. findParentCount ( deptId) ;
if ( count== 0 ) {
dao. deleteById ( deptId) ;
return true ;
} else {
return false ;
}
}
IDeptDao
void deleteById ( String deptId) ;
IDeptDao.xml
< select id = " findParentCount" parameterType = " string" resultType = " int" >
select count(*) from pe_dept where parent_id=#{deptId}
</ select>
< delete id = " deleteById" parameterType = " string" >
delete from pe_dept where dept_id=#{deptId}
</ delete>
部门删除前台
dept-list.jsp
location.href="${path}/system/dept/delete.do?deptId="+deptId;
DeptController
@RequestMapping ( path = "/delete" , method = RequestMethod. GET)
public String delete ( String deptId) {
l. info ( "delete deptId=" + deptId) ;
service. deleteDeptById ( deptId) ;
return "redirect:/system/dept/toList.do" ;
}