测试代码格式
来源:互联网 发布:网络流行伤感歌曲大全 编辑:程序博客网 时间:2024/05/17 07:20
测试
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="com.hzlh.mapper.CommentMapper"><resultMap type="CommentPo" id="RMCommentPo"><id property="id" column="ID" /><result property="correlateId" column="CORRELATE_ID" /><result property="correlateName" column="CORRELATE_NAME" /><result property="icon" column="ICON"/><result property="type" column="TYPE" /><result property="commentReplyType" column="COMMENT_REPLY_TYPE"/><result property="supplierId" column="SUPPLIER_ID" /><result property="supplierName" column="SUPPLIER_NAME" /><result property="songName" column="SONG_NAME"/><result property="content" column="CONTENT" /><result property="praiseCount" column="PRAISE_COUNT" /><result property="status" column="STATUS" /><result property="asterisk" column="ASTERISK"/><result property="discussantId" column="DISCUSSANT_ID" /><result property="discussantName" column="DISCUSSANT_NAME" /><result property="replyUserId" column="REPLY_USER_ID" /><result property="replyUserName" column="REPLY_USER_NAME" /><result property="replyCommentId" column="REPLY_COMMENT_ID" /><result property="presenter" column="IS_PRESENTER" /><result property="createTime" column="CREATE_TIME" /></resultMap><select id="getCommentPage" resultMap="RMCommentPo" parameterType="map"> SELECT * FROM (SELECT tcr.ID, tcr.CORRELATE_ID, CASE tcr.TYPE WHEN 0 THEN tt.TITLE WHEN 1 THEN tn.TITLE WHEN 2 THEN tc.TITLE WHEN 3 THEN tcr.SONG_NAME WHEN 4 THEN tcr.SONG_NAME WHEN 5 THEN tcr.SONG_NAME ELSE '' END as CORRELATE_NAME, CASE tcr.IS_PRESENTER WHEN 0 THEN tmpu.ICON WHEN 1 THEN tcau.ICON ELSE '' END as ICON, CASE tcr.TYPE WHEN 0 THEN tcr.CHANNEL_COLUMN_ID WHEN 1 THEN tcr.CHANNEL_COLUMN_ID WHEN 2 THEN tcr.CHANNEL_COLUMN_ID WHEN 3 THEN tcr.CORRELATE_ID WHEN 4 THEN tcr.CORRELATE_ID WHEN 5 THEN tcr.CORRELATE_ID ELSE '' END as CHANNEL_ID, tcr.CONTENT, tcr.TYPE, IF(tcr.REPLY_COMMENT_ID is null, 1 , 2) as COMMENT_REPLY_TYPE, tcr.SUPPLIER_ID, tcr.PRAISE_COUNT, tcr.STATUS, tcr.ASTERISK, tcr.DISCUSSANT_ID, CASE tcr.IS_PRESENTER WHEN 0 THEN IF(tcr.DISCUSSANT_ID is null,'匿名用户',IFNULL(tmpu.NICK_NAME,'匿名用户')) WHEN 1 THEN '主持人' ELSE '' END as DISCUSSANT_NAME, tcr.REPLY_USER_ID, IF(tcr.REPLY_USER_ID ='' || tcr.REPLY_USER_ID is null,'', IF(tcar.USER_ID ='' || tcar.USER_ID is null, IFNULL(tmpr.NICK_NAME,'匿名用户'),'主持人')) as REPLY_USER_NAME, tcr.REPLY_COMMENT_ID, tcr.CREATE_TIME, CASE tcr.TYPE WHEN 0 THEN tar.ANCHORPERSON_ID WHEN 1 THEN tar.ANCHORPERSON_ID WHEN 2 THEN tar.ANCHORPERSON_ID WHEN 3 THEN tcs.S_UPLOADER WHEN 4 THEN tar.ANCHORPERSON_ID WHEN 5 THEN tcc.PRODUCER ELSE '' END as USER_IDFROM TBL_COMMENT_REPLY tcr left join TBL_TOPIC tt on tcr.CORRELATE_ID = tt.ID left join TBL_NEWS tn on tcr.CORRELATE_ID = tn.ID left join TBL_CAMPAIGN tc on tcr.CORRELATE_ID = tc.ID left join TBL_ANCHORPERSON_RESOURCE tar on tcr.CORRELATE_ID = tar.RESOURCE_ID left join TBL_CLOUDTB_COLUMN tcc on tcr.CORRELATE_ID = tcc.id left join TBL_CLOUDTB_SONG tcs on tcr.CORRELATE_ID = tcs.ID left join TBL_MOBILE_PHONE_USER tmpu on tcr.DISCUSSANT_ID = tmpu.PHONE left join TBL_MOBILE_PHONE_USER tmpr on tcr.REPLY_USER_ID = tmpr.PHONE left join TBL_CLOUDTB_ADMIN tcau on tcr.DISCUSSANT_ID = tcau.ID left join TBL_CLOUDTB_ADMIN tcar on tcr.REPLY_USER_ID = tcar.ID <where> <if test="createTime != null and createTime !=''">AND DATE_FORMAT(tcr.CREATE_TIME,'%Y-%m-%d') = #{createTime}</if> <if test="correlateId != null">AND tcr.CORRELATE_ID in (${correlateId})</if> <if test="type != null">AND tcr.TYPE = #{type}</if><if test="status != null">AND tcr.STATUS = #{status}</if><if test="asterisk != null">AND tcr.ASTERISK =#{asterisk}</if><if test="filterStatus != null">AND tcr.STATUS != #{filterStatus}</if><if test="startTime != '' and endTime!= ''">AND tcr.CREATE_TIME BETWEEN #{startTime} AND #{endTime}</if></where>group by tcr.ID, tcr.CORRELATE_ID, CORRELATE_NAME, ICON, CHANNEL_ID, tcr.CONTENT, tcr.TYPE, COMMENT_REPLY_TYPE, tcr.SUPPLIER_ID, tcr.PRAISE_COUNT, tcr.STATUS, tcr.ASTERISK, tcr.DISCUSSANT_ID, DISCUSSANT_NAME, tcr.REPLY_USER_ID, REPLY_USER_NAME, tcr.REPLY_COMMENT_ID, tcr.CREATE_TIME, USER_ID ORDER BY tcr.CREATE_TIME DESC ) t <where> <if test="key != null and key !=''"> AND ( t.CONTENT like CONCAT('%',#{key},'%') OR t.DISCUSSANT_NAME like CONCAT('%',#{key},'%') ) </if> <if test="channelId != null and channelId !=''"> AND t.CHANNEL_ID in (${channelId}) </if> <if test="userId != null and userId !=''"> AND t.USER_ID in (${userId}) </if> </where> <if test="start != null and end != null"> LIMIT #{start},#{end}</if></select><select id="getCommentCount" resultType="java.lang.Integer" parameterType="map"> SELECT COUNT(*) from ( SELECT tcr.ID, tcr.CORRELATE_ID, CASE tcr.TYPE WHEN 0 THEN tt.TITLE WHEN 1 THEN tn.TITLE WHEN 2 THEN tc.TITLE WHEN 3 THEN tcr.SONG_NAME WHEN 4 THEN tcr.SONG_NAME WHEN 5 THEN tcr.SONG_NAME ELSE '' END as CORRELATE_NAME, CASE tcr.IS_PRESENTER WHEN 0 THEN tmpu.ICON WHEN 1 THEN tcau.ICON ELSE '' END as ICON, CASE tcr.TYPE WHEN 0 THEN tcr.CHANNEL_COLUMN_ID WHEN 1 THEN tcr.CHANNEL_COLUMN_ID WHEN 2 THEN tcr.CHANNEL_COLUMN_ID WHEN 3 THEN tcr.CORRELATE_ID WHEN 4 THEN tcr.CORRELATE_ID WHEN 5 THEN tcr.CORRELATE_ID ELSE '' END as CHANNEL_ID, tcr.CONTENT, tcr.TYPE, IF(tcr.REPLY_COMMENT_ID is null, 1 , 2) as COMMENT_REPLY_TYPE, tcr.SUPPLIER_ID, tcr.PRAISE_COUNT, tcr.STATUS, tcr.ASTERISK, tcr.DISCUSSANT_ID, CASE tcr.IS_PRESENTER WHEN 0 THEN IF(tcr.DISCUSSANT_ID is null,'匿名用户',IFNULL(tmpu.NICK_NAME,'匿名用户')) WHEN 1 THEN '主持人' ELSE '' END as DISCUSSANT_NAME, tcr.REPLY_USER_ID, IF(tcr.REPLY_USER_ID ='' || tcr.REPLY_USER_ID is null,'', IF(tcar.USER_ID ='' || tcar.USER_ID is null, IFNULL(tmpr.NICK_NAME,'匿名用户'),'主持人')) as REPLY_USER_NAME, tcr.REPLY_COMMENT_ID, tcr.CREATE_TIME, CASE tcr.TYPE WHEN 0 THEN tar.ANCHORPERSON_ID WHEN 1 THEN tar.ANCHORPERSON_ID WHEN 2 THEN tar.ANCHORPERSON_ID WHEN 3 THEN tcs.S_UPLOADER WHEN 4 THEN tar.ANCHORPERSON_ID WHEN 5 THEN tcc.PRODUCER ELSE '' END as USER_IDFROM TBL_COMMENT_REPLY tcr left join TBL_TOPIC tt on tcr.CORRELATE_ID = tt.ID left join TBL_NEWS tn on tcr.CORRELATE_ID = tn.ID left join TBL_CAMPAIGN tc on tcr.CORRELATE_ID = tc.ID left join TBL_ANCHORPERSON_RESOURCE tar on tcr.CORRELATE_ID = tar.RESOURCE_ID left join TBL_CLOUDTB_COLUMN tcc on tcr.CORRELATE_ID = tcc.id left join TBL_CLOUDTB_SONG tcs on tcr.CORRELATE_ID = tcs.ID left join TBL_MOBILE_PHONE_USER tmpu on tcr.DISCUSSANT_ID = tmpu.PHONE left join TBL_MOBILE_PHONE_USER tmpr on tcr.REPLY_USER_ID = tmpr.PHONE left join TBL_CLOUDTB_ADMIN tcau on tcr.DISCUSSANT_ID = tcau.ID left join TBL_CLOUDTB_ADMIN tcar on tcr.REPLY_USER_ID = tcar.ID <where> <if test="createTime != null and createTime !=''">AND DATE_FORMAT(tcr.CREATE_TIME,'%Y-%m-%d') = #{createTime}</if> <if test="correlateId != null">AND tcr.CORRELATE_ID in (${correlateId})</if> <if test="type != null">AND tcr.TYPE = #{type}</if> <if test="status != null">AND tcr.STATUS = #{status}</if><if test="asterisk != null">AND tcr.ASTERISK =#{asterisk}</if><if test="filterStatus != null">AND tcr.STATUS != #{filterStatus}</if><if test="startTime != '' and endTime!= ''">AND tcr.CREATE_TIME BETWEEN #{startTime} AND #{endTime}</if></where>group by tcr.ID, tcr.CORRELATE_ID, CORRELATE_NAME, ICON, CHANNEL_ID, tcr.CONTENT, tcr.TYPE, COMMENT_REPLY_TYPE, tcr.SUPPLIER_ID, tcr.PRAISE_COUNT, tcr.STATUS, tcr.ASTERISK, tcr.DISCUSSANT_ID, DISCUSSANT_NAME, tcr.REPLY_USER_ID, REPLY_USER_NAME, tcr.REPLY_COMMENT_ID, tcr.CREATE_TIME, USER_ID ) t <where> <if test="key != null and key !=''"> AND ( t.CONTENT like CONCAT('%',#{key},'%') OR t.DISCUSSANT_NAME like CONCAT('%',#{key},'%') ) </if> <if test="channelId != null and channelId !=''"> AND t.CHANNEL_ID in (${channelId}) </if> <if test="userId != null and userId !=''"> AND t.USER_ID in (${userId}) </if> </where></select><select id="getCommentById" resultMap="RMCommentPo" parameterType="java.lang.Long">SELECT tcr.ID, tcr.CORRELATE_ID, CASE tcr.TYPE WHEN 0 THEN tt.TITLE WHEN 1 THEN tn.TITLE WHEN 2 THEN tc.TITLE WHEN 3 THEN tcr.SONG_NAME WHEN 4 THEN tcr.SONG_NAME WHEN 5 THEN tcr.SONG_NAME ELSE '' END as CORRELATE_NAME, tcr.CONTENT, tcr.TYPE, IF(tcr.REPLY_COMMENT_ID is null, 1 , 2) as COMMENT_REPLY_TYPE, tcr.SUPPLIER_ID, tcr.PRAISE_COUNT, tcr.STATUS, tcr.ASTERISK, tcr.IS_PRESENTER, tcr.DISCUSSANT_ID, CASE tcr.IS_PRESENTER WHEN 0 THEN IF(tcr.DISCUSSANT_ID is null,'匿名用户',IFNULL(tmpu.NICK_NAME,'匿名用户')) WHEN 1 THEN '主持人' ELSE '' END as DISCUSSANT_NAME, tcr.REPLY_USER_ID, IF(tcr.REPLY_USER_ID ='' || tcr.REPLY_USER_ID is null,'', IF(tcar.USER_ID ='' || tcar.USER_ID is null, IFNULL(tmpr.NICK_NAME,'匿名用户'),'主持人')) as REPLY_USER_NAME, tcr.REPLY_COMMENT_ID, tcr.CREATE_TIMEFROM TBL_COMMENT_REPLY tcr left join TBL_TOPIC tt on tcr.CORRELATE_ID = tt.ID left join TBL_NEWS tn on tcr.CORRELATE_ID = tn.ID left join TBL_CAMPAIGN tc on tcr.CORRELATE_ID = tc.ID left join TBL_MOBILE_PHONE_USER tmpu on tcr.DISCUSSANT_ID = tmpu.PHONE left join TBL_MOBILE_PHONE_USER tmpr on tcr.REPLY_USER_ID = tmpr.PHONE left join TBL_CLOUDTB_ADMIN tcau on tcr.DISCUSSANT_ID = tcau.ID left join TBL_CLOUDTB_ADMIN tcar on tcr.REPLY_USER_ID = tcar.IDWHERE tcr.ID = #{id}</select><!-- 插入评论信息 --><insert id="insertCommment" parameterType="CommentPo" useGeneratedKeys="true" keyColumn="ID" keyProperty="id">INSERT INTO TBL_COMMENT_REPLY( ID, CORRELATE_ID,TYPE, SUPPLIER_ID, SONG_NAME, PRAISE_COUNT, CONTENT, STATUS, DISCUSSANT_ID, REPLY_USER_ID, REPLY_COMMENT_ID ,ASTERISK, IS_PRESENTER ,CREATE_TIME,CHANNEL_COLUMN_ID)VALUES(#{id}, #{correlateId}, #{type}, #{supplierId}, #{songName}, 0, #{content}, #{status} , #{discussantId} ,#{replyUserId} ,#{replyCommentId} ,0, #{presenter}, NOW(),#{channelColumnId})</insert><update id="updateAsterisk" parameterType="CommentPo">UPDATE TBL_COMMENT_REPLY <set> ASTERISK = #{asterisk}, <if test="asterisk == 1">STATUS = 1</if></set> WHERE ID = #{id}</update><!-- 批量更通过 --> <update id="batchUpdateCommentPassStatus" parameterType="ArrayList"> UPDATE TBL_COMMENT_REPLY SET STATUS = 1 WHERE ID IN <foreach item="item" collection="array" open="(" separator="," close=")"> #{item} </foreach></update> <update id="batchUpdateCommentNoPassStatus" parameterType="ArrayList" > UPDATE TBL_COMMENT_REPLY SET STATUS = 2 WHERE ID IN <foreach item="item" collection="array" open="(" separator="," close=")"> #{item} </foreach> </update> <update id="batchCancelAsterisk" parameterType="ArrayList"> UPDATE TBL_COMMENT_REPLY SET ASTERISK = 0 WHERE ID IN <foreach item="item" collection="array" open="(" separator="," close=")"> #{item} </foreach></update><update id="updateCancelAsterisk" parameterType="CommentPo"> UPDATE TBL_COMMENT_REPLY SET ASTERISK = #{asterisk} WHERE CORRELATE_ID in (${correlateIds}) and TYPE = #{type} </update> <select id="getCommentList" resultMap="RMCommentPo" parameterType="ArrayList"> SELECT ID, CORRELATE_ID, TYPE, SUPPLIER_ID, SONG_NAME, PRAISE_COUNT, CONTENT, STATUS,ASTERISK, DISCUSSANT_ID, REPLY_USER_ID, REPLY_COMMENT_ID, IS_PRESENTER, CREATE_TIME FROM TBL_COMMENT_REPLY WHERE REPLY_COMMENT_ID IS NOT NULL AND ID IN <foreach item="item" collection="array" open="(" separator="," close=")"> #{item} </foreach> </select> <select id="getChannelCommentCount" resultType="java.lang.Integer" parameterType="java.lang.Long"> SELECT COUNT(1) FROM TBL_COMMENT_REPLY WHERE CORRELATE_ID=#{channelId} AND TYPE=4 AND STATUS!=2 </select> <delete id="deleteCommentByAblumId" parameterType="map"> DELETE FROM TBL_COMMENT_REPLY where CORRELATE_ID in (${songIds}) </delete> <select id="getResourceCommentCount" resultType="java.lang.Integer" parameterType="CommentPo"> SELECT COUNT(1) FROM TBL_COMMENT_REPLY WHERE CORRELATE_ID=#{id} AND TYPE=#{type} AND STATUS=#{status} </select> <select id="getCommentStarCount" resultType="java.lang.Integer" parameterType="java.lang.Long"> SELECT COUNT(1) FROM TBL_COMMENT_REPLY WHERE CORRELATE_ID=#{channelId} and ASTERISK=1 </select> <select id="getMsgUserById" resultType="HashMap" parameterType="HashMap"> SELECT ID,NICK_NAME as NICKNAME, SEX,ICON FROM TBL_CLOUDTB_ADMIN WHERE ID = #{id} UNION ALL SELECT ID,NICK_NAME as NICKNAME, SEX,ICON FROM TBL_MOBILE_PHONE_USER WHERE PHONE = #{id} </select> <select id="getYnHuDongTotalCnts" resultType="java.lang.Integer" parameterType="HashMap"> SELECT COUNT(1) FROM TBL_COMMENT_REPLY where CLOUD = '1' </select> <!-- 查询云互动评论列表 --> <select id="getYnHuDong" resultType="HashMap" parameterType="HashMap"> SELECT ID,TITLE,CONTENT_TYPE,CREATE_TIME as CREATETIME FROM TBL_COMMENT_REPLY where CLOUD = '1' ORDER BY CREATE_TIME desc LIMIT ${start},${end} </select> <delete id="deleteById" parameterType="HashMap"> DELETE FROM TBL_COMMENT_REPLY WHERE ID = #{id} </delete></mapper>
0 0
- 测试代码格式
- 测试下代码格式
- 代码格式测试
- 代码格式、测试化工具
- 格式测试
- 测试格式
- 测试格式
- 代码格式
- 代码格式
- 安卓代码管理及代码格式改动对测试范围的影响
- 整洁代码----代码格式
- java识别文件编码格式代码(无引用jar包,测试可行)
- java 发送邮件 email相关操作代码测试,生成复杂格式邮件,发送邮件相关操作
- png格式读取测试
- CPI格式测试情况
- 程序配置文件格式测试
- 测试计划格式1
- 博客格式测试
- Nssting
- CodeForces 622A Infinite Sequence
- Android实现图片(拍照+相册)上传功能
- ppp and ndis
- 一些基础博客链接
- 测试代码格式
- Android 6.0 反射 newInstance
- NSLayoutConstraint-代码实现自动布局的函数用法
- 通过寄生组合式继承创建js的异常类
- 极光推送参考文档
- redis主从服务器搭建
- 我的Android面试经验总结
- hrbust 1430 神秘植物 [递推+矩阵快速幂]
- android studio1.01中导入library