主講人：吳佳云延遲符任務(wù)3.2部門信息管理動態(tài)SQL與關(guān)聯(lián)映射部門信息管理模塊部門信息管理模塊，主要實(shí)現(xiàn)部門信息的增加、修改、刪除、查看等功能。本任務(wù)主要以刪除部門信息為例講解實(shí)施過程，其開發(fā)過程如下：數(shù)據(jù)訪問層設(shè)計：主要包括部門管理的接口和對象映射文件（如：DepartmentMapper.java和DepartmentMapper.xml）和在mybatis-config.xml中配置mybatis的映射文件業(yè)務(wù)層設(shè)計：主要包括service接口和其實(shí)現(xiàn)（如：DepartmentService和DepartmentServiceImpl）控制層設(shè)計：主要包括servlet（如：DepartmentServlet）視圖層設(shè)計：主要為顯示機(jī)構(gòu)頁面(如：departmentList.jsp)刪除部門信息(1)數(shù)據(jù)庫準(zhǔn)備CREATETABLE`tb_department`(

`departId`intNOTNULLAUTO_INCREMENT,

`branchId`intNOTNULL,

`departName`varchar(50)DEFAULTNULL,

`tel`varchar(50)DEFAULTNULL,

`phone`varchar(50)DEFAULTNULL,

`fax`varchar(50)DEFAULTNULL,

`remark`varchar(50)DEFAULTNULL,

PRIMARYKEY(`departId`)USINGBTREE

)ENGINE=InnoDB刪除部門信息(2)實(shí)體類@Data

publicclassDepartment{

/**部門ID*/

privateIntegerdepartId;

/**機(jī)構(gòu)ID*/

privateIntegerbranchId;

/**部門名稱*/

privateStringdepartName;

/**部門電話*/

privateStringtel;

/**部門電話*/

privateStringphone;

/**部門傳真*/

privateStringfax;

/**備注*/

privateStringremark;

}Department.javaDepartmentVo.java@Data

publicclassDepartmentVo{

/**部門ID*/

privateIntegerdepartId;

/**部門名稱*/

privateStringdepartName;

/**部門電話*/

privateStringtel;

/**部門電話*/

privateStringphone;

/**部門傳真*/

privateStringfax;

/**備注*/

privateStringremark;

/**機(jī)構(gòu)信息*/

privateBranchbranch;

}刪除部門信息(3)數(shù)據(jù)訪問層DepartmentMapper.javapublicinterfaceDepartmentMapper{

/**

查詢部門列表

List<DepartmentVo>getAllDepartment();

/**

根據(jù)ID刪除部門信息

*/

booleandeleteDepartmentById(IntegerdepartId);

}刪除部門信息(3)數(shù)據(jù)訪問層DepartmentMapper.xml<mappernamespace="cn.js.ccit.mapper.DepartmentMapper">

<resultMapid="departmentVoMap"type="cn.js.ccit.vo.DepartmentVo">

<resultproperty="departId"column="departId"/>

<resultproperty="departName"column="departName"/>

<resultproperty="tel"column="tel"/>

<resultproperty="phone"column="phone"/>

<resultproperty="fax"column="fax"/>

<resultproperty="remark"column="remark"/>

<!--機(jī)構(gòu)信息-->

<associationproperty="branch"column="branchId"

javaType="cn.js.ccit.entity.Branch">

<idproperty="branchId"column="branchId"/>

<resultproperty="branchName"column="branchName"/>

<resultproperty="remark"column="bremark"/>

</association>

</resultMap>

<selectid="getAllDepartment"resultMap="departmentVoMap">

selectd.*,b.branchNameasbranchName,b.remarkasbremark

fromtb_departmentd,tb_branchb

whered.branchId=b.branchId

</select>

<deleteid="deleteDepartmentById">

deletefromtb_department

wheredepartId=#{departId}

</delete>

</mapper>刪除部門信息(4)業(yè)務(wù)邏輯層DepartmentService.javapublicinterfaceDepartmentService{

/**查詢部門列表*/

List<DepartmentVo>getAllDepartment();

/**刪除部門*/

booleandeleteDepartmentById(IntegerdepartmentId);

}DepartmentServiceImpl.javapublicclassDepartmentServiceImplimplementsDepartmentService{

DepartmentMapperdepartmentMapper=MyBatisUtils.getSession().getMapper(DepartmentMapper.class);

@Override

publicList<DepartmentVo>getAllDepartment(){

returndepartmentMapper.getAllDepartment();

}

@Override

publicbooleandeleteDepartmentById(IntegerdepartId){

returndepartmentMapper.deleteDepartmentById(departId);

}

}刪除部門信息(5)控制端DepartmentServlet.java@WebServlet("/departmentServlet")

publicclassDepartmentServletextendsHttpServlet{

DepartmentServicedepartmentService=newDepartmentServiceImpl();

protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{

//查詢部門信息列表

Departmentdepartment=newDepartment();

List<DepartmentVo>departmentList=departmentService.getAllDepartment();

req.setAttribute("departmentList",departmentList);

}

protectedvoiddoDelete(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{

StringdepartIdStr=req.getParameter("departId");//獲取參數(shù)

if(!StringUtils.isNullOrEmpty(departIdStr)){

//