public class MusicDatabase
{
ConnectionPool conPool = null;
public
MusicDatabase()
{
String driverName =
"oracle.jdbc.driver.OracleDriver";
String
connURL = "jdbc:oracle:thin:@MYSERVER:1521:WDEV";
String
username = "user";
String password = "pwd";
conPool = new ConnectionPool(1,
driverName, connURL,
username,
password);
}
public
ArrayList searchForSongs(ArrayList songIDs)
{
ArrayList songList = new ArrayList();
...searches
DB & populate ArrayList w/ SongBean objects
...