Spring层

1. 配置Spring整合MyBatis，我们这里数据源使用c3p0连接池；

2. 我们去编写Spring整合Mybatis的相关的配置文件； spring-dao.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
https://www.springframework.org/schema/context/springcontext.xsd">


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


<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}"/>
    
    <property name="maxPoolSize" value="30"/>
    <property name="minPoolSize" value="10"/>
    
    <property name="autoCommitOnClose" value="false"/>
    
    <property name="checkoutTimeout" value="10000"/>
    
    <property name="acquireRetryAttempts" value="2"/>
bean>

<bean id="sqlSessionFactory"
      class="org.mybatis.spring.SqlSessionFactoryBean">
    
    <property name="dataSource" ref="dataSource"/>
    
    <property name="configLocation" value="classpath:mybatisconfig.xml"/>
bean>


<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    
    <property name="sqlSessionFactoryBeanName"
              value="sqlSessionFactory"/>
    
    <property name="basePackage" value="com.kuang.dao"/>
bean>
beans>

3. Spring整合service层

        <?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">

<context:component-scan base-package="com.kuang.service" />

<bean id="BookServiceImpl"
      class="com.kuang.service.BookServiceImpl">
    <property name="bookMapper" ref="bookMapper"/>
bean>

<bean id="transactionManager"
      class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
>
    
    <property name="dataSource" ref="dataSource" />
bean>
beans>