mybatis配置

1、spring引入mybatis

<?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:aop="http://www.springframework.org/schema/aop"  
  xmlns:tx="http://www.springframework.org/schema/tx"   
  xmlns:jdbc="http://www.springframework.org/schema/jdbc"  
  xmlns:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="          
      http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd          
      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd          
      http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-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"
     >
    
    <!-- Mybatis 配置 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="configLocation" value="classpath:mybatis-config.xml"/>        
    </bean>

    <!-- scan  mappers and let them be autowired -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">       
        <property name="basePackage" value="com.trunkbow.online.persist.online" />
    </bean>
</beans> 

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"/>
        
        <!-- 当启用时，有延迟加载属性的对象在被调用时将会完全加载任意属性。否则，每种属性将会按需要加载。 -->
        <setting name="aggressiveLazyLoading" value="true"/>
        
        <!-- 允许或不允许多种结果集从一个单独的语句中返回（需要适合的驱动）。 -->
        <setting name="multipleResultSetsEnabled" value="true"/>
        
        <!-- 使用列标签代替列名。 -->
        <setting name="useColumnLabel" value="true"/>
        
        <!-- 允许JDBC支持生成的键。 -->
        <setting name="useGeneratedKeys" value="false"/>
        
        <!-- 指定MyBatis如何自动映射列到字段/属性。 -->
        <setting name="autoMappingBehavior" value="PARTIAL"/>
        
        <!-- 配置默认的执行器。 -->
        <setting name="defaultExecutorType" value="SIMPLE"/>
    </settings>
    
    <!-- java类别名 -->
    <typeAliases>
        <typeAlias alias="Order" type="com.trunkbow.common.model.Order" />
        <typeAlias alias="OrderError" type="com.trunkbow.common.model.OrderError" />
        <typeAlias alias="CustomerStage" type="com.trunkbow.common.model.bank.CustomerStage" />
        <typeAlias alias="CustmKey" type="com.trunkbow.common.model.bank.CustmKey" />
        <typeAlias alias="CustomerExtend" type="com.trunkbow.common.model.bank.CustomerExtend" />
    </typeAliases>
    
    <!-- SQL映射语句 -->
    <mappers>
        <mapper resource="mapper/OrderMapper.xml"/> 
        <mapper resource="mapper/OrderErrorMapper.xml"/>
        <mapper resource="mapper/CustomerStageMapper.xml"/>
        <mapper resource="mapper/CustmKeyMapper.xml"/>
        <mapper resource="mapper/CustmExtendMapper.xml"/>
    </mappers>
    
</configuration>

mybatis的Pom

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.2.2</version>
</dependency>
<dependency>
     <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.2.8</version>
</dependency>

 

注意：mybatis执行sql时，参数可以使基本类型、Map、对象，返回参数有对象（如果是多个就是list）、基本类型