weixin_56362639的博客

1.条件语句的添加 SELECT * FROM [dbo].[t_MesCheckLog] where mesBtnStation='False' and oid!='003976' ${if(len(meterId) == 0,"","and meterId = '"+meterId+"'")} ${if(len(date1) == 0,"","and processDate >= '"+date1+"'")} ${if(len(date2) == 0,"","and processDate