Mybatis

1.if......else

<choose>    
    <when test="createById == null">       
        and (attendee_id  = #{attendeeId})    
    </when>    
    <otherwise>
        and (create_by_id = #{createById} or attendee_id  = #{attendeeId})    
    </otherwise>
</choose>

2.提出sql

<sql id="selectGhyScheduleVo">    
    select DAYOFMONTH(start_time) thisDay, id, event_theme, start_time, end_time, event_status, event_remind, create_by_id, attendee_id, `source`, meeting_place, urgency from ghy_schedule 
</sql>
<select id="selectGhyScheduleList" parameterType="GhySchedule" resultMap="GhyScheduleResult">
        <include refid="selectGhyScheduleVo"/>
        <where>
            <if test="eventTheme != null  and eventTheme != ''"> 
                event_theme like concat('%', #{eventTheme}, '%')
            </if>
            <if test="urgency != null  and urgency != ''"> 
                urgency = #{urgency}
            </if>
        </where>
</select>

3.查询条件：需要获取dataDay时间的数据

DATE_FORMAT(字段,'%Y-%m-%d') = #{dataDay}

4.查询条件：需要获取区间之内信息（从selStartTime到selEndTime）

字段 BETWEEN #{selStartTime} and #{selEndTime}

5.select后面写：需要查询这是这个月第几天

DAYOFMONTH(字段)

GROUP_CONCAT( 字段 ) // 根据字段分组后每组的数据总数