#####多选题相关


###获得全部多选题记录
GET_ALL_MULTI_PROBLEMS = SELECT * FROM tb_OnLineExam_MultiProblem

###获得指定ID的多选题记录
GET_MULTI_PROBLEM_BY_ID = SELECT * FROM tb_OnLineExam_MultiProblem WHERE ID = ?

###获得匹配指定关键字的所有多选题记录
GET_MULTI_PROBLEMS_BY_KEY_WORD = SELECT * FROM tb_OnLineExam_MultiProblem WHERE Question LIKE ? OR OptionA LIKE ? OR OptionB LIKE ? OR OptionC LIKE ? OR OptionD LIKE ? OR Answer LIKE ?

###获得指定科目ID的所有多选题记录
GET_MULTI_PROBLEMS_BY_COURSE_ID = SELECT * FROM tb_OnLineExam_MultiProblem WHERE CourseID = ?

###获得指定科目ID、指定数量的多选题记录
###（无法指定SQL语句中的?参数）

###添加多选题记录
ADD_MULTI_PROBLEM = INSERT INTO tb_OnLineExam_MultiProblem (CourseID, Question, OptionA, OptionB, OptionC, OptionD, Answer, TotalTimes, ErrorTimes, Description) VALUES (?, ?, ?, ?, ?, ?, ?, 0, 0, ?)

###检查是否已存在相同内容的多选题记录
IS_EXISTENT_MULTI_PROBLEM = SELECT * FROM tb_OnLineExam_MultiProblem WHERE CourseID = ? AND Question = ? AND OptionA = ? AND OptionB = ? AND OptionC = ? AND OptionD = ? AND Answer = ?

###删除指定ID的多选题记录
DELETE_MULTI_PROBLEM_BY_ID = DELETE FROM tb_OnLineExam_MultiProblem WHERE ID = ?

###删除指定科目ID的所有多选题记录
DELETE_MULTI_PROBLEMS_BY_COURSE_ID = DELETE FROM tb_OnLineExam_MultiProblem WHERE CourseID = ?