批量增删改

最新推荐文章于 2024-09-09 14:40:58 发布

Triumph-CP

最新推荐文章于 2024-09-09 14:40:58 发布

阅读量53

点赞数

分类专栏： java 文章标签： java 数据库 mysql

本文链接：https://blog.csdn.net/cp1002327672/article/details/128574124

版权

java 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

批量增删改

批量增加

实现类

public Integer batchSaveMaster(List<Master> masters) {
    String sql = "insert into master(name,age,gender,yearnum,did) values";
    for (Master master :
            masters) {
        sql += "('" + master.getName() + "'," + master.getAge()
                + ",'" + master.getGender() + "'," + master.getYearnum() + ","
                + master.getDid() + "),";
    }
    sql = sql.substring(0,sql.length() - 1);//用来删除最后一个逗号
    System.out.println(sql);
    return super.executeUpdate(sql);
}

测试类

public void testBatchSaveDog(){
    Dogdao dogDao = new DogDaoImpl2();
    Dog dog1 = new Dog("a", 100, 100, "t1");
    Dog dog2 = new Dog("b", 100, 90, "t2");
    Dog dog3 = new Dog("c", 90, 90, "t3");
    ArrayList<Dog> dogs = new ArrayList<>();
    dogs.add(dog1);
    dogs.add(dog2);
    dogs.add(dog3);
    Integer num = dogDao.batchSaveDog(dogs);
    System.out.println(num);
}

批量删除

实现类

public Integer batchDelDog(List<Integer> ids) {
        String sql = "delete from dog where id in (";
        for (Integer id :
                ids) {
            sql += id + ",";
        }
        sql = sql.substring(0,sql.length() - 1);
        sql += ")";
        System.out.println(sql);
        //return null;
        return super.executeUpdate(sql);
    }

测试类

public void testBatchDelMaster() {
        MasterDao masterDao = new MasterDaoImpl();
        ArrayList<Integer> ids = new ArrayList<>();
        ids.add(11);
        ids.add(12);
        ids.add(13);
        Integer integer = masterDao.batchDelDog(ids);
        System.out.println(integer);
    }

批量修改

实现类

public Integer batchUpdateDog(List<Dog> dogs) {
        String sql = "";
        int num = 0;
        for (Dog dog :
                dogs) {
            sql = "update dog set";
            if (dog.getName() != null && dog.getName() != ""){
                sql += " name = '" + dog.getName() + "',";
            }
            if (dog.getHealth() != null){
                sql += " health = " + dog.getHealth() + ",";
            }
            if (dog.getLove() != null){
                sql += " love = " + dog.getLove() + ",";
            }
            if (dog.getStrain() != null && dog.getStrain() != ""){
                sql += " strain = '" + dog.getStrain() + "',";
            }
            sql = sql.substring(0,sql.length() - 1) + " where id = " + dog.getId() + ";";
            System.out.println(sql);
            num += super.executeUpdate(sql);

        }
        return num;
    }

测试类

public void testBatchUpdateMaster() {
        MasterDao masterDao = new MasterDaoImpl();
        Master master1 = new Master();
        master1.setPid(18);
        master1.setName("旺仔");
        Master master2 = new Master();
        master1.setPid(19);
        master1.setYearnum(5);
        Master master3 = new Master();
        master1.setPid(20);
        master1.setAge(50);
        ArrayList<Master> masters = new ArrayList<>();
        masters.add(master1);
        masters.add(master2);
        masters.add(master3);
        Integer integer = masterDao.batchUpdateMaster(masters);
        System.out.println(integer);
    }