转载

mybatis与spring的整合

本人刚刚接触mybatis,今天把它和spring整合起来用了一个上午==。

一开始是通过配置文件来配置,后来尝试用了一下注解,觉得mybatis的注解真的有点恶心。。。一大坨的,所以我还是建议使用配置文件吧!

1.首先配置spring配置文件

<!--数据源-->  <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">   <property name="url" value="jdbc:mysql://localhost:3306/test"/>   <property name="driverClassName" value="com.mysql.jdbc.Driver"/>   <property name="username" value="root"/>   <property name="password" value="root"/>  </bean>  <!--mybatis 的 sqlsessionFactoryNean-->  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">   <property name="dataSource" ref="datasource"/>   <property name="configLocation" value="classpath:conf.xml"/>   <property name="mapperLocations" value="classpath:com/seven/dao/*.xml"/>   <property name="typeAliasesPackage" value="com.seven.domain"/><!--指定实体类包,自动将实体类的简单类名映射为别名-->  </bean>  <!--映射器接口,,,,有了 下面配置就不用了--> <!-- <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">   <property name="sqlSessionFactory" ref="sqlSessionFactory"/>   <property name="mapperInterface" value="com.seven.dao.UserMapper"/>  </bean>-->  <!--mybatis自动扫描加载sql映射文件:mapperScannerConfigurer-->  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">   <property name="basePackage" value="com.seven.dao"/><!--指定sql映射文件、接口所在的包-->   <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>   </bean>  <!--事务管理器-->  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">   <property name="dataSource" ref="datasource"/>  </bean>  <!--声明事务-->  <tx:annotation-driven transaction-manager="transactionManager"/> 

2.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>  <settings>   <!-- 全局映射器启用缓存 -->   <setting name="cacheEnabled" value="true" />   <!-- 查询时,关闭关联对象即时加载以提高性能 -->   <setting name="lazyLoadingEnabled" value="true" />   <!-- 设置关联对象加载的形态,此处为按需加载字段(加载字段由SQL指     定),不会加载关联表的所有字段,以提高性能 -->   <setting name="aggressiveLazyLoading" value="false" />   <!-- 对于未知的SQL查询,允许返回不同的结果集以达到通用的效果 -->   <setting name="multipleResultSetsEnabled" value="true" />   <!-- 允许使用列标签代替列名 -->   <setting name="useColumnLabel" value="true" />   <!-- 允许使用自定义的主键值(比如由程序生成的UUID 32位编码作为键值),数据表的PK生成策略将被覆盖 -->   <setting name="useGeneratedKeys" value="true" />   <!-- 给予被嵌套的resultMap以字段-属性的映射支持 -->   <setting name="autoMappingBehavior" value="FULL" />   <!-- 对于批量更新操作缓存SQL以提高性能  -->   <setting name="defaultExecutorType" value="BATCH" />   <!-- 数据库超过25000秒仍未响应则超时 -->   <setting name="defaultStatementTimeout" value="25000" />  </settings>  <!-- 全局别名设置,在映射文件中只需写别名,而不必写出整个类路径  -->    <!-- <typeAliases>   <typeAlias alias="TestBean"        type="com.wotao.taotao.persist.test.dataobject.TestBean" />  </typeAliases>-->  <!-- 非注解的sql映射文件配置,如果使用mybatis注解,该mapper无需配置,但是如果mybatis注解中包含@resultMap注解,则mapper必须配置,给resultMap注解使用,交给spring管理了 -->  <!--<mappers>   <mapper resource="persist/test/orm/test.xml" />  </mappers>--> </configuration> 

3.实体,接口

package com.seven.domain; import java.util.Date; /**  * Created by Seven on 2015/5/29.  */ public class User {  private int id;  private String loginName;  private String userName;  private String password;  public int getId() {   return id;  }  public void setId(int id) {   this.id = id;  }  public String getLoginName() {   return loginName;  }  public void setLoginName(String loginName) {   this.loginName = loginName;  }  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;  } } 
package com.seven.dao; import com.seven.domain.User; import org.springframework.transaction.annotation.Transactional; import java.util.List; /**  * Created by Seven on 2015/5/29.  */ @Transactional public interface UserMapper {  void save(User user);  void update(User user);  void delete(int id);  User findById(int id);  List<User> findAll(); } 

4.接下就是比较重要的一步,写接口的映射文件,这样就实验了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"> <!--namespace必须是接口的全类名  --> <mapper namespace="com.seven.dao.UserMapper">  <resultMap id="userResult" type="User">   <result column="id" property="id"/>   <result column="loginName" property="loginName"/>   <result column="userName" property="userName"/>   <result column="password" property="password"/>  </resultMap>  <!-- 取得插入数据后的id -->  <insert id="save">   insert into tb_user(loginName,userName,password)   values(#{loginName},#{userName},#{password})  </insert>  <update id="update">   update tb_user   set loginName = #{loginName},   userName = #{userName},   password = #{password}   where id = #{id}  </update>  <delete id="delete">   delete from tb_user   where id = #{id}  </delete>  <select id="findById" resultMap="userResult">   select *   from tb_user   where id = #{id}  </select>  <select id="findAll" resultMap="userResult">   select *   from tb_user  </select> </mapper> 

5.测试,需要导入spring的测试包

package com.seven.test; import com.seven.dao.UserMapper; import com.seven.domain.User; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import java.util.Date; /**  * Created by Seven on 2015/5/29.  */ @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration("/application.xml") public class MyTest {  @Autowired  private UserMapper userMapper;  @Test  public void testSave(){   System.out.println(userMapper);   User user = new User();   user.setLoginName("seven");   user.setUserName("lin");   user.setPassword("123");   userMapper.save(user);  } } 
正文到此结束
Loading...