Database IOIfc
Properties
Functions
Writes all tables as separate comma separated value files into the supplied directory. The files are written to text files using the same name as the tables in the database
Writes all table data as insert queries to the PrintWriter
Writes all tables as separate comma separated value files into the supplied directory. The files are written to text files using the same name as the tables in the database
Writes the insert queries associated with the supplied table to the PrintWriter
Writes the table as comma separated values
Writes each table in the schema to an Excel workbook with each table being placed in a new sheet with the sheet name equal to the name of the table. The column names for each table are written as the first row of each sheet.
Writes each table in the list to an Excel workbook with each table being placed in a new sheet with the sheet name equal to the name of the table. The column names for each table are written as the first row of each sheet.
Copies the rows from the sheet to the table. The copy is assumed to start at row 1, column 1 (i.e. cell A1) and proceed to the right for the number of columns in the table and the number of rows of the sheet. The copy is from the perspective of the table. That is, all columns of a row of the table are attempted to be filled from a corresponding row of the sheet. If the row of the sheet does not have cell values for the corresponding column, then the cell is interpreted as a null value when being placed in the corresponding column. It is up to the client to ensure that the cells in a row of the sheet are data type compatible with the corresponding column in the table. Any rows that cannot be transfer in their entirety are logged to the supplied PrintWriter
Opens the workbook for reading only and writes the sheets of the workbook into database tables. The list of names is the names of the sheets in the workbook and the names of the tables that need to be written. They are in the order that is required for entering data so that no integrity constraints are violated. The underlying workbook is closed after the operation.
Prints all table data as insert queries to the console
Prints all tables as text to the console
Prints all tables as text to the console
Prints the insert queries associated with the supplied table to the console
Prints the table as comma separated values to the console
Prints the table as prettified text to the console
Prints the table as prettified text to the console
Writes all tables as text
Writes all tables as text
Writes all tables as text
Writes the table as prettified text.
Writes the table as prettified text.