JAVA 连接池 BoneCP 测试（2）- with spring 3

额外JAR包：

org.springframework.expression-3.0.1.RELEASE.jar

org.springframework.asm-3.0.1.RELEASE.jar

org.springframework.beans-3.0.1.RELEASE.jar

 

p:statementCacheSize="100"

<bean id="masterDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close"

p:driverClass="com.mysql.jdbc.Driver" 

p:jdbcUrl="jdbc:mysql://localhost/pesdog?autoReconnectForPools=true&amp;autoReconnect=true&amp;characterEncoding=utf-8" 

p:username="root" p:password="" 

p:idleConnectionTestPeriod="60" p:idleMaxAge="240"

p:maxConnectionsPerPartition="30" p:minConnectionsPerPartition="10"

p:partitionCount="3" p:acquireIncrement="5" 

p:releaseHelperThreads="3"

/>

 

<context:annotation-config/><bean id="foo" class="test.Foo">

</bean>

 

 

public static void main(String[] args){

ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");

Foo foo = (Foo)context.getBean("foo");

try{

foo.test();

}catch(Exception ex){

ex.printStackTrace();

}

}

 

@Component

public class Foo {

//@Autowired

private DataSource masterDataSource;

 

public DataSource getMasterDataSource() {

return masterDataSource;

}

 

@Required

@Autowired

public void setMasterDataSource(DataSource masterDataSource) {

this.masterDataSource = masterDataSource;

}

public void test() throws Exception{

Connection cn = this.masterDataSource.getConnection();

Statement stmt = cn.createStatement();

String sql = "select username,loginid from sys_user";

System.out.println(sql);

ResultSet rs = stmt.executeQuery(sql);

while(rs.next()){

System.out.println(rs.getString("username"));

System.out.println(rs.getString("loginid"));

}

}

}