oracle 条件查询失败

发布时间 2023-03-22 23:29:26作者: wangjin_1
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 ,然后可以正确查询出来了