- 在applicationContext.xml文件中
使用了DBCP数据库连接池
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/mtg"/>
<property name="username" value="mtg"/>
<property name="password" value="mtg321"/>
<property name="maxActive" value="50"/>
<property name="maxIdle" value="20"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/mtg"/>
<property name="username" value="mtg"/>
<property name="password" value="mtg321"/>
<property name="maxActive" value="50"/>
<property name="maxIdle" value="20"/>
<property name="maxWait" value="1000"/>
<property name="defaultAutoCommit" value="true"/>
<property name="removeAbandoned" value="true"/>
<property name="removeAbandonedTimeout" value="60"/>
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="/WEB-INF/classes/com/cdeledu/mis/mtg/current/config/ibatis-config.xml"></property
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>
<property name="configLocation" value="/WEB-INF/classes/com/cdeledu/mis/mtg/current/config/ibatis-config.xml"></property
<property name="dataSource">
<ref bean="dataSource"/>
</property>
</bean>
- 在ibatis-config.xml文件中
<sqlMapConfig>
<sqlMap resource="com/cdeledu/mis/mtg/current/sql/Users.xml"/>
</sqlMapConfig>
<sqlMap resource="com/cdeledu/mis/mtg/current/sql/Users.xml"/>
</sqlMapConfig>
转载于:https://blog.51cto.com/zhoujiyu/137367