數(shù)據(jù)庫(kù)中沒(méi)有滿足條件的id 就會(huì)報(bào)
HTTP Status 500 - Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Mapper method 'org.tsinghua.cis.dao.CisMedicineDetailsIdDao.findMedicineDetailsIdByClinicIdAndBarCode attempted to return null from a method with a primitive return type (int).
<select id="findMedicineDetailsIdByClinicIdAndBarCode" resultType="int">
<![CDATA[
SELECT
a.`id`
FROM
`cis_medicine_details_id` AS a
INNER JOIN
`cis_medicine_pricing` AS b
ON
a.id = b.medicine_details_id
WHERE
`medicine_bar_code` = ${medicineBarCode}
AND
`clinic_id` = ${clinicId}
]]>
</select>
解決方案
1.把resultType="int" 改為resultType="Integer"
在server層 判斷 if(null==參數(shù)){
做相應(yīng)的操作 是賦值0還是返回null 根據(jù)需要自行編寫(xiě)
}
2.使用IFNULL函數(shù)
<select id="findMedicineDetailsIdByClinicIdAndBarCode" resultType="int">
<![CDATA[
SELECT
IFNULL(a.`id`,0)
FROM
`cis_medicine_details_id` AS a
INNER JOIN
`cis_medicine_pricing` AS b
ON
a.id = b.medicine_details_id
WHERE
`medicine_bar_code` = ${medicineBarCode}
AND
`clinic_id` = ${clinicId}
]]>
</select>
