${if(len(year)==0,""," AND year = '"+year+"'")}
${if(len(year)==0,""," and year = '"+(year-1)+"'")}
year-1要用括号括起来
${if(len(year)==0,""," AND year = '"+year-1+"'")}