Mybatis和spring整合

新建web工程

工程目录

加入jar包

jar包列表

项目代码

//#User.java
package com.lee.domain;

public class User {
	private int userid;
	private String name;
	private String password;
	private int money;
	public int getUserid() {
		return userid;
	}
	public void setUserid(int userid) {
		this.userid = userid;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public int getMoney() {
		return money;
	}
	public void setMoney(int money) {
		this.money = money;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
}

//#UserMapper.java,Mybatis封装的mapper代理接口
package com.lee.mapper;

import java.util.List;

import com.lee.domain.User;

public interface UserMapper {
	
	public User selectUserById(int id);
	
	public void deleteUser(int id);
	
	public void addUser(User user);
	
	public List<User> selectUserByName(String name);
}

//#UserMapper.xml,Mybatis的映射文件
<?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.lee.mapper.UserMapper">
<!-- 通过id查询user --> 
  <select id="selectUserById" parameterType="int" resultType="com.lee.domain.User">
    select * from user where userid = #{value}
  </select>
  
  <!-- 通过id删除user -->
  <select id="deleteUser" parameterType="int">
    delete from user where userid = #{value}
  </select>
  
  <!-- 新增一条user记录 -->
  <select id="addUser" parameterType="com.lee.domain.User">
    insert into user (userid,name,password,money) values(#{userid},#{name},#{password},#{money})
  </select>
  
  <!-- 通过那么查询一个user的list集合 -->
  <select id="selectUserByName" parameterType="String" resultType="com.lee.domain.User">
    select * from user where name = #{value}
  </select>
</mapper>

//#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>
  <mappers>
  	<!-- 原始加载mapper，一条条的写 -->
    <!-- <mapper resource="domain/UserMapper.xml"/> -->
    
    <!-- 批量扫描，指定mapper接口的包名
    	规定，mapper接口名和mapper.xml名必须一致且在同一目录中
    	规范前提是，使用mapper代理，这里的任务是批量引入mapper.xml
    	spring的加载器帮助完成了此功能，并且实例化mapper.java
     -->
     <!-- <package name="com.lee.mapper"/> -->
  </mappers>
</configuration>

//#log4j配置文件
# Global logging configuration
log4j.rootLogger=debug, stdout
# MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE
# 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

//#db.properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///sun
jdbc.username=root
jdbc.password=sunshine

//#ApplicationContext.xml，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:tx="http://www.springframework.org/schema/tx"  
    xmlns:context="http://www.springframework.org/schema/context"  
    xmlns:aop="http://www.springframework.org/schema/aop"  
    xsi:schemaLocation="http://www.springframework.org/schema/beans   
                  http://www.springframework.org/schema/beans/spring-beans-3.2.xsd  
                  http://www.springframework.org/schema/context  
                  http://www.springframework.org/schema/context/spring-context-3.2.xsd  
                  http://www.springframework.org/schema/aop   
                  http://www.springframework.org/schema/aop/spring-aop.xsd        
                 http://www.springframework.org/schema/tx   
                 http://www.springframework.org/schema/tx/spring-tx-3.2.xsd"> 
	
	<!-- 加载db.proterties配置文件，读取内容 -->
	<context:property-placeholder location="classpath:db.properties"/>
	
	<!-- 数据源配置 -->
	<!-- 配置c3p0 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driver}"/>
		<property name="jdbcUrl" value="${jdbc.url}" />
		<property name="user" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>
	
	 <!-- 配置dbcp -->
	 <!-- <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
	 	<property name="driverClassName" value="${jdbc.driver}"/>
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	 </bean>
	  -->
	
	<!-- sqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 加载mybatis的配置文件 -->
		<property name="configLocation" value="classpath:SqlMapConfig.xml"/>
		<!-- 指定数据源 -->
		 <property name="dataSource" ref="dataSource"/>
	</bean>	
	
	<!-- 配置mapper，同原始开发的dao，实现类由Mybatis实现了
		MapperFactoryBean可以根据接口生成代理对象
		此种方式需要配置n个mapper，比较繁琐
	 -->
	 <!-- 
	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		指定哪一个mapper接口需要它代理 
		<property name="mapperInterface" value="com.lee.mapper.UserMapper"/>
		 指定sqlSessionFactory，内部通过此操作数据 
		<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
	</bean>
	-->
	
	<!-- mapper批量扫描实例化 ,使用这个扫描器，必须要遵守mapper.java
	和mapper.xml命名一致且在同一包中，这里的扫描器同时完成了Mybatis配置文件
	中加载mapper.xml的任务，这里自动扫描出来后，mapper的bean的id为mapper
	类名（首字母小写）-->
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<!-- 指定扫描的包 ，如果要扫描多个包，在后面加上“，包全路径名”-->
		<property name="basePackage" value="com.lee.mapper"/>
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
	</bean>
	
</beans>

//#测试类
package com.lee.mapper;

import org.junit.Before;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import com.lee.domain.User;

public class UserMapperTest {
	private ApplicationContext applicationContext;
	
	@Before
	public void getContext(){
		applicationContext = new ClassPathXmlApplicationContext("classpath:ApplicationContext.xml");
	}
	
	@Test
	public void testSelectUserById() {
		UserMapper userMapper = (UserMapper) applicationContext.getBean("userMapper");
		User user = userMapper.selectUserById(1);
		System.out.println(user);
	}

}