gpl.fredy.sqltools
Class XLSExport

java.lang.Object
  gpl.fredy.sqltools.XLSExport

public class XLSExport
extends java.lang.Object

Constructor Summary

XLSExport()

XLSExport(java.sql.Connection con)

Method Summary

int	createXLS(java.lang.String fileName) Create the XLS-File named fileName
java.sql.Connection	getCon() Get the value of con.
java.sql.SQLException	getException() Get the value of exception.
java.lang.String	getQuery() Get the value of query.
static void	main(java.lang.String[] args)
void	setCon(java.sql.Connection v) Set the value of con.
void	setException(java.sql.SQLException v) Set the value of exception.
void	setQuery(java.lang.String v) Set the value of query.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

XLSExport

public XLSExport(java.sql.Connection con)

XLSExport

public XLSExport()

Method Detail

getCon

public java.sql.Connection getCon()

Get the value of con.

Returns:

value of con.

setCon

public void setCon(java.sql.Connection v)

Set the value of con.

Parameters:

v - Value to assign to con.

getQuery

public java.lang.String getQuery()

Get the value of query.

Returns:

value of query.

setQuery

public void setQuery(java.lang.String v)

Set the value of query.

Parameters:

v - Value to assign to query.

getException

public java.sql.SQLException getException()

Get the value of exception.

Returns:

value of exception.

setException

public void setException(java.sql.SQLException v)

Set the value of exception.

Parameters:

v - Value to assign to exception.

createXLS

public int createXLS(java.lang.String fileName)

Create the XLS-File named fileName

Parameters:

fileName - is the Name (incl. Path) of the XLS-file to create

main

public static void main(java.lang.String[] args)