mybatis整合Spring编码

mybatis整合Spring的核心代码

spring-dao.xml

 <?xml version="1.0" encoding="UTF-8"?>

 <beans xmlns="http://www.springframework.org/schema/beans"

        xmlns:context="http://www.springframework.org/schema/context"

        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

        xsi:schemaLocation="http://www.springframework.org/schema/beans

        http://www.springframework.org/schema/beans/spring-beans-4.2.xsd

        http://www.springframework.org/schema/context

        http://www.springframework.org/schema/context/spring-context-4.2.xsd">

     <!--配置整合mybatis过程-->

     <!-- 1：配置数据库相关参数properties的属性：${url} -->

     <context:property-placeholder location="classpath:jdbc.properties"/>

     <!--2：数据库连接池-->

     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">

         <!--配置连接池属性-->

         <property name="driverClass" value="${jdbc.driver}"/>

         <property name="jdbcUrl" value="${jdbc.url}"/>

         <property name="user" value="${jdbc.username}"/>

         <property name="password" value="${jdbc.password}"/>

         <!--c3p0连接池的私有属性-->

         <property name="maxPoolSize" value="30"/>

         <property name="minPoolSize" value="10"/>

         <!--关闭连接后不自动commit-->

         <property name="autoCommitOnClose" value="false"/>

         <!--获取连接超时时间-->

         <property name="checkoutTimeout" value="1000"/>

          <!--当获取连接失败重试次数-->

         <property name="acquireRetryAttempts" value="2"/>

     </bean>

     <!--约定大于配置-->

     <!--3:配置SqlSessionFactory对象-->

     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

         <!--注入数据库连接池-->

         <property name="dataSource" ref="dataSource"/>

         <!--配置MyBatis全局配置文件：mybatis-config.xml-->

         <property name="configLocation" value="classpath:mybatis-config.xml"/>

         <!--扫描entity包 使用别名 org.seckill.entity.Seckill->Seckill-->

         <property name="typeAliasesPackage" value="org.seckill.entity"/>

         <!--扫描sql配置文件：mapper需要的xml文件-->

         <property name="mapperLocations" value="classpath:mapper/*.xml"/>

     </bean>

     <!--4:配置扫描Dao接口包，动态实现Dao接口，注入到spring容器中-->

     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

         <!--注入sqlsessionFactory-->

         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>

         <!--给出需要扫描Dao接口包-->

         <property name="basePackage" value="org.seckill.dao"/>

     </bean>

 </beans>