BotCommands/io.github.freya022.botcommands.api.core.db/BlockingTransaction/preparedStatement

preparedStatement

@NotNull
open fun preparedStatement(@Language(value = "PostgreSQL") @NotNull sql: @NotNull String): @NotNull BlockingPreparedStatement(source)

Creates a statement from the given SQL statement.

The returned statement must be closed, with a try-with-resource, for example.

Parameters

sql

An SQL statement that may contain one or more '?' IN parameter placeholders

@NotNull
open fun preparedStatement(@Language(value = "PostgreSQL") @NotNull sql: @NotNull String, columnIndexes: @NotNull Array<Int>): @NotNull BlockingPreparedStatement(source)

Creates a statement from the given SQL statement.

The returned statement must be closed, with a try-with-resource, for example.

Parameters

sql

An SQL statement that may contain one or more '?' IN parameter placeholders

columnIndexes

An array of column indexes indicating the columns that should be returned from the inserted row or rows

@NotNull
open fun preparedStatement(@Language(value = "PostgreSQL") @NotNull sql: @NotNull String, @NotNull columnNames: @NotNull Array<@NotNull String>): @NotNull BlockingPreparedStatement(source)

Creates a statement from the given SQL statement.

The returned statement must be closed, with a try-with-resource, for example.

Parameters

sql

An SQL statement that may contain one or more '?' IN parameter placeholders

columnNames

An array of column names indicating the columns that should be returned from the inserted row or rows