Mybatis和Spring整合

1.引入相关依赖

<dependencies>
  <!-- Spring相关jar包 -->
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-context</artifactId>
  		<version>4.3.21.RELEASE</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-orm</artifactId>
  		<version>4.3.21.RELEASE</version>
  	</dependency>
  	<!-- mybatis依赖 -->
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis</artifactId>
  		<version>3.4.6</version>
  	</dependency>
  	<!-- mysql驱动包 -->
  	<dependency>
  		<groupId>mysql</groupId>
  		<artifactId>mysql-connector-java</artifactId>
  		<version>5.1.34</version>
  	</dependency>
  	<!-- 日志框架 -->
  	<dependency>
  		<groupId>org.slf4j</groupId>
  		<artifactId>slf4j-log4j12</artifactId>
  		<version>1.7.25</version>
  	</dependency>
  	<!-- mybatis和spring整合包 -->
  	<dependency>
  		<groupId>org.mybatis</groupId>
  		<artifactId>mybatis-spring</artifactId>
  		<version>1.3.2</version>
  	</dependency>
  	<!-- c3p0 -->
  	<dependency>
  		<groupId>com.mchange</groupId>
  		<artifactId>c3p0</artifactId>
  		<version>0.9.5.3</version>
  	</dependency>
  	<!-- 单元测试 -->
  	<dependency>
  		<groupId>junit</groupId>
  		<artifactId>junit</artifactId>
  		<version>4.12</version>
  	</dependency>
  </dependencies>

2.创建配置文件

 2.1 mybatis的全局配置文件

<?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>

</configuration>

2.2 spring的配置文件

<?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:tx="http://www.springframework.org/schema/tx"
	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-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">

	<!-- 开启扫描 -->
		<context:component-scan base-package="com.i.service.impl"/>
	<!-- 引入第三方属性文件  注意:在web项目中要加 " classpath: " -->
		<context:property-placeholder location="db.properties"/>
		
	<!-- 配置数据源 -->
		<bean class="com.mchange.v2.c3p0.ComboPooledDataSource" id="dataSource">
			<property name="driverClass" value="${jdbc.driver}"/>
			<property name="jdbcUrl" value="${jdbc.url}"/>
			<property name="user" value="${jdbc.name}"/>
			<property name="password" value="${jdbc.password}"/>
		</bean>
	<!-- 整合Mybatis  当spring容器加载时 会同步加载mybatis中的SqlSessionFactory对象-->
		<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactoryBean">
			<!-- 配置Mybatis的配置文件  如果是在web项目中  同样要加上 "classpath" -->
				<property name="configLocation" value="mybatis-cfg.xml"/>
			<!-- 配置关联数据源 -->
				<property name="dataSource" ref="dataSource"/>
			<!-- 配置别名 -->
				<property name="typeAliasesPackage" value="com.i.pojo"/>
		</bean>
				
	<!-- 配置Mybatis接口扫描路径 -->
		<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
			<property name="basePackage" value="com.i.dao"/>
		</bean>
</beans>

注意如果接口映射文件和接口文件不在同一个包下可以如下配置:

<!-- 整合mybatis -->
<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactoryBean">
	<!-- 关联mybatis的全局配置文件 -->
	<property name="configLocation" value="classpath:mybatis-conf.xml"/>
	<!-- 关联数据源 -->
	<property name="dataSource" ref="dateSource"/>
	<!-- 给package取别名 -->
	<property name="typeAliasesPackage" value="com.i.model"/>
	<!-- 映射文件和接口文件不在同一个目录下的时候 -->
	<property name="mapperLocations" value="classpath:mapper/*.xml"/>
</bean>

3. db.properties文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/demo?useSSL=true&useUnicode=true&characterEncoding=utf-8
jdbc.name=root
jdbc.password=1234

4. log4j.properties文件

log4j.logger.com.i.mapper=DEBUG, CONSOLE,LOGFILE

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender 
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=-%c-%M-%d{yyyy-MM-dd HH:mm:ss,SSS}-%m%n

log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=D:/axis.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=-%c-%M-%d{yyyy-MM-dd HH:mm:ss,SSS}-%m%n

测试

Mapper接口和映射文件

public interface FlowerMapper {
	List<Flower> query();
}

<?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.i.dao.FlowerMapper">
	<select id="query" resultType="flower">
		SELECT * FROM flower
	</select>
</mapper>

service

public interface FlowerService {
	List<Flower> query();
}

@Service
public class FlowerServiceImpl implements FlowerService{

	@Resource
	private FlowerMapper flower;

	@Override
	public List<Flower> query() {
		return flower.query();
	}
}

测试方法

@Test
	public void test() {
		ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
		FlowerService fl = ac.getBean(FlowerService.class);
		List<Flower> query = fl.query();
		for (Flower f : query) {
			System.out.println(f);
		}
	}