批量查询语句：

 

List
       
         selectBatchInfo(List
        
          idList);
        
       

 

             select        from moirai_product_resource    WHERE PRODUCT_ID IN          #{item}      

批量插入：

int insertBatchInfo(List
       
         listMoiraiProductResource);
       

         
       
            insert into moirai_product_resource (PRODUCT_RESOURCE_ID, PRODUCT_ID, RESOURCE_ID,    CREATETIME, CREATER)    values    
        
               (#{item.productResourceId,jdbcType=BIGINT}, #{item.productId,jdbcType=BIGINT}, #{item.resourceId,jdbcType=BIGINT},      #{item.createtime,jdbcType=BIGINT}, #{item.creater,jdbcType=VARCHAR})