com.mysql.cj.jdbc

Class EscapeProcessor

java.lang.Object

com.mysql.cj.jdbc.EscapeProcessor

class EscapeProcessor
extends java.lang.Object

EscapeProcessor performs all escape code processing as outlined in the JDBC spec by JavaSoft.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.util.Map<java.lang.String,java.lang.String>	JDBC_CONVERT_TO_MYSQL_TYPE_MAP

Constructor Summary

Constructors

Constructor and Description
EscapeProcessor()

Method Summary

Modifier and Type	Method and Description
static java.lang.Object	escapeSQL(java.lang.String sql, java.util.TimeZone connectionTimeZone, boolean serverSupportsFractionalSecond, boolean serverTruncatesFractionalSecond, ExceptionInterceptor exceptionInterceptor) Escape process one string
private static java.lang.String	processConvertToken(java.lang.String functionToken, ExceptionInterceptor exceptionInterceptor) Re-writes {fn convert (expr, type)} as cast(expr AS type)
private static void	processTimestampToken(java.util.TimeZone tz, java.lang.StringBuilder newSql, java.lang.String token, boolean serverSupportsFractionalSecond, boolean serverTruncatesFractionalSecond, ExceptionInterceptor exceptionInterceptor)
private static void	processTimeToken(java.lang.StringBuilder newSql, java.lang.String token, boolean serverSupportsFractionalSecond, ExceptionInterceptor exceptionInterceptor)
private static java.lang.String	removeWhitespace(java.lang.String toCollapse) Removes all whitespace from the given String.

Methods inherited from class java.lang.Object

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

Field Detail

JDBC_CONVERT_TO_MYSQL_TYPE_MAP

private static java.util.Map<java.lang.String,java.lang.String> JDBC_CONVERT_TO_MYSQL_TYPE_MAP

Constructor Detail

EscapeProcessor

EscapeProcessor()

Method Detail

escapeSQL

public static final java.lang.Object escapeSQL(java.lang.String sql,
                                               java.util.TimeZone connectionTimeZone,
                                               boolean serverSupportsFractionalSecond,
                                               boolean serverTruncatesFractionalSecond,
                                               ExceptionInterceptor exceptionInterceptor)
                                        throws java.sql.SQLException

Escape process one string

Parameters:

sql - the SQL to escape process.

connectionTimeZone - server time zone

serverSupportsFractionalSecond - flag indicating if server supports fractional seconds

serverTruncatesFractionalSecond - flag indicating if server truncates fractional seconds (sql_mode contains TIME_TRUNCATE_FRACTIONAL)

exceptionInterceptor - exception interceptor

Returns:

the SQL after it has been escape processed.

Throws:

java.sql.SQLException - if error occurs

processTimeToken

private static void processTimeToken(java.lang.StringBuilder newSql,
                                     java.lang.String token,
                                     boolean serverSupportsFractionalSecond,
                                     ExceptionInterceptor exceptionInterceptor)
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

processTimestampToken

private static void processTimestampToken(java.util.TimeZone tz,
                                          java.lang.StringBuilder newSql,
                                          java.lang.String token,
                                          boolean serverSupportsFractionalSecond,
                                          boolean serverTruncatesFractionalSecond,
                                          ExceptionInterceptor exceptionInterceptor)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

processConvertToken

private static java.lang.String processConvertToken(java.lang.String functionToken,
                                                    ExceptionInterceptor exceptionInterceptor)
                                             throws java.sql.SQLException

Re-writes {fn convert (expr, type)} as cast(expr AS type)

Parameters:

functionToken - token

exceptionInterceptor - exception interceptor

Returns:

result of rewriting

Throws:

java.sql.SQLException - if error occurs

removeWhitespace

private static java.lang.String removeWhitespace(java.lang.String toCollapse)

Removes all whitespace from the given String. We use this to make escape token comparison white-space ignorant.

Parameters:

toCollapse - the string to remove the whitespace from

Returns:

a string with _no_ whitespace.