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

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

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

Record.getSQLFields介绍

[英]Get the SQL field string for this table.

(ie., (SELECT) 'EmployeeID,EmpName,"Emp Last",Salary') (ie., (UPDATE) 'EmployeeID=5,EmpName='Fred',"Emp Last"='Flintstone',Salary=null).
[中]获取此表的SQL字段字符串。
（即，（选择）“EmployeeID，EmpName”，“Emp Last”，Salary”）（即，（更新）“EmployeeID=5，EmpName='Fred'，“Emp Last”='Flintstone'，Salary=null）。

代码示例

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

/**
 * Get the SQL 'Insert' string.
 * INSERT INTO table(field1, field2) VALUES('value1', 'value2');
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @return The SQL insert string.
 */
public String getSQLInsert(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  String strFields = this.getBaseRecord().getSQLFields(DBConstants.SQL_INSERT_TABLE_TYPE, bUseCurrentValues);
  String strValues = this.getBaseRecord().getSQLFields(DBConstants.SQL_INSERT_VALUE_TYPE, bUseCurrentValues);
  strRecordset = "INSERT INTO " + strRecordset + "(" + strFields + ") VALUES (" + strValues + ")";
  return strRecordset;
}
/**

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

/**
 * Get the SQL 'Insert' string.
 * INSERT INTO table(field1, field2) VALUES('value1', 'value2');
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @return The SQL insert string.
 */
public String getSQLInsert(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  String strFields = this.getBaseRecord().getSQLFields(DBConstants.SQL_INSERT_TABLE_TYPE, bUseCurrentValues);
  String strValues = this.getBaseRecord().getSQLFields(DBConstants.SQL_INSERT_VALUE_TYPE, bUseCurrentValues);
  strRecordset = "INSERT INTO " + strRecordset + "(" + strFields + ") VALUES (" + strValues + ")";
  return strRecordset;
}
/**

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

/**
 * Get the SQL 'Insert' string.
 * INSERT INTO table(field1, field2) VALUES('value1', 'value2');
 * @param bUseCurrentValues If true, use the current field value, otherwise, use '?'.
 * @return The SQL insert string.
 */
public String getSQLInsert(boolean bUseCurrentValues)
{
  String strRecordset = this.getBaseRecord().makeTableNames(false);
  String strFields = this.getBaseRecord().getSQLFields(DBConstants.SQL_INSERT_TABLE_TYPE, bUseCurrentValues);
  String strValues = this.getBaseRecord().getSQLFields(DBConstants.SQL_INSERT_VALUE_TYPE, bUseCurrentValues);
  strRecordset = "INSERT INTO " + strRecordset + "(" + strFields + ") VALUES (" + strValues + ")";
  return strRecordset;
}
/**

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

String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
boolean bIsQueryRecord = this.isQueryRecord();
String strSortParams = this.addSortParams(bIsQueryRecord, true);

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

String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
boolean bIsQueryRecord = this.isQueryRecord();
String strSortParams = this.addSortParams(bIsQueryRecord, true);

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

String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
boolean bIsQueryRecord = this.isQueryRecord();
String strSortParams = this.addSortParams(bIsQueryRecord, true);

代码示例来源：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;
}
/**

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

record

相关文章

    查看更多
    微信公众号

    热门标签

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

    最新文章

    更多

    Record类方法

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