JavaEE企业级项目开发（第3版）课件 微课3-8：任务3.2部门信息管理

主讲人：吴佳云延迟符任务3.2部门信息管理动态SQL与关联映射部门信息管理模块部门信息管理模块，主要实现部门信息的增加、修改、删除、查看等功能。本任务主要以删除部门信息为例讲解实施过程，其开发过程如下：数据访问层设计：主要包括部门管理的接口和对象映射文件（如：DepartmentMapper.java和DepartmentMapper.xml）和在mybatis-config.xml中配置mybatis的映射文件业务层设计：主要包括service接口和其实现（如：DepartmentService和DepartmentServiceImpl）控制层设计：主要包括servlet（如：DepartmentServlet）视图层设计：主要为显示机构页面(如：departmentList.jsp)删除部门信息(1)数据库准备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)实体类@Data

publicclassDepartment{

/**部门ID*/

privateIntegerdepartId;

/**机构ID*/

privateIntegerbranchId;

/**部门名称*/

privateStringdepartName;

/**部门电话*/

privateStringtel;

/**部门电话*/

privateStringphone;

/**部门传真*/

privateStringfax;

/**备注*/

privateStringremark;

}Department.javaDepartmentVo.java@Data

publicclassDepartmentVo{

/**部门ID*/

privateIntegerdepartId;

/**部门名称*/

privateStringdepartName;

/**部门电话*/

privateStringtel;

/**部门电话*/

privateStringphone;

/**部门传真*/

privateStringfax;

/**备注*/

privateStringremark;

/**机构信息*/

privateBranchbranch;

}删除部门信息(3)数据访问层DepartmentMapper.javapublicinterfaceDepartmentMapper{

/**

查询部门列表

List<DepartmentVo>getAllDepartment();

/**

根据ID删除部门信息

*/

booleandeleteDepartmentById(IntegerdepartId);

}删除部门信息(3)数据访问层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"/>

<!--机构信息-->

<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)业务逻辑层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");//获取参数

if(!StringUtils.isNullOrEmpty(departIdStr)){

//