JAVA 批量插入时，未赋值字段，数据库设置默认值无效情况

最新推荐文章于 2022-12-03 17:15:20 发布

冰月落

最新推荐文章于 2022-12-03 17:15:20 发布

阅读量1.2k

点赞数

分类专栏： JAVA-基础文章标签： mysql java

本文链接：https://blog.csdn.net/m0_37759814/article/details/118543251

版权

MyBatis 批量插入数据库默认值 XML配置解决方案

关键词由CSDN通过智能技术生成

JAVA 批量插入时，未赋值字段，数据库设置默认值无效情况

*单量插入XML *

<!--新增所有列-->
    <insert id="insert" keyProperty="id" useGeneratedKeys="true">
        insert into wnsc_sales.sales_records
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="creator != null and creator != ''">
                 creator,
            </if>
            <if test="updator != null and updator != ''">
                 updator,
            </if>
            <if test="createTime != null">
                 create_time,
            </if>
            <if test="updateTime != null">
                 update_time,
            </if>
            <if test="orderSn != null and orderSn != ''">
                 order_sn,
            </if>
            <if test="memberId != null">
                 member_id,
            </if>
            <if test="memberName != null and memberName != ''">
                 member_name,
            </if>
            <if test="memberPhone != null and memberPhone != ''">
                 member_phone,
            </if>
            <if test="salesId != null">
                 sales_id,
            </if>
            <if test="salesName != null and salesName != ''">
                 sales_name,
            </if>
            <if test="salesPhone != null and salesPhone != ''">
                 sales_phone,
            </if>
            <if test="skuId != null">
                 sku_id,
            </if>
            <if test="skuName != null and skuName != ''">
                 sku_name