a.id AS "id", a.exam_paper_id AS "examPaperId", a.question_id AS "questionId", a.question_content AS "questionContent", a.question_type AS "questionType", a.answer AS "answer", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.dt AS "dt", a.remarks AS "remarks", a.del_flag AS "delFlag" groomer_exam_questions SELECT FROM groomer_exam_questions a WHERE a.id = #{id} SELECT FROM groomer_exam_questions a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM groomer_exam_questions a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO groomer_exam_questions( id, exam_paper_id, question_id, question_content, question_type, answer, create_by, create_date, update_by, update_date, dt, remarks, del_flag ) VALUES ( #{id}, #{examPaperId}, #{questionId}, #{questionContent}, #{questionType}, #{answer}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{dt}, #{remarks}, #{delFlag} ) UPDATE groomer_exam_questions SET exam_paper_id = #{examPaperId}, question_id = #{questionId}, question_content = #{questionContent}, question_type = #{questionType}, answer = #{answer}, update_by = #{updateBy.id}, update_date = #{updateDate}, dt = #{dt}, remarks = #{remarks} WHERE id = #{id} UPDATE groomer_exam_questions SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select from a a.exam_paper_id = #{examPaperId} and a.del_flag = '0' select from a a.exam_paper_id = #{examPaperId}