先帮你优化下SQL语句吧
exec="select * from xxxx where 1=1";
if(yqmc!="")exec+=" and yqmc='"+yqmc+"'";
if(cj!="")exec+=" and cj='"+cj+"'";
if(ck!="")exec+=" and ck='"+ck+"'";
if(xz!="")exec+=" and xz='"+xz+"'";
if(zrr!="")exec+=" and zrr='"+zrr+"'";
if(lyr!="")exec+=" and lyr='"+lyr+"'";
if(sydw!="")exec+=" and sydw='"+sydw+"'";
if(fph!="")exec+=" and fph="+fph;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024