ibatis中使用dbcp做为数据库连接池

1. 准备工作

 

（1）获取commons-dbcp-1.4-bin.zip 下载地址 http://commons.apache.org/dbcp/download_dbcp.cgi

（2）获取 commons-pool-1.5.6-bin.zip  下载地址  http://commons.apache.org/pool/download_pool.cgi

（3）获取 ibatis和相关文档 http://code.google.com/p/mybatis/  

        中文文档http://mybatis.googlecode.com/svn/trunk/doc/zh_cn/

 

3.  把 commons-dbcp-1.4-bin.zip 和 commons-pool-1.5.6-bin.zip  中相应jar文件加入到eclipse下的环境变量中

 

4. 配置如下

 

<sqlMapConfig> <!-- Configure a built-in transaction manager. If you're using an app server, you probably want to use its transaction manager and a managed datasource --> <transactionManager type="JDBC" commitRequired="false"> <dataSource type="DBCP"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /><property name="url" value="jdbc:mysql://127.0.0.1:3306/aaaaadb?autoReconnect=true&useUnicode=true&characterEncoding=utf8&mysqlEncoding=utf8" /><property name="username" value="aaaaaa" /><property name="password" value="aaaaaa" /><property name="maxActive" value="20" /><property name="initialSize" value="10" /><property name="maxIdle" value="20" /> </dataSource> </transactionManager> <sqlMap resource="com/dao/config/orm/XXXXArticle.xml"/> <sqlMap resource="com/dao/config/orm/XXXXXXFollow.xml"/> </sqlMapConfig> 

 

5. 配置说明：

 

连接地址：http://commons.apache.org/dbcp/configuration.html

 

中文配置说明：http://www.blogjava.net/aoxj/archive/2008/02/19/180704.html

 

6. 使用：

 

（1）获得SqlMapClient 

private static SqlMapClient sqlMapper;static { try { Reader reader = Resources.getResourceAsReader("XXXXSqlConfig.xml"); sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader); reader.close(); } catch (Exception e) { // Fail fast. throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e); }}public SqlMapClient getShopalUserUpdateSqlMapClient(){return sqlMapper;} 

（2）使用

public boolean deleteArticleModelByArticleId(Integer article_id) throws Exception{int result = getShopalUserUpdateSqlMapClient().delete("deleteArticleModelByArticleId",article_id);return result >= 1;}