mybatis 日期转换的方式

最新推荐文章于 2024-07-24 23:16:59 发布

孤舟听雨

最新推荐文章于 2024-07-24 23:16:59 发布

阅读量7.4k

点赞数

分类专栏： java mysql mybatis

本文链接：https://blog.csdn.net/u013043762/article/details/79867167

版权

mysql 同时被 3 个专栏收录

34 篇文章 0 订阅

订阅专栏

java

15 篇文章 0 订阅

订阅专栏

mybatis

5 篇文章 0 订阅

订阅专栏

  <select id="selectAndUser" parameterType="Map" resultMap="BaseResultMapAndUser">
        select t_user_auth.*,t_user.phone,t_user.inviter_count
        from t_user_auth
        inner join t_user on t_user_auth.user_id=t_user.id
            <if test="status!=null and status!=''">
                and t_user_auth.status =#{status}
            </if>
            <if test="startDate!=null">
                and t_user_auth.create_date &gt;=
                FROM_UNIXTIME(#{startDate},'%Y-%m-%d %H:%i:%s')
            </if>
            <if test="endDate!=null">
                and t_user_auth.create_date &lt;=FROM_UNIXTIME(#{endDate},'%Y-%m-%d %H:%i:%s')
            </if>
            <if test="phone!=null">
                and phone like  CONCAT('%',#{phone},'%')
            </if>
    </select>

 <select id="search" resultMap="BaseResultMapUserAndAuth" parameterType="map">
        select
        t_user.*,user1.username as inviterName
        from t_user inner join t_user user1
        on t_user.inviter_user_id=user1.id
        where 1=1
        <foreach collection="params" index="key" item="value">
            <choose>
                <when test="key=='startDate'">
                    and t_user.create_date &gt;=  str_to_date(#{value},'%Y-%m-%d %H:%i:%s')
                </when>
                <when test="key=='endDate'">
                    and t_user.create_date  &lt;= str_to_date(#{value},'%Y-%m-%d %H:%i:%s')
                </when>
                <when test="key=='inviterName'">
                    and user1.username like CONCAT('%',#{value},'%')
                </when>
                <otherwise>
                    and t_user.${key} like CONCAT('%',#{value},'%')
                </otherwise>
            </choose>
        </foreach>
    </select>