Article From:https://www.cnblogs.com/fengnan/p/9967416.html

If you encounter such a problem, you can look up the database according to some fields. The database is running well, but you can’t get it to mapper. xml.

As a result, I tried to look it up according to each condition, and found that there was no problem with the others. When a field was used as a conditional query, it could not be queried.

So try to change the value of 65507

<select id="getInventoryByThree" parameterType="com.docc.model.Inventory"
     resultType="com.docc.model.Inventory">
        select * from BUS_INVENTORY 
        where company = #{company,jdbcType=VARCHAR} 
              and reportdate = #{reportdate,jdbcType=CHAR} 
              and type = '${type}' 
    </select>

 

Leave a Reply

Your email address will not be published. Required fields are marked *