- 用eql语句对数据库进行查询
string sql = " SELECT * FROM XX x";
string[] wheres;
if(c.length)//(string类型)
{
wheres ~= "x.c '%" ~ c ~ "%'";//%"~ ~"%用来拼接字符串
}
if (z)
{
wheres ~= "x.z = :z";
}
if (wheres.length > 0)
{
sql ~= " WHERE ";
for (int i = 0; i < wheres.length; i++)
{
if (i > 0)
{
sql ~= " AND ";
}
sql ~= wheres[i];
}
}
sql ~= " ORDER BY x.created DESC(ASC)";//这部分是查询出来的条件按照创建时间来排序,可以根据需求来更换字段(DESC是倒序,ASC是正序)
auto query = _manager.createQuery!(XX)(sql, new pageable(page-1, limit));
query.setParameter("c"