查询评论

接口名： `/guang/comment/getList

方法

POST JSONRAW

入参

---

属性名称	类型	例子	说明	是否必填	长度限制
status	Integer	1	状态	否	0-2
condNum	int	2		否	0-1
condContent	String	xx	查询内容	否	0-128

---

对应SQL的操作库表

    <select id="selectCountByCondition" resultType="java.lang.Integer" >
        select 
        IFNULL(count(1),0)
        from comments
        where 1=1
        <if test="status != null" >
           and audit_status = #{status,jdbcType=TINYINT}
        </if>
        <if test="condContent != null and condNum ==1" >
           and content like concat('%', #{condContent}, '%')
        </if>
        <if test="condContent != null and condNum ==2" >
           and username = #{condContent}
        </if>
        <if test="condContent != null and condNum ==3" >
           and uid = #{condContent}
        </if>
        <if test="condContent != null and condNum == 4" >
           and article_title like concat('%', #{condContent}, '%')
        </if>
        <if test="condContent != null and condNum == 5" >
           and editor_name = #{condContent}
        </if>
    </select>
    <select id="selectListByCondition" resultMap="BaseResultMap" >
        select 
        <include refid="Base_Column_List" />
        from comments
        where 1=1
        <if test="status != null" >
           and audit_status = #{status,jdbcType=TINYINT}
        </if>
        <if test="condContent != null and condNum ==1" >
           and content like concat('%', #{condContent}, '%')
        </if>
        <if test="condContent != null and condNum ==2" >
           and username = #{condContent}
        </if>
        <if test="condContent != null and condNum ==3" >
           and uid = #{condContent}
        </if>
        <if test="condContent != null and condNum == 4" >
           and article_title like concat('%', #{condContent}, '%')
        </if>
        <if test="condContent != null and condNum == 5" >
           and editor_name = #{condContent}
        </if>
        order by id DESC limit #{offset},#{size}
    </select>

错误编码

---

错误码code	消息	说明
200	操作成功

返回

    {
        "code": 200,
        "data": [
            {
                "id": "1",
                "condNum": "222",
                "condContent": "xxxee",
                "status": "1"
            },
            {
                "id": "2",
                "condNum": "212",
                "condContent": "xxxee",
                "status": "1"
            }
        ]
    }