整合的方式新建 maven 项目

引入依赖包

配置资源文件

案例实操新建 maven 项目新建 maven 项目 spring_mybatis

目录结构如下:

主目录包:

com.xxx.dao、

com.xxx.mapper、

com.xxx.service、

com.xxx.service.impl

测试包：spring_mybatis

引入依赖包打开 pom.xml 开始添加依赖包

4.0.0

com.xxx test-xxxms 1.0-SNAPSHOT

test-xxxms

www.example.com

UTF-8 1.7 1.7 junit junit 4.11 test

<!-- spring 核心jar -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>4.3.2.RELEASE</version>
</dependency>

<!-- spring 测试jar -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-test</artifactId>
  <version>4.3.2.RELEASE</version>
</dependency>

<!-- spring jdbc -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-jdbc</artifactId>
  <version>4.3.2.RELEASE</version>
</dependency>

<!-- spring事物 -->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-tx</artifactId>
  <version>4.3.2.RELEASE</version>
</dependency>

<!-- c3p0 连接池 -->
<dependency>
  <groupId>c3p0</groupId>
  <artifactId>c3p0</artifactId>
  <version>0.9.1.2</version>
</dependency>

<!-- mybatis -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>3.4.1</version>
</dependency>

<!-- 添加mybatis与Spring整合的核心包 -->
<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis-spring</artifactId>
  <version>1.3.0</version>
</dependency>

<!-- mysql 驱动包 -->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.39</version>
</dependency>

<!-- 日志打印相关的jar -->
<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-log4j12</artifactId>
  <version>1.7.2</version>
</dependency>

<dependency>
  <groupId>org.slf4j</groupId>
  <artifactId>slf4j-api</artifactId>
  <version>1.7.2</version>
</dependency>

tpl-web

<resources>
  <resource>
    <directory>src/main/java</directory>
    <includes>
      <include>**/*.xml</include>
    </includes>
  </resource>
  <resource>
    <directory>src/main/resources</directory>
    <includes>
      <include>**/*.xml</include>
      <include>**/*.properties</include>
    </includes>
  </resource>
</resources>

配置资源文件 a) Spring 文件 spring.xml

b) Mybatis 文件 mybatis.xml

c) 数据库连接 properties 文件 db.properties

d) 日志输出文件 log4j.properties

spring.xml 文件配置

<context:component-scan base-package="com.xxx"/>

<context:property-placeholder location="db.properties"/>

<tx:annotation-driven  transaction-manager="txManager"/>

<!-- 配置c3p0 数据源  -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="${jdbc.driver}"></property>
    <property name="jdbcUrl" value="${jdbc.url}"></property>
    <property name="user" value="${jdbc.user}"></property>
    <property name="password" value="${jdbc.password}"></property>
</bean>

<bean id="txManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"></property>
</bean>

<!-- 配置 sqlSessionFactory-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <!-- 数据源 -->
    <property name="dataSource" ref="dataSource"></property>
    <!-- 框架的配置文件 -->
    <property name="configLocation" value="classpath:mybatis.xml" />
    <!-- 映射文件 -->
    <property name="mapperLocations" value="classpath:com/xxx/dao/mapper/*.xml" />
</bean>

<!-- 配置扫描器 -->
<bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <!-- 扫描com.xxx.dao这个包以及它的子包下的所有映射接口类 -->
    <property name="basePackage" value="com.xxx.dao" />
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
</bean>

mybatis.xml 文件配置

<!--别名的配置  每个人必须会 -->
<typeAliases>
    <package name="com.xxx.model"/>
</typeAliases>

db.properties 文件配置（对于其它数据源属性配置，见 c3p0 配置讲解，这里采用默认属性配置）建立数据库 mybatis（注意数据库，用户名，密码以自己本地数据库为准）

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=

utf8

jdbc.username=root

jdbc.password= log4j.properties 便于控制台日志输出

Global logging configuration

log4j.rootLogger=DEBUG, stdout

Console output...

log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n 扩展开始编写 helloworld User 实体类定义 public class User {

private int id; 

private String userName; 

private String userPwd; 

public int getId() { 

	return id; 

} 

public void setId(int id) { 

	this.id = id; 

} 

public String getUserName() { 

	return userName; 

} 

public void setUserName(String userName) { 

	this.userName = userName; 

} 

public String getUserPwd() { 

	return userPwd; 

} 

public void setUserPwd(String userPwd) { 

	this.userPwd = userPwd; 

} 

@Override 

public String toString() { 

	return "User [id=" + id + ", userName=" + userName + ", userPwd=" 

\+ userPwd + "]"; 

}

} UseDao 接口与映射文件定义 UserDao 接口

public interface UserDao {

public User queryUserById(int id);

} UserMapper.xml(注意：此时映射文件命名空间定义要符合规则：接口包名.接口类

名,否则不按规则出牌，测试会报错，然后你就蒙圈了！！！)

select id,userName,userPwd from user where id=#{id} UserService 接口类与实现类定义 public interface UserService {

public User queryUserById();

} UserServiceImpl 实现类(此时直接注入我们的 UserDao 接口即可，然后直接调用

其方法，事已至此，离成功仅差一步！)

@Service

public class UserServiceImpl implements UserService{

@Resource 

private UserDao userDao; 

public User queryUserById(){ 

	return userDao.queryUserById(7);  

}

} junit 测试因为与 spring 框架集成，我们采用 spring 框架测试 spring Test

@RunWith(SpringJUnit4ClassRunner.class)

@ContextConfiguration(locations = {"classpath:spring.xml"} )

public class TestSpringMybatis {

@Autowired 

private UserService userService; 

@Test 

public void testQueryUserById() { 

	System.out.println(userService.queryUserById(1)); 

}

}

两大热门框架 Spring 与 Mybatis 如何整合呢？

Global logging configuration

Console output...