org.jbundle.base.db.Record.isQueryRecord()方法的使用及代码示例

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

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

Record.isQueryRecord介绍

[英]Is this record a table (or a query stmt)? This class is a table.
[中]这条记录是表（还是查询stmt）？这个班是一张桌子。

代码示例

代码示例来源：origin: org.jbundle.base/org.jbundle.base

boolean bIsQueryRecord = this.isQueryRecord();
String strSortParams = this.addSortParams(bIsQueryRecord, true);

代码示例来源：origin: org.jbundle.base.db/org.jbundle.base.db

boolean bIsQueryRecord = this.isQueryRecord();
String strSortParams = this.addSortParams(bIsQueryRecord, true);

代码示例来源：origin: org.jbundle.base/org.jbundle.base.mixed

boolean bIsQueryRecord = this.isQueryRecord();
String strSortParams = this.addSortParams(bIsQueryRecord, true);

代码示例来源：origin: org.jbundle.base/org.jbundle.base

/**
 * Get the SQL 'Delete' string.
 * DELETE table WHERE key=value;
 * @param bUseCurrentValues   If true, insert field values, if false, insert '?'
 * @return The SQL delete string.
 */
public String getSQLDelete(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  KeyArea keyArea = this.getKeyArea(0); // Primary index
  boolean bIsQueryRecord = this.isQueryRecord();
  boolean bUseCurrentKeyValues = bUseCurrentValues ? true : keyArea.isNull(DBConstants.TEMP_KEY_AREA, false);
  String sFilter = "?";
  sFilter = keyArea.addSelectParams("=", DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentKeyValues, null, true, false);    // Always add!?
  if (sFilter.length() > 0)
    sFilter = " WHERE " + sFilter;
  strRecordset = "DELETE FROM " + strRecordset + sFilter;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base/org.jbundle.base.mixed

/**
 * Get the SQL 'Delete' string.
 * DELETE table WHERE key=value;
 * @param bUseCurrentValues   If true, insert field values, if false, insert '?'
 * @return The SQL delete string.
 */
public String getSQLDelete(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  KeyArea keyArea = this.getKeyArea(0); // Primary index
  boolean bIsQueryRecord = this.isQueryRecord();
  boolean bUseCurrentKeyValues = bUseCurrentValues ? true : keyArea.isNull(DBConstants.TEMP_KEY_AREA, false);
  String sFilter = "?";
  sFilter = keyArea.addSelectParams("=", DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentKeyValues, null, true, false);    // Always add!?
  if (sFilter.length() > 0)
    sFilter = " WHERE " + sFilter;
  strRecordset = "DELETE FROM " + strRecordset + sFilter;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base.db/org.jbundle.base.db

/**
 * Get the SQL 'Delete' string.
 * DELETE table WHERE key=value;
 * @param bUseCurrentValues   If true, insert field values, if false, insert '?'
 * @return The SQL delete string.
 */
public String getSQLDelete(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  KeyArea keyArea = this.getKeyArea(0); // Primary index
  boolean bIsQueryRecord = this.isQueryRecord();
  boolean bUseCurrentKeyValues = bUseCurrentValues ? true : keyArea.isNull(DBConstants.TEMP_KEY_AREA, false);
  String sFilter = "?";
  sFilter = keyArea.addSelectParams("=", DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentKeyValues, null, true, false);    // Always add!?
  if (sFilter.length() > 0)
    sFilter = " WHERE " + sFilter;
  strRecordset = "DELETE FROM " + strRecordset + sFilter;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base/org.jbundle.base

/**
 * Get the SQL 'Seek' string.
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @param vParamList The parameter list.
 * @return The SQL select string.
 */
public String getSQLSeek(String strSeekSign, boolean bUseCurrentValues, Vector<BaseField> vParamList)
{
  boolean bIsQueryRecord = this.isQueryRecord();
  String strRecordset = this.makeTableNames(false);
  String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
  String strSortParams = this.addSortParams(bIsQueryRecord, false);
  KeyArea keyArea = this.getKeyArea(-1);  // Current index
  keyArea.setupKeyBuffer(null, DBConstants.TEMP_KEY_AREA);        // Move params
  String sFilter = keyArea.addSelectParams(strSeekSign, DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentValues, vParamList, false, false);  // Always add!?
  if (sFilter.length() > 0)
  {
    if (strRecordset.indexOf(" WHERE ") == -1)
      sFilter = " WHERE " + sFilter;
    else
      sFilter = " AND " + sFilter;
  }
  strRecordset = "SELECT" + strFields + " FROM " + strRecordset + sFilter + strSortParams;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base/org.jbundle.base.mixed

/**
 * Get the SQL 'Seek' string.
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @param vParamList The parameter list.
 * @return The SQL select string.
 */
public String getSQLSeek(String strSeekSign, boolean bUseCurrentValues, Vector<BaseField> vParamList)
{
  boolean bIsQueryRecord = this.isQueryRecord();
  String strRecordset = this.makeTableNames(false);
  String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
  String strSortParams = this.addSortParams(bIsQueryRecord, false);
  KeyArea keyArea = this.getKeyArea(-1);  // Current index
  keyArea.setupKeyBuffer(null, DBConstants.TEMP_KEY_AREA);        // Move params
  String sFilter = keyArea.addSelectParams(strSeekSign, DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentValues, vParamList, false, false);  // Always add!?
  if (sFilter.length() > 0)
  {
    if (strRecordset.indexOf(" WHERE ") == -1)
      sFilter = " WHERE " + sFilter;
    else
      sFilter = " AND " + sFilter;
  }
  strRecordset = "SELECT" + strFields + " FROM " + strRecordset + sFilter + strSortParams;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base.db/org.jbundle.base.db

/**
 * Get the SQL 'Seek' string.
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @param vParamList The parameter list.
 * @return The SQL select string.
 */
public String getSQLSeek(String strSeekSign, boolean bUseCurrentValues, Vector<BaseField> vParamList)
{
  boolean bIsQueryRecord = this.isQueryRecord();
  String strRecordset = this.makeTableNames(false);
  String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
  String strSortParams = this.addSortParams(bIsQueryRecord, false);
  KeyArea keyArea = this.getKeyArea(-1);  // Current index
  keyArea.setupKeyBuffer(null, DBConstants.TEMP_KEY_AREA);        // Move params
  String sFilter = keyArea.addSelectParams(strSeekSign, DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentValues, vParamList, false, false);  // Always add!?
  if (sFilter.length() > 0)
  {
    if (strRecordset.indexOf(" WHERE ") == -1)
      sFilter = " WHERE " + sFilter;
    else
      sFilter = " AND " + sFilter;
  }
  strRecordset = "SELECT" + strFields + " FROM " + strRecordset + sFilter + strSortParams;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base.db/org.jbundle.base.db

/**
 * Get the SQL 'Update' string.
 * UPDATE table SET field1 = 'value1', field2 = 'value2' WHERE key = 'value'
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @param vParamList The parameter list.
 * @return The SQL select string.
 * @return null if nothing to update.
 */
public String getSQLUpdate(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  KeyArea keyArea = this.getBaseRecord().getKeyArea(0); // Primary index
  boolean bUseCurrentKeyValues = bUseCurrentValues ? true : keyArea.isNull(DBConstants.TEMP_KEY_AREA, true);
  boolean bIsQueryRecord = this.getBaseRecord().isQueryRecord();
  String sFilter = keyArea.addSelectParams("=", DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentKeyValues, null, true, true);   // Always add!?
  if (sFilter.length() > 0)
    sFilter = " WHERE " + sFilter;
  String strSetValues = this.getBaseRecord().getSQLFields(DBConstants.SQL_UPDATE_TYPE, bUseCurrentValues);
  if (strSetValues.length() == 0)
    return null;    // No fields to update
  strRecordset = "UPDATE " + strRecordset + " SET " + strSetValues + sFilter;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base/org.jbundle.base

/**
 * Get the SQL 'Update' string.
 * UPDATE table SET field1 = 'value1', field2 = 'value2' WHERE key = 'value'
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @param vParamList The parameter list.
 * @return The SQL select string.
 * @return null if nothing to update.
 */
public String getSQLUpdate(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  KeyArea keyArea = this.getBaseRecord().getKeyArea(0); // Primary index
  boolean bUseCurrentKeyValues = bUseCurrentValues ? true : keyArea.isNull(DBConstants.TEMP_KEY_AREA, true);
  boolean bIsQueryRecord = this.getBaseRecord().isQueryRecord();
  String sFilter = keyArea.addSelectParams("=", DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentKeyValues, null, true, true);   // Always add!?
  if (sFilter.length() > 0)
    sFilter = " WHERE " + sFilter;
  String strSetValues = this.getBaseRecord().getSQLFields(DBConstants.SQL_UPDATE_TYPE, bUseCurrentValues);
  if (strSetValues.length() == 0)
    return null;    // No fields to update
  strRecordset = "UPDATE " + strRecordset + " SET " + strSetValues + sFilter;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base/org.jbundle.base.mixed

/**
 * Get the SQL 'Update' string.
 * UPDATE table SET field1 = 'value1', field2 = 'value2' WHERE key = 'value'
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @param vParamList The parameter list.
 * @return The SQL select string.
 * @return null if nothing to update.
 */
public String getSQLUpdate(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  KeyArea keyArea = this.getBaseRecord().getKeyArea(0); // Primary index
  boolean bUseCurrentKeyValues = bUseCurrentValues ? true : keyArea.isNull(DBConstants.TEMP_KEY_AREA, true);
  boolean bIsQueryRecord = this.getBaseRecord().isQueryRecord();
  String sFilter = keyArea.addSelectParams("=", DBConstants.TEMP_KEY_AREA, false, bIsQueryRecord, bUseCurrentKeyValues, null, true, true);   // Always add!?
  if (sFilter.length() > 0)
    sFilter = " WHERE " + sFilter;
  String strSetValues = this.getBaseRecord().getSQLFields(DBConstants.SQL_UPDATE_TYPE, bUseCurrentValues);
  if (strSetValues.length() == 0)
    return null;    // No fields to update
  strRecordset = "UPDATE " + strRecordset + " SET " + strSetValues + sFilter;
  return strRecordset;
}
/**

代码示例来源：origin: org.jbundle.base/org.jbundle.base

boolean bIsQueryRecord = this.isQueryRecord();
if (iType != DBConstants.SQL_SELECT_TYPE)
  bAllSelected = false;

代码示例来源：origin: org.jbundle.base/org.jbundle.base.mixed

boolean bIsQueryRecord = this.isQueryRecord();
if (iType != DBConstants.SQL_SELECT_TYPE)
  bAllSelected = false;

代码示例来源：origin: org.jbundle.base.db/org.jbundle.base.db

boolean bIsQueryRecord = this.isQueryRecord();
if (iType != DBConstants.SQL_SELECT_TYPE)
  bAllSelected = false;

代码示例来源：origin: org.jbundle.base/org.jbundle.base

if (this.getRecord().isQueryRecord())

代码示例来源：origin: org.jbundle.base.db/org.jbundle.base.db

if (this.getRecord().isQueryRecord())

代码示例来源：origin: org.jbundle.base/org.jbundle.base.mixed

if (this.getRecord().isQueryRecord())

内容来源于网络，如有侵权，请联系作者删除！

record

相关文章

    查看更多
    微信公众号

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多

    Record类方法

    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com