NpsPreparedStatement class

NpsPreparedStatement can be applied to implement SQL statement precompiled by ORACLE. Database connection will adopt DataSource name as "nps" defined in db.xml. As default, the database connection transaction won’t be automatically submitted. Use “session.Commit()” to submit transaction. Use “session.Rollback()” to rollback transaction.

Currently, large object (CLOB, BLOB, LONG) and array is not supported.

top

Method Summary

void SetInt(int parameterIndex,int x) throws Exception
set specific parameter to int value.
void SetDouble(int parameterIndex,double x) throws Exception
set specific parameter to double value.
void SetString(int parameterIndex,String s) throws Exception
set specific parameter to string value.
void SetDate(int parameterIndex, Date d) throws Exception
set specific parameter to date value.
void SetNull(int parameterIndex,int sqlType) throws Exception
set specific parameter to null.
NpsResultSet ExecuteQuery() throws Exception
execute SQL statement, return to result set.
int ExecuteUpdate() throws Exception
execute “Insert、Delete、Update” statement, return to affected rows.
int Close()
close the given object, release the database connection.