Hibernate批量处理操作(批量查询批量删除)

最新推荐文章于 2020-06-07 15:25:52 发布

RobertoHuang

最新推荐文章于 2020-06-07 15:25:52 发布

阅读量3.4k

点赞数 1

分类专栏： Hibernate学习笔记文章标签： Hibernate 批处理

本文链接：https://blog.csdn.net/RobertoHuang/article/details/73823585

版权

Hibernate学习笔记专栏收录该内容

2 篇文章 0 订阅

订阅专栏

前言

此处以一个Student案例进行演示根据Student的ids进行批量查询和删除

1.批量查询

1.1 批量查询Dao层代码

public List<Student> excuteBatchQuery(String sql, Map<String, List<Object>> map) {
    Session session = this.getSessionFactory().getCurrentSession();
    SQLQuery query = session.createSQLQuery(sql).addEntity(Student.class);
    if (map != null && map.size() > 0) {
        for (Map.Entry<String, List<Object>> entry : map.entrySet()) {
            query.setParameterList(entry.getKey(), entry.getValue());
        }
    }
    return query.list();
}

1.2 批量查询Service层代码

@Transactional(rollbackFor = Throwable.class)
public List<Student> batchQuery(String ids) {
    String sql = "select * from T_STUDENT where STUDENT_ID in (:id)";
    Map<String, List<Object>> map = new HashMap<>();
    List<Object> idLong = new ArrayList<>();
    for (Object id : CollectionUtils.arrayToList(ids.split(","))) {
        idLong.add(Long.parseLong(id.toString()));
    }
    map.put("id", idLong);
    return studentDao.excuteBatchQuery(sql, map);
}

2.批量删除

2.1 批量删除Dao层代码

public void excuteBatchDelete(String sql, Map<String, List<Object>> map) {
    Session session = this.getSessionFactory().getCurrentSession();
    SQLQuery query = session.createSQLQuery(sql);
    if (map != null && map.size() > 0) {
        for (Map.Entry<String, List<Object>> entry : map.entrySet()) {
            query.setParameterList(entry.getKey(), entry.getValue());
        }
    }
    query.executeUpdate();
}

2.2 批量删除Service层代码

@Transactional(rollbackFor = Throwable.class)
public void batchDelete(String ids) {
    String sql = "delete from T_STUDENT where STUDENT_ID in(:id)";
    Map<String, List<Object>> map = new HashMap<>();
    List<Object> idLong = new ArrayList<>();
    for (Object id : CollectionUtils.arrayToList(ids.split(","))) {
        idLong.add(Long.parseLong(id.toString()));
    }
    map.put("id", idLong);
    this.studentDao.excuteBatchDelete(sql, map);
}