JavaEE企业级项目开发（第3版）课件 微课7-9：任务7.3会议查询设计

主讲人：吴佳云延迟符任务7.3会议查询设计SpringMVC入门与核心类会议查询设计

本任务基于XML的SSM框架整合的方式开发会议查询模块。该模块设计分为6个步骤：领域对象设计、Dao层设计、Service层设计、视图层设计、控制层设计，Bean的配置，模块设计的重点是SSM框架整合。会议查询设计(1)领域对象设计MeetingCommand.javapublicclassMeetingCommand{

privateStringtitle;

privateStringdepartMent;

……

//一组set/get属性方法

}

会议查询设计(2)Dao层设计MeetingDao.java@Repository

publicclassMeetingDAOimplementsIMeetingDAO{

@Autowired

privateJdbcTemplatejdbcTemplate;

privateStringnotes;

publicJdbcTemplategetJdbcTemplate(){

returnjdbcTemplate;

}

publicvoidsetJdbcTemplate(JdbcTemplatejdbcTemplate){

this.jdbcTemplate=jdbcTemplate;

}

//会议查询

publicListqueryMeeting(Stringtitle,StringdepartMent){

Stringsql="";

ListmeetingList=null;

title=title.trim();

departMent=departMent.trim();

System.out.println("title="+title.trim().equals(""));

System.out.println("departMent="+departMent.trim().equals(""));

if(title.equals("")&&departMent.equals("")){

sql="select*fromtb_meeting";

meetingList=jdbcTemplate.queryForList(sql);

}elseif(!title.equals("")&&departMent.equals("")){

meetingList=jdbcTemplate.queryForList("select*fromtb_meetingwheretitle=?",newObject[]{title});

}elseif(!title.equals("")&&departMent.equals("")){

meetingList=jdbcTemplate.queryForList("select*fromtb_meetingwheredepartMent=?",newObject[]{departMent});

}else{

meetingList=jdbcTemplate.queryForList("select*fromtb_meetingwheretitle=?anddepartMent=?",newObject[]{title,departMent});

}

System.out.println("meetingList.size="+meetingList.size());

returnmeetingList;

}

}会议查询设计(3)Service层设计MeetingService.java@Service

publicclassMeetingServiceimplementsIMeetingService{

@Autowired

privateIMeetingDAOmeetingDAO;

@Autowired

privateMeetingMappermeetingMapper;

publicIMeetingDAOgetMeetingDAO(){

returnmeetingDAO;

}

publicvoidsetMeetingDAO(IMeetingDAOmeetingDAO){

this.meetingDAO=meetingDAO;

}

publicListqueryMeeting(Stringtitle,StringdepartMent){

returnmeetingDAO.queryMeeting(title,departMent);

}

}会议查询设计(4)视图层设计会议查询设计(5)控制层设计MeetingController.java@Controller

@RequestMapping("/meetingController")

publicclassMeetingController{

@Autowired

privateMeetingServicemeetingService;

@RequestMapping("/queryMeetingBymyBatis")

publicStringqueryMeetingBymyBatis(HttpServletRequestrequest,MeetingCommandmeetingCommand,Modelmodel){

Stringtitle=meetingCommand.getTitle();

StringdepartMent=meetingCommand.getDepartMent();

if(title==null)title="";

if(departMent==null)departMent="";

ListmeetingList=meetingService.queryMeetingByMyBatis(title,departMent);

model.addAttribute("meetingList",meetingList);

return"showMeeting";

}

}会议查询设计(6)Bean的配置applicationContext.xml<context:component-scanbase-package="cn.js.ccit"/>

<!--引入java配置文件-->

<context:property-placeholderlocation="classpath:perties"/>

<!--配置数据源-->

<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.JdbcTemplate"

p:dataSource-ref="dataSource"/>

<beanclass="org.springframework.web.servlet.view.InternalResourceViewResolver"