"select * from(" + " select *, ROW_NUMBER() OVER(order by t1.md_user_id desc) as Row from " + " (select md_usertab.*,md_dr_service_station.md_service_name from md_usertab inner join md_dr_service_station" + " on md_dr_service_station.md_id=md_usertab.md_service_id and (md_usertab.md_user_number like '%"+md_user_number+"%' or '"+md_user_number+"'='null') and (md_usertab.md_user_name like '%"+md_user_name+"%' or '"+md_user_name+"'='null') and (md_usertab.md_state like '%"+md_state+"%' or '"+md_state+"'='null') and (md_usertab.md_user_type like '%"+md_user_type+"%' or '"+md_user_type+"'='null') and (md_dr_service_station.md_service_name like '%"+md_service_name+"%' or '"+md_service_name+"'='null') )as t1" + " ) as t2 " + "where t2.Row between "+pageIndex+" and "+pageSize);
如果模糊查询查不到数据,就看数据类型,举个栗子:(md_usertab.md_user_number like '%"+md_user_number+"%' or '"+md_user_number+"'='') md_usertab.md_user_number是Integer类型或者是String,那就改成(md_usertab.md_user_number like '%"+md_user_number+"%' or '"+md_user_number+"'='null')