Class JdbcQueryStatement

java.lang.Object

io.micronaut.data.jdbc.mapper.JdbcQueryStatement

All Implemented Interfaces:

QueryStatement<PreparedStatement, Integer>

public class JdbcQueryStatement
extends Object
implements QueryStatement<PreparedStatement, Integer>

A QueryStatement for a SQL PreparedStatement.

Since:

1.0.0

Author:

graemerocher

Constructor Summary

Constructors

Constructor	Description
JdbcQueryStatement(DataConversionService conversionService)	Constructs a new instance.
JdbcQueryStatement(DataConversionService conversionService, DataJdbcConfiguration jdbcConfiguration)	Constructs a new instance.

Method Summary

Modifier and Type	Method	Description
static int	findSqlType(DataType dataType, Dialect dialect)	Find the SQL type from DataType.
io.micronaut.core.convert.ConversionService	getConversionService()	Get conversion service.
QueryStatement<PreparedStatement, Integer>	setArray(PreparedStatement statement, Integer name, @Nullable Object array)	Sets an array value for the given name.
QueryStatement<PreparedStatement, Integer>	setBigDecimal(PreparedStatement statement, Integer name, @Nullable BigDecimal bd)	Write a BigDecimal value for the given name.
QueryStatement<PreparedStatement, Integer>	setBoolean(PreparedStatement statement, Integer name, boolean bool)	Write a boolean value for the given name.
QueryStatement<PreparedStatement, Integer>	setByte(PreparedStatement statement, Integer name, byte b)	Write a byte value for the given name.
QueryStatement<PreparedStatement, Integer>	setBytes(PreparedStatement statement, Integer name, byte @Nullable [] bytes)	Write a byte[] value for the given name.
QueryStatement<PreparedStatement, Integer>	setChar(PreparedStatement statement, Integer name, char value)	Write a char value for the given name.
QueryStatement<PreparedStatement, Integer>	setDate(PreparedStatement statement, Integer name, @Nullable Date date)	Write a date value for the given name.
QueryStatement<PreparedStatement, Integer>	setDouble(PreparedStatement statement, Integer name, double d)	Write a double value for the given name.
QueryStatement<PreparedStatement, Integer>	setDynamic(PreparedStatement statement, Integer index, DataType dataType, @Nullable Object value)	Write a value dynamically using the result set and the given name and data type.
QueryStatement<PreparedStatement, Integer>	setFloat(PreparedStatement statement, Integer name, float f)	Write a float value for the given name.
QueryStatement<PreparedStatement, Integer>	setInt(PreparedStatement statement, Integer name, int integer)	Write an int value for the given name.
QueryStatement<PreparedStatement, Integer>	setLong(PreparedStatement statement, Integer name, long value)	Write a long value for the given name.
QueryStatement<PreparedStatement, Integer>	setShort(PreparedStatement statement, Integer name, short s)	Write a short value for the given name.
QueryStatement<PreparedStatement, Integer>	setString(PreparedStatement statement, Integer name, @Nullable String string)	Write a string value for the given name.
QueryStatement<PreparedStatement, Integer>	setTime(PreparedStatement statement, Integer name, @Nullable Time instant)	Write an instant value for the given name.
QueryStatement<PreparedStatement, Integer>	setTimestamp(PreparedStatement statement, Integer name, @Nullable Instant instant)	Write an instant value for the given name.
QueryStatement<PreparedStatement, Integer>	setValue(PreparedStatement statement, Integer index, @Nullable Object value)	Sets the give given object value.

Methods inherited from class Object

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

Methods inherited from interface QueryStatement

convertRequired

Constructor Details

JdbcQueryStatement

public JdbcQueryStatement(DataConversionService conversionService)

Constructs a new instance.

Parameters:

conversionService - The data conversion service

Since:

3.1

JdbcQueryStatement

public JdbcQueryStatement(DataConversionService conversionService,
 DataJdbcConfiguration jdbcConfiguration)

Constructs a new instance.

Parameters:

conversionService - The data conversion service

jdbcConfiguration - The JDBC configuration

Since:

4.6.1

Method Details

findSqlType

@Internal
public static int findSqlType(DataType dataType,
 Dialect dialect)

Find the SQL type from DataType.

Parameters:

dataType - The data type

dialect - The dialect

Returns:

The SQL type

getConversionService

public io.micronaut.core.convert.ConversionService getConversionService()

Description copied from interface: QueryStatement

Get conversion service.

Specified by:

getConversionService in interface QueryStatement<PreparedStatement, Integer>

Returns:

the instance of ConversionService

setDynamic

public QueryStatement<PreparedStatement, Integer> setDynamic(PreparedStatement statement,
 Integer index,
 DataType dataType,
 @Nullable Object value)

Description copied from interface: QueryStatement

Write a value dynamically using the result set and the given name and data type.

