src/jdbc/JdbcSqlPreparedStatement.java

   1 package csql.jdbc;
   2 import java.io.InputStream;
   3 import java.io.Reader;
   4 import java.math.BigDecimal;
   5 import java.util.Calendar;
   6 import java.net.URL;
   7
   8 import java.sql.Connection;
   9 import java.sql.Statement;
  10 import java.sql.PreparedStatement;
  11 import java.sql.ResultSet;
  12 import java.sql.Blob;
  13 import java.sql.Clob;
  14 import java.sql.ResultSetMetaData;
  15 import java.sql.ParameterMetaData;
  16 import java.sql.SQLException;
  17 import java.sql.Ref;
  18 import java.sql.Array;
  19 import java.sql.SQLXML;
  20 import java.sql.RowId;
  21
  22 import java.sql.NClob;
  23 public final class JdbcSqlPreparedStatement extends JdbcSqlStatement
  24                    implements PreparedStatement
  25 {
  26
  27     JdbcSqlPreparedStatement(Connection con)
  28     {
  29         super(con);
  30     }
  31     public void clearParameters() throws SQLException
  32     {
  33         //TODO
  34         return;
  35     }
  36     public boolean execute() throws SQLException
  37     {
  38         return executeInt();
  39     }
  40     public ResultSet executeQuery() throws SQLException
  41     {
  42         if(!executeInt())
  43             throw getException(CSQL_NOT_QUERY);
  44         //Praba changed this
  45         rs.setStmt( this );
  46         return( rs );
  47         //return null;
  48     }
  49     public int executeUpdate() throws SQLException
  50     {
  51         if(executeInt())
  52             throw getException(CSQL_NOT_UPDATE);
  53         return(rowsAffect);
  54     }
  55     public ResultSetMetaData getMetaData() throws SQLException
  56     {
  57         //TODO
  58         return null;
  59     }
  60
  61     public ParameterMetaData getParameterMetaData() throws SQLException
  62     {
  63         //TODO
  64         return null;
  65     }
  66     public void setByte(int param, byte value) throws SQLException
  67     {
  68         jniStmt.setByte(param, value);
  69         return;
  70     }
  71     public void setDate(int param, java.sql.Date value) throws SQLException
  72     {
  73         jniStmt.setDate(param, value);
  74         return;
  75     }
  76     public void setDouble(int param, double value) throws SQLException
  77     {
  78         jniStmt.setDouble(param, value);
  79         return;
  80     }
  81     public void setFloat(int param, float value) throws SQLException
  82     {
  83         jniStmt.setFloat(param, value);
  84         return;
  85     }
  86     public void setInt(int param, int value) throws SQLException
  87     {
  88         jniStmt.setInt(param, value);
  89         return;
  90     }
  91     public void setLong(int param, long value) throws SQLException
  92     {
  93         jniStmt.setLong(param, value);
  94         return;
  95     }
  96     public void setNull (int param, int sqlType) throws SQLException
  97     {
  98         jniStmt.setNull(param);
  99         return;
 100     }
 101     public void setObject(int param, Object obj) throws SQLException
 102     {
 103         if(obj instanceof Double)
 104             setDouble(param, ((Double)obj).doubleValue() );
 105         else if(obj instanceof Float)
 106             setFloat(param, ((Float)obj).floatValue() );
 107         else if(obj instanceof Long)
 108             setLong(param, ((Long)obj).longValue() );
 109         else if(obj instanceof Integer)
 110             setInt(param, ((Integer)obj).intValue() );
 111         else if(obj instanceof Short)
 112             setShort(param, ((Short)obj).shortValue() );
 113         else if(obj instanceof Byte)
 114             setByte(param, ((Byte)obj).byteValue() );
 115         else if(obj instanceof java.sql.Date )
 116             setDate(param, ((java.sql.Date) obj));
 117         else if(obj instanceof java.sql.Time )
 118             setTime(param, ((java.sql.Time) obj));
 119         else if(obj instanceof java.sql.Timestamp )
 120             setTimestamp(param, ((java.sql.Timestamp) obj));
 121         else if(obj instanceof String )
 122             setString(param, ((String) obj));
 123         else
 124             throw getException(CSQL_INVALID_DATATYPE);
 125
 126         return;
 127     }
 128     public void setShort(int param, short value) throws SQLException
 129     {
 130         jniStmt.setShort(param, value);
 131         return;
 132     }
 133     public void setString(int param, String value) throws SQLException
 134     {
 135         jniStmt.setString(param, value);
 136         return;
 137     }
 138     public void setTime(int param, java.sql.Time value) throws SQLException
 139     {
 140         jniStmt.setTime(param, value);
 141         return;
 142     }
 143     public void setTimestamp(int param, java.sql.Timestamp value) throws SQLException
 144     {
 145         jniStmt.setTimestamp(param, value);
 146         return;
 147     }
 148
 149
 150
 151
 152     //Unsupported APIs
 153     public void addBatch() throws SQLException
 154     {
 155         throw getException(CSQL_NOT_SUPPORTED);
 156     }
 157     public void setArray (int i, Array value) throws SQLException
 158     {
 159         throw getException(CSQL_NOT_SUPPORTED);
 160     }
 161     public void setAsciiStream(int parameterIndex, InputStream value, int length)
 162                                            throws SQLException
 163     {
 164         throw getException(CSQL_NOT_SUPPORTED);
 165     }
 166     public void setBigDecimal(int parameterIndex, BigDecimal value) throws SQLException
 167     {
 168         throw getException(CSQL_NOT_SUPPORTED);
 169     }
 170     public void setBinaryStream(int parameterIndex, InputStream value, int length)
 171                                            throws SQLException
 172     {
 173         throw getException(CSQL_NOT_SUPPORTED);
 174     }
 175     public void setBlob(int i, Blob value) throws SQLException
 176     {
 177         throw getException(CSQL_NOT_SUPPORTED);
 178     }
 179     public void setBoolean (int param, boolean value) throws SQLException
 180     {
 181         throw getException(CSQL_NOT_SUPPORTED);
 182     }
 183     public void setBytes(int param, byte value[]) throws SQLException
 184     {
 185         throw getException(CSQL_NOT_SUPPORTED);
 186     }
 187     public void setCharacterStream(int param, Reader reader, int length)
 188                                             throws SQLException
 189     {
 190         throw getException(CSQL_NOT_SUPPORTED);
 191     }
 192     public void setClob (int i, Clob value) throws SQLException
 193     {
 194         throw getException(CSQL_NOT_SUPPORTED);
 195     }
 196     public void setDate(int param, java.sql.Date value, Calendar cal)
 197                                     throws SQLException
 198     {
 199         throw getException(CSQL_NOT_SUPPORTED);
 200     }
 201     public void setNull (int param, int sqlType, String typeName)
 202         throws SQLException
 203     {
 204         throw getException(CSQL_NOT_SUPPORTED);
 205     }
 206     public void setObject (int param, Object value, int targetSqlType)
 207         throws SQLException
 208     {
 209         throw getException(CSQL_NOT_SUPPORTED);
 210     }
 211     public void setObject (int param, Object value,
 212         int targetSqlType, int scale) throws SQLException
 213     {
 214         throw getException(CSQL_NOT_SUPPORTED);
 215     }
 216     public void setRef(int i, Ref value)  throws SQLException
 217     {
 218         throw getException(CSQL_NOT_SUPPORTED);
 219     }
 220     public void setTime(int param, java.sql.Time value, Calendar cal)
 221                                              throws SQLException
 222     {
 223         throw getException(CSQL_NOT_SUPPORTED);
 224     }
 225     public void setTimestamp(int param, java.sql.Timestamp value,
 226                                Calendar cal) throws SQLException
 227     {
 228         throw getException(CSQL_NOT_SUPPORTED);
 229     }
 230     public void setUnicodeStream (int param, InputStream value, int length)
 231                                                        throws SQLException
 232     {
 233         throw getException(CSQL_NOT_SUPPORTED);
 234     }
 235     public void setURL(int parameterName, URL value) throws SQLException
 236     {
 237         throw getException(CSQL_NOT_SUPPORTED);
 238     }
 239     //java 1.6 methods
 240     public void setBlob(int  paramIndex, InputStream value ) throws SQLException
 241     {
 242         throw getException(CSQL_NOT_SUPPORTED);
 243     }
 244     public void setBlob(int  paramIndex, InputStream value, long length ) throws SQLException
 245     {
 246         throw getException(CSQL_NOT_SUPPORTED);
 247     }
 248     public void setClob(int  paramIndex, Reader value ) throws SQLException
 249     {
 250         throw getException(CSQL_NOT_SUPPORTED);
 251     }
 252     public void setClob(int  paramIndex, Reader value, long length ) throws SQLException
 253     {
 254         throw getException(CSQL_NOT_SUPPORTED);
 255     }
 256     public void setNCharacterStream(int  paramIndex, Reader value)
 257                                                      throws SQLException
 258     {
 259         throw getException(CSQL_NOT_SUPPORTED);
 260     }
 261     public void setNCharacterStream(int  paramIndex,Reader value,long length)
 262                                                            throws SQLException
 263     {
 264         throw getException(CSQL_NOT_SUPPORTED);
 265     }
 266     public void setNClob(int  paramIndex, NClob value)
 267                                                   throws SQLException
 268     {
 269         throw getException(CSQL_NOT_SUPPORTED);
 270     }
 271     public void setNClob(int  paramIndex, Reader value)
 272                                                   throws SQLException
 273     {
 274         throw getException(CSQL_NOT_SUPPORTED);
 275     }
 276     public void setNClob(int  paramIndex, Reader value, long length)
 277                                                   throws SQLException
 278     {
 279         throw getException(CSQL_NOT_SUPPORTED);
 280     }
 281     public void setNString(int  paramIndex, String value)
 282                                                   throws SQLException
 283     {
 284         throw getException(CSQL_NOT_SUPPORTED);
 285     }
 286     public void setCharacterStream(int param, Reader reader)
 287                                             throws SQLException
 288     {
 289         throw getException(CSQL_NOT_SUPPORTED);
 290     }
 291     public void setCharacterStream(int param, Reader reader, long length)
 292                                             throws SQLException
 293     {
 294         throw getException(CSQL_NOT_SUPPORTED);
 295     }
 296     public void setBinaryStream(int parameterIndex, InputStream value)
 297                                            throws SQLException
 298     {
 299         throw getException(CSQL_NOT_SUPPORTED);
 300     }
 301     public void setBinaryStream(int parameterIndex, InputStream value, long length)
 302                                            throws SQLException
 303     {
 304         throw getException(CSQL_NOT_SUPPORTED);
 305     }
 306     public void setAsciiStream(int parameterIndex, InputStream value)
 307                                            throws SQLException
 308     {
 309         throw getException(CSQL_NOT_SUPPORTED);
 310     }
 311     public void setAsciiStream(int parameterIndex, InputStream value, long length)
 312                                            throws SQLException
 313     {
 314         throw getException(CSQL_NOT_SUPPORTED);
 315     }
 316     public void setSQLXML(int paramIndex, SQLXML xmlObj) throws SQLException
 317     {
 318         throw getException(CSQL_NOT_SUPPORTED);
 319     }
 320     public void setRowId(int paramIndex, RowId x) throws SQLException
 321     {
 322         throw getException(CSQL_NOT_SUPPORTED);
 323     }
 324
 325
 326
 327 }