Spring整合Mybatis一览

这是一个简单的功能实现，CRUD，算是入门。

第一步：创建数据库表 

CREATE TABLE user  
(  
  id int(11) NOT NULL AUTO_INCREMENT,  
  username varchar(20) NOT NULL,  
  password varchar(20) NOT NULL,  
  PRIMARY KEY (id)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

第二步：创建model 

public class User {
	private int id;
	private String username;
	private String password;

	public User() {

	}

	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 getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public String toString() {
		return "User [id = " + id + " , username = " + username + "]"
				+ " , password = " + password;
	}
}

第三步：创建DAO接口-实现简单的增删改查操作

public interface UserMapper {

	public User selectUser(User user);

	public void insertUser(User user);

	public void updateUser(User user);

	public void deleteUser(int userId);
}

第四步：实现DAO接口 

在dao包下创建一个UserMapper.xml文件作为上一步创建的DAO接口的实现。 

<?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.dao.UserMapper">
	<select id="selectUser" parameterType="user" resultType="user">
		SELECT * FROM user WHERE username=#{username} AND password=#{password}
	</select>
	<insert id="insertUser" parameterType="user" flushCache="true">
		INSERT INTO user (id,username,password) VALUES
		(#{id},#{username},#{password})
	</insert>
	<update id="updateUser" parameterType="user">
		UPDATE user SET password=#{password} WHERE id=#{id}
	</update>
	<delete id="deleteUser" parameterType="int">
		DELETE FROM user WHERE id=#{userId}
	</delete>
</mapper> 

第五步：创建MyBatis的配置文件 
在src下创建一个mybatis-config.xml文件，由于我们的数据源部分是要交给Spring管理，所以此处的配置文件只包含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>
<typeAliases>
	<typeAlias type="com.mybatis.model.User" alias="user"/>
</typeAliases>
    <mappers>  
        <mapper resource="com/mybatis/dao/UserMapper.xml"/>  
    </mappers>  
</configuration> 

第六步：在Spring中配置数据源 

在src下创建一个ApplicationContext.xml文件作为Spring的配置文件。 

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:tx="http://www.springframework.org/schema/tx" xmlns:p="http://www.springframework.org/schema/p"
	xmlns:aop="http://www.springframework.org/schema/aop" 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   
    http://www.springframework.org/schema/tx   
    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd   
    http://www.springframework.org/schema/aop    
    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd">  
<!-- 配置数据源 -->
	<bean id="jdbcDataSource"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>root</value>
		</property>
	</bean>
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="jdbcDataSource" />
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
	</bean>
	<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
		<property name="mapperInterface" value="com.mybatis.dao.UserMapper"></property>
		<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
	</bean>
</beans>  

第七步：单元测试

public class UserTest {

	private static ApplicationContext ctx = null;
	private static UserMapper userMapper = null;
	User user = null;

	@BeforeClass
	public static void init() {
		ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
		userMapper = (UserMapper) ctx.getBean("userMapper");
	}

	@Before
	public void setUp() {
		user = new User();
	}

	@Test
	public void testAddUser() {
		user.setUsername("admin");
		user.setPassword("admin");
		userMapper.insertUser(user);
	}

	@Test
	public void testUpdateUser() {
		user.setId(2);
		user.setPassword("123456");
		userMapper.updateUser(user);
	}

	@Test
	public void testSelect() {
		user.setUsername("admin");
		user.setPassword("123456");
		System.out.println(userMapper.selectUser(user));
	}

	@Test
	public void testDelete() {
		userMapper.deleteUser(1);
	}

	@After
	public void tearDown() {
		user = null;
	}

	@AfterClass
	public static void destory() {
		ctx = null;
		userMapper = null;
	}
}

附录jar文件名一览
aopalliance-1.0.jar
commons-logging-1.1.1.jar
hamcrest-core-1.3.jar
jettison-1.1.jar
junit-4.11.jar
mybatis-3.1.1.jar
mybatis-spring-1.1.1.jar
mysql-connector-java-5.1.13-bin.jar
spring-aop-3.1.1.RELEASE.jar
spring-asm-3.1.1.RELEASE.jar
spring-batch-core-2.1.8.RELEASE.jar
spring-batch-infrastructure-2.1.8.RELEASE.jar
spring-beans-3.1.1.RELEASE.jar
spring-context-3.1.1.RELEASE.jar
spring-core-3.1.1.RELEASE.jar
spring-expression-3.1.1.RELEASE.jar
spring-jdbc-3.1.1.RELEASE.jar
spring-tx-3.1.1.RELEASE.jar
xpp3_min-1.1.4c.jar
xstream-1.3.jar