在做成绩查询的时候动态SQL报错了。
@Select("<script> select classinf.cid,cname,id,term,name,point,score from classinf,s_finish,person where classinf.cid=s_finish.cid and classinf.tid=s_finish.tid and person.id=s_finish.tid and s_finish.sid=#{sid}"+
"<if test='pass==2'> and score>=60</if>" +
"<if test='pass==1'> and score<60</if>" +
"<if test='term!=null'> and term=#{term}</if>" +
"<if test='order==0'> order by score desc</if>" +
"<if test='order==1'> order by score</if>" +
"</script>")
@Results({
@Result(column="cid",property="cid"),
@Result(column="cname",pro