Cannot read property ‘code’ of null

開始不知道哪裏出了問題

XML裏面代碼是這個
SELECT rm.code AS CODE , rm.raw_name AS NAME, rm.stock_number AS safenumber, IFNULL(st.sum,0) AS nownumber,(IFNULL(st.store_type_name,‘無’)) AS warehouse,
(IFNULL(rm.stock_number,0)-IFNULL(st.sum,0)) AS number ,(IFNULL(rm.qg_type,0)) AS rmtype
FROM raw_materials rm LEFT JOIN (SELECT SUM ,CODE , store_type_name FROM stock WHERE TYPE=1 )st ON rm.code=st.code
WHERE (IFNULL(rm.stock_number,0)-IFNULL(st.sum,0)) >0 AND rm.forbid=0 and code = #{value}

這段代碼在Navicate裏面是運行成功的

後來找出了問題原來實體類寫的是小寫所以不能大寫，將CODE,NAME改成code ,name就可以了
SELECT rm.code AS code, rm.raw_name AS name, rm.stock_number AS safenumber, IFNULL(st.sum,0) AS nownumber,(IFNULL(st.store_type_name,‘無’)) AS warehouse,
(IFNULL(rm.stock_number,0)-IFNULL(st.sum,0)) AS number ,(IFNULL(rm.qg_type,0)) AS rmtype
FROM raw_materials rm LEFT JOIN (SELECT SUM ,CODE , store_type_name FROM stock WHERE TYPE=1 )st ON rm.code=st.code
WHERE (IFNULL(rm.stock_number,0)-IFNULL(st.sum,0)) >0 AND rm.forbid=0 and code = #{value}