问在Hibernate中选择有两个以上值的查询

EN

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

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;
    }
}

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