Spring-Mybatis整合的所需配置文件

短命女 2023-10-05 10:22 41阅读 0赞

## Spring-Mybatis整合 ##

### database.properties文件 ###

driver=com.mysql.jdbc.Driver
    url=jdbc:mysql://127.0.0.1:3306/smbms?useUncode=true&characterEncoding=utf-8
    uname=root
    password=ok

### applicationContext配置文件 ###

<?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-3.2.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.2.xsd
        ">
    
    	
    
    	
    	<context:component-scan base-package="dao,service" />
    
    	
    	<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    		<property name="location" value="classpath:database.properties" />
    	</bean>
    
    	
    	<context:property-placeholder location="classpath:database.properties" />
    
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    		<property name="driverClassName" value="${driver}" />
    		<property name="url"
    			value="jdbc:mysql://127.0.0.1:3306/smbms?useUncode=true&characterEncoding=utf-8" />
    		<property name="username" value="${username}" />
    		<property name="password" value="${password}" />
    	</bean>
    
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="classpath:mybatis-config.xml" />
    		
    		<property name="dataSource" ref="dataSource" />
    		
    		<property name="typeAliasesPackage" value="pojo" />
    		
    		<property name="mapperLocations">
    			<list>
    				<value>classpath:dao/*/*.xml</value>
    			</list>
    		</property>
    	</bean>
    
    	
    	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="basePackage" value="dao" />
    	</bean>
    
    	
    	<bean id="txManager"
    	class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    		<property name="dataSource" ref="dataSource" />
    	</bean>
    
    		
    	<tx:annotation-driven transaction-manager="txManager" />
    
    	
    	
    	<import resource="applicationtx.xml" />
    
    </beans>