jvsq3lite.Sq3StmtC Class Reference

Sq3StmtC - the class known as sq3stmt or Statement defined by Sq3StmtS … More...

Inheritance diagram for jvsq3lite.Sq3StmtC:

Collaboration diagram for jvsq3lite.Sq3StmtC:

Public Member Functions
native void	BindBlob (int pos, byte[] blob)
	Java: sq3stmt.BindBlob(int pos, byte[] blob) → C-API Bind a MkBinaryR Value To a Prepared Statement …
native void	BindDouble (int arg1, double arg2)
	Java: sq3stmt.BindDouble(int arg1, double arg2) → C-API Binding Values To Prepared Statements …
native void	BindInt (int arg1, int arg2)
	Java: sq3stmt.BindInt(int arg1, int arg2) → C-API Binding Values To Prepared Statements …
native void	BindInt64 (int arg1, long arg2)
	Java: sq3stmt.BindInt64(int arg1, long arg2) → C-API Binding Values To Prepared Statements …
native void	BindNull (int arg1)
	Java: sq3stmt.BindNull(int arg1) → C-API Binding Values To Prepared Statements …
native void	BindParameterCount ()
	Java: sq3stmt.BindParameterCount() → C-API Number Of SQL Parameters …
native void	BindParameterIndex (String zName)
	Java: sq3stmt.BindParameterIndex(String zName) → C-API Index Of A Parameter With A Given Name …
native String	BindParameterName (int arg1)
	Java: String sq3stmt.BindParameterName(int arg1) → C-API Name Of A Host Parameter …
native void	BindText (int pos, String text)
	Java: sq3stmt.BindText(int pos, String text) → C-API Bind a MkStringR Value To a Prepared Statement …
native void	BindValue (int arg1, Sq3ValueC arg2)
	Java: sq3stmt.BindValue(int arg1, Sq3ValueC arg2) → C-API Binding Values To Prepared Statements …
native void	BindZeroblob (int arg1, int n)
	Java: sq3stmt.BindZeroblob(int arg1, int n) → C-API Binding Values To Prepared Statements …
native void	BindZeroblob64 (int arg1, long arg2)
	Java: sq3stmt.BindZeroblob64(int arg1, long arg2) → C-API Binding Values To Prepared Statements …
native Sq3StmtC	Next ()
	Java: Sq3StmtC stmt.Next() → C-API get next instance from linked-list of Sq3StmtS type
native Sq3StmtC	Prev ()
	Java: Sq3StmtC stmt.Prev() → C-API get previous instance from linked-list of Sq3StmtS type
native Sq3ValueC	ColumnValue (int iCol)
	Java: Sq3ValueC sq3stmt.ColumnValue(int iCol) → C-API Result Values From A Query …
native byte[]	ColumnBlob (int iCol)
	Java: byte[] sq3stmt.ColumnBlob(int iCol) → C-API Result a MkBinaryR Value From A Query.
native int	ColumnBytes (int iCol)
	Java: int sq3stmt.ColumnBytes(int iCol) → C-API Result Values From A Query …
native int	ColumnCount ()
	Java: int pStmt.ColumnCount() → C-API Number Of Columns In A Result Set …
native double	ColumnDouble (int iCol)
	Java: double sq3stmt.ColumnDouble(int iCol) → C-API Result Values From A Query …
native int	ColumnInt (int iCol)
	Java: int sq3stmt.ColumnInt(int iCol) → C-API Result Values From A Query …
native long	ColumnInt64 (int iCol)
	Java: long sq3stmt.ColumnInt64(int iCol) → C-API Result Values From A Query …
native String	ColumnName (int N)
	Java: String sq3stmt.ColumnName(int N) → C-API Column Names In A Result Set …
native String	ColumnText (int iCol)
	Java: String sq3stmt.ColumnText(int iCol) → C-API Result a MkStringR Value From A Query.
