public void openPool() throws SQLException,ClassNotFoundException
{
try
{
hashtableNowConnections = new Hashtable(intMaxConnections);
vectorFreeConnections = new Vector(intMaxConnections);
Class.forName(strDriverName);//装载驱动程序
for(int i = 0;i<intMaxConnections;i++)
vectorFreeConnections.addElement(DriverManager.getConnection(strJdbcURL,strUserName,strUserPwd));//建立连接
}
catch(ClassNotFoundException ex)
{
hashtableNowConnections = null;
vectorFreeConnections = null;
throw new ClassNotFoundException(ex.getMessage());
}
catch(SQLException ex)
{
hashtableNowConnections = null;
vectorFreeConnections = null;
throw new SQLException(ex.getMessage());
}
}
{
try
{
hashtableNowConnections = new Hashtable(intMaxConnections);
vectorFreeConnections = new Vector(intMaxConnections);
Class.forName(strDriverName);//装载驱动程序
for(int i = 0;i<intMaxConnections;i++)
vectorFreeConnections.addElement(DriverManager.getConnection(strJdbcURL,strUserName,strUserPwd));//建立连接
}
catch(ClassNotFoundException ex)
{
hashtableNowConnections = null;
vectorFreeConnections = null;
throw new ClassNotFoundException(ex.getMessage());
}
catch(SQLException ex)
{
hashtableNowConnections = null;
vectorFreeConnections = null;
throw new SQLException(ex.getMessage());
}
}
{
DemoHelper helper = new DemoHelper();
DataSource ds = new DataSource();
String strResult = "";
int strID = 0;
Vector dbResult = new Vector();
Vector result = new Vector();
Dcols dcols = new Dcols(); String strSql = "select * from SYS_DEMO";
if(ds.executeQuery(strSql))
{
dbResult = ds.getAllData();
for(int i=0;i < dbResult.size();i++)
{
dcols = (Dcols)dbResult.elementAt(i);
int intTemp = dcols.getInt("ID");
String strTemp = dcols.getString("NAME");
helper.setstrID(new Integer(intTemp));
helper.setstrName(strTemp);
result.addElement(helper);
}
}
return result;
}
但是尽量不要过多使用,因为这样子效率会比较低
绝对好用
如果列表不存在,那么
大家在什么时会考虑去用Vector呢?---------想多了解一些.