传智医疗中:Cannot read properties of null (reading 'member')问题解决
原代码如下
<!--根据预约id查询预约信息,包括体检人信息、套餐信息-->
<select id="findById4Detail" parameterType="int" resultType="map">
select m.name member ,s.name setmeal,o.orderDate orderDate,o.orderType orderType
from
t_order o,
t_member m,
t_setmeal s
where o.member_id=m.id and o.setmeal_id=s.id and o.id=#{id}
</select>
<!--根据预约id查询预约信息,包括体检人信息、套餐信息-->
<select id="findById4Detail" parameterType="int" resultType="map">
select m.name member ,s.name setmeal,o.orderDate orderDate,o.orderType orderType
from
t_order o,
t_member m,
t_setmeal s
where o.member_id=m.id and o.setmeal_id=s.id and o.id=#{id}
</select>
修改后代码
<!--根据预约id查询预约信息,包括体检人信息、套餐信息-->
<select id="findById4Detail" parameterType="int" resultType="map">
select m.name 'member', s.name 'setmeal', o.orderDate 'orderDate', o.orderType 'orderType'
from t_order o,
t_member m,
t_setmeal s
where o.member_id = m.id
and o.setmeal_id = s.id
and o.id = #{id}
</select>
<!--根据预约id查询预约信息,包括体检人信息、套餐信息-->
<select id="findById4Detail" parameterType="int" resultType="map">
select m.name 'member', s.name 'setmeal', o.orderDate 'orderDate', o.orderType 'orderType'
from t_order o,
t_member m,
t_setmeal s
where o.member_id = m.id
and o.setmeal_id = s.id
and o.id = #{id}
</select>
产生原因:
由于MySQL版本不同相关得数据库语法好像也有改变
8.0以上的对表起别名需要加单引号!!!!
求你们了一定刷到我的文章,那天晚上看了半天不知道为啥因为代码跟老师讲的一模一样,浏览器缓存清理了还是不行,重新安装还是不行,麻烦了直接睡觉了。刚才开弹幕看才发现问题!!!!