native Sq3TypeE	ColumnType (int iCol)
	Java: Sq3TypeE sq3stmt.ColumnType(int iCol) → C-API Result Values From A Query …
native Sq3LiteC	DbHandle ()
	Java: Sq3LiteC sq3stmt.DbHandle() → C-API Find The Database Handle Of A Prepared Statement …
native void	Busy ()
	Java: sq3stmt.Busy() → C-API Determine If A Prepared Statement Has Been Reset …
native void	DataCount ()
	Java: pStmt.DataCount() → C-API Number of columns in a result set …
native void	IsExplain ()
	Java: pStmt.IsExplain() → C-API Query The EXPLAIN Setting For A Prepared Statement …
void	Log ()
	Java: stmt.Log(?MkObjectC fmtobj = null?, ?int debug = 0?, ?String callfunc = null?, ?int lvl = 0?) → C-API log the val …
void	Log (MkObjectC fmtobj)
	Java: stmt.Log(?MkObjectC fmtobj = null?, ?int debug = 0?, ?String callfunc = null?, ?int lvl = 0?) → C-API log the val …
void	Log (MkObjectC fmtobj, int debug)
	Java: stmt.Log(?MkObjectC fmtobj = null?, ?int debug = 0?, ?String callfunc = null?, ?int lvl = 0?) → C-API log the val …
void	Log (MkObjectC fmtobj, int debug, String callfunc)
	Java: stmt.Log(?MkObjectC fmtobj = null?, ?int debug = 0?, ?String callfunc = null?, ?int lvl = 0?) → C-API log the val …
native void	Readonly ()
	Java: pStmt.Readonly() → C-API Determine If An SQL Statement Writes The Database …
native void	Status (Sq3StmtStatusE op, boolean resetFlg)
	Java: sq3stmt.Status(Sq3StmtStatusE op, boolean resetFlg) → C-API Prepared Statement Status …
native void	ClearBindings ()
	Java: sq3stmt.ClearBindings() → C-API Reset All Bindings On A Prepared Statement …
native void	Explain (int eMode)
	Java: pStmt.Explain(int eMode) → C-API Change The EXPLAIN Setting For A Prepared Statement …
native void	Reset ()
	Java: pStmt.Reset() → C-API Reset A Prepared Statement Object …
native Sq3ErrorE	Step ()
	Java: Sq3ErrorE sq3stmt.Step() → C-API Evaluate An SQL Statement …
native String	ExpandedSql ()
	Java: String pStmt.ExpandedSql() → C-API Retrieving Statement SQL …
native String	GetPzTail ()
	Java: String sq3stmt.GetPzTail() → C-API return the non compiled sql-statement from Sq3StmtPrepareV2 and Sq3StmtPrepareV3 …
native String	Sql ()
	Java: String pStmt.Sql() → C-API Retrieving Statement SQL …
	Sq3StmtC (Sq3LiteC db, String zSql)
	Java: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV2(Sq3LiteC db, String zSql) → C-API Compiling An SQL Statement …
native void	Finalize ()
	Java: [destructor] pStmt.Finalize() → C-API Destroy A Prepared Statement Object …
