static PreparedStatement pstmt;
...
if (pstmt == null) {
pstmt = conn.prepareStatement ("select pid from people where pid = ?");
}
for (int i = 0; i < 10000; i++) {
pstmt.setInt(1, i);
pstmt.execute();
}