额外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&autoReconnect=true&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"));
}
}
}