SELECT
ttc.id,ttc.teacher_id,ttc.teach_class_id,ttc.school_year,tc.name
FROM
tt_teacher_teach_class ttc
LEFT JOIN tt_teach_class tc ON ttc.teach_class_id = tc.id
WHERE
ttc.is_delete = 0
AND ttc.teacher_id = #{teacherId}
AND ttc.school_year = #{semester}
String semester = YearSemester.getYearSemesterCode(0, 0).get(0);
List<SelectTeacherTeachClassModel> teacherTeachClassEntities = teacherTeachClassDao.getByTeacherId1(teacherId,semester);
if(teacherTeachClassEntities.size() == 0){
return null;
}
else{
return teacherTeachClassEntities;
}
一段代码
最新推荐文章于 2024-03-23 13:28:35 发布