java - 在 Hibernate 中选择具有两个以上值的查询

Question

如何编写 Hibernate 查询来选择具有两个以上值的值？

metrics = new long[]{1, 2, 3};
rprtAutoCustomColum = reportSettingServive.getColumnsMap("1,2,3");

共有三个columnId。我想选择columnId和变量名称并存储在HashMap

public Map<Long, String> customeCol = new HashMap<>();

public HashMap<Long, String> getColumnsMap(String columnIds) {
    Session session = null;
    Transaction transaction = null;
    List<ReportsAutomationCustomColumns> automationCustomColumns = new ArrayList();

    SQLQuery query;
    try {
        session = sessionFactory.openSession();
        transaction = (Transaction) session.beginTransaction();
        String hql = "from lxr_reportsauto_customcolumns  where column_id=:columnIds";
        Query query = session.createQuery(hql);
        List<ReportsAutomationCustomColumns> list = query.list();
        transaction.commit();

        list.stream().forEach((ReportsAutomationCustomColumns clist) -> {
            customeCol.put(clist.getColumnId(), clist.getVariableName());
        });
        return (HashMap<Long, String>) customeCol;
    }
}

正常的 SQL 看起来像:

select column_id,variable_name from lxr_reportsauto_customcolumns
where column_id in(1,2,3) order by column_id 

但我想要 hibernate 。

Answer 1

您需要使用所需的值创建一个List，然后将其传递给您的查询，如下所示:

List<Long> values = new ArrayList<Long>();
values.add(1L);
values.add(2L);
values.add(3L);

String hql = "from lxr_reportsauto_customcolumns  where column_id in (:columnIds)";
Query query = session.createQuery(hql);
query.setParameterList("columnIds", values);