mybaits批量存储记录（有实例）

最新推荐文章于 2023-09-20 13:54:26 发布

xinghuo0007

最新推荐文章于 2023-09-20 13:54:26 发布

阅读量440

点赞数

分类专栏： mybatis日记文章标签： url 存储实例百度

本文链接：https://blog.csdn.net/xinghuo0007/article/details/53817598

版权

mybatis日记专栏收录该内容

8 篇文章 0 订阅

订阅专栏

说明：今天想要批量存储一些记录，百度了一下，自己写了出来，在这里记录一下：

先看一下mybaits的Mapper文件：

<sql id="Base_Column_List">
        id, title, url, time, type, discussnum, description,
        imagesurl, ishot,
        source, storage_time,
        status
    </sql>


<insert id="batchInsert" parameterType="java.util.List" >
        insert into ss_news (
        <include refid="Base_Column_List" />
        )
        values
        <foreach collection="list" index="index" item="n" separator=",">
            (#{n.id},#{n.title},#{n.url},#{n.time},#{n.type},#{n.discussNum},#{n.description},#{n.imagesUrl},#{n.isHot},#{n.source},#{n.storageTime},#{n.status})
        </foreach>
    </insert>

对应的Service：

package cn.cupcat.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import cn.cupcat.dao.DaoSupport;
import cn.cupcat.models.News;

@Service
@Transactional
public class NewsService {


    @Autowired
    private DaoSupport dao;


    public void batchInsert(List<News> list) throws Exception{
         dao.save("NewsMapper.batchInsert", list);
    }

}

测试：

package cn.cupcat.test;

import java.text.ParseException;
import java.util.ArrayList;
import java.util.List;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import cn.cupcat.models.News;
import cn.cupcat.service.NewsService;
import cn.cupcat.util.DateTimeUtil;
import cn.cupcat.util.UUIDUtil;

public class TestNewsService {

    ApplicationContext ac ,bc= null;

    @org.junit.Before
    public void before(){
        bc = new ClassPathXmlApplicationContext("spring-mybatis.xml");
        //ac = new ClassPathXmlApplicationContext("spring.xml");
    }



    public List<News> getNews() throws ParseException{
        List<News> list = new ArrayList<News>();
        News news = null;
        int num =100;
        for(int i=0;i<num;i++ ){
            news = new News();
            news.setId(UUIDUtil.get32UUID());
            news.setTitle("测试标题");
            news.setUrl("http://www.cupcat.cn");
            news.setTime(DateTimeUtil.getDateTime());
            news.setSource("向杨新闻");
            news.setStorageTime(DateTimeUtil.getTimestamp());
            list.add(news);
        }
        System.out.println(list);
        return list;
    }
    @Test
    public void testNewsService(){
        NewsService newsService  =  (NewsService) bc.getBean("newsService");
        try {
            newsService.batchInsert(getNews());
        } catch (Exception e) {
            e.printStackTrace();
        }
        //System.out.println(newsService);
    }
}