@Select("select * from orders where `phoneNum` = #{phoneNum} and `finishTime` is null")
@Results({
@Result(property = "task",column = "taskId",
one = @One(select = "com.example.ProjectPractice.Dao.taskDao.getTaskByTaskId"))
})
List<Orders> getOrderingByPhoneNum(String phoneNum);
样的代码进行查询,根据order中的taskId去task表中找到对应的task,但是在最后返回的结果中:
[Orders{orderId=1, taskId=null, phoneNum='155', receiveTime=Mon Apr 12 22:07:34 GMT+08:00 2021, finishTime=Mon Apr 12 23:14:02 GMT+08:00 2021, task=Task{taskId=6, phoneNum='15505422837', taskTitle='学习服务', taskType=4, taskReward=250, taskContent='学习学习', taskInTime=Sun Apr 11 14:41:51 GMT+08:00 2021, taskOutTime=Sat May 01 14:41:56 GMT+08:00 2021, taskState=2, taskPeoNum=5}}]
找到了符合的结果为taskId = 6的task但是order中的taskId外键却成了null?
很是不解???