Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Platforms to show: All Mac Windows Linux Cross-Platform

JavaPreparedStatementMBS class

Super class: JavaStatementMBS

Type Topic Plugin Version macOS Windows Linux Console & Web iOS
class Java Database MBS Java Plugin 8.5 Yes Yes Yes Yes No
Function: An object that represents a precompiled SQL statement.
Notes:
A SQL statement is precompiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Note: The setter methods (setShort, setString, and so on) for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type INTEGER, then the method setInt should be used.

If arbitrary parameter type conversions are required, the method setObject should be used with a target SQL type.

In the following example of setting a parameter, con represents an active connection:

PreparedStatement pstmt = con.prepareStatement("UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?");
pstmt.setBigDecimal(1, 153833.00)
pstmt.setInt(2, 110592)
Subclass of the JavaStatementMBS class.
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.

Feedback, Comments & Corrections

Super class JavaStatementMBS

Super class JavaObjectMBS

This class has no sub classes.

Some methods using this class:

Some examples which use this class:


The items on this page are in the following plugins: MBS Java Plugin.


JavaParameterMetaDataMBS   -   JavaResultSetMBS




Links
MBS Xojo blog