主講人：吳佳云延遲符任務3.3員工基本信息管理動態(tài)SQL與關聯(lián)映射員工基本信息管理模塊員工基本信息管理模塊，主要實現(xiàn)員工信息的增加、修改、刪除、查看等功能。本任務以查看所有員工信息為例講解實施過程，其開發(fā)過程如下：數(shù)據(jù)訪問層設計：主要包括員工管理的接口和實現(xiàn)（如：UserMapper和UserMapper.xml）業(yè)務層設計：主要包括service接口和實現(xiàn)（如：UserService和UserServiceImpl）控制層設計：主要包括servlet（如：UserServlet）視圖層設計：主要為顯示員工頁面(如：userList.jsp)查看員工列表(1)數(shù)據(jù)庫準備CREATETABLE`tb_user`(

`userId`intNOTNULLAUTO_INCREMENT,

`userName`varchar(50)DEFAULTNULL,

`jobNumber`varchar(50)DEFAULTNULL,

`userPassword`varchar(50)DEFAULTNULL,

`gender`intDEFAULTNULL,

`userState`intDEFAULTNULL,

`roleId`intDEFAULTNULL,

`departId`intDEFAULTNULL,

PRIMARYKEY(`userId`)USINGBTREE

)ENGINE=InnoDB查看員工列表(2)實體類User.javaUserVo.java@Data

publicclassUserimplementsSerializable{

/**員工ID*/

privateIntegeruserId;

/**員工姓名*/

privateStringuserName;

/**員工姓名*/

privateStringjobNumber;

/**密碼*/

privateStringuserPassword;

/**性別*/

privateIntegergender;

/**狀態(tài)*/

privateIntegeruserState;

/**權限ID*/

privateIntegerroleId;

/**部門ID*/

privateIntegerdepartId;

}@Data

publicclassUserVo{

/**員工ID*/

privateIntegeruserId;

/**員工姓名*/

privateStringuserName;

/**員工姓名*/

privateStringjobNumber;

/**密碼*/

privateStringuserPassword;

/**性別*/

privateIntegergender;

/**狀態(tài)*/

privateIntegeruserState;

/**權限ID*/

privateIntegerroleId;

/**部門ID*/

privateIntegerdepartId;

/**部門信息*/

privateDepartmentVodepartment;

}查看員工列表(3)數(shù)據(jù)訪問層UserMapper.javapublicinterfaceUserMapper{

@Select("select*fromtb_userwhereuserId=#{userId}")

@Results(

@Result(column="departId",property="department",

one=@One(select="cn.js.ccit.mapper.DepartmentMapper.getDepartmentById"))

)

UserVogetUserById(IntegeruserId);

@Select("select*fromtb_user")

@Results(

@Result(column="departId",property="department",

one=@One(select="cn.js.ccit.mapper.DepartmentMapper.getDepartmentById"))

)

List<UserVo>getAllUser();

}查看員工列表(4)業(yè)務邏輯層UserService.javaUserServiceImpl.javapublicinterfaceUserService{

/**查詢用戶列表*/

List<UserVo>getAllUser();

UserVogetUserById(Integerid);

}publicclassUserServiceImplimplementsUserService{

UserMapperuserMapper=MyBatisUtils.getSession().getMapper(UserMapper.class);

@Override

publicList<UserVo>getAllUser(){

returnuserMapper.getAllUser();

}

@Override

publicUserVogetUserById(IntegeruserId){

returnuserMapper.getUserById(userId);

}

}查看員工列表(5)控制端UserServlet.java@WebServlet("/userServlet")

publicclassUserServletextendsHttpServlet{

UserServiceuserService=newUserServiceImpl();

@Override

protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp)throwsServletException,IOException{

//獲取參數(shù)

StringuserIdStr=req.getParameter("userId");

List<UserVo>userList=newArrayList<>();

if(StringUtils.isNullOrEmpty(userIdStr)){

//查詢員工信息列表

userList=userService.getAllUser();

}else{

//根據(jù)ID查詢員工信息

UserVouser=userServic