SSM项目中实现数据批量插入数据库

迷南。 2022-02-26 05:08 626阅读 0赞

(一)持久层部分TbUserDao.java

![20190329093103868.png][]

TbUserMapper.xml

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTAyNzQx_size_16_color_FFFFFF_t_70][]

(二)逻辑控制层UserService.java接口

![2019032909341934.png][]

实现类UserServiceImpl.java

![20190329093540667.png][]

(三)使用单元测试验证代码

>     @Test
>     public void insertTbUserBatch(){
>         TbUser tbUser = new TbUser();
>         tbUser.setId(8L);
>         tbUser.setUsername("8");
>         tbUser.setPassword("8");
>         tbUser.setPhone("8");
>         tbUser.setEmail("8");
>         String strdate1="2017-05-17";
>         String strdate2="2017-05-28";
>         SimpleDateFormat  sdf = new SimpleDateFormat("yyyy-MM-dd");
>     
>         try {
>             tbUser.setCreated(sdf.parse(strdate1));
>             tbUser.setUpdated(sdf.parse(strdate2));
>         } catch (ParseException e) {
>             e.printStackTrace();
>         }
>     
>         TbUser tbUser1 = new TbUser();
>         tbUser1.setId(7L);
>         tbUser1.setUsername("7");
>         tbUser1.setPassword("7");
>         tbUser1.setPhone("7");
>         tbUser1.setEmail("7");
>         String strdate11="2018-05-17";
>         String strdate21="2018-05-28";
>         SimpleDateFormat  sdf1 = new SimpleDateFormat("yyyy-MM-dd");
>         try {
>             tbUser1.setCreated(sdf1.parse(strdate11));
>             tbUser1.setUpdated(sdf1.parse(strdate21));
>         } catch (ParseException e) {
>             e.printStackTrace();
>         }
>     
>         List<TbUser> list = new ArrayList<TbUser>();
>         list.add(tbUser);
>         list.add(tbUser1);
>        int result = userService.insertTbUserBatch(list);
>        if(result == list.size()){
>            System.out.println("批量插入成功");
>        }else{
>            System.out.println("批量插入失败");
>        }
>     }

验证结果:

![20190329094755714.png][]

[20190329093103868.png]: /images/20220226/bf4371e30dcf4c659ca6e6c09f61247a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMyOTAyNzQx_size_16_color_FFFFFF_t_70]: /images/20220226/758a364abcb94b8a8937c502bb158626.png
[2019032909341934.png]: /images/20220226/00a6f0ba21b84f588a7ceae4e12dccaa.png
[20190329093540667.png]: /images/20220226/cdd52da934a14bb496dfa86a7b11a766.png
[20190329094755714.png]: /images/20220226/d404be3ae0f842609b0a40c84202e145.png