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 public final class JdbcSqlPreparedStatement extends JdbcSqlStatement
  20                    implements PreparedStatement
  21 {
  22
  23     JdbcSqlPreparedStatement(Connection con)
  24     {
  25         super(con);
  26     }
  27     public void clearParameters() throws SQLException
  28     {
  29         //TODO
  30         return;
  31     }
  32     public boolean execute() throws SQLException
  33     {
  34         return executeInt();
  35     }
  36     public ResultSet executeQuery() throws SQLException
  37     {
  38         if(!executeInt())
  39             throw getException(CSQL_NOT_QUERY);
  40         //Praba changed this
  41         rs.setStmt( this );
  42         return( rs );
  43         //return null;
  44     }
  45     public int executeUpdate() throws SQLException
  46     {
  47         if(executeInt())
  48             throw getException(CSQL_NOT_UPDATE);
  49         return(rowsAffect);
  50     }
  51     public ResultSetMetaData getMetaData() throws SQLException
  52     {
  53         //TODO
  54         return null;
  55     }
  56
  57     public ParameterMetaData getParameterMetaData() throws SQLException
  58     {
  59         //TODO
  60         return null;
  61     }
  62     public void setByte(int param, byte value) throws SQLException
  63     {
  64         jniStmt.setByte(param, value);
  65         return;
  66     }
  67     public void setDate(int param, java.sql.Date value) throws SQLException
  68     {
  69         jniStmt.setDate(param, value);
  70         return;
  71     }
  72     public void setDouble(int param, double value) throws SQLException
  73     {
  74         jniStmt.setDouble(param, value);
  75         return;
  76     }
  77     public void setFloat(int param, float value) throws SQLException
  78     {
  79         jniStmt.setFloat(param, value);
  80         return;
  81     }
  82     public void setInt(int param, int value) throws SQLException
  83     {
  84         jniStmt.setInt(param, value);
  85         return;
  86     }
  87     public void setLong(int param, long value) throws SQLException
  88     {
  89         jniStmt.setLong(param, value);
  90         return;
  91     }
  92     public void setNull (int param, int sqlType) throws SQLException
  93     {
  94         jniStmt.setNull(param);
  95         return;
  96     }
  97     public void setObject(int param, Object obj) throws SQLException
  98     {
  99         if(obj instanceof Double)
 100             setDouble(param, ((Double)obj).doubleValue() );
 101         else if(obj instanceof Float)
 102             setFloat(param, ((Float)obj).floatValue() );
 103         else if(obj instanceof Long)
 104             setLong(param, ((Long)obj).longValue() );
 105         else if(obj instanceof Integer)
 106             setInt(param, ((Integer)obj).intValue() );
 107         else if(obj instanceof Short)
 108             setShort(param, ((Short)obj).shortValue() );
 109         else if(obj instanceof Byte)
 110             setByte(param, ((Byte)obj).byteValue() );
 111         else if(obj instanceof java.sql.Date )
 112             setDate(param, ((java.sql.Date) obj));
 113         else if(obj instanceof java.sql.Time )
 114             setTime(param, ((java.sql.Time) obj));
 115         else if(obj instanceof java.sql.Timestamp )
 116             setTimestamp(param, ((java.sql.Timestamp) obj));
 117         else if(obj instanceof String )
 118             setString(param, ((String) obj));
 119         else
 120             throw getException(CSQL_INVALID_DATATYPE);
 121
 122         return;
 123     }
 124     public void setShort(int param, short value) throws SQLException
 125     {
 126         jniStmt.setShort(param, value);
 127         return;
 128     }
 129     public void setString(int param, String value) throws SQLException
 130     {
 131         jniStmt.setString(param, value);
 132         return;
 133     }
 134     public void setTime(int param, java.sql.Time value) throws SQLException
 135     {
 136         jniStmt.setTime(param, value);
 137         return;
 138     }
 139     public void setTimestamp(int param, java.sql.Timestamp value) throws SQLException
 140     {
 141         jniStmt.setTimestamp(param, value);
 142         return;
 143     }
 144
 145
 146
 147
 148     //Unsupported APIs
 149     public void addBatch() throws SQLException
 150     {
 151         throw getException(CSQL_NOT_SUPPORTED);
 152     }
 153     public void setArray (int i, Array value) throws SQLException
 154     {
 155         throw getException(CSQL_NOT_SUPPORTED);
 156     }
 157     public void setAsciiStream(int parameterIndex, InputStream value, int length)
 158                                            throws SQLException
 159     {
 160         throw getException(CSQL_NOT_SUPPORTED);
 161     }
 162     public void setBigDecimal(int parameterIndex, BigDecimal value) throws SQLException
 163     {
 164         throw getException(CSQL_NOT_SUPPORTED);
 165     }
 166     public void setBinaryStream(int parameterIndex, InputStream value, int length)
 167                                            throws SQLException
 168     {
 169         throw getException(CSQL_NOT_SUPPORTED);
 170     }
 171     public void setBlob(int i, Blob value) throws SQLException
 172     {
 173         throw getException(CSQL_NOT_SUPPORTED);
 174     }
 175     public void setBoolean (int param, boolean value) throws SQLException
 176     {
 177         throw getException(CSQL_NOT_SUPPORTED);
 178     }
 179     public void setBytes(int param, byte value[]) throws SQLException
 180     {
 181         throw getException(CSQL_NOT_SUPPORTED);
 182     }
 183     public void setCharacterStream(int param, Reader reader, int length)
 184                                             throws SQLException
 185     {
 186         throw getException(CSQL_NOT_SUPPORTED);
 187     }
 188     public void setClob (int i, Clob value) throws SQLException
 189     {
 190         throw getException(CSQL_NOT_SUPPORTED);
 191     }
 192     public void setDate(int param, java.sql.Date value, Calendar cal)
 193                                     throws SQLException
 194     {
 195         throw getException(CSQL_NOT_SUPPORTED);
 196     }
 197     public void setNull (int param, int sqlType, String typeName)
 198         throws SQLException
 199     {
 200         throw getException(CSQL_NOT_SUPPORTED);
 201     }
 202     public void setObject (int param, Object value, int targetSqlType)
 203         throws SQLException
 204     {
 205         throw getException(CSQL_NOT_SUPPORTED);
 206     }
 207     public void setObject (int param, Object value,
 208         int targetSqlType, int scale) throws SQLException
 209     {
 210         throw getException(CSQL_NOT_SUPPORTED);
 211     }
 212     public void setRef(int i, Ref value)  throws SQLException
 213     {
 214         throw getException(CSQL_NOT_SUPPORTED);
 215     }
 216     public void setTime(int param, java.sql.Time value, Calendar cal)
 217                                              throws SQLException
 218     {
 219         throw getException(CSQL_NOT_SUPPORTED);
 220     }
 221     public void setTimestamp(int param, java.sql.Timestamp value,
 222                                Calendar cal) throws SQLException
 223     {
 224         throw getException(CSQL_NOT_SUPPORTED);
 225     }
 226     public void setUnicodeStream (int param, InputStream value, int length)
 227                                                        throws SQLException
 228     {
 229         throw getException(CSQL_NOT_SUPPORTED);
 230     }
 231     public void setURL(int parameterName, URL value) throws SQLException
 232     {
 233         throw getException(CSQL_NOT_SUPPORTED);
 234     }
 235
 236 }