org.apache.flink.connector.jdbc.statement

Class FieldNamedPreparedStatementImpl

java.lang.Object

org.apache.flink.connector.jdbc.statement.FieldNamedPreparedStatementImpl

All Implemented Interfaces:

AutoCloseable, FieldNamedPreparedStatement

public class FieldNamedPreparedStatementImpl
extends Object
implements FieldNamedPreparedStatement

Simple implementation of FieldNamedPreparedStatement.

Method Summary

Modifier and Type	Method and Description
void	addBatch() Adds a set of parameters to this NamedPreparedStatement object's batch of commands.
void	clearParameters() Clears the current parameter values immediately.
void	close() Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
int[]	executeBatch() Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
ResultSet	executeQuery() Executes the SQL query in this NamedPreparedStatement object and returns the ResultSet object generated by the query.
static String	parseNamedStatement(String sql, Map<String,List<Integer>> paramMap) Parses a sql with named parameters.
static FieldNamedPreparedStatement	prepareStatement(Connection connection, String sql, String[] fieldNames) Creates a NamedPreparedStatement object for sending parameterized SQL statements to the database.
void	setBigDecimal(int fieldIndex, BigDecimal x) Sets the designated parameter to the given java.math.BigDecimal value.
void	setBoolean(int fieldIndex, boolean x) Sets the designated parameter to the given Java boolean value.
void	setByte(int fieldIndex, byte x) Sets the designated parameter to the given Java byte value.
void	setBytes(int fieldIndex, byte[] x) Sets the designated parameter to the given Java array of bytes.
void	setDate(int fieldIndex, Date x) Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
void	setDouble(int fieldIndex, double x) Sets the designated parameter to the given Java double value.
void	setFloat(int fieldIndex, float x) Sets the designated parameter to the given Java float value.
void	setInt(int fieldIndex, int x) Sets the designated parameter to the given Java int value.
void	setLong(int fieldIndex, long x) Sets the designated parameter to the given Java long value.
void	setNull(int fieldIndex, int sqlType) Sets the designated parameter to SQL NULL.
void	setObject(int fieldIndex, Object x) Sets the value of the designated parameter using the given object.
void	setShort(int fieldIndex, short x) Sets the designated parameter to the given Java short value.
void	setString(int fieldIndex, String x) Sets the designated parameter to the given Java String value.
void	setTime(int fieldIndex, Time x) Sets the designated parameter to the given java.sql.Time value.
void	setTimestamp(int fieldIndex, Timestamp x) Sets the designated parameter to the given java.sql.Timestamp value.

Methods inherited from class java.lang.Object

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

Method Detail

clearParameters

public void clearParameters()
                     throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Clears the current parameter values immediately.

In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method clearParameters.

Specified by:

clearParameters in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.clearParameters()

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Executes the SQL query in this NamedPreparedStatement object and returns the ResultSet object generated by the query.

Specified by:

executeQuery in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.executeQuery()

addBatch

public void addBatch()
              throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Adds a set of parameters to this NamedPreparedStatement object's batch of commands.

Specified by:

addBatch in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.addBatch()

executeBatch

public int[] executeBatch()
                   throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The int elements of the array that is returned are ordered to correspond to the commands in the batch, which are ordered according to the order in which they were added to the batch.

Specified by:

executeBatch in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

Statement.executeBatch()

setNull

public void setNull(int fieldIndex,
                    int sqlType)
             throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to SQL NULL.

Note: You must specify the parameter's SQL type.

Specified by:

setNull in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setNull(int, int)

setBoolean

public void setBoolean(int fieldIndex,
                       boolean x)
                throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java boolean value. The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.

Specified by:

setBoolean in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setBoolean(int, boolean)

setByte

public void setByte(int fieldIndex,
                    byte x)
             throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.

Specified by:

setByte in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setByte(int, byte)

setShort

public void setShort(int fieldIndex,
                     short x)
              throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.

Specified by:

setShort in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setShort(int, short)

setInt

public void setInt(int fieldIndex,
                   int x)
            throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java int value. The driver converts this to an SQL INTEGER value when it sends it to the database.

Specified by:

setInt in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setInt(int, int)

setLong

public void setLong(int fieldIndex,
                    long x)
             throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java long value. The driver converts this to an SQL BIGINT value when it sends it to the database.

Specified by:

setLong in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setLong(int, long)

setFloat

public void setFloat(int fieldIndex,
                     float x)
              throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java float value. The driver converts this to an SQL REAL value when it sends it to the database.

Specified by:

setFloat in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setFloat(int, float)

setDouble

public void setDouble(int fieldIndex,
                      double x)
               throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.

Specified by:

setDouble in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setDouble(int, double)

setBigDecimal

public void setBigDecimal(int fieldIndex,
                          BigDecimal x)
                   throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given java.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.

Specified by:

setBigDecimal in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setBigDecimal(int, BigDecimal)

setString

public void setString(int fieldIndex,
                      String x)
               throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java String value. The driver converts this to an SQL VARCHAR or LONGVARCHAR value (depending on the argument's size relative to the driver's limits on VARCHAR values) when it sends it to the database.

Specified by:

setString in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setString(int, String)

setBytes

public void setBytes(int fieldIndex,
                     byte[] x)
              throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL VARBINARY or LONGVARBINARY (depending on the argument's size relative to the driver's limits on VARBINARY values) when it sends it to the database.

Specified by:

setBytes in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setBytes(int, byte[])

setDate

public void setDate(int fieldIndex,
                    Date x)
             throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application. The driver converts this to an SQL DATE value when it sends it to the database.

Specified by:

setDate in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setDate(int, Date)

setTime

public void setTime(int fieldIndex,
                    Time x)
             throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given java.sql.Time value. The driver converts this to an SQL TIME value when it sends it to the database.

Specified by:

setTime in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setTime(int, Time)

setTimestamp

public void setTimestamp(int fieldIndex,
                         Timestamp x)
                  throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.

Specified by:

setTimestamp in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setTimestamp(int, Timestamp)

setObject

public void setObject(int fieldIndex,
                      Object x)
               throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Sets the value of the designated parameter using the given object.

Specified by:

setObject in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

PreparedStatement.setObject(int, Object)

close

public void close()
           throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources.

Specified by:

close in interface AutoCloseable

Specified by:

close in interface FieldNamedPreparedStatement

Throws:

SQLException

See Also:

Statement.close()

prepareStatement

public static FieldNamedPreparedStatement prepareStatement(Connection connection,
                                                           String sql,
                                                           String[] fieldNames)
                                                    throws SQLException

Description copied from interface: FieldNamedPreparedStatement

Creates a NamedPreparedStatement object for sending parameterized SQL statements to the database.

Specified by:

prepareStatement in interface FieldNamedPreparedStatement

Parameters:

connection - the connection used to connect to database.

sql - an SQL statement that may contain one or more ':fieldName' as parameter placeholders

fieldNames - the field names in schema order used as the parameter names

Throws:

SQLException

parseNamedStatement

public static String parseNamedStatement(String sql,
                                         Map<String,List<Integer>> paramMap)

Parses a sql with named parameters. The parameter-index mappings are put into the map, and the parsed sql is returned.

Parameters:

sql - sql to parse

paramMap - map to hold parameter-index mappings

Returns:

the parsed sql