JavaEE企業(yè)級(jí)項(xiàng)目開發(fā)（第3版）課件 微課7-3：任務(wù)7.1會(huì)議申請(qǐng)?jiān)O(shè)計(jì)

主講人：吳佳云延遲符任務(wù)7.1會(huì)議申請(qǐng)?jiān)O(shè)計(jì)SpringMVC入門與核心類會(huì)議申請(qǐng)?jiān)O(shè)計(jì)

會(huì)議申請(qǐng)通常操作是用戶首先提出會(huì)議申請(qǐng)，輸入會(huì)議信息，系統(tǒng)首先判斷信息填寫是否完整，如果不完整則返回，否則將會(huì)議申請(qǐng)信息保存到數(shù)據(jù)庫中。

會(huì)議申請(qǐng)模塊主要功能是輸入會(huì)議信息，提交會(huì)議申請(qǐng)。會(huì)議申請(qǐng)模塊按照分層方式設(shè)計(jì)，共分為5個(gè)步驟：DAO層、Servicice層、視圖層設(shè)計(jì)、控制層設(shè)計(jì)、Bean的配置。會(huì)議申請(qǐng)?jiān)O(shè)計(jì)(1)DAO層設(shè)計(jì)@Repository

publicclassMeetingDAOimplementsIMeetingDAO{

@Autowired

privateJdbcTemplatejdbcTemplate;

privateStringnotes;

publicvoidaddMeeting(Meetingmeeting){

finalStringtitle=meeting.getTitle();

finalStringplace=meeting.getPlace();

//省略部分代碼

finalStringnotes=meeting.getNotes();

jdbcTemplate.update(“insertintotb_meeting(title,place,host,particiPant,departMent,meetingLevel,budget,startDate,startTime,endDate,endTime,stauts,approvingPerson,approvingDate,topic,notes)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)”,newPreparedStatementSetter(){

publicvoidsetValues(PreparedStatementps)throwsSQLException{

ps.setString(1,title);

//省略部分代碼

ps.setString(16,notes);

}

});

}

publicJdbcTemplategetJdbcTemplate(){

returnjdbcTemplate;

}

publicvoidsetJdbcTemplate(JdbcTemplatejdbcTemplate){

this.jdbcTemplate=jdbcTemplate;

}

}MeetingDAO.java會(huì)議申請(qǐng)?jiān)O(shè)計(jì)(2)Service層設(shè)計(jì)@Service

publicclassMeetingServiceimplementsIMeetingService{

@Autowired

privateIMeetingDAOmeetingDAO;

@Autowired

privateMeetingMappermeetingMapper;

publicvoidaddMeeting(Meetingmeeting){

meetingDAO.addMeeting(meeting);

}

publicIMeetingDAOgetMeetingDAO(){

returnmeetingDAO;

}

publicvoidsetMeetingDAO(IMeetingDAOmeetingDAO){

this.meetingDAO=meetingDAO;

}

}MeetingService.java會(huì)議申請(qǐng)?jiān)O(shè)計(jì)(3)視圖層設(shè)計(jì)會(huì)議申請(qǐng)?jiān)O(shè)計(jì)(4)控制層設(shè)計(jì)MeetingController.java@Controller

@RequestMapping("/meetingController")

publicclassMeetingController{

privateStringviewPage;

@Autowired

privateMeetingServicemeetingService;

@RequestMapping("/applyMetting")

publicStringapplyMeeting(HttpServletRequestrequest,HttpServletResponseresponse

,Modelmodel)throwsException{

//獲取會(huì)議申請(qǐng)信息

Stringtitle=request.getParameter("title");

//……

/*通過請(qǐng)求對(duì)象獲取place、host、particiPant、departMent、meetingLevel、budget

、startDate、startTime、endDate、endTime、stauts、approvingPerson

、approvingDate、topic、notes*/

//創(chuàng)建會(huì)議對(duì)象

Meetingmeeting=newMeeting();

meeting.setTitle(title);

//……

/*meeting對(duì)象設(shè)置place、host、particiPant、departMent、meetingLevel、budget

、startDate、startTime、endDate、endTime、stauts、approvingPerson

、approvingDate、topic、notes*/

//調(diào)用會(huì)議申請(qǐng)服務(wù)的方法

meetingService.addMeeting(meeting);

model.addAttribute("meeting",meeting);

return"addMeetingSuccess";

}

}會(huì)議申請(qǐng)?jiān)O(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.springframewo