Statement stmt = conn.createStatement();
for (int i = 0; i < 10000; i++) {
    ResultSet rs = stmt.executeQuery("select pid from people where pid =" + i ) ;
    stmt.close();
}