Java Database Connectivity (JDBC)

Hi, I have a quick question I hope someone can help me with. I'm a student and what I'm looking for should be easy but I can't find any information on it.

Here's my code, it's probably self-explanatory but to clarify I'm trying to get a list of "Captains" in the order of who has the most wins.

The problem is that the database tables have thousands of "Captains" and I'm only supposed to look at 200 specific "Captains" which have their ssn in a specific arraylist and then return the top 80 "Captains" from that selection.


Something like this...
-----------------------------------------------------------------
SELECT first 80 E.name, L.ssn, COUNT(L.wins) as Wins
FROM log L, employees E
where type matches "[Captain]"
and E.ssn = L.ssn
and L.ssn IN (...arraylist...) // How do I loop through the arraylist but still return a list of the top 80 winners?

group by E.name, L.ssn
order by Wins desc;
-----------------------------------------------------------------

Should I start by taking the list of social security numbers from the arraylist and insert them into a temporary table and then use that temporary table to base my selection on?

For example:

int rows = 0;
PreparedStatement ps = conn.prepareStatement("INSERT INTO TEMP captainsTemp (ssn) VALUES(?)");
Iterator i = myArrayList.iterator();

while (i.hasNext())
{
// Set the variables
for (int pos = 1; pos <= 63; pos++)
{
String s = (String)i.next();
ps.setString(pos,s);
}
// insert a row
rows += ps.execute();
}

...and then below that I could use
"SELECT * FROM captains
...
...
WHERE ssn IN (SELECT * FROM captainTemp)..."

----------------------------------------------------------------

This looks like an ugly solution and I'm not sure if it works, sessionwise..

Everything's written in Java and SQL.
If you have any thoughts on this I would be most grateful.
I should add that this is NOT a school assignment but something I'm trying to figure out for my work...

Many thanks,
sincerely,
JT.