本文整理了Java中org.jbundle.base.db.Record.makeTableNames
方法的一些代码示例,展示了Record.makeTableNames
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Record.makeTableNames
方法的具体详情如下:
包路径:org.jbundle.base.db.Record
类名称:Record
方法名:makeTableNames
[英]The name of this table in a sql query.
Override this to supply the name of a built-in query.
[中]sql查询中此表的名称。
重写此选项以提供内置查询的名称。
代码示例来源:origin: org.jbundle.base/org.jbundle.base
String strRecordset = this.makeTableNames(false);
String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
boolean bIsQueryRecord = this.isQueryRecord();
代码示例来源:origin: org.jbundle.base.db/org.jbundle.base.db
String strRecordset = this.makeTableNames(false);
String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
boolean bIsQueryRecord = this.isQueryRecord();
代码示例来源: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
String strRecordset = this.makeTableNames(false);
String strFields = this.getSQLFields(DBConstants.SQL_SELECT_TYPE, bUseCurrentValues);
boolean bIsQueryRecord = this.isQueryRecord();
代码示例来源: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/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.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 '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 '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.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;
}
/**
内容来源于网络,如有侵权,请联系作者删除!