Help to use getHibernateTemplate().find

[kleysonr]

How can I use getHibernateTemplate().find to do the following select:

select * from DmControl where status in ('Open','Close')

Regards.

[chelu]

For example:

String query = "SELECT * FROM DmControl WHERE status in (?, ?)";
List<Map<String, Object>> rs = template.queryForList(query, "Open", "Close");