你的位置:首页 > Java教程

[Java教程]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./>    <property name="mapperLocations" value="classpath:com/seven/dao/*./>    <property name="typeAliasesPackage" value="com.seven.domain"/><!--指定实体类包,自动将实体类的简单类名映射为别名-->  </bean>  <!--映射器接口,,,,有了 下面配置就不用了-->  <!-- <bean id="userMapper" >    <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本身的相关配置

<??><!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.--></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. */@Transactionalpublic interface UserMapper {  void save(User user);  void update(User user);  void delete(int id);  User findById(int id);  List<User> findAll();}

4.接下就是比较重要的一步,写接口的映射文件,这样就实验了dao

<??><!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.)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);  }}