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