org.equanda.util.script
Class DatabaseExtension

java.lang.Object
  org.equanda.util.script.DatabaseExtension

All Implemented Interfaces:

murlen.util.fscript.FSArrayExtension, murlen.util.fscript.FSExtension, murlen.util.fscript.FSFunctionExtension, murlen.util.fscript.FSVarExtension

public class DatabaseExtension
extends Object
implements murlen.util.fscript.FSExtension

DatabaseExtension, FScript extension for database access using SQL and JDBC This extension introduces the function "DBset(name[,db])" which creates a database object with name "name" which accesses database "db". This object has several functions available to it, and allows you to get the current value of the fields using the notation "name.fieldname". Functions have the notation "name.function()", possibly with parameters. Following functions exist : .query(sqlStatement) .command(sqlStatement) .first() .next() .field()

Author:

Joachim Van der Auwera

Nested Class Summary

static interface	DatabaseExtension.ExceptionListener ExceptionListener allows proper handling of database access errors
static interface	DatabaseExtension.JDBCLogger JDBCLogger allows proper handling of database access logging

Constructor Summary

DatabaseExtension(Connection connection)

DatabaseExtension(Hashtable connections, String def)

Method Summary

Object	callFunction(String name, ArrayList params)
Object	getVar(String name)
Object	getVar(String name, Object index)
void	setExceptionListener(DatabaseExtension.ExceptionListener listener)
void	setJDBCLogger(DatabaseExtension.JDBCLogger log)
void	setVar(String name, Object value)
void	setVar(String name, Object index, Object value)

Methods inherited from class java.lang.Object

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

Constructor Detail

DatabaseExtension

public DatabaseExtension(Connection connection)

DatabaseExtension

public DatabaseExtension(Hashtable connections,
                         String def)

Method Detail

setExceptionListener

public void setExceptionListener(DatabaseExtension.ExceptionListener listener)

setJDBCLogger

public void setJDBCLogger(DatabaseExtension.JDBCLogger log)

callFunction

public Object callFunction(String name,
                           ArrayList params)
                    throws murlen.util.fscript.FSException

Specified by:

callFunction in interface murlen.util.fscript.FSFunctionExtension

Throws:

murlen.util.fscript.FSException

getVar

public Object getVar(String name)
              throws murlen.util.fscript.FSException

Specified by:

getVar in interface murlen.util.fscript.FSVarExtension

Throws:

murlen.util.fscript.FSException

setVar

public void setVar(String name,
                   Object value)
            throws murlen.util.fscript.FSException

Specified by:

setVar in interface murlen.util.fscript.FSVarExtension

Throws:

murlen.util.fscript.FSException

getVar

public Object getVar(String name,
                     Object index)
              throws murlen.util.fscript.FSException

Specified by:

getVar in interface murlen.util.fscript.FSArrayExtension

Throws:

murlen.util.fscript.FSException

setVar

public void setVar(String name,
                   Object index,
                   Object value)
            throws murlen.util.fscript.FSException

Specified by:

setVar in interface murlen.util.fscript.FSArrayExtension

Throws:

murlen.util.fscript.FSException