<select id="queryVehicleBySelective" parameterType="com.svw.vms.vehicle.dto.VehicleStorageReqDto" resultType="com.svw.vms.vehicle.dto.VehicleStorageResultDto"> SELECT a.hq_vehicle_id hqVehicleId, a.vin vin, a.offline_date offlineDate, a.storage_code storageCode, a.storage_status storageStatus, a.quality_status qualityStatus, (select 1 from tt_sales_lock s where a.commission_no = s.commission_no or a.vin = s.vin) salesLockFlag, a.logistics_lock_flag logisticsLockFlag, a.identity_code identityCode, a.model_code modelCode, a.interior_code interiorCode, a.color_code colorCode, a.pr_list prList, a.engine_no engineNo, a.cert_no certNo, a.purchase_storage_code purchaseStorageCode, a.factory_plate_model factoryPlateModel, a.bol_no bolNo, a.instruction_no instructionNo, a.instruction_type instructionType, a.bill_type billType, b.storage_area_name storageAreaName FROM tt_hq_vehicle a LEFT JOIN tt_trans_storage_lastest b ON a.vin = b.vin AND b.brand_id = #{brandId, jdbcType=BIGINT} WHERE a.brand_id = #{brandId, jdbcType=BIGINT} <if test="storageCode != null and storageCode !=''"> AND a.storage_code = #{storageCode, jdbcType=VARCHAR} </if> <if test="vin != null and vin !=''"> AND a.vin = #{vin, jdbcType=VARCHAR} </if> <if test="modelCode != null and modelCode != ''"> AND a.model_code = #{modelCode, jdbcType=VARCHAR} </if> <if test="interiorCode != null and interiorCode != ''"> AND a.interior_code = #{interiorCode, jdbcType=VARCHAR} </if> <if test="colorCode != null and colorCode != ''"> AND a.color_code = #{colorCode, jdbcType=VARCHAR} </if> <if test="identityCode != null and identityCode != ''"> AND a.identity_code = #{identityCode, jdbcType=VARCHAR} </if> <if test="offlineDateStart != null and offlineDateStart != ''"> AND a.offline_date >= TO_DATE(#{offlineDateStart, jdbcType=VARCHAR}, 'YYYY-MM-DD') </if> <if test="offlineDateEnd != null and offlineDateEnd != ''"> AND a.offline_date < TO_DATE(#{offlineDateEnd, jdbcType=VARCHAR}, 'YYYY-MM-DD') + 1 </if> <if test="qualityStatus != null and qualityStatus != ''"> AND a.quality_status = #{qualityStatus, jdbcType=VARCHAR} </if> <if test="billType != null and billType != ''" > AND a.bill_type = #{billType, jdbcType=CHAR} </if> <if test="vinList != null and vinList.size() > 0"> AND a.vin IN <foreach collection="vinList" item="item" index="index" open="(" close=")" separator=","> #{item} </foreach> </if> <if test="logisticsLockFlag != null and logisticsLockFlag != ''"> <choose> <when test="logisticsLockFlag == '0'"> AND a.logistics_lock_flag = 0 </when> <otherwise> AND a.logistics_lock_flag > 0 </otherwise> </choose> </if> ORDER BY a.hq_vehicle_id DESC </select>
同样的sql语句在数据库中根据条件能查出结果,但是在springboot项目中,却查不出来
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
5条回答 默认 最新
- g5zhu5896 2020-11-26 10:14关注
mybatis 在执行时可以在控制台打印sql,以及对于的参数,把sql复制出来参数放上去在数据库执行看看
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决评论 打赏 举报无用 3
悬赏问题
- ¥15 机器学习教材中的例题询问
- ¥15 求.net core 几款免费的pdf编辑器
- ¥15 C# P/Invoke的效率问题
- ¥20 thinkphp适配人大金仓问题
- ¥20 Oracle替换.dbf文件后无法连接,如何解决?(相关搜索:数据库|死循环)
- ¥15 数据库数据成问号了,前台查询正常,数据库查询是?号
- ¥15 算法使用了tf-idf,用手肘图确定k值确定不了,第四轮廓系数又太小才有0.006088746097507285,如何解决?(相关搜索:数据处理)
- ¥15 彩灯控制电路,会的加我QQ1482956179
- ¥200 相机拍直接转存到电脑上 立拍立穿无线局域网传
- ¥15 (关键词-电路设计)