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(),应该怎么写啊 |