MyBatis Plus 查询教练修改时间段信息 - 注解和XML两种方式

{"title":"create table UPDATE_TIME\n(\n UPDATE_TIME_ID bigint not null,\n COACH_ID bigint,\n PROJECT_TYPE varchar(255),\n COURSE_DATE date,\n START_RESERVATION_TIME varchar(255),\n END_RESERVATION_TIME varchar(255),\n MAX_RESERVATION int,\n CURRENT_RESERVATION int,\n COURSE_STATUS tinyint,\n IS_BREAK_DATE tinyint,\n IS_BRESK_TIME tinyint,\n primary key (UPDATE_TIME_ID)\n);\ncreate table COURSE_INFO\n(\n COURSE_ID bigint not null,\n CAR_USER_ID bigint,\n UPDATE_TIME_ID bigint not null,\n TRAINING_STATUS int,\n primary key (COURSE_ID)\n);\n\n通过这两个表，java怎么通过mybatisplus查询到一个教练当前的所有修改时间段信息内容：可以通过MyBatis Plus的注解方式或者XML方式来编写查询语句。\n\n使用注解方式编写查询语句：\njava\n@Mapper\npublic interface UpdateTimeMapper extends BaseMapper<UpdateTime> {\n\n @Select("SELECT * FROM UPDATE_TIME WHERE COACH_ID = #{coachId}")\n List<UpdateTime> getUpdateTimeByCoachId(@Param("coachId") Long coachId);\n}\n\n@Mapper\npublic interface CourseInfoMapper extends BaseMapper<CourseInfo> {\n\n @Select("SELECT * FROM COURSE_INFO WHERE CAR_USER_ID = #{carUserId}")\n List<CourseInfo> getCourseInfoByCarUserId(@Param("carUserId") Long carUserId);\n}\n\n\n使用XML方式编写查询语句：\n在resources/mapper目录下创建UpdateTimeMapper.xml和CourseInfoMapper.xml，分别编写查询语句：\n\nUpdateTimeMapper.xml：\nxml\n<mapper namespace="com.example.mapper.UpdateTimeMapper">\n\n <select id="getUpdateTimeByCoachId" resultType="com.example.entity.UpdateTime">\n SELECT * FROM UPDATE_TIME WHERE COACH_ID = #{coachId}\n </select>\n\n</mapper>\n\n\nCourseInfoMapper.xml：\nxml\n<mapper namespace="com.example.mapper.CourseInfoMapper">\n\n <select id="getCourseInfoByCarUserId" resultType="com.example.entity.CourseInfo">\n SELECT * FROM COURSE_INFO WHERE CAR_USER_ID = #{carUserId}\n </select>\n\n</mapper>\n\n\n然后在对应的Service类中注入对应的Mapper接口，并调用方法来查询数据：\njava\n@Service\npublic class CoachService {\n\n @Autowired\n private UpdateTimeMapper updateTimeMapper;\n\n @Autowired\n private CourseInfoMapper courseInfoMapper;\n\n public List<UpdateTime> getUpdateTimesByCoachId(Long coachId) {\n return updateTimeMapper.getUpdateTimeByCoachId(coachId);\n }\n\n public List<CourseInfo> getCourseInfosByCarUserId(Long carUserId) {\n return courseInfoMapper.getCourseInfoByCarUserId(carUserId);\n }\n}\n\n\n以上代码示例假设已经定义了UpdateTime和CourseInfo的实体类。