smartFilter过滤不了中文

qwertyu

jishuang 发表于 2019-3-7 12:03
视图中只有select吗？

select View_ztfzb_claim.*
    from View_ztfzb_claim View_ztfzb_claim

public static Table query(String concept, String idColumn, String select, String from, String condition, List<DataPermission> range,
                        String filter, Boolean distinct, int offset, int limit, String columns, String orderBy, String aggregate, String aggregateColumns,
                        Map<String, Object> variables, String dataModel, String fnModel) {
                return BizData.query(concept, idColumn, select, from, condition, range, filter, distinct, offset, limit, columns, orderBy, aggregate,
                                aggregateColumns, variables, dataModel, fnModel);
        }

qwertyu

jishuang 发表于 2019-3-7 12:03
视图中只有select吗？

这个是数据库中视图的语句
select from_unixtime(`bill`.`ctime`) AS `paytime`,from_unixtime(`zorder`.`ctime`) AS `order_create_time`,`bill`.`serial_number` AS `pay_number`,`inst`.`inmae` AS `pay_unit`,`inst`.`inmae` AS `tenderer_unit`,'' AS `pay_abstract`,0 AS `had_claim_money`,0 AS `ing_claim_money`,0 AS `no_claim_money`,`bill`.`pay_money` AS `pay_money`,`bill`.`pay_money` AS `claim_money`,`p`.`pname` AS `project_name`,`p`.`pno` AS `project_no`,'标书费' AS `cost_type`,'微信支付' AS `pay_mentod`,`inst`.`ibank_account` AS `company_bank_account`,`inst`.`ibank_account` AS `tenderer_unit__account`,`inst`.`inmae` AS `bank_account_name`,NULL AS `voucher_no`,NULL AS `voucher_time`,NULL AS `acceptance_time`,`bill`.`serial_number` AS `pay_description` from ((((`ztfzb_origin_bills` `bill` join `ztfzb_origin_order` `zorder`) join `ztfzb_origin_institution` `inst`) join `ztfzb_origin_apply` `apply`) join `ztfzb_origin_project` `p`) where ((`bill`.`order_id` = `zorder`.`id`) and (`apply`.`id` = `zorder`.`apply_id`) and (`apply`.`institution_id` = `inst`.`id`) and (`apply`.`project_id` = `p`.`id`) and (not(`bill`.`serial_number` in (select `claim`.`serial_number` from `ztfzb_origin_claim` `claim` where (`claim`.`claim_status` = 1)))))

jishuang

用java的jdbc的方式调用执行sql语句看看查出的数据是什么