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

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

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

Query.getType介绍

暂无

代码示例

代码示例来源: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

@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

switch (query.getType()) {
  case SELECT:
    sql.append("SELECT ");

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

switch (query.getType()) {
  case SELECT:
    sql.append("SELECT ");

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

switch (query.getType()) {
  case SELECT:

代码示例来源: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

switch (query.getType()) {
  case SELECT:

代码示例来源: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();
}

相关文章