A random sampling of several database records Java code __ Database

10 indicates the number of records extracted, 200000 indicates the total number of records minus the remaining value of the number of extracted records, where the RID is the primary key

Public Vector Getsomereader () {
Vector result = new vector ();
try {
Random r=new Random ();
PreparedStatement pstm = con
. Preparestatement ("Select top" rid of newreaderfull where rid not in (select Top +r.nextint (200000) + "rid from newre Aderfull order by RID);
ResultSet res = Pstm.executequery ();
while (Res.next ()) {
Vector sub = new vector ();
Sub.add (res.getstring (1));
Result.add (sub);
}
catch (Exception e) {
System.out.println (E.getmessage ());
}
return result;
}