select * from Stscore where 1=1
${if(len(CLASSNO) == 0,"","and CLASSNO ='"+ CLASSNO +"'")}
${if(len(STUDENTNO) == 0,"","where STUDENTNO in('"+ STUDENTNO +"')")}
select distinct CLASSNO from Stscore order by CLASSNO
select distinct STUDENTNO from Stscore where CLASSNO = '${CLASSNO}' order by STUDENTNO