1、新建一个属性文件dbconfig.propertiesjdbc.jdbcUrl=jdbc:mysql://localhost:3306/ssm_crudjdbc.driverClass=com.mysql.jdbc.Driverjdbc.user=rootjdbc.password=root
2、在application.xml中引入该配置文件<context:property-placeholder location="classpath:dbconfig.properties"/>
3、配置数据源c3p0,增加一个属性文件dbconfig.properties<bean 罕铞泱殳class=媪青怍牙"com.mchange.v2.c3p0.ComboPooledDataSource" id="comboPooledDataSource"> <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> <property name="driverClass" value="${jdbc.driverClass}"></property> <property name="user" value="${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></property> </bean>
4、配置扫描业务逻辑组件，并且不要扫描控制器<context:component-scan base-package="com.gwolf"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/> </context:component-scan>
5、创建一个mybatis全局配置文件：mybatis-config.xml
6、配置与mybatis的整合<bean class="org.mybatis.衡痕贤伎spring.SqlSessionFactoryBean" id="sqlSessionFactoryBean"> <!-- 指定mybatis全局配置文件的位置 --> <property name="configLocation" value="classpath:mybatis-config.xml"></property> <property name="dataSource" ref="comboPooledDataSource"></property> <property name="mapperLocations" value="classpath:mapper/*.xml"></property> </bean>
7、配置扫描器，将mybatis接口的实现加入到ioc容器中<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.gwolf.crud.dao"></property> </bean>
8、事务控制的配置<bean class="org.springframework.jdbc.datasource.肛舀辨乔DataSourceTransactionManager" id="dataSourceTransactionManager"> <property name="dataSource" ref="comboPooledDataSource"></property> </bean> <aop:config> <aop:pointcut expression="execution(* com.gwolf.crud.service..*(..))" id="txPoint"/> <aop:advisor advice-ref="txAdvice" pointcut-ref="txPoint"/> </aop:config> <!-- 配置事务如何切入 --> <tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager"> <tx:attributes> <!-- 所有方法都是事务方法 --> <tx:method name="*"/> <tx:method name="get*" read-only="true"/> </tx:attributes> </tx:advice>
