15_Spring_JDBCTemplate批操作

一次连接,操作表格里的多条数据,就是批量操作

1 批量增加

2 批量修改

3 批量删除

实体类

DeptService

int[] deptBatchUpdate(List<Dept> depts);

int[] deptBatchDelete(List<Integer> deptnos);

public int[] deptBatchAdd(List<Dept> depts) {

    return deptDao.deptBatchAdd(depts);

public int[] deptBatchUpdate(List<Dept> depts) {

    return  deptDao.deptBatchUpdate(depts);

public int[] deptBatchDelete(List<Integer> deptnos) {

    return  deptDao.deptBatchDelete(deptnos);

DeptDao

int[] deptBatchUpdate(List<Dept> depts);

int[] deptBatchDelete(List<Integer> deptnos);

public int[] deptBatchAdd(List<Dept> depts) {

    String sql ="insert into dept values(DEFAULT,?,?)";

    List<Object[]> args =new LinkedList<>();

        Object[] arg ={dept.getDname(),dept.getLoc()};

    return jdbcTemplate.batchUpdate(sql, args);

public int[] deptBatchUpdate(List<Dept> depts) {

    String sql ="update dept set dname =? ,loc =? where deptno=?";

    List<Object[]> args =new LinkedList<>();

        Object[] arg ={dept.getDname(),dept.getLoc(),dept.getDeptno()};

    return jdbcTemplate.batchUpdate(sql, args);

public int[] deptBatchDelete(List<Integer> deptnos) {

    String sql ="delete from dept where deptno =?";

    List<Object[]> args =new LinkedList<>();

    return jdbcTemplate.batchUpdate(sql, args);

测试

package com.msb.test;
import com.msb.pojo.Dept;
import com.msb.service.DeptService;
import com.msb.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: Ma HaiYang
- @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<>();

        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<>();

        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<>();

    int[] ints = deptService.deptBatchDelete(deptnos);

    System.out.println(Arrays.toString(ints));

标签：15,int,Spring,List,JDBCTemplate,depts,import,com,msb
From： https://www.cnblogs.com/01way/p/17591286.html