4 import java
.sql
.Timestamp
;
5 public class JSqlStatement
7 public long sqlStmtPtr
;
13 public void setPtr( long ptr
)
20 public native void alloc(int mode
);
21 public native void free();
22 public native void freeStmt();
25 public native void setConnectionPtr(long ptr
);
26 public native int prepare( String statement
);
27 public native boolean isSelect();
28 public native int execute();
29 public native long next(); //returns next tuple
30 public native long close(); //close the scan
33 public native void setShort( int pos
, short value
);
34 public native void setInt( int pos
, int value
);
35 public native void setLong( int pos
, long value
);
36 public native void setByte( int pos
, byte value
); // TINYINT
37 public native void setFloat( int pos
, float value
);
38 public native void setDouble( int pos
, double value
);
39 public native void setString( int pos
, String value
);
40 public native void setDate( int pos
, Date d
);
41 public native void setTime( int pos
, Time t
);
42 public native void setTimestamp( int pos
, Timestamp tms
);
43 public native void setBoolean( int pos
, boolean value
); //TODO
45 public native void setNull( int pos
);
47 // To retrieve Field values
48 public native short getShort( int pos
);
49 public native int getInt( int pos
);
50 public native long getLong( int pos
);
51 public native byte getByte( int pos
); // TINYINT
52 public native float getFloat( int pos
);
53 public native double getDouble( int pos
);
54 public native String
getString( int pos
);
55 public native Date
getDate( int pos
);
56 public native Time
getTime( int pos
);
57 public native Timestamp
getTimestamp( int pos
);
58 public native boolean getBoolean( int pos
);
61 public native int findColumn( String str
);
62 public native int getNoOfFields();
63 public native String
getFieldName( int pos
);