一起使用IN和LIKE子句进行休眠 [英] Hibernate using IN and LIKE clause together

问题描述

我有以下休眠代码，

session.createQuery("from Car as car where car.keywordName like :keyword").setString("keyword", keyword ).list(); 

接受一个带有以下括号％keyword％的关键字，并返回包含该关键字的汽车列表.汽车的关键字是一个长字符串，例如，以逗号分隔.对于汽车，关键字将为豪华，宽敞，敞篷，4人座"和另一条声明

which takes in a keyword with the following parenthesis %keyword% and return the list of cars which has contain the keyword. The keywords of a car is a long string which is comma delimited for e.g. for a car the keywords will be "luxury, spacious, honta, 4seater" and another statement

session.createQuery("from Car as car where car.carId IN (:idList)").setParameterList( "idList", idList ).list();

从ID列表返回汽车列表.我一直试图将像和IN这样的两个子句组合在一起，以从关键字列表中返回一个汽车列表，而不只是一个关键字.

which returns the list of cars from a list of id. I having been trying to combine the two clauses like and IN together to returns a list of cars from a list of keywords instead of just a single keyword.

如果有人能阐明一些想法，将不胜感激.干杯！

Would appreciate if someone can shed some light. Cheers!

推荐答案

您必须动态创建查询才能创建类似

You'll have to dynamically create a query to create something like

select car from Car car 
where car.keywordName like :k1 
or car.keywordName like :k2
or car.keywordName like :k3
...

做到这一点的最佳工具是标准API (请参阅第三个代码段，使用和解，以或分隔的限制列表的示例).

The best tool to do that is the Criteria API (See the third code snippet, using a disjunction, for an example of a list of restrictions seperated with or).

这篇关于一起使用IN和LIKE子句进行休眠的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！