Public Member Functions inherited from jvmkkernel::MkObjectC
void	close ()
String	toString ()
native void	HandleDelete ()
native boolean	HandleExists ()
native int	HandleGet ()
native int	HandleGetOfType ()
native int	HandleGetOr0 ()
native MkObjectC	Next ()
native MkObjectC	Prev ()
native void	DbgDump (String message, String callfunc)
void	DbgDump ()
void	DbgDump (String message)
native void	DbgL (String message, int debug, String callfunc, int lvl)
void	DbgL (String message)
void	DbgL (String message, int debug)
void	DbgL (String message, int debug, String callfunc)
native void	DbgLogC (String callfunc)
void	DbgLogC ()
native void	DbgO (String callfunc)
void	DbgO ()
native void	DbgSTACK (int skip, int num, String callfunc)
void	DbgSTACK ()
void	DbgSTACK (int skip)
void	DbgSTACK (int skip, int num)
native void	LogC (String message, int debug, String callfunc)
void	LogC (String message)
void	LogC (String message, int debug)
native void	LogHEX (String callfunc, byte[] data)
native void	Log (MkObjectC fmtobj, int debug, String callfunc, int lvl)
native void	LogLong (MkObjectC fmtobj, int debug, String callfunc, int lvl)
void	LogLong ()
void	LogLong (MkObjectC fmtobj)
void	LogLong (MkObjectC fmtobj, int debug)
void	LogLong (MkObjectC fmtobj, int debug, String callfunc)
native void	LogShort (MkObjectC fmtobj, int debug, String callfunc, int lvl)
void	LogShort ()
void	LogShort (MkObjectC fmtobj)
void	LogShort (MkObjectC fmtobj, int debug)
void	LogShort (MkObjectC fmtobj, int debug, String callfunc)
native void	LogType (MkObjectC fmtobj, int debug, String callfunc, int lvl)
void	LogType ()
void	LogType (MkObjectC fmtobj)
void	LogType (MkObjectC fmtobj, int debug)
void	LogType (MkObjectC fmtobj, int debug, String callfunc)
void	Log ()
void	Log (MkObjectC fmtobj)
void	Log (MkObjectC fmtobj, int debug)
void	Log (MkObjectC fmtobj, int debug, String callfunc)
native MkErrorC	ErrorCatch (Throwable exception, String callfunc)
MkErrorC	ErrorCatch ()
MkErrorC	ErrorCatch (Throwable exception)
native MkErrorC	ToError ()
native boolean	IsNull ()
native String	ToName ()
native String	ToNameOfClass ()
native String	ToNameOfType ()
native String	ToString ()
native int	RefGet ()
native void	SysKill (int pid, int signal)
native int	SysGetPid ()
native void	Dispose ()
native void	Delete ()
void	printP ()
void	L0 ()
void	L1 ()
void	L2 ()
void	L3 ()
void	L4 ()
void	L5 ()
void	L6 ()
void	L7 ()
void	L8 ()
void	L9 ()
void	LA ()
void	LB ()
void	LE ()
void	printL (String name, Object val)

Static Public Member Functions
static native Sq3StmtC	HandleResolve (int netHdl)
	Java: [static] Sq3StmtC Sq3StmtC.HandleResolve(int netHdl) → C-API Handle-Resolve-Slot - return a Sq3StmtC from netHdl or null if invalid…
static native Sq3StmtC	Instances ()
	Java: [static] Sq3StmtC Sq3StmtC.Instances() → C-API get head-instance from linked-list of Sq3StmtS type …
static native Sq3StmtC	GetNull ()
	Java: [static] Sq3StmtC Sq3StmtC.GetNull() → C-API Null-Slot - return a Sq3StmtC typed NULL instance …
static native Sq3StmtC	NextStmt (Sq3LiteC pDb, Sq3StmtC pStmt)
	Java: [static] Sq3StmtC Sq3StmtC.NextStmt(Sq3LiteC pDb, ?Sq3StmtC pStmt = null?) → C-API Find the next prepared statement …
static Sq3StmtC	NextStmt (Sq3LiteC pDb)
	Java: [static] Sq3StmtC Sq3StmtC.NextStmt(Sq3LiteC pDb, ?Sq3StmtC pStmt = null?) → C-API Find the next prepared statement …
static native Sq3StmtC	PrepareV2 (Sq3LiteC db, String zSql)
	Java: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV2(Sq3LiteC db, String zSql) → C-API Compiling An SQL Statement …
static native Sq3StmtC	PrepareV3 (Sq3LiteC db, String zSql, Sq3PrepareEF prepFlags)
	Java: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV3(Sq3LiteC db, String zSql, ?Sq3PrepareEF prepFlags = SQ3_PREPARE_NO?) → C-API Compiling An SQL Statement …
