select top语句 mysql_select top改写成mysql数据库支持的语句

publicListexampaper(inta,intb,intc,intd,inte)throwsSQLException{Listlist=newArrayList();this.dbsConnection();Stringsql1="selecttop"+a+"exidfromite...

public List exampaper(int a,int b ,int c ,int d,int e) throws SQLException{

List list =new ArrayList();

this.dbsConnection();

String sql1 ="select top "+ a+" exid from itempool where type='exam' and exty='choose' Order By NewID()";

rs = stmt.executeQuery(sql1);

while(rs.next()){

list.add(rs.getString(1));

}

String sql2 ="select top "+ b+" exid from itempool where type='exam' and exty='judge' Order By NewID()";

rs = stmt.executeQuery(sql2);

while(rs.next()){

list.add(rs.getString(1));

}

String sql3 ="select top "+ c+" exid from itempool where type='exam' and exty='fill' Order By NewID()";

rs = stmt.executeQuery(sql3);

while(rs.next()){

list.add(rs.getString(1));

}

String sql4 ="select top "+ d+" exid from itempool where type='exam' and exty='shorta' Order By NewID()";

rs = stmt.executeQuery(sql4);

while(rs.next()){

list.add(rs.getString(1));

}

String sql5 ="select top "+e+" exid from itempool where type='exam' and exty='solution' Order By NewID()";

rs = stmt.executeQuery(sql5);

while(rs.next()){

list.add(rs.getString(1));

请问上述语句该如何改写才能让mysql支持呢？菜鸟请教内行的朋友们:-D，各个题目的数量，选择填空判断10道，简答5问答8道

展开