package flyweight;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Vector;
public class ConnectionPool {
private Vector<Connection> pool;
/*公有属性*/
private String url = "jdbc:mysql://localhost:3306/test";
private String username = "root";
private String password = "root";
private String driverClassName = "com.mysql.jdbc.Driver";
private int poolSize = 100;
private static ConnectionPool instance = null;
Connection conn = null;
/*构造方法，做一些初始化工作*/
private ConnectionPool() {
pool = new Vector<Connection>(poolSize);
for (int i = 0; i < poolSize; i++) {
try {
Class.forName(driverClassName);
conn = DriverManager.getConnection(url, username, password);
pool.add(conn);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/* 返回连接到连接池 */
public synchronized void release() {
pool.add(conn);
}
/* 返回连接池中的一个数据库连接 */
public synchronized Connection getConnection() {
if (pool.size() > 0) {
Connection conn = pool.get(0);
pool.remove(conn);
return conn;
} else {
return null;
}
}
}
设计模式学习历程和心得
需积分: 18 67 浏览量
2015-11-21
18:10:46
上传
评论
收藏 88KB ZIP 举报
设计模式学习历程和心得 （184个子文件） 
ConnectionPool.class 2KB TreeNode.class 1KB AbstractSubject.class 1KB Test.class 1KB Computer.class 1KB MyHandler.class 1016B MyIterator.class 1002B AbstractCalculator.class 925B Tree.class 881B Test.class 872B Context.class 864B MyMediator.class 843B Original.class 837B StrategyTest.class 829B State.class 827B Proxy.class 808B MyCollection.class 801B MyVisitor.class 797B Wrapper.class 769B StrategyTest.class 759B Test.class 731B BridgeTest.class 723B AbstractCalculator.class 715B Test.class 709B AdapterTest.class 707B Context.class 701B Test.class 692B Decorator.class 692B WrapperTest.class 683B ObserverTest.class 662B Test.class 658B DecoratorTest.class 632B Bridge.class 628B AbstractHandler.class 612B Test.class 601B MySubject.class 598B Memory.class 590B AdapterTest.class 581B Disk.class 580B CPU.class 575B Adapter.class 552B User1.class 551B User2.class 551B Multiply.class 550B Test.class 548B SourceSub2.class 547B SourceSub1.class 546B MySubject.class 544B Storage.class 541B Minus.class 540B Memento.class 538B Plus.class 538B Observer2.class 533B Observer1.class 533B SourceSub2.class 532B SourceSub1.class 531B Source.class 526B Source.class 514B Minus.class 514B Source.class 511B Plus.class 511B Source.class 509B ProxyTest.class 507B User.class 505B MyCommand.class 503B Receiver.class 497B Invoker.class 472B User.class 468B Wrapper2.class 446B Minus.class 405B Plus.class 402B MyBridge.class 260B Collection.class 212B Subject.class 209B Iterator.class 203B Subject.class 187B Expression.class 160B Sourceable.class 158B Targetable.class 157B Targetable.class 156B ICalculator.class 156B Mediator.class 155B Handler.class 142B Visitor.class 142B Sourceable.class 134B Sourceable.class 131B Sourceable.class 130B Sourceable.class 130B Observer.class 129B Command.class 123B .classpath 301B ConnectionPool.java 1KB TreeNode.java 815B MyIterator.java 663B Test.java 640B AbstractCalculator.java 608B BridgeTest.java 589B Computer.java 587B Context.java 547B AbstractSubject.java 546B共 184 条
- 1
- 2
资源评论
