SELECT * FROM 订单 where 1=1
${if(type=="日报"," and date(订购日期)='"+ date +"'",
if(type=="月报"," and strftime('%m',订单.订购日期)='"+ month+"'"+" and strftime('%Y',订单.订购日期)='"+ year+"'"," and strftime('%Y',订单.订购日期)='"+ year+"'"))}
这语句中 1=1 是什么意思啊,if语句怎么用啊,对finereport的sql语句完全小白。有没有这方面的资料可以学习啊,如果是sql server 数据库,不用strftime(),应该怎么写啊