spring 集成ibatis及mysql配置

数据源配置：

database.properties内容：

Java代码

1. UserName=*** 
2. Password=***** 
3. jdbc.DriverClassName=com.mysql.jdbc.Driver 
4. jdbc.url=jdbc:mysql://localhost:3306/databaseName 
5. jdbc.username=${UserName} 
6. jdbc.password=${Password} 
7. jdbc.maxActive=10 
8. jdbc.maxIdle=5 
9. jdbc.maxWait=10000 

UserName=***
Password=*****
jdbc.DriverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/databaseName
jdbc.username=${UserName}
jdbc.password=${Password}
jdbc.maxActive=10
jdbc.maxIdle=5
jdbc.maxWait=10000

ibatis模板类配置：

Java代码

1. <context:property-placeholder location="classpath:database.properties" /> 
2.     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" 
3.         destroy-method="close"> 
4.         <property name="url" value="${jdbc.url}" /> 
5.         <property name="driverClassName" value="${jdbc.DriverClassName}" /> 
6.         <property name="username" value="${jdbc.username}" /> 
7.         <property name="password" value="${jdbc.password}" /> 
8.         <property name="maxActive" value="${jdbc.maxActive}" /> 
9.         <property name="maxIdle" value="${jdbc.maxIdle}" /> 
10.         <property name="maxWait" value="${jdbc.maxWait}" /> 
11.     </bean> 
12.  
13. <!-- 声明iBatis模板类 --> 
14.     <bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate"> 
15.         <property name="sqlMapClient"> 
16.             <bean class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> 
17.                 <property name="dataSource" ref="dataSource" /> 
18.                 <property name="configLocation" value="classpath:sqlMapConfig.xml" /> 
19.             </bean> 
20.         </property> 
21.     </bean> 

<context:property-placeholder location="classpath:database.properties" />
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="url" value="${jdbc.url}" />
		<property name="driverClassName" value="${jdbc.DriverClassName}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
		<property name="maxActive" value="${jdbc.maxActive}" />
		<property name="maxIdle" value="${jdbc.maxIdle}" />
		<property name="maxWait" value="${jdbc.maxWait}" />
	</bean>

<!-- 声明iBatis模板类 -->
	<bean id="sqlMapClientTemplate" class="org.springframework.orm.ibatis.SqlMapClientTemplate">
		<property name="sqlMapClient">
			<bean class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
				<property name="dataSource" ref="dataSource" />
				<property name="configLocation" value="classpath:sqlMapConfig.xml" />
			</bean>
		</property>
	</bean>

sqlMapConfig.xml 内容：

Java代码

1. <?xml version="1.0" encoding="UTF-8"?> 
2. <!DOCTYPE sqlMapConfig       
3.     PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"       
4.     "http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> 
5. <sqlMapConfig> 
6.     <settings cacheModelsEnabled="false" enhancementEnabled="true" 
7.         lazyLoadingEnabled="true" useStatementNamespaces="true" /> 
8.     <sqlMap resource="com/UserInfo.xml" /> 
9. </sqlMapConfig> 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig      
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"      
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
	<settings cacheModelsEnabled="false" enhancementEnabled="true"
		lazyLoadingEnabled="true" useStatementNamespaces="true" />
	<sqlMap resource="com/UserInfo.xml" />
</sqlMapConfig>