mysql - Hibernate 标准表达式

Question

如何将以下 sql 查询转换为条件:

select count(*) from table where column >= 'value'

我尝试了这个例子:

Criteria criteria=sessionFactory.getCurrentSession()
                  .createCriteria(RadioCsv.class)        
                  .add(Restrictions.ge("signalstrength", -35))      
                  .setProjection(Projections.projectionList()
                  .add(Projections.count("signalstrength"))           
                  );

Answer 1

试试这个:

Integer count = session.createQuery("from table where column >= ?").setParameter(0, value).list().size();

或者这个:

Integer count = session.createQuery("from table where column >="+value).list().size();