Mybatis中使用动态标签实现order by多字段排序

最新推荐文章于 2024-06-20 15:44:27 发布

godkzz

最新推荐文章于 2024-06-20 15:44:27 发布

阅读量4.8k

点赞数 4

分类专栏： mysql 文章标签： mysql sql mybatis java springboot

本文链接：https://blog.csdn.net/godkzz/article/details/121850638

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

查看了许多文章，发现都是使用${}的方法去实现，如果不进行过滤会有sql注入的风险，于是想了一种使用单纯使用Mybatis动态标签实现的方法

    <select id="selectProductList" parameterType="ProductListQuery">
        SELECT * from product
        <if test="productSaleDesc != null or productScoreDesc != null or productPriceDesc != null or createTimeDesc != null">
            <trim prefix="order by" suffixOverrides=",">
                <if test="productSaleDesc != null and productSaleDesc == 0">
                    product.product_sale DESC,
                </if>
                <if test="productSaleDesc != null and productSaleDesc == 1">
                    product.product_sale ASC,
                </if>
                <if test="productScoreDesc != null and productScoreDesc == 0">
                    product.product_score DESC,
                </if>
                <if test="productScoreDesc != null and productScoreDesc == 1">
                    product.product_score ASC,
                </if>
                <if test="productPriceDesc != null and productPriceDesc == 0">
                    product.product_price DESC,
                </if>
                <if test="productPriceDesc != null and productPriceDesc == 1">
                    product.product_price ASC,
                </if>
                <if test="createTimeDesc != null and createTimeDesc == 0">
                    product.create_time DESC,
                </if>
                <if test="createTimeDesc != null and createTimeDesc == 1">
                    product.create_time ASC,
                </if>
            </trim>
        </if>
    </select>