JavaEE企業(yè)級項(xiàng)目開發(fā)（第3版）課件 微課7-6：任務(wù)7.2會議審批設(shè)計(jì)

主講人：吳佳云延遲符任務(wù)7.2會議審批設(shè)計(jì)SpringMVC入門與核心類會議審批設(shè)計(jì)

會議審批通常操作是部門負(fù)責(zé)人登錄后查看會議列表，點(diǎn)擊“審批”按鈕進(jìn)入會議審批頁面，根據(jù)會議審批的內(nèi)容判斷是否同意會議，會議審批后進(jìn)入結(jié)果頁面。

會議審批分為兩個(gè)業(yè)務(wù)流程：查詢所有會議審批信息、審批會議審批信息。會議審批模塊按照分層方式設(shè)計(jì)，共分為5個(gè)步驟：DAO層、Servicice層、視圖層設(shè)計(jì)、控制層設(shè)計(jì)、Bean的配置。會議審批設(shè)計(jì)(1)DAO層設(shè)計(jì)MeetingDAO.javapublicbooleanapprovalMeeting(Meetingmeeting){

booleanflag=false;

intid=meeting.getId();

intstauts=0;

StringapprovingPerson="";

StringapprovingDate="";

inti=jdbcTemplate.update(

"updatetb_meetingsetstauts=?,approvingPerson=?,approvingDate=?whereid=?",newObject[]{meeting.getStauts(),

meeting.getApprovingPerson(),

meeting.getApprovingDate(),

meeting.getId()});

if(i>0){

flag=true;

}

returnflag;

}會議審批設(shè)計(jì)(2)Service層設(shè)計(jì)MeetingService.java//查詢所有會議申請信息

publicListgetAllMeeting(){

returnmeetingDAO.getAllMeeting();

}

//審批會議

publicbooleanapprovalMeeting(Meetingmeeting){

returnmeetingDAO.approvalMeeting(meeting);

}會議審批設(shè)計(jì)(3)視圖層設(shè)計(jì)會議審批設(shè)計(jì)(4)控制層設(shè)計(jì)MeetingController.java@RequestMapping("/approvalMeeting")

//審批會議

publicStringapproval(HttpServletRequestrequest,

HttpServletResponseresponse)throwsException{

StringidStr=request.getParameter("id");//獲取id

if(idStr==null){

idStr="0";

}

intid=Integer.parseInt(idStr);

StringstautsStr=request.getParameter("status");

intstauts=Integer.parseInt(stautsStr);

//設(shè)定審批人

StringapprovingPerson="院辦主任";

//審批日期

Datedate=newDate();

SimpleDateFormatsimple=newSimpleDateFormat("yyyy-MM-dd");

StringapprovingDate=simple.format(date);

Meetingmeeting=newMeeting();

meeting.setId(id);

meeting.setStauts(stauts);

meeting.setApprovingPerson(approvingPerson);

meeting.setApprovingDate(approvingDate);

booleanresult=meetingService.approvalMeeting(meeting);

return"approvalSuccess";

}會議審批設(shè)計(jì)(5)Bean的配置mvc-config.xml<!--配置數(shù)據(jù)源-->

<beanid="dataSource"class="mons.dbcp2.BasicDataSource">

<propertyname="driverClassName"value="${db.driver}"/>

<propertyname="url"value="${db.url}"/>

<propertyname="username"value="${db.username}"/>

<propertyname="password"value="${db.password}"/>

<propertyname="maxIdle"value="5"/>

</bean>

<beanid="jdbcTemplate"class="org.springframework.jdbc.core.JdbcTe