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