Mybatis

1）传入String参数

<select id="getAllProdTotal" resultType="java.math.BigDecimal" parameterType="java.lang.String" >
   SELECT IFNULL(SUM(PROD_AMOUNT_TOTAL),0) FROM eb_prod_rubb_type t
   WHERE t.CREDIT_CODE = #{_parameter}
</select>

下面这种好像也可以

<!--区用户下获取所有产生台账数量-->
<select id="getAllProdDayBillCount" resultType="Long" parameterType="string" lang="velocity">
   select count(1) from eb_prod_day_bill t1, eb_prod_rubb_type t2,qy_company_info t3
   where t1.RUBB_TYPE_ID = t2.ID and t2.CREDIT_CODE = t3.CREDIT_CODE
   and t3.COUNTRY_CODE = @{_parameter,jdbcType=VARCHAR}
</select>

2）传入Map参数

<select id="getAllHazardousDraftCount" resultType="Long" parameterType="java.util.Map" >
   SELECT count(1) FROM
   tp_hazardous_draft t1
   LEFT JOIN qy_company_info t2 ON t1.CREDIT_CODE = t2.CREDIT_CODE
   LEFT JOIN qy_company_info t3 ON t1.handle_CREDIT_CODE = t3.CREDIT_CODE
   WHERE
   (t2.COUNTRY_CODE = #{areaCode}
   OR t3.COUNTRY_CODE = #{areaCode}) AND t1.transfer_time &gt;= #{startTime}
</select>