集成iBATIS3和bonecp

来源：互联网发布：冷藏室软件下载编辑：程序博客网时间：2024/06/16 00:34

bonecp是一款开源的、高效的数据库连接池组件，它号称是现在最快的连接池组件，官网上称是dbcp的25倍，但是iBATIS3并没有为它开发类厂，iBATIS3只支持3中类型的类厂，分别是UNPOOLED，POOLED和JNDI，要想集成只能自己开发了，自己开发也不难，只要实现DataSourceFactory接口就可以了，代码很简单：

package com.ibatis.factory;

import java.util.Properties;
import javax.sql.DataSource;
import org.apache.ibatis.datasource.DataSourceFactory;
import org.apache.ibatis.reflection.MetaObject;
import com.jolbox.bonecp.BoneCPDataSource;
public class BoneCPFactory implements DataSourceFactory {

    private DataSource dataSource;
    public BoneCPFactory()
    {
        // 创建bonecp datasource
        dataSource = new BoneCPDataSource();

    }
    public DataSource getDataSource() {
        // TODO Auto-generated method stub
        return dataSource;
    }
    /**
    * 配置属性
    */
    public void setProperties(Properties properties) {

        // TODO Auto-generated method stub
        Properties driverProperties = new Properties();
        MetaObject metaDataSource = MetaObject.forObject(dataSource);

        for (Object key : properties.keySet()) {
            String propertyName = (String) key;
            // 处理driver.xxx属性,e.g driver.encoding=UTF8
            if (propertyName.startsWith(DRIVER_PROPERTY_PREFIX)) {
                String value = properties.getProperty(propertyName);
                driverProperties.setProperty(propertyName.substring(DRIVER_PROPERTY_PREFIX_LENGTH), value);
            }
            else
            {
                // 利用反射技术,初始化datasource属性的值
                if (metaDataSource.hasSetter(propertyName)) {
                    String value = (String) properties.get(propertyName);
                    Object convertedValue = convertValue(metaDataSource, propertyName, value);
                    metaDataSource.setValue(propertyName, convertedValue);
                }
            }
        }
        // 如果配置driver.xxx属性,初始化
        if (driverProperties.size() > 0) {
            metaDataSource.setValue("driverProperties", driverProperties);
        }
    }
    /**
    * 转换数字和Boolean型
    * @param metaDataSource
    * @param propertyName
    * @param value
    * @return
    */
    @SuppressWarnings("unchecked")
    private Object convertValue(MetaObject metaDataSource, String propertyName,
            String value) {
        Object convertedValue = value;
        Class targetType = metaDataSource.getSetterType(propertyName);
        if (targetType == Integer.class || targetType == int.class) {
            convertedValue = Integer.valueOf(value);
        } else if (targetType == Long.class || targetType == long.class) {
            convertedValue = Long.valueOf(value);
        } else if (targetType == Boolean.class || targetType == boolean.class) {
            convertedValue = Boolean.valueOf(value);
        }
        return convertedValue;
    }
    private static final String DRIVER_PROPERTY_PREFIX = "driver.";
    private static final int DRIVER_PROPERTY_PREFIX_LENGTH = DRIVER_PROPERTY_PREFIX.length();
}

然后在Configuration.xml配置就可以了，首先配置类厂别名：

接着配置environmen：

需要配置的属性很简单，就是BoneCPDataSource类的属性。如此就大功告成了。