static Sq3StmtC	PrepareV3 (Sq3LiteC db, String zSql)
	Java: [constructor,static] Sq3StmtC Sq3StmtC.PrepareV3(Sq3LiteC db, String zSql, ?Sq3PrepareEF prepFlags = SQ3_PREPARE_NO?) → C-API Compiling An SQL Statement …
Static Public Member Functions inherited from jvmkkernel::MkObjectC
static native MkObjectC	HandleResolve (int netHdl)
static native void	HandleDeleteByNetHdl (int netHdl)
static native MkObjectC	Instances ()
static native MkObjectC	GetNull ()
static native void	DbgM (String message, int debug, String callfunc, int lvl)
static void	DbgM (String message)
static void	DbgM (String message, int debug)
static void	DbgM (String message, int debug, String callfunc)
static native int	SysHashI32 (String key, int length)
static int	SysHashI32 (String key)
static native String	SysHashSTR (String key, int length)
static String	SysHashSTR (String key)
static native void	DeleteCallbackCleanup (String ident)
static native void	DeleteCallbackSetup (String ident, MkObjectDeleteIF callback, String filter)
static void	DeleteCallbackSetup (String ident)
static void	DeleteCallbackSetup (String ident, MkObjectDeleteIF callback)
static int	getPId ()
static long	getTId ()
static String	getCallerProc (int level)
static String	getCallerProc ()
static String	getStackTrace (int level)
static String	getStackTrace ()
static int	getCallerLine (int level)
static int	getCallerLine ()
static String	getCallerFile (int level)
static String	getCallerFile ()
static void	SF (String msg, String name, int framelvl)
static void	SF (String msg)
static void	SF (String msg, String name)
static void	printP (long ptr, String name, int framelvl)
static void	printO (byte byt, String name, int framelvl)
static void	printBool (boolean bol, String name, int framelvl)
static void	printObj (Object id, String caller, int framelvl)
static void	printObj (Object id, String caller)
static void	printObj (Object id)
static void	printC (String id, String name, int framelvl)
static void	printC (String id)
static void	printTyp (MkObjectC id, String name, int framelvl)
static void	printStack (String name, int framelvl)
static void	M0 ()
static void	M1 ()
static void	M2 ()
static void	M3 ()
static void	M4 ()
static void	M5 ()
static void	M6 ()
static void	M7 ()
static void	M8 ()
static void	M9 ()
static void	MA ()
static void	MB ()
static void	MC ()
static void	MD ()
static void	ME ()

Additional Inherited Members
Protected Member Functions inherited from jvmkkernel::MkObjectC
	MkObjectC (long mng, boolean dummy)
void	Dispose (boolean disposing)

Detailed Description

Sq3StmtC - the class known as sq3stmt or Statement defined by Sq3StmtS …

Struct to represent the data of the Sq3StmtC …

Prepared Statement Object …

An instance of this object represents a single SQL statement that has been compiled into binary form and is ready to be evaluated.

Think of each SQL statement as a separate computer program. The original SQL text is source code. A prepared statement object is the compiled object code. All SQL must be converted into a prepared statement before it can be run.

The life-cycle of a prepared statement object usually goes like this:

1. Create the prepared statement object using Sq3StmtPrepareV2 ().
2. Bind values to parameters using the Sq3StmtBindValue*() interfaces.
3. Run the SQL by calling Sq3StmtStep () one or more times.
4. Reset the prepared statement using Sq3StmtReset () then go back to step 2. Do this zero or more times.
5. Destroy the object using Sq3StmtFinalize ().

Reference code from sqlite3:

typedef struct sqlite3_stmt sqlite3_stmt;

Definition at line 20 of file Sq3StmtC.java.

---

The documentation for this class was generated from the following file:

• Sq3StmtC.java