Uses of Class
com.basiscomponents.db.ResultSet

Packages that use ResultSet

Package	Description
com.basiscomponents.bc
com.basiscomponents.db
com.basiscomponents.db.export
com.basiscomponents.db.importer
com.basiscomponents.db.seeder
com.basiscomponents.db.sql
com.basiscomponents.db.tree
com.basiscomponents.db.util
com.basiscomponents.rest
com.basiscomponents.util

Uses of ResultSet in com.basiscomponents.bc

Methods in com.basiscomponents.bc that return ResultSet

Modifier and Type	Method	Description
ResultSet	ConfigurationsBC.getAvailableConfigurations()	returns the available configurations the user can access with the current filter.
ResultSet	IConfigurationsBC.getAvailableConfigurations()	returns the available configurations the user can access with the current filter.
ResultSet	ConfigurationsBC.getEffectiveConfiguration()	gets the effective configuration for a user.
ResultSet	IConfigurationsBC.getEffectiveConfiguration()	gets the effective configuration for a user.
ResultSet	BusinessComponent.getLookupData(String fieldName, DataRow dr)	like getLookup, but instead returns a resultset containg the lookup data.
ResultSet	ConfigurationsBC.getLookupData(String fieldName, DataRow dr)
ResultSet	SqlTableBC.getLookupData(String fieldName, DataRow dr)
ResultSet	BCBinder.getRS()
ResultSet	ConfigurationsBC.getSharedConfigs()	returns the shared configurations the user can access with the current filter.
ResultSet	IConfigurationsBC.getSharedConfigs()	returns the shared configurations the user can access with the current filter.
protected ResultSet	ConfigurationsBC.mergeResultSetsOnKeys(ResultSet rs1, ResultSet rs2)	merges 2 resultsets
ResultSet	BusinessComponent.retrieve()	Retrieves a ResultSet with DataRow's. If a filter is set, this will be applied to filter the result. If a scope and/or a field selection is set, it will be used to retrieve the desired fields.
ResultSet	BusinessComponent.retrieve(int first, int last)	Retrieves a ResultSet containing a subset of DataRow's (for pagination f.g.). If a filter is set, this will be applied to filter the result. If a scope and/or a field selection is set, it will be used to retrieve the desired fields.
ResultSet	ConfigurationsBC.retrieve()
ResultSet	ConfigurationsBC.retrieve(int first, int last)
ResultSet	SqlQueryBC.retrieve(String sql)
ResultSet	SqlQueryBC.retrieve(String sql, List<Object> params)
ResultSet	SqlTableBC.retrieve()	Retrieves a ResultSet with DataRow's. If a filter is set, this will be applied to filter the result. If a scope and/or a field selection is set, it will be used to retrieve the desired fields.
ResultSet	SqlTableBC.retrieve(int first, int last)	Retrieves a ResultSet containing a subset of DataRow's (for pagination f.g.). If a filter is set, this will be applied to filter the result. If a scope and/or a field selection is set, it will be used to retrieve the desired fields.
ResultSet	SqlTableBC.retrieve(String sql, DataRow params)	Executes a SQL query statement and returns the result as a ResultSet.
ResultSet	BusinessComponent.validateRemove(DataRow dr)	Validates a DataRow object before it can be removed. This method is internally used by the remove method. But it can also be called from the frontend to check for dependencies before it can be removed.
ResultSet	ConfigurationsBC.validateRemove(DataRow dr)	validates datarow before removal.
ResultSet	SqlTableBC.validateRemove(DataRow dr)	Validates a DataRow object before it can be removed. This method is internally used by the remove method. But it can also be called from the frontend to check for dependencies before it can be removed.
ResultSet	BusinessComponent.validateWrite(DataRow dr)	Validates a DataRow object before it can be written. This method is internally used by the write method. But it can also be called from the frontend to check for required or missing data.
ResultSet	ConfigurationsBC.validateWrite(DataRow dr)	Validates a DataRow object before it can be written. This method is internally used by the write method. But it can also be called from the frontend to check for required or missing data.
ResultSet	SqlTableBC.validateWrite(DataRow dr)	Validates a DataRow object before it can be written. This method is internally used by the write method. But it can also be called from the frontend to check for required or missing data.

Methods in com.basiscomponents.bc with parameters of type ResultSet

