spring 集成mybatis

参考：

http://zy3381.iteye.com/blog/1673934

关键点：

一、接口

package dao;

import model.User;

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

这里对这个xml文件作几点说明：
1. namespace要指定为接口的类路径。
2. select,insert,update,delete的id必须要和UserMapper.java接口中的方法同名。

三、spring配置mybatis

ibatis-mappings.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="dao/UserMapper.xml"/>
	</mappers>
</configuration>

      <bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">  
        <property name="jndiName">  
            <value>java:comp/env/jdbc/oa</value> 
        </property>  
    </bean>
 
 <!-- Myibatis中SessionFactory配置 -->
    <bean id="sessionFactoryMyibatis" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="classpath:resources/spring/ibatis-mappings.xml"/>
    </bean>

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

  
   <tx:advice id="txAdviceMyIbatis" transaction-manager="transactionManagerMyIbatis">
        <tx:attributes>
            <tx:method name="insert*" rollback-for="Exception"/>
            <tx:method name="save*"   rollback-for="Exception"/>
            <tx:method name="update*" rollback-for="Exception"/>
            <tx:method name="remove*" rollback-for="Exception"/>
            <tx:method name="delete*" rollback-for="Exception"/>
             <tx:method name="add*"    rollback-for="Exception"/>
            <tx:method name="modify*" rollback-for="Exception"/>
            <tx:method name="deploy*" rollback-for="Exception"/>              
            <tx:method name="*" read-only="true" rollback-for="Exception"/>
        </tx:attributes>
    </tx:advice>

<aop:config proxy-target-class="true">
        <aop:pointcut id="txPointcut" expression="execution(* *..*Service.*(..))" />
           <aop:advisor advice-ref="txAdviceMyIbatis" pointcut-ref="txPointcut"  />
    </aop:config>