与Spring3集成

Spring作为基础框架，可以集成后端框架，如Hibernate，MyBatis等。

前面是介绍单独使用MyBatis的，大致逻辑是：

sqlSessionFactory <- configuration file (包括数据库连接配置)

IXxxMapper <- sqlSession <- sqlSessionFactory

<- mapper interface <- mapper xml

得到IxxMapper后，就可以调用其方法进行数据交互了。

和Spring集成时，上面的这些对象需要作为bean来管理：

dataSource bean <- 数据库连接配置

sqlSessionFactory bean <- dataSource

<- configuration file

userMapper bean <- sqlSessionFactory

<- mapper interface

1. 在pom.xml中加入依赖：

<properties> <mybatis.spring.version>1.2.1</mybatis.spring.version> <dbcp.version>1.4</dbcp.version> <spring.version>3.1.2.RELEASE</spring.version> </properties> <dependencies> <dependency><> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>${mybatis.spring.version}</version> </dependency> <dependency><> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency><> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>${dbcp.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> </dependency> </dependencies>

2. 在类路径下创建beans-da.xml文件：

<"1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <bean id="dataSource"><> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/hbatis?characterEncoding=utf8" /> <property name="username" value="root" /> <property name="password" value="123456" /> </bean> <bean id="sqlSessionFactory"><> <property name="dataSource" ref="dataSource" /><> <property name="configLocation" value="classpath:Configuration.xml" /><> </bean> <bean id="userMapper"><> <property name="sqlSessionFactory" ref="sqlSessionFactory" /> <property name="mapperInterface" value="com.john.hbatis.mapper.IUserMapper" /><> </bean> </beans>

3. 测试类：

@ContextConfiguration(locations = { "classpath:beans-da.xml" }) public class SpringIntegrationTest extends AbstractTestNGSpringContextTests { private static final Logger log = LoggerFactory.getLogger(SpringIntegrationTest.class); @Resource IUserMapper mapper; @Test public void queryTest() { User user = mapper.getUserById(1); log.info("Name: {}, address: {}", user.getName(), user.getAddress()); } }

与SpringMVC集成

这里我们建立在与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><> </listener> <listener> <listener-class>org.springframework.web.context.ContextCleanupListener</listener-class><> </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>--><> <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：

<"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" p:driverClassName="${driverClassName}" p:url="${url}" p:username="${user_name}" p:password="${password}" /><> <bean id="sqlSessionFactory"><> <property name="dataSource" ref="dataSource" /><> <property name="configLocation" value="classpath:Configuration.xml" /><> <><> </bean> <bean id="mapperConfigurer"><> <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：

<"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 /><> <context:component-scan base-package="com.john.hbatis.controller" /><> <> <bean id="viewResolverFtl"> <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="order" value="0"/><> </bean> <bean id="freemarkerConfig"> <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查看结果。

【Java环境中MyBatis与Spring或Spring MVC框架的集成方法】相关文章：

★ java中sdk与jdk的区别详细解析

★ Java中去除字符串中所有空格的几种方法

★ Java中instanceof关键字的用法总结

★ 使用Rhino让java执行javascript的方法实例

★ java 页面url传值中文乱码的解决方法

★ 使用java获取md5值的两种方法

★ 解析Java线程同步锁的选择方法

★ javz笔记之：有趣的静态方法的使用

★ java string类的常用方法详细介绍

★ java string 转date方法如何实现