myBatis系列之六：与SpringMVC集成

myBatis系列之一：搭建开发环境
myBatis系列之二：以接口方式交互数据
myBatis系列之三：增删改查
myBatis系列之四：关联数据的查询
myBatis系列之五：与Spring3集成
myBatis系列之七：事务管理


在myBatis系列之五：与Spring3集成基础上：

1. 往pom.xml添加SpringMVC和Freemarker依赖：

  <properties>
    <freemarker.version>2.3.19</freemarker.version>
    <servlet.version>2.5</servlet.version>
  </properties>

  <dependency>  
    <groupId>org.freemarker</groupId>  
    <artifactId>freemarker</artifactId>  
    <version>${freemarker.version}</version>  
  </dependency>
  <dependency>
    <groupId>javax.servlet</groupId>  
    <artifactId>servlet-api</artifactId>  
    <version>${servlet.version}</version>
    <scope>provided</scope>
  </dependency>

2. 在web.xml中加入Spring的监听器和SpringMVC的servlet：

<listener>
  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class><!-- 监听容器事件，初始化和关闭Web应用上下文并调用ContextCleanupListener清理资源 -->
</listener>
<listener>
  <listener-class>org.springframework.web.context.ContextCleanupListener</listener-class><!-- Web应用关闭时，清理ServletContext中spring相关的可销毁资源 -->
</listener>

<servlet>
  <servlet-name>hbatis</servlet-name>
  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  <!--<init-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>/WEB-INF/hbatis-servlet.xml</param-value>
  </init-param>--><!-- 未配置时，SpringMVC会到WEB-INF目录下找${project.name}-servlet.xml -->
  <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
  <servlet-name>hbatis</servlet-name>
  <url-pattern>*.htm</url-pattern>
</servlet-mapping>

3. 在WEB-INF下新建：

Spring配置文件applicationContext.xml：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:p="http://www.springframework.org/schema/p"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">

  <context:property-placeholder location="classpath:/database.properties" /><!-- 数据库配置文件 -->

  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
  	p:driverClassName="${driverClassName}"
	p:url="${url}"
	p:username="${user_name}"
	p:password="${password}" /><!-- 数据源配置 -->
  
  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- sqlSessionFactory对象 -->
  	<property name="dataSource" ref="dataSource" /><!-- 数据源 -->
	<property name="configLocation" value="classpath:Configuration.xml" /><!-- myBatis配置文件 -->
	<!--<property name="mapperLocations" value="classpath*:com/john/hbatis/model/*.xml" />--><!-- 可以在Configuration.xml或此处配置映射文件，但其中不能有相同id的parameterMap, resultMap或sql等 -->
  </bean>
  
  <bean id="mapperConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer"><!-- 扫描指定包以获取映射器 -->
  	<property name="basePackage" value="com.john.hbatis.mapper" />
  </bean>
</beans>

类路径下的database.properties：

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf8
user_name=root
password=123456

注：因为MapperScannerConfigurer可能会导致username取的是系统用户的账号，而造成数据库连接失败，所以改成其它值：user_name。

SpringMVC配置文件hbatis-servlet.xml：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:context="http://www.springframework.org/schema/context"
 xmlns:mvc="http://www.springframework.org/schema/mvc"
 xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
 http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
 http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">

  <mvc:annotation-driven /><!-- 注册RequestMappingHandlerMapping, RequestMappingHandlerAdapter和ExceptionHandlerExceptionResolver以提供对@RequestMapping,@ExceptionHandler等注解的支持 -->

  <context:component-scan base-package="com.john.hbatis.controller" /><!-- 扫描控制器包下有特定注解的类，并实例化和依赖注入 -->

  <!-- FreeMarker视图处理器 -->
  <bean id="viewResolverFtl" class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver">  
    <property name="viewClass" value="org.springframework.web.servlet.view.freemarker.FreeMarkerView"/>  
    <property name="contentType" value="text/html;charset=utf-8"/>  
    <property name="prefix" value="" />  
    <property name="cache" value="false"/>  
    <property name="viewNames">  
        <array>  
            <value>*.ftl</value>  
        </array>  
    </property>  
    <!--<property name="suffix" value=".ftl"/>-->  
    <property name="order" value="0"/><!-- 优先级，数值越小优先级越高 -->  
  </bean>

  <bean id="freemarkerConfig" class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer">  
    <property name="templateLoaderPaths">  
        <list>  
            <value>/WEB-INF/ftl/</value><!-- 模板加载路径 -->  
        </list>  
    </property>  
  </bean>
</beans>

4. MVC：

控制层：UserController.java

@Controller
@RequestMapping("/article")
public class UserController {

	@Autowired
	IUserMapper mapper;

	@RequestMapping("/list")
	public String showAll(ModelMap modelMap) {
		List<Article> articles = mapper.getArticlesByUserId(1);
		modelMap.addAttribute("articles", articles);
		return "main.ftl";
	}
}

视图层：main.ftl:

<#list articles as article>
	<div>${article.id}. ${article.title}: ${article.content}</div>
</#list>

5. 启动工程，浏览器输入：http://localhost:8080/hbatis/article/list.htm查看结果。

参考：
http://www.yihaomen.com/article/java/318.htm