mybatis与spring整合（基于配置文件）
? 本文主要介绍了如何将mybatis和spring整合在一起使用，本人使用的是mybatis3.05 + spring3.1.0M2 ，使用dbcp作为数据库连接池。
1.编写数据访问接口（UserDao.java）
package com.mybatis;publicinterface UserDao {??? publicint countAll();}2.编写数据访问接口映射文件（UserDaoMapper.xml）
?
<?xml version="1.0" encoding="UTF-8" ?>? <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.mybatis.UserDao">??? <select id="countAll" resultType="int">??????? select count(*) c from user;??? </select></mapper>
?
3.编写mybatis配置文件（MyBatis-Configuration.xml）
?
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>??? <mappers>??????? <mapper resource="com/mybatis/UserDaoMapper.xml"/>??? </mappers></configuration>
?
4.编写服务层接口（UserService.java）
package com.mybatis;publicinterface UserService {??? publicint countAll();}5.编写服务层实现代码（UserServiceImpl.java）
?
package com.mybatis;publicclass UserServiceImpl implements UserService {??? private UserDao userDao;??? public UserDao getUserDao() {??????? return userDao;??? }??? publicvoid setUserDao(UserDao userDao) {??????? this.userDao = userDao;??? }??? ??? publicint countAll() {??????? returnthis.userDao.countAll();??? }}?
6.编写spring配置文件（applicationContext.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"??? xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">??? <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">??????? <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>??????? <property name="url" value="jdbc:mysql://localhost:3306/hlp?useUnicode=true& characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull"> </property>??????? <property name="username" value="root"></property>??????? <property name="password" value="1234"></property>??????? <property name="maxActive" value="100"></property>??????? <property name="maxIdle" value="30"></property>??????? <property name="maxWait" value="500"></property>??????? <property name="defaultAutoCommit" value="true"></property>??? </bean>??? <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">??????? <property name="configLocation" value="classpath:MyBatis-Configuration.xml"> </property>??????? <property name="dataSource" ref="dataSource"/>??? </bean>??? <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">??????? <property name="mapperInterface" value="com.mybatis.UserDao"></property>??????? <property name="sqlSessionFactory" ref="sqlSessionFactory"></property>??? </bean>??? <bean id="userService" class="com.mybatis.UserServiceImpl">??????? <property name="userDao" ref="userDao"></property>??? </bean></beans>
?
7.测试代码（UserServiceTest.java）
?
package com.mybatis;import org.junit.Test;import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;publicclass UserServiceTest {??? ??? @Test??? publicvoid userServiceTest(){??????? ApplicationContext context = new ClassPathXmlApplicationContext ("applicationContext.xml");??????? UserService userService = (UserService)context.getBean("userService");??????? System.out.println(userService.countAll());??? }}?
?
?
?