public class DBStringTrimmed extends DBString
Support DBvolution at Patreon
SORT_ASCENDING, SORT_DESCENDING| Constructor and Description |
|---|
DBStringTrimmed()
The default constructor for DBStringTrimmed.
|
DBStringTrimmed(String string)
Creates a DBString with the value provided.
|
DBStringTrimmed(StringExpression stringExpression)
Creates a column expression with a string result from the expression
provided.
|
| Modifier and Type | Method and Description |
|---|---|
String |
formatColumnForSQLStatement(DBDefinition db,
String formattedColumnName)
Returns the column of the object formatted for the database.
|
String |
formatValueForSQLStatement(DBDefinition db)
Returns the value of the object formatted for the database
This should be overridden in each subclass
This method is called by toSQLString after checking for NULLs and should
return a string representation of the object formatted for use within a SQL
select, insert, update, or delete statement.
|
copy, excludedPattern, excludedPattern, excludedRange, excludedRange, excludedRangeExclusive, excludedRangeExclusive, excludedRangeInclusive, excludedRangeInclusive, excludedValues, excludedValues, excludedValues, excludedValuesIgnoreCase, excludedValuesIgnoreCase, excludedValuesIgnoreCase, getColumn, getFromResultSet, getIncludesNull, getQueryableDatatypeForExpressionValue, getSQLDatatype, getTablesInvolved, getValue, isAggregator, isEmptyOrNullString, isEmptyString, permittedPattern, permittedPattern, permittedPatternIgnoreCase, permittedRange, permittedRange, permittedRangeExclusive, permittedRangeExclusive, permittedRangeInclusive, permittedRangeInclusive, permittedValues, permittedValues, permittedValues, permittedValues, permittedValuesIgnoreCase, permittedValuesIgnoreCase, permittedValuesIgnoreCase, permittedValuesIgnoreCase, setToNull, setValue, setValueFromStandardStringEncoding, stringResult, toStringListclear, createSQLForFromClause, equals, getColumnExpression, getLiteralValue, getOperator, getPreviousSQLValue, getPreviousValue, getPropertyWrapperDefinition, getQueryableDatatypeForObject, getQueryableDatatypeInstance, getSortOrder, hasBeenSet, hasChanged, hasColumnExpression, hashCode, includingNulls, isComplexExpression, isDefined, isNotNull, isNull, isPurelyFunctional, negateOperator, removeConstraints, setChanged, setColumnExpression, setDefined, setFromResultSet, setLiteralValue, setOperator, setPreviousValue, setSortOrderAscending, setSortOrderDescending, setToNull, setUnchanged, setValueToNull, stringValue, toSQLString, toStringclone, finalize, getClass, notify, notifyAll, wait, wait, waitcreateSQLForFromClause, isComplexExpression, isPurelyFunctional, toSQLStringpublic DBStringTrimmed()
Creates an unset undefined DBStringTrimmed object.
public DBStringTrimmed(String string)
The resulting DBString will be set as having the value provided but will not be defined in the database.
string - stringpublic DBStringTrimmed(StringExpression stringExpression)
Used in DBReport, and some DBRow, sub-classes to derive
data from the database prior to retrieval.
stringExpression - stringExpressionpublic String formatValueForSQLStatement(DBDefinition db)
QueryableDatatypeformatValueForSQLStatement in class DBStringdb - db
Support DBvolution at Patreon
public String formatColumnForSQLStatement(DBDefinition db, String formattedColumnName)
QueryableDatatypeThis method provides a route to transforming all calls to a column prior to use in SQL.
See
the implementation in DBStringTrimmed
for an example.
formatColumnForSQLStatement in class QueryableDatatype<String>db - dbformattedColumnName - the name of the database column or similar
expression ready to be used in an SQL excerpt
Support DBvolution at Patreon
Copyright © 2018. All Rights Reserved.