Java Doc for RowDataConverter.java in  » Database-Client » SQL-Workbench » workbench » db » exporter » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database Client » SQL Workbench » workbench.db.exporter   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    workbench.db.exporter.RowDataConverter All known Subclasses:   workbench.db.exporter.SqlRowDataConverter,  workbench.db.exporter.TextRowDataConverter,  workbench.db.exporter.XlsXMLRowDataConverter,  workbench.db.exporter.XlsRowDataConverter,  workbench.db.exporter.XmlRowDataConverter,  workbench.db.exporter.OdsRowDataConverter,  workbench.db.exporter.HtmlRowDataConverter, RowDataConverter abstract public class RowDataConverter implements DataFileWriter(Code) Interface for classes that can take objects of type RowData and convert them to e.g. text, XML, HTML author:    support@sql-workbench.net Field Summary final public static  String BLOB_ARCHIVE_SUFFIX      protected  List<String> blobIdColumns      protected  int[] blobNameCols      protected  boolean convertDateToTimestamp      protected  long currentRow      protected  RowData currentRowData      protected  SimpleDateFormat defaultDateFormatter      protected  DecimalFormat defaultNumberFormatter      protected  SimpleDateFormat defaultTimestampFormatter      protected  String encoding      protected  ErrorReporter errorReporter      protected  List exportColumns      protected  OutputFactory factory      protected  String filenameColumn      protected  int filenameColumnIndex      protected  String generatingSql      protected  ResultInfo metaData      protected  boolean needsUpdateTable      protected  WbConnection originalConnection      protected  boolean useRowNumForBlobFile      protected  boolean writeHeader      Constructor Summary public   RowDataConverter()      Method Summary abstract public  StrBuffer convertRowData(RowData row, long rowIndex)      public  File createBlobFile(RowData row, int colIndex, long rowNum)      protected  String createFilename(RowData row, int colIndex, long rowNum)      protected  OutputStream createOutputStream(File output)      public  void exportFinished()      public  File generateDataFileName(ColumnData data)      public  File getBaseDir()      public  String getEncoding()      abstract public  StrBuffer getEnd(long totalRows)      Returns the String sequence needed in before the actual data part. protected  String getFileExtension()      protected  File getOutputFile()      public  String getPageTitle()      public  String getPageTitle(String defaultTitle)      public  ResultInfo getResultInfo()      abstract public  StrBuffer getStart()      Returns the String sequence needed in before the actual data part. public  String getValueAsFormattedString(RowData row, int col)      Return the column's value as a formatted String. public  boolean includeColumnInExport(int col)      public  boolean needsUpdateTable()       void setBlobIdColumns(List<String> cols)      public  void setColumnsToExport(List<ColumnIdentifier> columns)      public  void setCompressExternalFiles(boolean flag)      public  void setDefaultDateFormat(String format)      public  void setDefaultDateFormatter(SimpleDateFormat formatter)      public  void setDefaultNumberFormat(String aFormat)      public  void setDefaultNumberFormatter(DecimalFormat formatter)      public  void setDefaultTimestampFormat(String format)      public  void setDefaultTimestampFormatter(SimpleDateFormat formatter)      public  void setEncoding(String enc)      Set the encoding for the output string. public  void setErrorReporter(ErrorReporter reporter)      public  void setFilenameColumn(String colname)      public  void setGeneratingSql(String sql)      The SQL statement that was used to generate the data. public  void setOriginalConnection(WbConnection conn)      The connection that was used to generate the source data. public  void setOutputFile(File f)      public  void setPageTitle(String title)      public  void setResultInfo(ResultInfo meta)      Define the structure of the result to be exported. public  void setWriteHeader(boolean writeHeader)      public  void writeBlobFile(Object value, File f)      public  void writeClobFile(String value, File f, String encoding)      protected  void writeEscapedXML(StrBuffer out, String s, boolean keepCR)      Field Detail BLOB_ARCHIVE_SUFFIX final public static String BLOB_ARCHIVE_SUFFIX(Code) blobIdColumns protected List<String> blobIdColumns(Code) blobNameCols protected int[] blobNameCols(Code) convertDateToTimestamp protected boolean convertDateToTimestamp(Code) currentRow protected long currentRow(Code) currentRowData protected RowData currentRowData(Code) defaultDateFormatter protected SimpleDateFormat defaultDateFormatter(Code) defaultNumberFormatter protected DecimalFormat defaultNumberFormatter(Code) defaultTimestampFormatter protected SimpleDateFormat defaultTimestampFormatter(Code) encoding protected String encoding(Code) errorReporter protected ErrorReporter errorReporter(Code) exportColumns protected List exportColumns(Code) factory protected OutputFactory factory(Code) filenameColumn protected String filenameColumn(Code) filenameColumnIndex protected int filenameColumnIndex(Code) generatingSql protected String generatingSql(Code) metaData protected ResultInfo metaData(Code) needsUpdateTable protected boolean needsUpdateTable(Code) originalConnection protected WbConnection originalConnection(Code) useRowNumForBlobFile protected boolean useRowNumForBlobFile(Code) writeHeader protected boolean writeHeader(Code) Constructor Detail RowDataConverter public RowDataConverter()(Code) The metadata for the result set that should be exported Method Detail convertRowData abstract public StrBuffer convertRowData(RowData row, long rowIndex)(Code) Returns the data for one specific row as a String in the correct format createBlobFile public File createBlobFile(RowData row, int colIndex, long rowNum)(Code) createFilename protected String createFilename(RowData row, int colIndex, long rowNum)(Code) createOutputStream protected OutputStream createOutputStream(File output) throws IOException(Code) exportFinished public void exportFinished() throws IOException(Code) generateDataFileName public File generateDataFileName(ColumnData data)(Code) Needed for the SqlLiteralFormatter getBaseDir public File getBaseDir()(Code) getEncoding public String getEncoding()(Code) getEnd abstract public StrBuffer getEnd(long totalRows)(Code) Returns the String sequence needed in before the actual data part. (might be an empty string) getFileExtension protected String getFileExtension()(Code) getOutputFile protected File getOutputFile()(Code) getPageTitle public String getPageTitle()(Code) getPageTitle public String getPageTitle(String defaultTitle)(Code) getResultInfo public ResultInfo getResultInfo()(Code) getStart abstract public StrBuffer getStart()(Code) Returns the String sequence needed in before the actual data part. (might be an empty string) getValueAsFormattedString public String getValueAsFormattedString(RowData row, int col) throws IndexOutOfBoundsException(Code) Return the column's value as a formatted String. Especially for Date objects this is different then getValueAsString() as a default formatter can be defined. Parameters:   row - The requested row Parameters:   col - The column in aRow for which the value should be formatted The formatted value as a String See Also:   RowDataConverter.setDefaultDateFormatter(SimpleDateFormat) See Also:   RowDataConverter.setDefaultTimestampFormatter(SimpleDateFormat) See Also:   RowDataConverter.setDefaultNumberFormatter(DecimalFormat) See Also:   RowDataConverter.setDefaultDateFormat(String) See Also:   RowDataConverter.setDefaultTimestampFormat(String) See Also:   RowDataConverter.setDefaultNumberFormat(String) includeColumnInExport public boolean includeColumnInExport(int col)(Code) needsUpdateTable public boolean needsUpdateTable()(Code) setBlobIdColumns void setBlobIdColumns(List<String> cols)(Code) setColumnsToExport public void setColumnsToExport(List<ColumnIdentifier> columns)(Code) Set a list of columns that should be exported Parameters:   columns - the list (of ColumnIdentifier objects) of columns to be exported.null means export all columns setCompressExternalFiles public void setCompressExternalFiles(boolean flag)(Code) setDefaultDateFormat public void setDefaultDateFormat(String format)(Code) setDefaultDateFormatter public void setDefaultDateFormatter(SimpleDateFormat formatter)(Code) setDefaultNumberFormat public void setDefaultNumberFormat(String aFormat)(Code) setDefaultNumberFormatter public void setDefaultNumberFormatter(DecimalFormat formatter)(Code) setDefaultTimestampFormat public void setDefaultTimestampFormat(String format)(Code) setDefaultTimestampFormatter public void setDefaultTimestampFormatter(SimpleDateFormat formatter)(Code) setEncoding public void setEncoding(String enc)(Code) Set the encoding for the output string. This might not be used by all implemented Converters setErrorReporter public void setErrorReporter(ErrorReporter reporter)(Code) setFilenameColumn public void setFilenameColumn(String colname)(Code) setGeneratingSql public void setGeneratingSql(String sql)(Code) The SQL statement that was used to generate the data. setOriginalConnection public void setOriginalConnection(WbConnection conn)(Code) The connection that was used to generate the source data. setOutputFile public void setOutputFile(File f)(Code) setPageTitle public void setPageTitle(String title)(Code) setResultInfo public void setResultInfo(ResultInfo meta)(Code) Define the structure of the result to be exported. setWriteHeader public void setWriteHeader(boolean writeHeader)(Code) writeBlobFile public void writeBlobFile(Object value, File f) throws IOException(Code) writeClobFile public void writeClobFile(String value, File f, String encoding) throws IOException(Code) writeEscapedXML protected void writeEscapedXML(StrBuffer out, String s, boolean keepCR)(Code) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)