org.mmbase.util

Class SqlExecutor

java.lang.Object

org.mmbase.util.SqlExecutor

All Implemented Interfaces:

Runnable

Direct Known Subclasses:

SqlExecutorListener

public class SqlExecutor
extends Object
implements Runnable

Generic tool to execute some SQL

Since:

MMBase-1.9.5

Version:

$Id: FullBackupDataWriter.java 34900 2009-05-01 16:29:42Z michiel $

Author:

Michiel Meeuwissen

Field Summary

Fields

Modifier and Type	Field and Description
protected DataSource	dataSource
protected String	prefix

Constructor Summary

Constructors

Constructor and Description
SqlExecutor()

Method Summary

Modifier and Type	Method and Description
protected boolean	executeOnlyIf(Connection con, String q)
protected void	executeQuery(Statement stmt, String q)
protected void	executeUpdate(Statement stmt, String u)
DataSource	getDataSource()
String	getPrefix()
void	run()
void	setDataSource(DataSource dataSource)
void	setIgnoreException(String e)
void	setOnlyIf(String q) A query returning either true of false.
void	setPrefix(String pref)
void	setQuery(String q)
void	setUpdate(String u)
String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

dataSource

protected DataSource dataSource

prefix

protected String prefix

Constructor Detail

SqlExecutor

public SqlExecutor()

Method Detail

setDataSource

public void setDataSource(DataSource dataSource)

setPrefix

public void setPrefix(String pref)

getDataSource

public DataSource getDataSource()

getPrefix

public String getPrefix()

setIgnoreException

public void setIgnoreException(String e)

setQuery

public void setQuery(String q)

setUpdate

public void setUpdate(String u)

setOnlyIf

public void setOnlyIf(String q)

A query returning either true of false. E.g.

executeQuery

protected void executeQuery(Statement stmt,
                            String q)
                     throws SQLException

Throws:

SQLException

executeUpdate

protected void executeUpdate(Statement stmt,
                             String u)
                      throws SQLException

Throws:

SQLException

executeOnlyIf

protected boolean executeOnlyIf(Connection con,
                                String q)
                         throws SQLException

Throws:

SQLException

run

public void run()

Specified by:

run in interface Runnable

toString

public String toString()

Overrides:

toString in class Object