erkka
Class ODBCQuery

java.lang.Object
  |
  +--erkka.ODBCQuery

public class ODBCQuery
extends java.lang.Object

Title: Connects to mdb (Access)/odb (OO 2.0 HSQLDB) database or using ODBC/JDBC and executes SQL query batch

Copyright: Copyright (c) 2005

Company: jyu

Version:
1.2 Unzips .odb-files, connects to db, and zips back again when disconnected

Constructor Summary
ODBCQuery(java.lang.String localdatabase, java.lang.String suffix)
           
ODBCQuery(java.lang.String ajuri, java.lang.String URL, java.lang.String nick, java.lang.String passwd)
          java -Djdbc.drivers=yourJdbcDriver -classpath driverPath -jar erkka.jar
 
Method Summary
 void connect()
           
 void disconnect()
           
 java.lang.String executeQueryBatch(java.lang.String sqlquery)
           
 java.lang.String executeQueryBatch(java.lang.String sqlquery, char separator)
           
 int getDisplaySize()
           
 boolean isConnected()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

ODBCQuery

public ODBCQuery(java.lang.String localdatabase,
                 java.lang.String suffix)

ODBCQuery

public ODBCQuery(java.lang.String ajuri,
                 java.lang.String URL,
                 java.lang.String nick,
                 java.lang.String passwd)

java -Djdbc.drivers=yourJdbcDriver -classpath driverPath -jar erkka.jar

Method Detail

connect

public void connect()
             throws java.lang.Exception
java.lang.Exception

isConnected

public boolean isConnected()

disconnect

public void disconnect()
                throws java.lang.Exception
java.lang.Exception

executeQueryBatch

public java.lang.String executeQueryBatch(java.lang.String sqlquery)
                                   throws java.lang.Exception
java.lang.Exception

executeQueryBatch

public java.lang.String executeQueryBatch(java.lang.String sqlquery,
                                          char separator)
                                   throws java.lang.Exception
java.lang.Exception

getDisplaySize

public int getDisplaySize()