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