net.java.ao.Query.getLimit()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(7.3k)|赞(0)|评价(0)|浏览(126)

本文整理了Java中net.java.ao.Query.getLimit方法的一些代码示例,展示了Query.getLimit的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Query.getLimit方法的具体详情如下:
包路径:net.java.ao.Query
类名称:Query
方法名:getLimit

Query.getLimit介绍

暂无

代码示例

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

@Override
public void setQueryStatementProperties(Statement stmt, Query query) throws SQLException {
  int limit = query.getLimit();
  if (limit >= 0) {
    stmt.setFetchSize(limit);
    stmt.setMaxRows(limit);
  }
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

@Override
public void setQueryStatementProperties(Statement stmt, Query query) throws SQLException {
  int limit = query.getLimit();
  if (limit >= 0) {
    stmt.setFetchSize(limit);
    stmt.setMaxRows(limit);
  }
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

@Override
protected String renderQueryLimit(final Query query) {
  final StringBuilder sql = new StringBuilder();
  // H2 requires a LIMIT when OFFSET is specified; -1 indicates unlimited
  if (query.getLimit() < 0 && query.getOffset() > 0) {
    sql.append(" LIMIT -1");
  }
  sql.append(super.renderQueryLimit(query));
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

@Override
protected String renderQueryLimit(final Query query) {
  StringBuilder sql = new StringBuilder();
  // use the "LIMIT [<OFFSET>, ] <LIMIT>" style, with (2^64-1) meaning "unlimited"
  int offset = query.getOffset();
  int limit = query.getLimit();
  if (offset > 0) {
    sql.append(" LIMIT ");
    sql.append(offset);
    sql.append(", ");
    if (limit >= 0) {
      sql.append(limit);
    } else {
      sql.append("18446744073709551615");
    }
  } else if (limit >= 0) {
    sql.append(" LIMIT ");
    sql.append(limit);
  }
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

@Override
protected String renderQueryLimit(final Query query) {
  final StringBuilder sql = new StringBuilder();
  // H2 requires a LIMIT when OFFSET is specified; -1 indicates unlimited
  if (query.getLimit() < 0 && query.getOffset() > 0) {
    sql.append(" LIMIT -1");
  }
  sql.append(super.renderQueryLimit(query));
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

@Override
protected String renderQueryLimit(final Query query) {
  StringBuilder sql = new StringBuilder();
  // use the "LIMIT [<OFFSET>, ] <LIMIT>" style, with (2^64-1) meaning "unlimited"
  int offset = query.getOffset();
  int limit = query.getLimit();
  if (offset > 0) {
    sql.append(" LIMIT ");
    sql.append(offset);
    sql.append(", ");
    if (limit >= 0) {
      sql.append(limit);
    } else {
      sql.append("18446744073709551615");
    }
  } else if (limit >= 0) {
    sql.append(" LIMIT ");
    sql.append(limit);
  }
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

StringBuilder sql = new StringBuilder();
int limit = query.getLimit();
if (limit >= 0) {
  sql.append(" LIMIT ");

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

@Override
protected String renderQueryLimit(Query query) {
  StringBuilder sql = new StringBuilder();
  if (Query.QueryType.SELECT.equals(query.getType())) {
    int offset = query.getOffset();
    int limit = query.getLimit();
    if (offset > 0 && limit >= 0) {
      sql.append(" ) QUERY_INNER WHERE ROWNUM <= ");
      sql.append(offset + limit);
      sql.append(" ) WHERE ROWNUM_INNER > ");
      sql.append(offset);
    } else if (offset > 0) {
      sql.append(" ) QUERY_INNER ) WHERE ROWNUM_INNER > ");
      sql.append(offset);
    } else if (limit >= 0) {
      sql.append(" ) WHERE ROWNUM <= ");
      sql.append(limit);
    }
  }
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

@Override
protected String renderQueryLimit(Query query) {
  StringBuilder sql = new StringBuilder();
  if (Query.QueryType.SELECT.equals(query.getType())) {
    int offset = query.getOffset();
    int limit = query.getLimit();
    if (offset > 0 && limit >= 0) {
      sql.append(" ) QUERY_INNER WHERE ROWNUM <= ");
      sql.append(offset + limit);
      sql.append(" ) WHERE ROWNUM_INNER > ");
      sql.append(offset);
    } else if (offset > 0) {
      sql.append(" ) QUERY_INNER ) WHERE ROWNUM_INNER > ");
      sql.append(offset);
    } else if (limit >= 0) {
      sql.append(" ) WHERE ROWNUM <= ");
      sql.append(limit);
    }
  }
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

StringBuilder sql = new StringBuilder();
int limit = query.getLimit();
if (limit >= 0) {
  sql.append(" LIMIT ");

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

@Override
protected String renderQuerySelect(final Query query, final TableNameConverter converter, final boolean count) {
  StringBuilder sql = new StringBuilder();
  // see http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html
  if (Query.QueryType.SELECT.equals(query.getType())) {
    int offset = query.getOffset();
    int limit = query.getLimit();
    if (offset > 0) {
      sql.append("SELECT * FROM ( SELECT QUERY_INNER.*, ROWNUM ROWNUM_INNER FROM ( ");
    } else if (limit >= 0) {
      sql.append("SELECT * FROM ( ");
    }
  }
  sql.append(super.renderQuerySelect(query, converter, count));
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

@Override
protected String renderQuerySelect(final Query query, final TableNameConverter converter, final boolean count) {
  StringBuilder sql = new StringBuilder();
  // see http://www.oracle.com/technetwork/issue-archive/2006/06-sep/o56asktom-086197.html
  if (Query.QueryType.SELECT.equals(query.getType())) {
    int offset = query.getOffset();
    int limit = query.getLimit();
    if (offset > 0) {
      sql.append("SELECT * FROM ( SELECT QUERY_INNER.*, ROWNUM ROWNUM_INNER FROM ( ");
    } else if (limit >= 0) {
      sql.append("SELECT * FROM ( ");
    }
  }
  sql.append(super.renderQuerySelect(query, converter, count));
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

int limit = query.getLimit();
int offset = query.getOffset();
if (limit >= 0 || offset > 0) {

代码示例来源:origin: net.java.dev.activeobjects/activeobjects-core

@Override
protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) {
  StringBuilder sql = new StringBuilder();
  String tableName = query.getTable();
  if (tableName == null) {
    tableName = converter.getName(query.getTableType());
  }
  switch (query.getType()) {
    case SELECT:
      sql.append("SELECT ");
      if (query.isDistinct()) {
        sql.append("DISTINCT ");
      }
      int limit = query.getLimit();
      if (limit >= 0) {
        if (query.getOffset() > 0) {
          limit += query.getOffset();
        }
        sql.append("TOP ").append(limit).append(' ');
      }
      if (count) {
        sql.append("COUNT(*)");
      } else {
        sql.append(querySelectFields(query, converter));
      }
      sql.append(" FROM ").append(queryTableName(query, converter));
      break;
  }
  return sql.toString();
}

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

int limit = query.getLimit();
int offset = query.getOffset();
if (limit >= 0 || offset > 0) {

代码示例来源:origin: net.java.dev.activeobjects/activeobjects

@Override
protected String renderQuerySelect(Query query, TableNameConverter converter, boolean count) {
  StringBuilder sql = new StringBuilder();
  String tableName = query.getTable();
  if (tableName == null) {
    tableName = converter.getName(query.getTableType());
  }
  switch (query.getType()) {
    case SELECT:
      sql.append("SELECT ");
      if (query.isDistinct()) {
        sql.append("DISTINCT ");
      }
      int limit = query.getLimit();
      if (limit >= 0) {
        if (query.getOffset() > 0) {
          limit += query.getOffset();
        }
        sql.append("TOP ").append(limit).append(' ');
      }
      if (count) {
        sql.append("COUNT(*)");
      } else {
        sql.append(querySelectFields(query, converter));
      }
      sql.append(" FROM ").append(queryTableName(query, converter));
      break;
  }
  return sql.toString();
}

相关文章