Modifier and Type	Method	Description
protected void	ConfigurationsBC.checkDataRowMustContainField(DataRow dr, ResultSet errorRS, String fieldName)	checks if the field is contained in the datarow, otherwise an error is added to the resultset
protected void	ConfigurationsBC.checkDataRowMustNotContainField(DataRow dr, ResultSet errorRS, String fieldName)	checks if the field is NOT contained in the datarow, otherwise an error is added to the resultset
protected void	ConfigurationsBC.checkEditableFieldsInDataRow(DataRow dr, ResultSet errorRS, boolean checkKeysOnly)	checks a data row if it violates the requirements as defined in the attributesRecord. For example if a field is a key, the dataRow must contain it. If it is read only, the dataRow must not contain it (That is, if 'checkKeysOnly' is false.
protected ResultSet	ConfigurationsBC.mergeResultSetsOnKeys(ResultSet rs1, ResultSet rs2)	merges 2 resultsets
protected void	ConfigurationsBC.throwValidation(ResultSet validation)	throws a validation error if the validation has failed.

Uses of ResultSet in com.basiscomponents.db

Methods in com.basiscomponents.db that return ResultSet

Modifier and Type	Method	Description
ResultSet	ResultSet.clone()
ResultSet	ResultSet.clone(Boolean fDeepClone)	creates a clone of the ResultSet
ResultSet	JDBCDataSource.fetchResultSet(String sql)
ResultSet	ResultSet.filterBy(DataRow simpleFilterCondition)	Search for DataRow(s) containing a specific value(s) Returns a new ResultSet with the DataRow(s) found in the current instance.
ResultSet	ResultSet.filterBy(String queryClause)	Applies the queryClause to a ResultSet and returns a new ResultSet that only contains records that match the clause.
ResultSet	ResultSet.filterBy(String QueryClause, boolean caseSensitive, boolean trimmed)	Applies the queryClause to a ResultSet and returns a new ResultSet that only contains records that match the clause.
static ResultSet	ResultSet.fromJson(String js)	Returns a ResultSet object created by parsing the given JSON String.
ResultSet	ResultSet.orderBy(String orderByClause)	re-orders a result set according to an ORDER BY clause like in SQL ORDER BY: e.g.
static ResultSet	ResultSetImporter.readExcel(File excelFile)	Parses the given Excel file and returns a com.basiscomponents.db.ResultSet with the data defined the the Excel file.
static ResultSet	ResultSetImporter.readExcel(File excelFile, DataRow attributesRecord)	Parses the given Excel file and returns a com.basiscomponents.db.ResultSet with the data defined the the Excel file.
static ResultSet	ResultSetImporter.readExcel(File excelFile, DataRow attributesRecord, List<String> columnNames, Boolean firstRowHasData)	Parses the given Excel file and returns a com.basiscomponents.db.ResultSet with the data defined the the Excel file.

Methods in com.basiscomponents.db with parameters of type ResultSet

Modifier and Type	Method	Description
static void	ResultSetExporter.exportToCSV(File outputFile, ResultSet rs)	Exports the content of the given ResultSet from a BBjGridExWidget
static void	ResultSetExporter.exportToCSV(File outputFile, ResultSet rs, DataRow baseDR, boolean useLabel)	Method to export a result set to a CSV file
static net.sf.jasperreports.engine.JasperPrint	ResultSetExporter.exportToJasperPrint(File file, ResultSet rs, SheetConfiguration sheetConfig, boolean baristaMode, int fitTo, boolean landscapeMode)
static File	ResultSetExporter.exportToPDF(File file, ResultSet rs, SheetConfiguration sheetConfig, boolean baristaMode, int fitTo, boolean landscapeMode)	Exports the content of the given ResultSet from a BBjGridExWidget
static File	ResultSetExporter.exportToPDFByCustomReport(File outputFile, File customReport, ResultSet rs)	Exports the content of the given ResultSet from a BBjGridExWidget
void	ResultSet.merge(ResultSet rs2, String onFieldName, boolean fOverwrite)
static DataRow	DataRow.newInstance(ResultSet resultSet)	Returns a new instance of a DataRow object which has been initialized with the column metadata from the given ResultSet object.
static void	ResultSetExporter.writeHTML(ResultSet resultSet, Writer writer)	Uses the given Writer object to write the ResultSet's content as HTML <table> element to the output stream.
static void	ResultSetExporter.writeHTML(ResultSet resultSet, Writer writer, DataRow baseDR, boolean useLabel)	Uses the given Writer object to write the ResultSet's content as HTML <table> element to the output stream.
static void	ResultSetExporter.writeHTML(ResultSet resultSet, Writer writer, HashMap<String,String> links)	Uses the given Writer object to write the ResultSet's content as HTML <table> element to the output stream.
static void	ResultSetExporter.writeHTML(ResultSet resultSet, Writer writer, HashMap<String,String> links, DataRow baseDR, boolean useLabel)	Uses the given Writer object to write the ResultSet's content as HTML <table> element to the output stream.
static void	ResultSetExporter.writeJSON(ResultSet resultSet, Writer writer)	Converts the given ResultSet object to a JSON String and writes it to the output stream using the given writer object.
static void	ResultSetExporter.writeJSON(ResultSet resultSet, Writer writer, Boolean fMeta)
static void	ResultSetExporter.writeTXT(ResultSet resultSet, Writer writer)	Uses the given Writer object to write the ResultSet's content as plain text to the output stream.
static void	ResultSetExporter.writeTXT(ResultSet resultSet, Writer writer, DataRow baseDR, Boolean useLabel)	Uses the given Writer object to write the ResultSet's content as plain text to the output stream.
static void	ResultSetExporter.writeXLSX(ResultSet rs, File outputFile, boolean writeHeader)	Writes the content of the given ResultSet as XLSX into the specified File.
static void	ResultSetExporter.writeXLSX(ResultSet rs, File outputFile, boolean writeHeader, boolean useLabelIfPresent, String sheetName, DataRow AttributesRecord)	Writes the content of the given ResultSet as XLSX into the specified File.
static void	ResultSetExporter.writeXLSX(ResultSet rs, File outputFile, boolean writeHeader, SheetConfiguration sheetConfig)	Writes the content of the given ResultSet as XLSX into the specified File.
static void	ResultSetExporter.writeXLSX(ResultSet rs, OutputStream out, boolean writeHeader)	Writes the content of the given ResultSet into an output stream.
static void	ResultSetExporter.writeXLSX(ResultSet rs, OutputStream out, boolean writeHeader, boolean useLabelIfPresent, String sheetName, DataRow attributesRecord)	Writes the content of the given ResultSet into an output stream.
static void	ResultSetExporter.writeXLSX(ResultSet rs, OutputStream out, boolean writeHeader, boolean useLabelIfPresent, String sheetName, DataRow AttributesRecord, SheetConfiguration sheetConfig)	Writes the content of the given ResultSet into an output stream.
static void	ResultSetExporter.writeXML(ResultSet resultSet, String rootTagName, String entityName, Writer writer)	Uses the given Writer object to write the ResultSet's content as XML to the output stream.
static void	ResultSetExporter.writeXML(ResultSet resultSet, String rootTagName, String entityName, Writer writer, DataRow baseDR, boolean useLabel)	Uses the given Writer object to write the ResultSet's content as XML to the output stream.

Constructors in com.basiscomponents.db with parameters of type ResultSet

Constructor	Description
DataRow(ResultSet resultSet)	Instantiates a new DataRow object and sets the column metadata to the given ResultSet object's column metadata.

Uses of ResultSet in com.basiscomponents.db.export

Methods in com.basiscomponents.db.export with parameters of type ResultSet

Modifier and Type	Method	Description
static String	CsvExport.buildExportString(ResultSet rs)	Method to build the CSV export String
static String	CsvExport.buildExportString(ResultSet rs, DataRow baseDR, boolean useLabel)	Method to build the CSV export String
static DataRow	ColumnWidthCalculator.calculateColumnWidths(ResultSet rs, float fontSize)	Calculates the column widths
static DataRow	ColumnWidthCalculator.calculateColumnWidths(ResultSet rs, float fontSize, boolean useLabel)	Calculates the column widths
static DataRow	ColumnWidthCalculator.calculateColumnWidths(ResultSet rs, float fontSize, boolean calculateAllRows, boolean useLabel)	Calculates the column widths
static DataRow	ColumnWidthCalculator.calculateColumnWidths(ResultSet rs, String fontResourcePath, float fontSize, int rowsToCheck, boolean calculateAllRows, boolean useLabel)	Calculates the column widths
static void	CsvExport.exportToCSV(File outputFile, ResultSet rs)	Method to export a result set to a CSV file
static void	CsvExport.exportToCSV(File outputFile, ResultSet rs, DataRow baseDR, boolean useLabel)	Method to export a result set to a CSV file
static net.sf.jasperreports.engine.JasperPrint	PdfExport.exportToJasperPrint(File outputFile, ResultSet rs, SheetConfiguration sheetConfig, boolean baristaMode, int fitTo, boolean landscapeMode)
static File	PdfExport.exportToPDF(File outputFile, ResultSet rs, SheetConfiguration sheetConfig, boolean baristaMode, int fitTo, boolean landscapeMode)	Exports the content of the given ResultSet from a BBjGridExWidget
static File	PdfExport.exportToPDF(File outputFile, File customReport, ResultSet rs)	Exports the content of the given ResultSet from a BBjGridExWidget
static void	HtmlExport.writeHTML(ResultSet resultSet, Writer writer, HashMap<String,String> links, DataRow baseDR, boolean useLabel)	Uses the given Writer object to write the ResultSet's content as HTML <table> element to the output stream.
static void	TxtExport.writeTXT(ResultSet resultSet, Writer writer, DataRow baseDR, boolean useLabel)	Uses the given Writer object to write the ResultSet's content as plain text to the output stream.
static void	XlsxExport.writeXLSX(ResultSet rs, OutputStream out, boolean writeHeader, boolean useLabelIfPresent, String sheetName, DataRow AttributesRecord, SheetConfiguration sheetConfig)	Writes the content of the given ResultSet into an output stream.
static void	XmlExport.writeXML(ResultSet resultSet, String rootTagName, String entityName, Writer writer, DataRow baseDR, boolean useLabel)	Uses the given Writer object to write the ResultSet's content as XML to the output stream.

Uses of ResultSet in com.basiscomponents.db.importer

Methods in com.basiscomponents.db.importer that return ResultSet

Modifier and Type	Method	Description
static ResultSet	ListImporter.ResultSetFromVector(List li, DataRow AttributesRecord)	Create a ResultSet from a List (like BBjVector)
ResultSet	JLibResultSetImporter.retrieve()	Returns a ResultSet object with the content of the Data file based on the specified filter, offset, field selection.

Uses of ResultSet in com.basiscomponents.db.seeder

Methods in com.basiscomponents.db.seeder that return ResultSet

Modifier and Type	Method	Description
ResultSet	CommonDataTypeSeeder.retrieve(int resultSetSize)	Creates a ResultSet, filled with a specific number of data rows which are filled with common data types data

Uses of ResultSet in com.basiscomponents.db.sql

Methods in com.basiscomponents.db.sql that return ResultSet

Modifier and Type	Method	Description
ResultSet	SQLResultSet.getResultSet()

Constructors in com.basiscomponents.db.sql with parameters of type ResultSet

Constructor	Description
SQLResultSet(ResultSet rs)
SQLResultSetMetaData(ResultSet rs)

Uses of ResultSet in com.basiscomponents.db.tree

Methods in com.basiscomponents.db.tree that return ResultSet

Modifier and Type	Method	Description
ResultSet	Node.getResultSet()

Methods in com.basiscomponents.db.tree with parameters of type ResultSet

Modifier and Type	Method	Description
void	Node.setResultSet(ResultSet rs)

Uses of ResultSet in com.basiscomponents.db.util

Methods in com.basiscomponents.db.util that return ResultSet

Modifier and Type	Method	Description
static ResultSet	ResultSetJsonMapper.fromJson(String js)	Returns a ResultSet object created by processing the given JSON String.

Methods in com.basiscomponents.db.util with parameters of type ResultSet

Modifier and Type	Method	Description
static String	BBTemplateProvider.createBBTemplate(ResultSet resultSet, boolean extendedInfo)
static String	BBTemplateProvider.createBBTemplateColumn(ResultSet rs, int col, int cols, boolean extendedInfo)	Creates and returns BB template definition for indexed column used by getBBTemplateColumn(java.lang.String, int, java.lang.Boolean)
static Double	DataFieldConverter.fieldToNumber(ResultSet resultSet, DataField field, int column, int type)
static List<String>	ValuesUtil.fieldValuesAsList(ResultSet rs, String columnName)
static List<String>	ValuesUtil.fieldValuesAsList(ResultSet rs, String columnName, boolean addEmptyRow, boolean unique)
static com.basis.startup.type.BBjVector	ValuesUtil.fieldValuesAsVector(ResultSet rs, String columnName)
static com.basis.startup.type.BBjVector	ValuesUtil.fieldValuesAsVector(ResultSet rs, String columnName, boolean addEmptyRow, boolean unique)
static String	ResultSetJsonMapper.toJson(ResultSet rs, boolean meta, String addIndexColumn, boolean f_trimStrings, boolean writeDataRowAttributes)
static String	ResultSetJsonMapper.toJson(ResultSet rs, boolean meta, String addIndexColumn, boolean f_trimStrings, boolean writeDataRowAttributes, ConversionRuleSet crs)

Constructors in com.basiscomponents.db.util with parameters of type ResultSet

Constructor	Description
JRDataSourceAdapter(ResultSet rs)	public constructor

Uses of ResultSet in com.basiscomponents.rest

Methods in com.basiscomponents.rest that return ResultSet

Modifier and Type	Method	Description
ResultSet	RestClient.get(String path, String request_parms)

Uses of ResultSet in com.basiscomponents.util

Methods in com.basiscomponents.util that return ResultSet

Modifier and Type	Method	Description
ResultSet	JLibDataFileHandler.retrieve()	Returns a ResultSet object with the content of the Data file based on the specified filter, offset, field selection.