android - ORMLite (Android) 请帮我起草一个请求

Question

真的需要你的帮助来起草一份给ORMlite的请求(安卓)。

有sql查询(NamedQuery):

1. 从 MessageEntityImpl m 中选择 m.contact.stringId，count(m.contact.stringId)，其中 m.status = MessageStatus.NEW group by m.contact.stringId"

2. SELECT m.chat_id, c.stringid, c.fullname, m.message, Max(posted) as postDate from messageentity m inner join (select chat_id, MAX(posted) max_posted from messageentity 组依据chat_id) max_posted_date ON m.chat_id = max_posted_date.chat_id 和 posted = max_posted_date.max_posted inner join contactentity c on c.ID = m.contact_id group by m.chat_id, c.stringid, c.fullname, m.message order by postDate desc

Answer 1

您最好发出原始查询以获取结果(如 GenericRawResults<T> )，然后遍历容器以获取所需的结果。这是一个例子 -

String sql = "select m.contact.stringId from MessageEntityImpl m where m.status = MessageStatus.NEW group by m.contact.stringId";

ArrayList<String> id = new ArrayList<>();

try
{
    GenericRawResults<String[]> grr = getDao().queryRaw(sql);
    List<String[]> results = grr.getResults();
    for (String[] outArray : results)
        id.add (outArray[0]);
}
catch (SQLException sqle)
{
    sqle.printStackTrace();
}

getDao() 可以是 BaseDaoImpl<T,ID> .