无条件查询时,能够正常返回数据,在前台输入一个入参到后台就没有数据返回,控制台不抱错,js无报错
系统框架是springMVC
mapper.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
select a.wareid,a.warename,a.warekindid,a.blockid,a.regdate,a.yavgprice,a.wpoint,a.taxrate,a.fpdefrate,a.minprice,a.mintrade,
a.oncenum,a.setmatchtype,a.setpricetype,a.MYS_FIRMID,a.minsetnum,a.setdate,a.setdays,a.pickdays,a.mkinvoicedays,a.avgdays,
a.pricescale,a.END_LIST_DATE,a.SELECTED_END_DATE,b.variety_name
from ebp.t_contract_commodity a left join msdata.T_VARIETY b on a.variety_id=b.variety_id
where 1=1
and wareid = #{wareid,jdbcType=VARCHAR}
and warename = #{warename,jdbcType=VARCHAR}