• 在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>
<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>
  • 在ibatis-config.xml文件中
<sqlMapConfig>
    <sqlMap resource="com/cdeledu/mis/mtg/current/sql/Users.xml"/>
</sqlMapConfig>