src/jdbc/JdbcSqlResultSetMetaData.java

   1
   2 package csql.jdbc;
   3
   4 import java.sql.SQLException;
   5 import java.sql.ResultSetMetaData;
   6
   7 /**
   8  *
   9  * @author bijaya
  10  */
  11 public final class JdbcSqlResultSetMetaData
  12 extends JSqlError implements ResultSetMetaData, JSqlErrorType
  13 {
  14     private boolean isClosed;
  15     JdbcSqlStatement stmt; // This guy creates me
  16     private boolean shouldDriverHandles;
  17     private  FieldInfo[] fieldMeta;
  18
  19     JdbcSqlResultSetMetaData()
  20     {
  21         isClosed = false;
  22         shouldDriverHandles = false;
  23     }
  24
  25     void setStmt( JdbcSqlStatement s )
  26     {
  27         stmt = s;
  28         isClosed = false;
  29     }
  30
  31     JdbcSqlResultSetMetaData(FieldInfo[] fields)
  32     {
  33         isClosed = false;
  34         shouldDriverHandles = true;
  35         fieldMeta = fields;
  36     }
  37
  38     public void close() throws SQLException
  39     {
  40         if( ! isClosed )
  41             isClosed = true;
  42         return;
  43     }
  44
  45     public int getColumnCount () throws SQLException
  46     {
  47         if( isClosed ) throw getException( CSQL_INVALID_STATE );
  48         if (shouldDriverHandles){
  49             return this.fieldMeta.length;
  50         }
  51         return( stmt.jniStmt.getTotalProjFld() );
  52     }
  53
  54
  55     public int getColumnIndex (String name) throws SQLException
  56     {
  57         if( isClosed ) throw getException( CSQL_INVALID_STATE );
  58         if(shouldDriverHandles){
  59             for ( int i=0; i< this.fieldMeta.length; i++)
  60             {
  61                 if(fieldMeta[i].getColname().equals(name))
  62                     return (i+1);
  63             }
  64         }
  65         return( stmt.jniStmt.findColumn( name ) );//TO DO
  66     }
  67
  68     public String getColumnName (int colNum) throws SQLException
  69     {
  70         if( isClosed ) throw getException( CSQL_INVALID_STATE );
  71         if(shouldDriverHandles){
  72             if(this.fieldMeta.length < colNum)
  73                 return null;
  74             else
  75                 return this.fieldMeta[colNum-1].getColname();
  76         }
  77         String name= stmt.jniStmt.getProjFldName(colNum);
  78         return( name );
  79     }
  80     public String getColumnLabel (int colNum) throws SQLException
  81     {
  82         return getColumnName( colNum );
  83     }
  84
  85     public boolean isReadOnly (int colNum) throws SQLException
  86     {
  87         if( isClosed ) throw getException( CSQL_INVALID_STATE );
  88         return( false );
  89     }
  90     public boolean isWritable (int colNum) throws SQLException
  91     {
  92         if( isClosed ) throw getException( CSQL_INVALID_STATE );
  93         if(shouldDriverHandles) {
  94             return false;
  95         }
  96         return( true );
  97     }
  98     public boolean isDefinitelyWritable (int colNum) throws SQLException
  99     {
 100         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 101         if(shouldDriverHandles) {
 102             return false;
 103         }
 104         return( true );
 105     }
 106
 107
 108     public String getColumnClassName(int colNum) throws SQLException
 109     {
 110         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 111         if(shouldDriverHandles) {
 112             return Util.getClassName(this.fieldMeta[colNum-1].getCsqlType());
 113         }
 114         return Util.getClassName(this.stmt.jniStmt.getProjFldType(colNum));
 115     }
 116
 117     public int getColumnType (int colNum) throws SQLException
 118     {
 119         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 120         if(shouldDriverHandles) {
 121             return Util.getType(this.fieldMeta[colNum-1].getCsqlType());
 122         }
 123         return Util.getType(this.stmt.jniStmt.getProjFldType(colNum));
 124     }
 125     public String getColumnTypeName (int colNum) throws SQLException
 126     {
 127         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 128         if(shouldDriverHandles) {
 129             return Util.getTypeName(this.fieldMeta[colNum-1].getCsqlType());
 130         }
 131         return Util.getTypeName(this.stmt.jniStmt.getProjFldType(colNum));
 132     }
 133     public boolean isCaseSensitive (int colNum) throws SQLException
 134     {
 135         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 136         return( false );
 137     }
 138
 139     public int isNullable (int colNum) throws SQLException
 140     {
 141         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 142         if(shouldDriverHandles) {
 143             if(this.fieldMeta[colNum-1].isNullable())
 144                  return JdbcSqlResultSetMetaData.columnNoNulls ;
 145             else
 146                  return JdbcSqlResultSetMetaData.columnNullable ;
 147         }
 148
 149         if (this.stmt.jniStmt.isFldNullable(colNum))
 150             return JdbcSqlResultSetMetaData.columnNoNulls ;
 151         else
 152             return JdbcSqlResultSetMetaData.columnNullable ;
 153     }
 154
 155     public String getTableName (int colNum) throws SQLException
 156     {
 157         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 158         if(shouldDriverHandles){
 159             return "";
 160         }
 161         //TODO
 162         return( null );
 163     }
 164     public boolean isSigned (int colNum) throws SQLException
 165     {
 166         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 167         return false;
 168     }
 169     public int getPrecision (int colNum) throws SQLException //TODO
 170     {
 171         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 172         return 0;
 173     }
 174     public int getScale (int colNum) throws SQLException //TODO
 175     {
 176         if( isClosed ) throw getException( CSQL_INVALID_STATE );
 177         return 0;
 178     }
 179     public String getSchemaName (int colNum) throws SQLException
 180     {
 181         return "";
 182     }
 183
 184
 185     // UN-SUPPORTED API's
 186     public int getColumnDisplaySize (int colNum) throws SQLException
 187     {
 188         return( 1 );
 189     }
 190     //TODO:
 191     public boolean isAutoIncrement (int colNum) throws SQLException
 192     {
 193         return( false );
 194     }
 195     public boolean isCurrency (int colNum) throws SQLException
 196     {
 197         return( false );
 198     }
 199     public String getCatalogName (int colNum) throws SQLException
 200     {
 201         return "csql";
 202     }
 203     public boolean isSearchable (int colNum) throws SQLException
 204     {
 205         if(shouldDriverHandles) return false;
 206         return( true );
 207     }
 208     //java 1.6 methods
 209     public boolean isWrapperFor(Class ifact) throws SQLException
 210     {
 211         throw getException(CSQL_NOT_SUPPORTED);
 212     }
 213     public Class unwrap(Class iface) throws SQLException
 214     {
 215         throw getException(CSQL_NOT_SUPPORTED);
 216     }
 217
 218 }