从连接表中选择OrmLite新对象进行插入

// 假设有三个类：Student, Course, StudentCourse
public class Student {
    @DatabaseField(generatedId = true)
    private int id;
    private String name;
    // getters and setters
}

public class Course {
    @DatabaseField(generatedId = true)
    private int id;
    private String title;
    // getters and setters
}

public class StudentCourse {
    @DatabaseField(foreign = true, foreignAutoRefresh = true, columnName = "student_id")
    private Student student;
    
    @DatabaseField(foreign = true, foreignAutoRefresh = true, columnName = "course_id")
    private Course course;
    // getters and setters
}

// 数据库帮助类
public class DatabaseHelper extends OrmLiteSqliteOpenHelper {
    // 初始化数据库和表
}

// 使用OrmLite进行操作
public List<StudentCourse> getStudentCourses(int studentId) throws SQLException {
    Dao<StudentCourse, Integer> studentCourseDao = getDao(StudentCourse.class);
    QueryBuilder<StudentCourse, Integer> queryBuilder = studentCourseDao.queryBuilder();
    queryBuilder.where().eq("student_id", studentId);
    return queryBuilder.query();
}

// 创建新的StudentCourse对象并插入
public void addStudentCourse(Student student, Course course) throws SQLException {
    Dao<StudentCourse, Integer> studentCourseDao = getDao(StudentCourse.class);
    StudentCourse studentCourse = new StudentCourse();
    studentCourse.setStudent(student);
    studentCourse.setCourse(course);
    studentCourseDao.create(studentCourse);
}