Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

com.rohanclan.ashpool.core
Class SelectFilter  view SelectFilter download SelectFilter.java

java.lang.Object
  extended bycom.rohanclan.ashpool.core.SelectFilter

public class SelectFilter
extends java.lang.Object

Tries to take an SQL statement, turn it into a style sheet and apply it to an xml file to get a ResultSet. Attempts to emulate an sql select statment


Field Summary
private static java.lang.String AL_XSLT
           
private static java.lang.String AS_XSLT
           
private static java.lang.String AW_XSLT
           
private  BasicXSLEngine bXSL
           
private static java.lang.String D_sort
           
private static java.lang.String E_sort
           
private  java.lang.String mainfile
           
private static java.lang.String O_sort
           
private  org.xml.sax.XMLReader reader
           
private static java.lang.String S_sort
          the basics of the a sort
private static java.lang.String S_XSLT
          the basics of the xslt stylesheet
private static java.lang.String SF_XSLT
           
private  TableManager tableman
           
private  XMLtoResultSetFilter xmlfilter
           
 
Constructor Summary
SelectFilter(TableManager tman)
          Creates a new instance of SelectFilter
 
Method Summary
private  java.lang.String createXPath(java.lang.String sql)
          try to convert an sql select statement into an xslt stylesheet
private  java.lang.String escapeOperator(java.lang.String inop)
          convert normal sql operators to xml operators
 byte[] executeQuery(java.lang.String sql)
          returns the XML document results in a bytearray from the generated xslt from the sql statement
 void executeQuery(java.lang.String sql, AResultSet ars)
          fills a result set with with the results of an sql->xslt query
 void getTableColumns(java.lang.String tablename, AResultSet ars)
          get the names, and types of a tables columns
 void setTableManager(TableManager tman)
          sets the table manager
 void setXSLEngine(BasicXSLEngine bxsl)
          sets the xslt engine
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

mainfile

private java.lang.String mainfile

tableman

private TableManager tableman

bXSL

private BasicXSLEngine bXSL

reader

private org.xml.sax.XMLReader reader

xmlfilter

private XMLtoResultSetFilter xmlfilter

S_XSLT

private static final java.lang.String S_XSLT
the basics of the xslt stylesheet

See Also:
Constant Field Values

SF_XSLT

private static final java.lang.String SF_XSLT
See Also:
Constant Field Values

AS_XSLT

private static final java.lang.String AS_XSLT
See Also:
Constant Field Values

AW_XSLT

private static final java.lang.String AW_XSLT
See Also:
Constant Field Values

AL_XSLT

private static final java.lang.String AL_XSLT
See Also:
Constant Field Values

S_sort

private static final java.lang.String S_sort
the basics of the a sort

See Also:
Constant Field Values

O_sort

private static final java.lang.String O_sort
See Also:
Constant Field Values

D_sort

private static final java.lang.String D_sort
See Also:
Constant Field Values

E_sort

private static final java.lang.String E_sort
See Also:
Constant Field Values
Constructor Detail

SelectFilter

public SelectFilter(TableManager tman)
             throws java.lang.Exception
Creates a new instance of SelectFilter

Method Detail

setTableManager

public void setTableManager(TableManager tman)
sets the table manager


setXSLEngine

public void setXSLEngine(BasicXSLEngine bxsl)
sets the xslt engine


getTableColumns

public void getTableColumns(java.lang.String tablename,
                            AResultSet ars)
                     throws java.lang.Exception
get the names, and types of a tables columns


executeQuery

public byte[] executeQuery(java.lang.String sql)
                    throws java.lang.Exception
returns the XML document results in a bytearray from the generated xslt from the sql statement


executeQuery

public void executeQuery(java.lang.String sql,
                         AResultSet ars)
                  throws java.lang.Exception
fills a result set with with the results of an sql->xslt query


createXPath

private java.lang.String createXPath(java.lang.String sql)
try to convert an sql select statement into an xslt stylesheet


escapeOperator

private java.lang.String escapeOperator(java.lang.String inop)
convert normal sql operators to xml operators