使用mybatis时 有一个sql查询不到结果 日志也显示查询为o 但是从日志中取出执行的sql到数据库客户端手动执行，可以查到数据

bug场景
使用mybatis时 有一个sql查询不到结果 日志也显示查询为o 但是从日志中取出执行的sql到数据库客户端手动执行，可以查到数据

日志：
2018-08-08 13:57:13,101 DEBUG [jeesite.modules.sys.interceptor.LogInterceptor] - 开始计时: 01:57:13.101 URI: /DShare/jhgx/evidence/list
2018-08-08 13:59:31,883 DEBUG [jeesite.common.persistence.interceptor.PaginationInterceptor] - COUNT SQL: select count(1) from (select FLOW_ID, FLOWTYPE, FLOWINFO, RES_ID, RES_NAME, RES_DESC, FLOW_SEQ, APPLY_USERID, REPLY_USERID, APPLY_USERNAME, REPLY_USERNAME, APPLY_TIME, REPLY_TIME, OPER_TIME, OPER_USERID, OPER_USERNAME, APPLY_CONTENT, APPLY_ENTITY, REPLY_CONTENT, REPLY_ENTITY, RES_ORG, FARM_RESOURCE_FLOW.APPLY_ORG, FLAG, ATTACHMENT, FILENAME, RES_ORGNAME, apply_orgname, CONFIG_CONTENT, FROM_TYPE from FARM_RESOURCE_FLOW where 1=1 and FARM_RESOURCE_FLOW.APPLY_ORG =? ORDER BY OPER_TIME DESC) tmp_count
2018-08-08 13:59:31,953 DEBUG [modules.resource.dao.ResourceTemplateDao.queryPageResourceFlow] - ==> Preparing: select row_.*, rownum rownum_ from ( select FLOW_ID, FLOWTYPE, FLOWINFO, RES_ID, RES_NAME, RES_DESC, FLOW_SEQ, APPLY_USERID, REPLY_USERID, APPLY_USERNAME, REPLY_USERNAME, APPLY_TIME, REPLY_TIME, OPER_TIME, OPER_USERID, OPER_USERNAME, APPLY_CONTENT, APPLY_ENTITY, REPLY_CONTENT, REPLY_ENTITY, RES_ORG, FARM_RESOURCE_FLOW.APPLY_ORG, FLAG, ATTACHMENT, FILENAME, RES_ORGNAME, apply_orgname, CONFIG_CONTENT, FROM_TYPE from FARM_RESOURCE_FLOW where 1=1 and FARM_RESOURCE_FLOW.APPLY_ORG =? ORDER BY OPER_TIME DESC ) row_ where rownum <= 10
2018-08-08 13:59:31,964 DEBUG [modules.resource.dao.ResourceTemplateDao.queryPageResourceFlow] - ==> Parameters: 010101000(String)
2018-08-08 13:59:32,033 DEBUG [modules.resource.dao.ResourceTemplateDao.queryPageResourceFlow] - <== Total: 0

同样的sql放到数据库客户端执行，结果如下：

**

解决方案：将查询条件中的“#”替换成“$”.

**

修改后运行日志：
COUNT SQL: select count(1) from (select FLOW_ID, FLOWTYPE, FLOWINFO, RES_ID, RES_NAME, RES_DESC, FLOW_SEQ, APPLY_USERID, REPLY_USERID, APPLY_USERNAME, REPLY_USERNAME, APPLY_TIME, REPLY_TIME, OPER_TIME, OPER_USERID, OPER_USERNAME, APPLY_CONTENT, APPLY_ENTITY, REPLY_CONTENT, REPLY_ENTITY, RES_ORG, FARM_RESOURCE_FLOW.APPLY_ORG, FLAG, ATTACHMENT, FILENAME, RES_ORGNAME, apply_orgname, CONFIG_CONTENT, FROM_TYPE from FARM_RESOURCE_FLOW where 1=1 and FARM_RESOURCE_FLOW.APPLY_ORG =010101000 ORDER BY OPER_TIME DESC) tmp_count
2018-08-08 14:34:19,784 DEBUG [modules.resource.dao.ResourceTemplateDao.queryPageResourceFlow] - ==> Preparing: select row_.*, rownum rownum_ from ( select FLOW_ID, FLOWTYPE, FLOWINFO, RES_ID, RES_NAME, RES_DESC, FLOW_SEQ, APPLY_USERID, REPLY_USERID, APPLY_USERNAME, REPLY_USERNAME, APPLY_TIME, REPLY_TIME, OPER_TIME, OPER_USERID, OPER_USERNAME, APPLY_CONTENT, APPLY_ENTITY, REPLY_CONTENT, REPLY_ENTITY, RES_ORG, FARM_RESOURCE_FLOW.APPLY_ORG, FLAG, ATTACHMENT, FILENAME, RES_ORGNAME, apply_orgname, CONFIG_CONTENT, FROM_TYPE from FARM_RESOURCE_FLOW where 1=1 and FARM_RESOURCE_FLOW.APPLY_ORG =010101000 ORDER BY OPER_TIME DESC ) row_ where rownum <= 10
2018-08-08 14:34:19,784 DEBUG [modules.resource.dao.ResourceTemplateDao.queryPageResourceFlow] - ==> Parameters:
2018-08-08 14:34:19,814 DEBUG [modules.resource.dao.ResourceTemplateDao.queryPageResourceFlow] - <== Total: 4

MyBatis看到 #{}会认为你在给sql中的变量赋值，就像JDBC编程中给问号赋值一样(自动在前后加单引号)也就是说，他把你传入的字符串并没有当做多个值，而是当做一个大的字符串，所以查询不到值

而MyBatis看到${}的时候会直接将之替换成变量的值而不做任何处理。

修改好的sql：

    <if test="apply_org !=null and apply_org !='' ">
        and FARM_RESOURCE_FLOW.APPLY_ORG =${apply_org}
    </if>
    <if test="reply_org !=null and reply_org !='' ">
        and RES_ORG =#{reply_org}
    </if>

由于出的bug是第一个的问题，第二个就不做修改，经测试查询正常