SSM项目中实现数据批量插入数据库
(一)持久层部分TbUserDao.java
TbUserMapper.xml
(二)逻辑控制层UserService.java接口
实现类UserServiceImpl.java
(三)使用单元测试验证代码
@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("批量插入失败"); } }
验证结果: