按条件查找html,SQL按条件批量查询

DAO层方法：

/**

*

* @param planPurchaseId

* @param goodsDbIdList

* @return

*/

List selectPlanReqDetail(@Param("planPurchaseId") String planPurchaseId, @Param("goodsDbIdList") List goodsDbIdList);

SELECT

PROJECT_PLAN_REQ_DETAIL.PLAN_DETAIL_ID,

PROJECT_PLAN_REQ_DETAIL.PLAN_PURCHASE_ID,

PROJECT_PLAN_REQ_DETAIL.PLAN_MAT_CODE,

PROJECT_PLAN_REQ_DETAIL.PLAN_REQ_NUM_NOW,

PROJECT_PLAN_REQ_DETAIL.PLAN_ALREADY_BUY_NUM,

PROJECT_PLAN_REQ_DETAIL.PLAN_SHOULD_BUY_NUM

FROM

PROJECT_PLAN_REQ_DETAIL

INNER JOIN GOODS_INFO ON GOODS_INFO.GOODS_MAT_CODE = PROJECT_PLAN_REQ_DETAIL.PLAN_MAT_CODE

AND GOODS_INFO.GOODS_MAT_CODE = PROJECT_PLAN_REQ_DETAIL.PLAN_MAT_CODE

WHERE

PROJECT_PLAN_REQ_DETAIL.PLAN_PURCHASE_ID = #{planPurchaseId}

AND

GOODS_INFO.GOODS_DBID IN

#{item}

原文：https://www.cnblogs.com/gslgb/p/13849969.html