org.mmbase.util.transformers

Class Sql

java.lang.Object

org.mmbase.util.transformers.ReaderTransformer

org.mmbase.util.transformers.ConfigurableReaderTransformer

org.mmbase.util.transformers.Sql

All Implemented Interfaces:

Serializable, CharTransformer, ConfigurableTransformer, Transformer

public class Sql
extends ConfigurableReaderTransformer
implements CharTransformer

Encodings related to Sql. It can escape quotes, by replacing them by double quotes, as is needed in SQL statements.

Author:

Michiel Meeuwissen, Jaco de Groot

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
static int	ESCAPE_QUOTES

Fields inherited from class org.mmbase.util.transformers.ConfigurableReaderTransformer

to

Constructor Summary

Constructors

Constructor and Description
Sql()
Sql(int conf)

Method Summary

Modifier and Type	Method and Description
String	getEncoding() Returns the encoding that is currently active
static Writer	singleQuote(Reader r, Writer w) Escapes single quotes in a string.
static Writer	singleQuoteBack(Reader r, Writer w) Unescapes single quotes in a string.
Writer	transform(Reader r, Writer w)
Writer	transformBack(Reader r, Writer w)
Map<String,Config>	transformers() Used when registering this class as a possible Transformer

Methods inherited from class org.mmbase.util.transformers.ConfigurableReaderTransformer

configure, toString

Methods inherited from class org.mmbase.util.transformers.ReaderTransformer

transform, transform, transformBack, transformBack

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.mmbase.util.transformers.CharTransformer

transform, transform, transformBack, transformBack

Methods inherited from interface org.mmbase.util.transformers.Transformer

toString

Field Detail

ESCAPE_QUOTES

public static final int ESCAPE_QUOTES

See Also:

Constant Field Values

Constructor Detail

Sql

public Sql()

Sql

public Sql(int conf)

Method Detail

singleQuote

public static Writer singleQuote(Reader r,
                                 Writer w)

Escapes single quotes in a string. Escaping is done by doubling any quotes encountered. Strings that are rendered in such way can more easily be included in a SQL query.

Parameters:

r - the string to escape

w - The escaped string goes to this writer

Returns:

the writer

Since:

MMBase-1.7

singleQuoteBack

public static Writer singleQuoteBack(Reader r,
                                     Writer w)

Unescapes single quotes in a string. Unescaping is done by replacing two quotes with one quote.

Parameters:

r - the string to unescape

w - the result is written to this writer.

Returns:

the writer

Since:

MMBase-1.7.2

transformers

public Map<String,Config> transformers()

Used when registering this class as a possible Transformer

Specified by:

transformers in interface ConfigurableTransformer

Specified by:

transformers in class ConfigurableReaderTransformer

Returns:

A Map with String Integer/Class pairs.

transform

public Writer transform(Reader r,
                        Writer w)

Specified by:

transform in interface CharTransformer

Specified by:

transform in class ReaderTransformer

transformBack

public Writer transformBack(Reader r,
                            Writer w)

Specified by:

transformBack in interface CharTransformer

Overrides:

transformBack in class ReaderTransformer

getEncoding

public String getEncoding()

Description copied from interface: ConfigurableTransformer

Returns the encoding that is currently active

Specified by:

getEncoding in interface ConfigurableTransformer

Specified by:

getEncoding in class ConfigurableReaderTransformer

Returns:

An String representing the coding that is currently used.