<select id="getProblemOnlineByUserId" resultType="com.examstack.common.domain.sets.ProblemOnline">
select a.id histId, a.user_id userId, a.group_id groupId, b.id problemId,
c.id problemSetsId, b.problem_name problemName, c.name AS problemSetsName,
c.content, c.answer_sheet answerSheet, c.field_id fieldId, c.duration,
c.total_point totalPoint, c.pass_point passPoint, b.start_time effTime,
b.end_time expTime, a.start_time answerTime, a.submit_time submitTime,
a.point_get pointGet
from et_user_problem_history a, et_problem b, et_problem_sets c
<where>
a.problem_id = b.id AND a.problem_sets_id = c.id AND b.approved = 1
AND b.released = 1 AND <![CDATA[ b.start_time <= NOW() AND b.end_time >= NOW() ]]>
AND a.user_id = #{userId}
</where>
</select>
时间判断的时候
<![CDATA[ b.start_time <= NOW() AND b.end_time >= NOW() ]]>