WorkBook2.zip
SELECT * FROM stscore where 1=1 ${if(len(classno)==0,""," and classno='
"+classno+"'")} ${if(len(studentno)==0,""," and studentno in ('
"+studentno+"')")}
sql查询
where 1=1
${if(len(class)=0,"","and 班级字段 in ('"+class+"')")}
${if(len(student)=0,"","and 学号字段 in ('"+student+"')")}
然后把class 、student这两个参数分别付到控件上即可