jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/jkdb?characterEncoding=utf-8

jdbc.username=root

jdbc.password=

c3p0.pool.size.max=

c3p0.pool.size.min=

c3p0.pool.size.ini=

c3p0.pool.size.increment=

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

</configuration>    

<?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:mvc="http://www.springframework.org/schema/mvc"

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

    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"

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

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

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

            http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd

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

            http://www.springframework.org/schema/context/spring-context-3.0.xsd

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

            http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

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

            http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">

    <!-- 管理service和dao -->

    <context:component-scan base-package="cn.itcast.jk.service,cn.itcast.jk.dao"/>

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

    <!-- 数据库链接信息 -->

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

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

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

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

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

        <property name="maxPoolSize" value="${c3p0.pool.size.max}"/>

        <property name="minPoolSize" value="${c3p0.pool.size.min}" />

        <property name="initialPoolSize" value="${c3p0.pool.size.ini}"/>

        <property name="acquireIncrement" value="${c3p0.pool.size.increment}"/>

    </bean>

    <!-- sqlSessionFactory spring和myBatis整合 -->

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

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

        <property name="configLocation" value="classpath:sqlMapConfig.xml"/>

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

    </bean>

    <!-- 事务管理 -->

    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

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

    </bean>

    <!-- 通知 -->

    <tx:advice id="txAdvice" transaction-manager="txManager">

        <tx:attributes>

            <tx:method name="find*" read-only="true" />

            <tx:method name="get*" read-only="true" />

            <tx:method name="view*" read-only="true" />

            <tx:method name="insert*" propagation="REQUIRED" />

            <tx:method name="update*" propagation="REQUIRED" />

            <tx:method name="delete*" propagation="REQUIRED" />

            <tx:method name="*" propagation="REQUIRED" /><!-- 防止漏网之鱼 -->

        </tx:attributes>

    </tx:advice>

    <aop:config>

        <!-- 切点 管理所有Service的方法 -->

        <aop:pointcut expression="execution(* cn.itcast.jk.service.*.*(..))" id="transactionPointCut"/>

        <!-- 增强，进行事务控制 Advisor -->

        <aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointCut"/>

    </aop:config>

</beans>            

<?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:mvc="http://www.springframework.org/schema/mvc"

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

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

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

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

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

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

    http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd

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

    http://www.springframework.org/schema/context/spring-context-3.0.xsd

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

    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

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

    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd ">

    <mvc:annotation-driven/>

    <!-- 扫描controller -->

    <context:component-scan base-package="cn.itcast.jk.controller"/>

    <!-- 内部资源视图解析器 -->

    <bean id="jspInternalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">

        <property name="prefix" value="/WEB-INF/pages/"/>

        <property name="suffix" value=""/>

    </bean>

</beans>