Server
PreparedStatement for query construction at the server side.
Type parameters
- F
-
The effect type
Value parameters
- initialPacket
-
the initial packet
- params
-
the parameters
- resetSequenceId
-
the reset sequence id
- socket
-
the packet socket
- sql
-
the SQL statement
- statementId
-
the statement id
Attributes
- Source
- PreparedStatement.scala
- Graph
-
- Supertypes
-
trait Serializabletrait Producttrait Equalstrait PreparedStatement[F]trait Statement[F]class Objecttrait Matchableclass AnyShow all
Members list
Value members
Concrete methods
Releases this Statement object's database and LDBC 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.
Releases this Statement object's database and LDBC 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.
Calling the method close on a Statement object that is already closed has no effect.
Note: When a Statement object is closed, its current ResultSet object, if one exists, is also closed.
Attributes
- Definition Classes
- Source
- PreparedStatement.scala
Executes the specified SQL statement and returns one or more ResultSet objects.
Executes the specified SQL statement and returns one or more ResultSet objects.
Attributes
- Definition Classes
- Source
- PreparedStatement.scala
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
Attributes
- Definition Classes
- Source
- PreparedStatement.scala
Retrieves any auto-generated keys created as a result of executing this Statement object.
Retrieves any auto-generated keys created as a result of executing this Statement object.
Attributes
- Definition Classes
- Source
- PreparedStatement.scala
Inherited methods
Attributes
- Inherited from:
- Product
Attributes
- Inherited from:
- Product
Sets the designated parameter to the given Scala.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.
Sets the designated parameter to the given Scala.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.
Sets the designated parameter to the given Scala.math.BigDecimal value. The driver converts this to an SQL NUMERIC value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala boolean value. The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.
Sets the designated parameter to the given Scala boolean value. The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala boolean value. The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.
Sets the designated parameter to the given Scala boolean value. The driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.
Sets the designated parameter to the given Scala byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.
Sets the designated parameter to the given Scala byte value. The driver converts this to an SQL TINYINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala 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.
Sets the designated parameter to the given Scala 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.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala 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.
Sets the designated parameter to the given Scala 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.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database. With a Calendar object, the driver can calculate the date taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
Sets the designated parameter to the given java.time.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database. With a Calendar object, the driver can calculate the date taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database. With a Calendar object, the driver can calculate the date taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
Sets the designated parameter to the given java.time.Date value, using the given Calendar object. The driver uses the Calendar object to construct an SQL DATE value, which the driver then sends to the database. With a Calendar object, the driver can calculate the date taking into account a custom timezone. If no Calendar object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.
Sets the designated parameter to the given Scala double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.
Sets the designated parameter to the given Scala double value. The driver converts this to an SQL DOUBLE value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala float value. The driver converts this to an SQL REAL value when it ends it to the database.
Sets the designated parameter to the given Scala float value. The driver converts this to an SQL REAL value when it ends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala float value. The driver converts this to an SQL REAL value when it ends it to the database.
Sets the designated parameter to the given Scala float value. The driver converts this to an SQL REAL value when it ends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala int value. The driver converts this to an SQL INTEGER value when it sends it to the database.
Sets the designated parameter to the given Scala int value. The driver converts this to an SQL INTEGER value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala int value. The driver converts this to an SQL INTEGER value when it sends it to the database.
Sets the designated parameter to the given Scala int value. The driver converts this to an SQL INTEGER value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Sets the designated parameter to the given Scala long value. The driver converts this to an SQL BIGINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to SQL NULL.
Sets the designated parameter to SQL NULL.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.
Sets the designated parameter to the given Scala short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.
Sets the designated parameter to the given Scala short value. The driver converts this to an SQL SMALLINT value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala 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.
Sets the designated parameter to the given Scala 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.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given Scala 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.
Sets the designated parameter to the given Scala 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.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Time value. The driver converts this to an SQL TIME value when it sends it to the database.
Sets the designated parameter to the given java.time.Time value. The driver converts this to an SQL TIME value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Time value. The driver converts this to an SQL TIME value when it sends it to the database.
Sets the designated parameter to the given java.time.Time value. The driver converts this to an SQL TIME value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.
Sets the designated parameter to the given java.time.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.
Sets the designated parameter to the given java.time.Timestamp value. The driver converts this to an SQL TIMESTAMP value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Year value. The driver converts this to an SQL YEAR value when it sends it to the database.
Sets the designated parameter to the given java.time.Year value. The driver converts this to an SQL YEAR value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala
Sets the designated parameter to the given java.time.Year value. The driver converts this to an SQL YEAR value when it sends it to the database.
Sets the designated parameter to the given java.time.Year value. The driver converts this to an SQL YEAR value when it sends it to the database.
Value parameters
- index
-
the first parameter is 1, the second is 2, ...
- value
-
the parameter value
Attributes
- Inherited from:
- PreparedStatement
- Source
- PreparedStatement.scala