org.mycore.backend.sql
Class MCRSQLStatement

java.lang.Object
  org.mycore.backend.sql.MCRSQLStatement

public class MCRSQLStatement
extends Object

Version:

$Revision: 13085 $ $Date: 2008-02-06 18:27:24 +0100 (Mi, 06 Feb 2008) $

Author:

Frank Lützenkirchen, Thomas Scheffler (yagee)

Field Summary

protected Vector	columns
protected Properties	conditions
protected static String	NULL
protected List	sqlColumns
protected String	tableName
protected Properties	values

Constructor Summary

MCRSQLStatement(String tableName)

Method Summary

MCRSQLStatement	addColumn(String columnDefinition)
protected String	condition()
protected String	getSQLValue(String key)
MCRSQLStatement	setCondition(String columnName, String columnValue)
MCRSQLStatement	setValue(MCRSQLColumn column)
MCRSQLStatement	setValue(String columnName, String columnValue)
String	toCountStatement(String column)
String	toCreateTableStatement()
String	toDeleteStatement()
String	toIndexStatement()
String	toInsertStatement()
String	toRowSelector()
String	toSelectStatement()
String	toSelectStatement(String columns)
String	toTypedInsertStatement()
String	toUpdateStatement()

Methods inherited from class java.lang.Object

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

Field Detail

NULL

protected static final String NULL

See Also:

Constant Field Values

values

protected Properties values

conditions

protected Properties conditions

columns

protected Vector columns

sqlColumns

protected List sqlColumns

tableName

protected String tableName

Constructor Detail

MCRSQLStatement

public MCRSQLStatement(String tableName)

Method Detail

setValue

public final MCRSQLStatement setValue(String columnName,
                                      String columnValue)

setValue

public final MCRSQLStatement setValue(MCRSQLColumn column)

setCondition

public final MCRSQLStatement setCondition(String columnName,
                                          String columnValue)

addColumn

public final MCRSQLStatement addColumn(String columnDefinition)

getSQLValue

protected final String getSQLValue(String key)

condition

protected final String condition()

toInsertStatement

public final String toInsertStatement()

toTypedInsertStatement

public final String toTypedInsertStatement()

toUpdateStatement

public final String toUpdateStatement()

toCreateTableStatement

public final String toCreateTableStatement()

toIndexStatement

public final String toIndexStatement()

toRowSelector

public final String toRowSelector()

toSelectStatement

public final String toSelectStatement()

toSelectStatement

public final String toSelectStatement(String columns)

toDeleteStatement

public final String toDeleteStatement()

toCountStatement

public final String toCountStatement(String column)