// 存储老师到内存和数据库中
// 第一次使用httpdata获取老师列表时，直接存入数据库，然后从数据库中读出前100条
private void storeTeachers(Elements elements) {
try {
Teacher teacher;
SQLiteDatabase writeData = dbUtils.getWriteData();
String add_sql = "insert into teachers(id,name) values(?,?);";
for (Element element : elements) {
teacher = new Teacher();
teacher.setId(element.attr("value").trim());
teacher.setName(element.text().trim());
// 保存到数据库中
writeData.execSQL(add_sql, new String[] {teacher.getId(), teacher.getName()});
}
} catch (Exception e) {
e.printStackTrace();
}
}
@Override
public void build(
JsonObjectBuilder pBuilder, Examiner pReadOnly, UriInfo pUriInfo, LocalCache pLocalCache) {
if (pReadOnly.getId() != null) {
pBuilder.add("id", pReadOnly.getId());
}
Course course =
(Course)
pLocalCache.cache(() -> pReadOnly.getCourse(), pReadOnly.getCourseId(), Course.class);
pBuilder.add("courseId", course.getId());
pBuilder.add("courseNo", course.getNo());
pBuilder.add("courseTitle", course.getTitle());
pBuilder.add("courseCrHr", course.getCrHr());
pBuilder.add("year", course.getYear());
pBuilder.add("semester", course.getSemester());
pBuilder.add("syllabusId", course.getSyllabusId());
if (!StringUtils.isEmpty(pReadOnly.getPreparerId())) {
Teacher teacher =
(Teacher)
pLocalCache.cache(
() -> pReadOnly.getPreparer(), pReadOnly.getPreparerId(), Teacher.class);
pBuilder.add("preparerId", teacher.getId());
pBuilder.add("preparerName", teacher.getName());
}
if (!StringUtils.isEmpty(pReadOnly.getScrutinizerId())) {
Teacher teacher =
(Teacher)
pLocalCache.cache(
() -> pReadOnly.getScrutinizer(), pReadOnly.getScrutinizerId(), Teacher.class);
pBuilder.add("scrutinizerId", teacher.getId());
pBuilder.add("scrutinizerName", teacher.getName());
}
Department department =
(Department)
pLocalCache.cache(
() -> course.getOfferedBy(), course.getOfferedDepartmentId(), Department.class);
pBuilder.add("courseOfferedByDepartmentId", department.getId());
pBuilder.add("courseOfferedByDepartmentName", department.getShortName());
Syllabus syllabus =
(Syllabus)
pLocalCache.cache(() -> course.getSyllabus(), course.getSyllabusId(), Syllabus.class);
Program program =
(Program)
pLocalCache.cache(() -> syllabus.getProgram(), syllabus.getProgramId(), Program.class);
Department offeredToDepartment =
(Department)
pLocalCache.cache(
() -> program.getDepartment(), program.getDepartmentId(), Department.class);
pBuilder.add("courseOfferedToDepartmentId", offeredToDepartment.getId());
pBuilder.add("courseOfferedToDepartmentName", offeredToDepartment.getShortName());
}
