src/jdbc/JSqlStatement.java

   1 package csql.jdbc;
   2 import java.sql.Time;
   3 import java.sql.Date;
   4 import java.sql.Timestamp;
   5 public class JSqlStatement
   6 {
   7     public long sqlStmtPtr;
   8
   9     public long getPtr()
  10     {
  11         return sqlStmtPtr;
  12     }
  13     public void setPtr( long ptr )
  14     {
  15         sqlStmtPtr = ptr;
  16     }
  17
  18     // Wrappers Below
  19
  20     public native void alloc(int mode);
  21     public native void free();
  22     public native void freeStmt();
  23
  24     // Operations
  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
  31
  32     // Parameters
  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
  44
  45     public native void setNull( int pos );
  46     public native boolean isNull(int pos);
  47
  48     // To retrieve Field values
  49     public native short getShort( int pos );
  50     public native int getInt( int pos );
  51     public native long getLong( int pos );
  52     public native byte getByte( int pos );  // TINYINT
  53     public native float getFloat( int pos );
  54     public native double getDouble( int pos );
  55     public native String getString( int pos );
  56     public native Date getDate( int pos );
  57     public native Time getTime( int pos );
  58     public native Timestamp getTimestamp( int pos );
  59     public native boolean getBoolean( int pos );
  60
  61     // ResultSet
  62     public native int findColumn( String str );
  63     public native int getNoOfFields();
  64     public native String getFieldName( int pos );
  65
  66     // ResultSetMetaData
  67     public native int getTotalProjFld();
  68     public native int getProjFldType(int pos);
  69     public native boolean isFldNullable(int pos);
  70     public native String getProjFldName(int pos);
  71     public native String getTableName();
  72     //ParameterMetaData
  73     public native String getParamFldName(int param);
  74     public native int getTotalparam();
  75     public native int getType(int param);
  76     public native boolean isNullable(int pos);
  77
  78     //Callable statement.
  79     public native int executePro();
  80     public native int preparePro(String statemnt);
  81     public native long nextSet();
  82 };