搭建mybatis和spring
1、spring-application-context引入资源文件
<context:property-placeholder location="classpath:mybatis/jdbc.properties"/>
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc\:mysql\://localhost\:3306/XXXXXX?useUnicode\=true&characterEncoding\=UTF-8&zeroDateTimeBehavior\=convertToNull&allowMultiQueries\=true
jdbc.username=roots
jdbc.password=password
2、spring-application-context配置管理数据源
<bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
3、spring-application-context声明事务管理器
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="druidDataSource"/>
</bean>
4、spring-application-context开启事务注解驱动
<tx:annotation-driven transaction-manager="transactionManager"/>
5、spring-application-context管理mybatis操作数据库的会话对象sqlsession
<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean" >
<!--连接数据源-->
<property name="dataSource" value="druidDataSource"/>
<!--设置mybatis的核心配置文件-->
<property name="configLocation" value="classpath:mybatis/mybatis-config.xml"/>
<!--设置类型别名-->
<property name="typeAliasesPackage" value="com.lvleigang.frame"/>
<!--设置映射文件路径-->
<property name="mapperLocations" value="classpath*:com/lvleigang/frame/**/*.xml"/>
</bean>
6、spring-application-context接口自动生成动态代理实现类
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.lvleigang.frame"/>
</bean>