java - Hibernate我用criteria查找产品名称里包含abc的产品,用了Restrictions.like,但是没结果
ringa_lee
ringa_lee 2017-04-18 09:18:31
0
1
630

//查找产品名称里包含abc的产品

Criteria criteria = session.createCriteria(Product.class);
criteria.add(Restrictions.like("name", "%abc%"));
l = criteria.list();

product表里明明有名称包含abc的产品。

ringa_lee
ringa_lee

ringa_lee

reply all(1)
Peter_Zhu

The reason why the query cannot be found is because the Oracle database is case-sensitive by default.

Solution:

criteria.add(Restrictions.like("name", "%abc%").ignoreCase());
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template