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:

CharTransformer, ConfigurableTransformer, Serializable, 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

static int

ESCAPE_QUOTES

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

to

Constructor Summary

Sql()

Sql(int conf)

Method Summary

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	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 transformers()

Used when registering this class as a possible Transformer

Specified by:

transformers in interface ConfigurableTransformer

Specified by:

transformers in class ConfigurableReaderTransformer

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