<select id="getLikeObject" parameterType="java.util.Map" resultMap="OaOperation" >
SELECT
ID,
USER_ID,
TITLE,
CURRWEEK,
NEXTWEEK,
QUESTION,
REMARK,
DESCRIPTION,
COMMENT,
READFLAG,
READER,
ISSUE,
CLOSED,
CREATOR,
CREATE_TIME,
MODIFIER,
MODIFY_TIME,
FLAG
FROM ${OA_OPERATION}
<where>
<trim prefixOverrides="AND">
<if test="userId != null"> AND USER_ID = #{userId} </if>
<if test="createTime != null"> AND DATE_FORMAT(CREATE_TIME,'%Y-%m-%d')=#{createTime}</if>
</trim>
</where>
SELECT
ID,
USER_ID,
TITLE,
CURRWEEK,
NEXTWEEK,
QUESTION,
REMARK,
DESCRIPTION,
COMMENT,
READFLAG,
READER,
ISSUE,
CLOSED,
CREATOR,
CREATE_TIME,
MODIFIER,
MODIFY_TIME,
FLAG
FROM ${OA_OPERATION}
<where>
<trim prefixOverrides="AND">
<if test="userId != null"> AND USER_ID = #{userId} </if>
<if test="createTime != null"> AND DATE_FORMAT(CREATE_TIME,'%Y-%m-%d')=#{createTime}</if>
</trim>
</where>
</select>
select *from tablename where DATE_FORMAT(CREATE_TIME,'%Y-%m-%d')=now(); //拿当前日期跟table 中的数据比较