关于MyBatis中String和varchar进行大小比较（均保存的数字）

最新推荐文章于 2025-05-21 17:50:42 发布

ByYourSide_

最新推荐文章于 2025-05-21 17:50:42 发布

阅读量6.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： myBatis 文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/qq_29463709/article/details/78794917

myBatis 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现复杂条件查询的例子，包括自定义Java Bean、XML映射文件配置及SQL语法技巧等内容。重点讲解了如何处理大于小于号及数据类型的转换问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

业务场景：

①bean

public class ProductParam extends BaseQuery {

    private static final long serialVersionUID = 3115760968824884833L;

    /*
     * 贷款金额
     */
    private String amount;

    /*
     * 贷款期限
     */
    private String limitTime;

    public String getAmount() {
        return amount;
    }

    public void setAmount(String amount) {
        this.amount = amount;
    }

    public String getLimitTime() {
        return limitTime;
    }

    public void setLimitTime(String limitTime) {
        this.limitTime = limitTime;
    }

}

②SqlMap

 <select id="queryProductListPageByParam" parameterType="com.hundsun.trade.product.vo.ProductParam"  resultMap="ProductFullInfoResultMap">
        SELECT
        <include refid="ProductInfoSearchColumn" />
        FROM
        DK_PLATFORM_PRODUCT dpp 
        LEFT JOIN DK_PLATFORM_INFO dpi ON dpp.PLATFORM_CODE=dpi.PLATFORM_CODE 
         <where>

            <if test="platformCode != '' and platformCode != null">
                AND dpp.PLATFORM_CODE = #{platformCode}
            </if>
            <if test="platformName != '' and platformName != null">
                AND dpi.PLATFORM_NAME LIKE
                CONCAT('%',#{platformName},'%')
            </if>
            <if test="productName != '' and productName != null">
                AND dpp.PRODUCT_NAME LIKE
                CONCAT('%',#{productName},'%')
            </if>
            <if test="amount != '' and amount != null">
                AND <![CDATA[CONVERT(dpp.PRODUCT_UP_NUM,SIGNED) > #{amount,jdbcType=INTEGER} and CONVERT(dpp.PRODUCT_DOWN_NUM,SIGNED) < #{amount,jdbcType=INTEGER}]]>
            </if>
             <if test="limitTime != '' and limitTime != null">
                AND <![CDATA[CONVERT(dpp.PRODUCT_REPAYMENT_UP_TIME,SIGNED) > #{limitTime,jdbcType=INTEGER} and CONVERT(dpp.PRODUCT_REPAYMENT_DOWN_TIME,SIGNED) < #{limitTime,jdbcType=INTEGER}]]>
            </if>

        </where>
    </select>