MyBatis中传入参数parameterType类型详解

 
 id, car_dept_name, car_maker_name, icon,car_maker_py,hot_type 
  
  
 select 
  
 from common_car_make 
 where id = #{id,jdbcType=BIGINT} 
  

 
  select 
   
  from common_car_make cm 
  where 1=1 
   
   and cm.id = #{id,jdbcType=DECIMAL} 
   
   
   and cm.car_dept_name = #{carDeptName,jdbcType=VARCHAR} 
   
   
   and cm.car_maker_name = #{carMakerName,jdbcType=VARCHAR} 
   
   
   and cm.hot_type = #{hotType,jdbcType=BIGINT} 
   
  ORDER BY cm.id 
  

 
 update common_car_make 
  
   
  car_dept_name = #{carDeptName,jdbcType=VARCHAR}, 
   
   
  car_maker_name = #{carMakerName,jdbcType=VARCHAR}, 
   
   
  icon = #{icon,jdbcType=VARCHAR}, 
   
   
   car_maker_py = #{carMakerPy,jdbcType=VARCHAR}, 
   
   
   hot_type = #{hotType,jdbcType=BIGINT}, 
   
  
 where id = #{id,jdbcType=BIGINT} 
  

 
  select sum(pro_order_num) proOrderNum,product_id productId,promotion_id promotionId 
  from pro_order 
  where 1=1 
   
   and 
    
    #{item,jdbcType=BIGINT} 
    
   
  GROUP BY product_id,promotion_id 
  

List selectIdBySortTime(@Param(value="startdate")String startDate); 

 
 select distinct ajlcid from ebd_fh_ajlc where sorttime >= to_date(#{startdate,jdbcType=VARCHAR},'YYYY-MM-DD') and created_date=updated_date 
 and keyvalue in (select distinct companyname from ebd_fh_company_list where isupdate='0') 
  

List selectIds(@Param(value="dateVo")DateVo dateVo); 

 
 select distinct ajlcid from ebd_fh_ajlc where sorttime >= to_date(#  {dateVo.startDate,jdbcType=VARCHAR},'YYYY-MM-DD') and created_date=updated_date 
 and keyvalue in (select distinct companyname from ebd_fh_company_list where isupdate='0')