就比如说,有三个月的时间,我定一月份为开始时间,我选择二月份为截止时间,但是表格内的数据,没有变动,和开始时间为一月份,截止时间也是一月份显示的数据是一样的SELECT '${nys}' nys,'${nye}' nye,cbdshi,insu_admdvs,jylx,nld,sum(jyrs) jyrs,sum(jyrc) jyrc,sum(zfy) zfy,sum(zcnfy) zcnfy,sum(jjzfze) jjzfze,sum(jjzfze)/sum(zcnfy) zcnbxbl,sum(jjzfze)/sum(zfy) sjbxbl,sum(zfy)/sum(jyrs) rjylfy,sum(jjzfze)/sum(jyrs) rjjjzf FROM dws_t_xsfx06where 1=1 and rydl= '职工' ${if(len(nys)==0,""," and ny >= '" + nys + "')"} ${if(len(nye)==0,""," and ny <= '" + nye+ "')"} ${if(len(tcq) == 0,"","and cbdshi = '" + tcq + "'")} ${if(len(tcqx) == 0,"","and insu_admdvs = '" + tcqx + "'")} ${if(len(rydl) == 0,"","and rydl = '" + rydl + "'")} ${if(len(jylx) == 0,"","and jylx = '" + jylx + "'")} ${if(len(nld) == 0,"","and nld = '" + nld + "'")}group by cbdshi,insu_admdvs,jylx,nld