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 class JdbcSqlPreparedStatement extends JdbcSqlStatement
  24                    implements PreparedStatement
  25 {
  26     public JdbcSqlParameterMetaData pmtd;
  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         pmtd = new JdbcSqlParameterMetaData();
  64         pmtd.setStmt(this);
  65         return pmtd;
  66     }
  67     public void setByte(int param, byte value) throws SQLException
  68     {
  69         jniStmt.setByte(param, value);
  70         return;
  71     }
  72     public void setDate(int param, java.sql.Date value) throws SQLException
  73     {
  74         jniStmt.setDate(param, value);
  75         return;
  76     }
  77     public void setDouble(int param, double value) throws SQLException
  78     {
  79         jniStmt.setDouble(param, value);
  80         return;
  81     }
  82     public void setFloat(int param, float value) throws SQLException
  83     {
  84         jniStmt.setFloat(param, value);
  85         return;
  86     }
  87     public void setInt(int param, int value) throws SQLException
  88     {
  89         jniStmt.setInt(param, value);
  90         return;
  91     }
  92     public void setLong(int param, long value) throws SQLException
  93     {
  94         jniStmt.setLong(param, value);
  95         return;
  96     }
  97     public void setNull (int param, int sqlType) throws SQLException
  98     {
  99         jniStmt.setNull(param);
 100         return;
 101     }
 102     public void setObject(int param, Object obj) throws SQLException
 103     {
 104         if(obj instanceof Double)
 105             setDouble(param, ((Double)obj).doubleValue() );
 106         else if(obj instanceof Float)
 107             setFloat(param, ((Float)obj).floatValue() );
 108         else if(obj instanceof Long)
 109             setLong(param, ((Long)obj).longValue() );
 110         else if(obj instanceof Integer)
 111             setInt(param, ((Integer)obj).intValue() );
 112         else if(obj instanceof Short)
 113             setShort(param, ((Short)obj).shortValue() );
 114         else if(obj instanceof Byte)
 115             setByte(param, ((Byte)obj).byteValue() );
 116         else if(obj instanceof java.sql.Date )
 117             setDate(param, ((java.sql.Date) obj));
 118         else if(obj instanceof java.sql.Time )
 119             setTime(param, ((java.sql.Time) obj));
 120         else if(obj instanceof java.sql.Timestamp )
 121             setTimestamp(param, ((java.sql.Timestamp) obj));
 122         else if(obj instanceof String )
 123             setString(param, ((String) obj));
 124         else
 125             throw getException(CSQL_INVALID_DATATYPE);
 126
 127         return;
 128     }
 129     public void setShort(int param, short value) throws SQLException
 130     {
 131         jniStmt.setShort(param, value);
 132         return;
 133     }
 134     public void setString(int param, String value) throws SQLException
 135     {
 136         jniStmt.setString(param, value);
 137         return;
 138     }
 139     public void setTime(int param, java.sql.Time value) throws SQLException
 140     {
 141         jniStmt.setTime(param, value);
 142         return;
 143     }
 144     public void setTimestamp(int param, java.sql.Timestamp value) throws SQLException
 145     {
 146         jniStmt.setTimestamp(param, value);
 147         return;
 148     }
 149
 150
 151
 152
 153     //Unsupported APIs
 154     public void addBatch() throws SQLException
 155     {
 156         throw getException(CSQL_NOT_SUPPORTED);
 157     }
 158     public void setArray (int i, Array value) throws SQLException
 159     {
 160         throw getException(CSQL_NOT_SUPPORTED);
 161     }
 162     public void setAsciiStream(int parameterIndex, InputStream value, int length)
 163                                            throws SQLException
 164     {
 165         throw getException(CSQL_NOT_SUPPORTED);
 166     }
 167     public void setBigDecimal(int parameterIndex, BigDecimal value) throws SQLException
 168     {
 169         throw getException(CSQL_NOT_SUPPORTED);
 170     }
 171     public void setBinaryStream(int parameterIndex, InputStream value, int length)
 172                                            throws SQLException
 173     {
 174         throw getException(CSQL_NOT_SUPPORTED);
 175     }
 176     public void setBlob(int i, Blob value) throws SQLException
 177     {
 178         throw getException(CSQL_NOT_SUPPORTED);
 179     }
 180     public void setBoolean (int param, boolean value) throws SQLException
 181     {
 182         throw getException(CSQL_NOT_SUPPORTED);
 183     }
 184     public void setBytes(int param, byte value[]) throws SQLException
 185     {
 186         throw getException(CSQL_NOT_SUPPORTED);
 187     }
 188     public void setCharacterStream(int param, Reader reader, int length)
 189                                             throws SQLException
 190     {
 191         throw getException(CSQL_NOT_SUPPORTED);
 192     }
 193     public void setClob (int i, Clob value) throws SQLException
 194     {
 195         throw getException(CSQL_NOT_SUPPORTED);
 196     }
 197     public void setDate(int param, java.sql.Date value, Calendar cal)
 198                                     throws SQLException
 199     {
 200         throw getException(CSQL_NOT_SUPPORTED);
 201     }
 202     public void setNull (int param, int sqlType, String typeName)
 203         throws SQLException
 204     {
 205         throw getException(CSQL_NOT_SUPPORTED);
 206     }
 207     public void setObject (int param, Object value, int targetSqlType)
 208         throws SQLException
 209     {
 210         throw getException(CSQL_NOT_SUPPORTED);
 211     }
 212     public void setObject (int param, Object value,
 213         int targetSqlType, int scale) throws SQLException
 214     {
 215         throw getException(CSQL_NOT_SUPPORTED);
 216     }
 217     public void setRef(int i, Ref value)  throws SQLException
 218     {
 219         throw getException(CSQL_NOT_SUPPORTED);
 220     }
 221     public void setTime(int param, java.sql.Time value, Calendar cal)
 222                                              throws SQLException
 223     {
 224         throw getException(CSQL_NOT_SUPPORTED);
 225     }
 226     public void setTimestamp(int param, java.sql.Timestamp value,
 227                                Calendar cal) throws SQLException
 228     {
 229         throw getException(CSQL_NOT_SUPPORTED);
 230     }
 231     public void setUnicodeStream (int param, InputStream value, int length)
 232                                                        throws SQLException
 233     {
 234         throw getException(CSQL_NOT_SUPPORTED);
 235     }
 236     public void setURL(int parameterName, URL value) throws SQLException
 237     {
 238         throw getException(CSQL_NOT_SUPPORTED);
 239     }
 240     //java 1.6 methods
 241     public void setBlob(int  paramIndex, InputStream value ) throws SQLException
 242     {
 243         throw getException(CSQL_NOT_SUPPORTED);
 244     }
 245     public void setBlob(int  paramIndex, InputStream value, long length ) throws SQLException
 246     {
 247         throw getException(CSQL_NOT_SUPPORTED);
 248     }
 249     public void setClob(int  paramIndex, Reader value ) throws SQLException
 250     {
 251         throw getException(CSQL_NOT_SUPPORTED);
 252     }
 253     public void setClob(int  paramIndex, Reader value, long length ) throws SQLException
 254     {
 255         throw getException(CSQL_NOT_SUPPORTED);
 256     }
 257     public void setNCharacterStream(int  paramIndex, Reader value)
 258                                                      throws SQLException
 259     {
 260         throw getException(CSQL_NOT_SUPPORTED);
 261     }
 262     public void setNCharacterStream(int  paramIndex,Reader value,long length)
 263                                                            throws SQLException
 264     {
 265         throw getException(CSQL_NOT_SUPPORTED);
 266     }
 267     public void setNClob(int  paramIndex, NClob value)
 268                                                   throws SQLException
 269     {
 270         throw getException(CSQL_NOT_SUPPORTED);
 271     }
 272     public void setNClob(int  paramIndex, Reader value)
 273                                                   throws SQLException
 274     {
 275         throw getException(CSQL_NOT_SUPPORTED);
 276     }
 277     public void setNClob(int  paramIndex, Reader value, long length)
 278                                                   throws SQLException
 279     {
 280         throw getException(CSQL_NOT_SUPPORTED);
 281     }
 282     public void setNString(int  paramIndex, String value)
 283                                                   throws SQLException
 284     {
 285         throw getException(CSQL_NOT_SUPPORTED);
 286     }
 287     public void setCharacterStream(int param, Reader reader)
 288                                             throws SQLException
 289     {
 290         throw getException(CSQL_NOT_SUPPORTED);
 291     }
 292     public void setCharacterStream(int param, Reader reader, long length)
 293                                             throws SQLException
 294     {
 295         throw getException(CSQL_NOT_SUPPORTED);
 296     }
 297     public void setBinaryStream(int parameterIndex, InputStream value)
 298                                            throws SQLException
 299     {
 300         throw getException(CSQL_NOT_SUPPORTED);
 301     }
 302     public void setBinaryStream(int parameterIndex, InputStream value, long length)
 303                                            throws SQLException
 304     {
 305         throw getException(CSQL_NOT_SUPPORTED);
 306     }
 307     public void setAsciiStream(int parameterIndex, InputStream value)
 308                                            throws SQLException
 309     {
 310         throw getException(CSQL_NOT_SUPPORTED);
 311     }
 312     public void setAsciiStream(int parameterIndex, InputStream value, long length)
 313                                            throws SQLException
 314     {
 315         throw getException(CSQL_NOT_SUPPORTED);
 316     }
 317     public void setSQLXML(int paramIndex, SQLXML xmlObj) throws SQLException
 318     {
 319         throw getException(CSQL_NOT_SUPPORTED);
 320     }
 321     public void setRowId(int paramIndex, RowId x) throws SQLException
 322     {
 323         throw getException(CSQL_NOT_SUPPORTED);
 324     }
 325
 326
 327
 328 }