limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(S_ID,'') S_ID, ifnull(S_NAME,'') S_NAME, ifnull(S_IDENTIFICATION,'') S_IDENTIFICATION, ifnull(S_BIRTHDAY,'') S_BIRTHDAY, ifnull(D_TIMESTAMP,'') D_TIMESTAMP, ifnull(S_CHECKERID,'') S_CHECKERID, ifnull(S_CHECKERNAME,'') S_CHECKERNAME, ifnull(S_CHECKERUNITNAME,'') S_CHECKERUNITNAME, ifnull(S_RESULT,'') S_RESULT, ifnull(S_X,'') S_X, ifnull(S_Y,'') S_Y, ifnull(S_PHOTO,'') S_PHOTO, ifnull(S_REASON,'') S_REASON from vw_ry_zhb_ryydpcxx AND ( S_NAME like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(S_ID,'') S_ID, ifnull(D_TIMESTAMP,'') D_TIMESTAMP, ifnull(S_CHECKERID,'') S_CHECKERID, ifnull(S_CHECKERNAME,'') S_CHECKERNAME, ifnull(S_CHECKERUNITNAME,'') S_CHECKERUNITNAME, ifnull(S_RESULT,'') S_RESULT, ifnull(S_X,'') S_X, ifnull(S_Y,'') S_Y, ifnull(S_PHOTO,'') S_PHOTO, ifnull(S_REASON,'') S_REASON from vw_zz_zhb_cspcxx AND ( S_CHECKERNAME like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(QYMC,'') QYMC, ifnull(ZCH,'') ZCH, ifnull(FR,'') FR, ifnull(QYLX,'') QYLX, ifnull(ZT,'') ZT, ifnull(ZCZB,'') ZCZB, ifnull(ZS,'') ZS, ifnull(ZSFS,'') ZSFS, ifnull(TZZE,'') TZZE, ifnull(SSZB,'') SSZB from VW_ZZ_SH_GSQYJBXX AND ( QYMC like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(YBZJ,'') YBZJ, ifnull(DWMC,'') DWMC, ifnull(ZWXM,'') ZWXM, ifnull(SFZH,'') SFZH, ifnull(CYRQ,'') CYRQ, ifnull(ZYLB,'') ZYLB, ifnull(ZC,'') ZC, ifnull(GZXZ,'') GZXZ, ifnull(YXZT,'') YXZT, ifnull(DJJG,'') DJJG, ifnull(DJR,'') DJR, ifnull(DJSJ,'') DJSJ from VW_ZA_RY_SQJW_DWCYRY AND ( ZWXM like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(ID,'') ID, ifnull(NAME,'') NAME, ifnull(ID_CARD_NO,'') ID_CARD_NO, ifnull(ORG_CODE,'') ORG_CODE, ifnull(ORG_NAME,'') ORG_NAME, ifnull(PASS,'') PASS, ifnull(SCORE,'') SCORE, ifnull(SEX,'') SEX, ifnull(STATION_TYPE_NAME,'') STATION_TYPE_NAME, ifnull(CAR_ID,'') CAR_ID, ifnull(VALID_DATE,'') VALID_DATE, ifnull(BREAK_TYPE_NAME,'') BREAK_TYPE_NAME, ifnull(DEPART,'') DEPART, ifnull(DEVICE_ADDRESS,'') DEVICE_ADDRESS, ifnull(DEVICE_ADDRESS_NAME,'') DEVICE_ADDRESS_NAME, ifnull(DEVICE_NAME,'') DEVICE_NAME, ifnull(DEVICE_SN,'') DEVICE_SN, ifnull(FACE_IMAGE,'') FACE_IMAGE, ifnull(ID_CARD_IMAGE,'') ID_CARD_IMAGE, ifnull(NATION,'') NATION from VW_RY_ZA_ZARYGZLSXX AND ( NAME like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(CAR_NUMBER,'') CAR_NUMBER, ifnull(CREATE_DATE,'') CREATE_DATE, ifnull(DRIVER_NAME,'') DRIVER_NAME, ifnull(DRIVER_MOBILE,'') DRIVER_MOBILE, ifnull(FLIGHT_ATTENDANT_MOBILE,'') FLIGHT_ATTENDANT_MOBILE, ifnull(FLIGHT_ATTENDANT_NAME,'') FLIGHT_ATTENDANT_NAME, ifnull(OBJECTIVE_PLACE,'') OBJECTIVE_PLACE, ifnull(PASSENGER_ID_CARD,'') PASSENGER_ID_CARD, ifnull(PASSENGER_NAME,'') PASSENGER_NAME, ifnull(RIDE_DATE,'') RIDE_DATE, ifnull(RIDE_TIME,'') RIDE_TIME, ifnull(RIDE_TRAIN,'') RIDE_TRAIN, ifnull(START_PLACE,'') START_PLACE, ifnull(STATION,'') STATION from VW_ZA_ZJXT_QCGPXX AND ( PASSENGER_NAME like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(XM,'') XM, ifnull(XB,'') XB, ifnull(MZ,'') MZ, ifnull(SFZH,'') SFZH, ifnull(HJDPCS,'') HJDPCS, ifnull(HJDXZ,'') HJDXZ, ifnull(XZDXZ,'') XZDXZ from VW_RY_QB_QGZTRYXX AND ( XM like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(XM,'') XM, ifnull(XB,'') XB, ifnull(MZ,'') MZ, ifnull(SFZH,'') SFZH, ifnull(HJDPCS,'') HJDPCS, ifnull(HJDXZ,'') HJDXZ, ifnull(XZDXZ,'') XZDXZ from VW_RY_QB_QGZSZHJSBYXX AND ( XM like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(XM,'') XM, ifnull(XB,'') XB, ifnull(MZ,'') MZ, ifnull(SFZH,'') SFZH, ifnull(HJDPCS,'') HJDPCS, ifnull(HJDXZ,'') HJDXZ, ifnull(XZDXZ,'') XZDXZ from VW_RY_QB_QGXSFZQKRYXX AND ( XM like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(XM,'') XM, ifnull(XB,'') XB, ifnull(MZ,'') MZ, ifnull(SFZH,'') SFZH, ifnull(HJDPCS,'') HJDPCS, ifnull(HJDXZ,'') HJDXZ, ifnull(XZDXZ,'') XZDXZ from VW_RY_QB_QGSWRYXX AND ( XM like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(XM,'') XM, ifnull(XB,'') XB, ifnull(MZ,'') MZ, ifnull(SFZH,'') SFZH, ifnull(HJDPCS,'') HJDPCS, ifnull(HJDXZ,'') HJDXZ, ifnull(XZDXZ,'') XZDXZ from VW_RY_QB_QGSKRYXX AND ( XM like CONCAT('%', TRIM(#{keywords}), '%') ) limit #{iDisplayStart}, #{iDisplayLength} select count(1) as total from ( ) total_tab select ifnull(CLPP,'') CLPP, ifnull(CLXH,'') CLXH, ifnull(HPHM,'') HPHM, ifnull(JDCSYR,'') JDCSYR, ifnull(CLSBDH,'') CLSBDH, ifnull(BAR,'') BAR, ifnull(LASJ,'') LASJ, ifnull(LADWMC,'') LADWMC, ifnull(LAJBR,'') LAJBR, ifnull(SLDWMC,'') SLDWMC, ifnull(SLJBR,'') SLJBR, ifnull(BZ,'') BZ from VW_CL_ZA_QGBDQJDCXX AND ( BAR like CONCAT('%', TRIM(#{keywords}), '%') )