Mybatis获取自增id

最新推荐文章于 2024-05-06 07:14:09 发布

lifeisfuckingmovie

最新推荐文章于 2024-05-06 07:14:09 发布

阅读量997

点赞数

文章标签： mybatis java mysql

本文链接：https://blog.csdn.net/ubaby/article/details/108403014

版权

在这里插入图片描述

在insert标签上加上 keyProperty=“id” useGeneratedKeys=“true”

  <!--新增所有列-->
    <insert id="insert" keyProperty="id" useGeneratedKeys="true">
        insert  into zcb_groupbuy(promotename,groupprice, goodsid, goodsname, jcsl, cxsl, mrxg, bgtm, endtm, status, tjflag, spjsurl, spggurl, sffwurl, tm)
        values (#{promotename},#{groupprice}, #{goodsid}, #{goodsname}, #{jcsl}, #{cxsl}, #{mrxg}, #{bgtm}, #{endtm}, #{status}, #{tjflag}, #{spjsurl}, #{spggurl}, #{sffwurl}, #{tm})
    </insert>

 /**
     * 新增数据
     *
     * @param zcbGroupbuy 实例对象
     * @return 实例对象
     */
    @Override
    @Transactional(rollbackFor = RuntimeException.class)
    public int insert(ZcbGroupBuyVo zcbGroupbuy, MultipartFile[] files) {
        List<String> paths = ImageUtil.saveimages(files);
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        String format = df.format(new Date());
        int insert = zcbGroupbuyDao.insert(zcbGroupbuy);
        for (String path : paths) {
            StuffImagecxList cximagelist = new StuffImagecxList();
            cximagelist.setCreateTime(format);
            cximagelist.setCxflag("1");
            cximagelist.setCxid(zcbGroupbuy.getId()+ "");
            cximagelist.setStuffImageUrl(path);
            log.info("图片路径 ={} ", path);
            stuffImagecxListDao.insert(cximagelist);
        }
        zcbGroupbuy.setTm(new Date());
        return insert;
    }