PreparedStatement - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : PreparedStatement : Database/PreparedStatement/Execute

PreparedStatement

  

Execute

  

execute a prepared statement

 

Calling Sequence

Parameters

Description

Examples

Calling Sequence

preparedstat:-Execute( opts )

Parameters

preparedstat

-

PreparedStatement module

opts

-

anything; parameter to insert into the prepared statement

Description

• 

Execute inserts its arguments into the prepared statement represented by preparedstat. The statement is then executed.

• 

Execute accepts at most the number of arguments as parameters ("?") in the SQL string passed into CreatePreparedStatement. If less are given, then SQL NULL is used for the unspecified parameters.

• 

Maple attempts to convert the Maple type passed into Execute to the correct SQL type.  If the default Maple conversion is incorrect, you can specify the conversion using a type cast. For details, see Database/conversions.

• 

Execute returns the return value of the first statement.  The return values of subsequent statements are accessible via NextResult.

• 

If a statement is an update, then the return value is an integer representing the update count.  If a statement is a query, then the return value is a Result module representing the table of values.

• 

Not all Java Database Connectivity [JDBC] Drivers can handle multiple SQL statements in a single string.  In this case, the behavior of Execute with multiple statements is undefined.

• 

If a large number of similar statements are to be executed (for example populating a table with INSERTs), using a PreparedStatement may be more efficient than Statement.

Examples

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:pstatconn:-CreateStatementSELECT name FROM animals WHERE id = ?; SELECT name FROM animals WHERE id = ?; SELECT name FROM animals WHERE id = ?;:

Execute some statements.

respstat:-Execute1,2,3:

Check the value.

res:-Next;res:-GetDataname

fish

(1)

Get the next result.

respstat:-NextResult:

Get the value.

res:-Next:res:-GetDataname

dog

(2)

Now the last result

respstat:-NextResult:res:-Next:res:-GetDataname

cat

(3)

See Also

Database

Database[Connection][ExecuteQuery]

Database[Connection][ExecuteUpdate]

Database[PreparedStatement]

Database[PreparedStatement][NextResult]

Database[Result]

Database[Statement]

Database[usage]

 


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam