请教大神ORMLite多条件查询的使用方法

[dangdang2471]

形如下面的sql，使用ORMLite该如何写？

select * from AuthManagement where ExpiryTime>当前时间 and (AgreedCode='1234' or DisagreeCode='1234')

[dangdang2471]

谢谢大神！

[jklwan]

Where<AuthManagement, String> where = queryBuilder.where();
  where.and(
    where.gt("ExpiryTime", 当前时间),
    where.or(  where.eq("AgreedCode", "1234"), 
     where.eq("DisagreeCode", "1234")
  )
);

文档地址http://ormlite.com/javadoc/ormlite-core/doc-files/ormlite_3.html#Building-Queries