把最后1个OR改成AND,如果是or,而且你的keyword是空的话就会全部显示,这里用了or,你前面的所有AND都等于没写string sql = "SELECT sysjcompany.* FROM sysjcompany INNER JOIN sysbcompany ON sysjcompany.bcomID = sysbcompany.bcomID WHERE (sysjcompany.dzhiwei ='" + dziwei + "') AND (sysjcompany.city = '" + city + "') AND (sysjcompany.youxiaos = '" + date + "') AND (sysbcompany.cname like '%" + keyword + "%')";
把最后1个OR改成AND,如果是or,而且你的keyword是空的话就会全部显示,这里用了or,你前面的所有AND都等于没写string sql = "SELECT sysjcompany.* FROM sysjcompany INNER JOIN sysbcompany ON sysjcompany.bcomID = sysbcompany.bcomID WHERE (sysjcompany.dzhiwei ='" + dziwei + "') AND (sysjcompany.city = '" + city + "') AND (sysjcompany.youxiaos = '" + date + "') AND (sysbcompany.cname like '%" + keyword + "%')";