Spring基础（十三）：JDBCTemplate的批操作
【摘要】 JDBCTemplate的批操作一次连接，操作表格里的多条数据，就是批量操作。案例操作批量增加批量修改批量删除一、实体类package com.lanson.pojo;import lombok.AllArgsConstructor;import lombok.Data;import lombok.NoArgsConstructor;import java.io.Serializable;/...
JDBCTemplate的批操作
一次连接，操作表格里的多条数据，就是批量操作。
案例操作
- 批量增加
- 批量修改
- 批量删除
一、实体类
package com.lanson.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
/**
* @Author: Lansonli
* @Description: MircoMessage:Mark_7001
*/
@AllArgsConstructor
@NoArgsConstructor
@Data
public class Dept implements Serializable {
private Integer deptno;
private String dname;
private String loc;
}二、DeptService
package com.lanson.service;
import com.lanson.pojo.Dept;
import java.util.List;
/**
* @Author: Lansonli
* @Description: MircoMessage:Mark_7001
*/
public interface DeptService {
int[] deptBatchAdd(List<Dept> depts);
int[] deptBatchUpdate(List<Dept> depts);
int[] deptBatchDelete(List<Integer> deptnos);
}package com.lanson.service.impl;
import com.lanson.dao.DeptDao;
import com.lanson.pojo.Dept;
import com.lanson.service.DeptService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
* @Author: Lansonli
* @Description: MircoMessage:Mark_7001
*/
@Service
public class DeptServiceImpl implements DeptService {
@Autowired
private DeptDao deptDao;
@Override
public int[] deptBatchAdd(List<Dept> depts) {
return deptDao.deptBatchAdd(depts);
}
@Override
public int[] deptBatchUpdate(List<Dept> depts) {
return deptDao.deptBatchUpdate(depts);
}
@Override
public int[] deptBatchDelete(List<Integer> deptnos) {
return deptDao.deptBatchDelete(deptnos);
}
}三、DeptDao
package com.lanson.dao;
import com.lanson.pojo.Dept;
import java.util.List;
/**
* @Author: Lansonli
* @Description: MircoMessage:Mark_7001
*/
public interface DeptDao {
int[] deptBatchAdd(List<Dept> depts);
int[] deptBatchUpdate(List<Dept> depts);
int[] deptBatchDelete(List<Integer> deptnos);
}package com.lanson.dao.impl;
import com.lanson.dao.DeptDao;
import com.lanson.pojo.Dept;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import java.util.LinkedList;
import java.util.List;
/**
* @Author: Lansonli
* @Description: MircoMessage:Mark_7001
*/
@Repository
public class DeptDaoImpl implements DeptDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public int[] deptBatchAdd(List<Dept> depts) {
String sql ="insert into dept values(DEFAULT,?,?)";
List<Object[]> args =new LinkedList<>();
for (Dept dept : depts) {
Object[] arg ={dept.getDname(),dept.getLoc()};
args.add(arg);
}
return jdbcTemplate.batchUpdate(sql, args);
}
@Override
public int[] deptBatchUpdate(List<Dept> depts) {
String sql ="update dept set dname =? ,loc =? where deptno=?";
List<Object[]> args =new LinkedList<>();
for (Dept dept : depts) {
Object[] arg ={dept.getDname(),dept.getLoc(),dept.getDeptno()};
args.add(arg);
}
return jdbcTemplate.batchUpdate(sql, args);
}
@Override
public int[] deptBatchDelete(List<Integer> deptnos) {
String sql ="delete from dept where deptno =?";
List<Object[]> args =new LinkedList<>();
for (Integer deptno : deptnos) {
Object[] arg ={deptno};
args.add(arg);
}
return jdbcTemplate.batchUpdate(sql, args);
}
}四、测试
package com.lanson.test;
import com.lanson.pojo.Dept;
import com.lanson.service.DeptService;
import com.lanson.service.EmpService;
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
/**
* @Author: Lansonli
* @Description: MircoMessage:Mark_7001
*/
public class Test2 {
@Test
public void testBatchAdd(){
ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");
DeptService deptService = context.getBean(DeptService.class);
List<Dept> depts =new ArrayList<>();
for (int i = 0; i < 10; i++) {
depts.add(new Dept(null,"name"+i,"loc"+i));
}
int[] ints = deptService.deptBatchAdd(depts);
System.out.println(Arrays.toString(ints));
}
@Test
public void testBatchUpdate(){
ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");
DeptService deptService = context.getBean(DeptService.class);
List<Dept> depts =new ArrayList<>();
for (int i = 51; i <=60; i++) {
depts.add(new Dept(i,"newname","newLoc"));
}
int[] ints = deptService.deptBatchUpdate(depts);
System.out.println(Arrays.toString(ints));
}
@Test
public void testBatchDelete(){
ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");
DeptService deptService = context.getBean(DeptService.class);
List<Integer> deptnos =new ArrayList<>();
for (int i = 51; i <=69; i++) {
deptnos.add(i);
}
int[] ints = deptService.deptBatchDelete(deptnos);
System.out.println(Arrays.toString(ints));
}
}
【版权声明】本文为华为云社区用户原创内容，转载时必须标注文章的来源（华为云社区）、文章链接、文章作者等基本信息， 否则作者和本社区有权追究责任。如果您发现本社区中有涉嫌抄袭的内容，欢迎发送邮件进行举报，并提供相关证据，一经查实，本社区将立刻删除涉嫌侵权内容，举报邮箱：
cloudbbs@huaweicloud.com
- 点赞
- 收藏
- 关注作者
评论（0）