Preparing: SELECT accuse_id,receive_channel,industry_category,delegate_flag,transfer_department,accuse_content,accuser_type,accuser_id_no,accuser_name,accuser_address,accuser_company,accuser_credit_no,accuser_company_address,accused_type,accused_id_no,accused_name,accused_address,accused_company,accused_credit_no,accused_company_address,accept_flag,solution_channel,process_procedure_stage,receive_procedure_stage,inspection_partner_name,inspection_partner_opinion,inspection_headman_name,inspection_headman_opinion,juzhang_opinion,tingzhang_opinion,receive_date,process_begin_date,decide_date,command_end_date FROM JC_ACCUSE WHERE (accuser_type = ?)
==> Parameters: 1(String)
<== Total: 0
前端请求查询,返回空集合
但是通过sql 到navicat 上查询有数据
前端不用条件查询,可以正确返回数据库记录数量。
非常神奇的方法解决了这个问题,在建表的时候,将所有不是varchar2的字符串类型改为varchar2 ,然后可以正确查询出来了
标签:accuser,no,company,查询,accused,失败,address,oracle From: https://www.cnblogs.com/come-here/p/17245422.html