MyBaitis SQL(一)

<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() ]]> 

转载于:https://www.cnblogs.com/bobc/p/8391987.html