Specified by:

setDynamic in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

index - The index

dataType - The data type

value - the value

Returns:

The writer

setTimestamp

public QueryStatement<PreparedStatement, Integer> setTimestamp(PreparedStatement statement,
 Integer name,
 @Nullable Instant instant)

Description copied from interface: QueryStatement

Write an instant value for the given name.

Specified by:

setTimestamp in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

instant - The instant

Returns:

This writer

setTime

public QueryStatement<PreparedStatement, Integer> setTime(PreparedStatement statement,
 Integer name,
 @Nullable Time instant)

Description copied from interface: QueryStatement

Write an instant value for the given name.

Specified by:

setTime in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

instant - The time

Returns:

This writer

setValue

public QueryStatement<PreparedStatement, Integer> setValue(PreparedStatement statement,
 Integer index,
 @Nullable Object value)
                                                    throws DataAccessException

Description copied from interface: QueryStatement

Sets the give given object value.

Specified by:

setValue in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

index - The index

value - The value

Returns:

this writer

Throws:

DataAccessException - if the value cannot be read

setLong

public QueryStatement<PreparedStatement, Integer> setLong(PreparedStatement statement,
 Integer name,
 long value)

Description copied from interface: QueryStatement

Write a long value for the given name.

Specified by:

setLong in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

value - The value

Returns:

This writer

setChar

public QueryStatement<PreparedStatement, Integer> setChar(PreparedStatement statement,
 Integer name,
 char value)

Description copied from interface: QueryStatement

Write a char value for the given name.

Specified by:

setChar in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

value - The char value

Returns:

This writer

setDate

public QueryStatement<PreparedStatement, Integer> setDate(PreparedStatement statement,
 Integer name,
 @Nullable Date date)

Description copied from interface: QueryStatement

Write a date value for the given name.

Specified by:

setDate in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

date - The date

Returns:

This writer

setString

public QueryStatement<PreparedStatement, Integer> setString(PreparedStatement statement,
 Integer name,
 @Nullable String string)

Description copied from interface: QueryStatement

Write a string value for the given name.

Specified by:

setString in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

string - The string

Returns:

This writer

setInt

public QueryStatement<PreparedStatement, Integer> setInt(PreparedStatement statement,
 Integer name,
 int integer)

Description copied from interface: QueryStatement

Write an int value for the given name.

Specified by:

setInt in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

integer - The integer

Returns:

This writer

setBoolean

public QueryStatement<PreparedStatement, Integer> setBoolean(PreparedStatement statement,
 Integer name,
 boolean bool)

Description copied from interface: QueryStatement

Write a boolean value for the given name.

Specified by:

setBoolean in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

bool - The boolean

Returns:

This writer

setFloat

public QueryStatement<PreparedStatement, Integer> setFloat(PreparedStatement statement,
 Integer name,
 float f)

Description copied from interface: QueryStatement

Write a float value for the given name.

Specified by:

setFloat in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

f - The float

Returns:

This writer

setByte

public QueryStatement<PreparedStatement, Integer> setByte(PreparedStatement statement,
 Integer name,
 byte b)

Description copied from interface: QueryStatement

Write a byte value for the given name.

Specified by:

setByte in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

b - The byte

Returns:

This writer

setShort

public QueryStatement<PreparedStatement, Integer> setShort(PreparedStatement statement,
 Integer name,
 short s)

Description copied from interface: QueryStatement

Write a short value for the given name.

Specified by:

setShort in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

s - The short

Returns:

This writer

setDouble

public QueryStatement<PreparedStatement, Integer> setDouble(PreparedStatement statement,
 Integer name,
 double d)

Description copied from interface: QueryStatement

Write a double value for the given name.

Specified by:

setDouble in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

d - The double

Returns:

This writer

setBigDecimal

public QueryStatement<PreparedStatement, Integer> setBigDecimal(PreparedStatement statement,
 Integer name,
 @Nullable BigDecimal bd)

Description copied from interface: QueryStatement

Write a BigDecimal value for the given name.

Specified by:

setBigDecimal in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

bd - The big decimal

Returns:

This writer

setBytes

public QueryStatement<PreparedStatement, Integer> setBytes(PreparedStatement statement,
 Integer name,
 byte @Nullable [] bytes)

Description copied from interface: QueryStatement

Write a byte[] value for the given name.

Specified by:

setBytes in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

bytes - the bytes

Returns:

This writer

setArray

public QueryStatement<PreparedStatement, Integer> setArray(PreparedStatement statement,
 Integer name,
 @Nullable Object array)

Description copied from interface: QueryStatement

Sets an array value for the given name.

Specified by:

setArray in interface QueryStatement<PreparedStatement, Integer>

Parameters:

statement - The statement

name - The name (such as the column name)

array - the array

Returns:

This writer