mybatis spring xml设置

所有的properties文件在最初入口xml文件中定义。

<bean id="configProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">   <property name="locations">      <list>         <value>classpath*:*.properties</value>      </list>   </property></bean>

<!-- 创建SqlSessionFactory，同时指定数据源 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">    <property name="dataSource" ref="accgDataSource" />    <property name="mapperLocations">        <array>            <value>classpath*:META-INF/mybatis/mapper/*.xml</value>        </array>    </property>    <!--typeHandlersPackage 节点保存了数据库字段类型和java字段类型之间的映射 -->    <property name="typeHandlersPackage" value="common.mybatis.type" />    <property name="configurationProperties">        <map>            <entry key="__dbPrefix" value="${db.prefix}" />        </map>    </property></bean>

typeHandlersPackage的value是一个package，可以保存多个class

<!-- 事务相关配置 --><tx:annotation-driven transaction-manager="transactionManager" order="1" /><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">    <property name="dataSource" ref="accgDataSource" /></bean>

配置事务

<property name="dataSource" ref="accgDataSource" />定义的bean在下方

<!-- Mybatis Mapper扫描 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">    <property name="annotationClass" value="org.springframework.stereotype.Repository" />    <property name="basePackage" value="com.fcore.**.dao" />    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" /></bean>

<!-- 数据源配置 --><bean id="accgDataSource" parent="abstractDataSource">    <property name="driverClassName" value="${accg.0.mysql.driver}" />    <property name="maxActive" value="${accg.0.jdbc.maxActive}" />    <property name="url" value="${accg.0.jdbc.url}" />    <property name="username" value="${accg.0.jdbc.username}" />    <property name="password" value="${accg.0.jdbc.password}" />    <property name="numTestsPerEvictionRun" value="${accg.0.jdbc.numTestsPerEvictionRun}" /></bean><bean id="abstractDataSource" class="com.alibaba.druid.pool.DruidDataSource" destroy-method="close">    <property name="filters" value="${accg.datasource.filters}" />    <property name="defaultAutoCommit" value="${accg.datasource.defaultAutoCommit}" />    <property name="initialSize" value="${accg.datasource.initialSize}" />    <property name="minIdle" value="${accg.datasource.minIdle}" />    <property name="maxWait" value="${accg.datasource.maxWait}" />    <property name="testWhileIdle" value="${accg.datasource.testWhileIdle}" />    <property name="testOnBorrow" value="${accg.datasource.testOnBorrow}" />    <property name="testOnReturn" value="${accg.datasource.testOnReturn}" />    <property name="validationQuery" value="${accg.datasource.validationQuery}" />    <property name="timeBetweenEvictionRunsMillis" value="${accg.datasource.timeBetweenEvictionRunsMillis}" />    <property name="minEvictableIdleTimeMillis" value="${accg.datasource.minEvictableIdleTimeMillis}" />    <property name="logAbandoned" value="${accg.datasource.logAbandoned}" />    <property name="removeAbandoned" value="${accg.datasource.removeAbandoned}" />    <property name="removeAbandonedTimeout" value="${accg.datasource.removeAbandonedTimeout}" /></bean><bean id="batchSqlSession" class="org.mybatis.spring.SqlSessionTemplate">    <constructor-arg index="0" ref="sqlSessionFactory" />    <constructor-arg index="1" value="BATCH" /></bean>

再如下贴出配置文件。

test.resources.config/mysql.properties

定义了所有的字段。

另外，在test中有一个spring-config-mysql.xml

<?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:context="http://www.springframework.org/schema/context"   xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">   <!-- 确保可在@Value中, 使用SeEL表达式获取资源属性 -->   <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">      <property name="properties" ref="configProperties" />   </bean>   <bean id="configProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">      <property name="locations">         <list>            <value>classpath:/config/*.properties</value>         </list>      </property>   </bean>   <!-- 初始化Flogger Container -->   <bean id="initLogContainerBean" class="com.common.logger.InitLogContainerBean">      <property name="logLocation" value="classpath*:META-INF/log/*.log.xml" />      <property name="errorLocation" value="classpath*:META-INF/error/*.error.xml" />   </bean>   <!-- Spring annotation扫描 -->   <context:component-scan base-package="com.fbu.fcore.accounting.common" />   <!-- 日切服务 -->   <bean id="dayCutService" class="com.common.daycut.service.impl.DayCutServiceImpl" />         <bean id="accountingEntryGenerator" class="com.accounting.common.service.AccountingEntryGenerator" />   <bean id="accountingRuleEngine" class="com.accounting.common.service.AccountingRuleEngine" init-method="init" />   <!-- Imports -->   <import resource="classpath:/spring/spring-mybatis.xml" />   <import resource="classpath:/spring/spring-cache.xml" />   <import resource="classpath:/spring/spring-uid-generator.xml" />   <import resource="classpath:/spring/spring-jobs.xml" /></beans>