com.ibm.jtopenlite.database.jdbc

Class JDBCPreparedStatement

    • Constructor Detail

      • JDBCPreparedStatement

        public JDBCPreparedStatement(JDBCConnection conn,
                             java.lang.String sql,
                             java.util.Calendar calendar,
                             java.lang.String statementName,
                             java.lang.String cursorName,
                             int rpbID)
                              throws java.sql.SQLException
        Throws:
        java.sql.SQLException
    >
    • Method Detail

      • addBatch

        public void addBatch()
                      throws java.sql.SQLException
        Not implemented.
        Specified by:
        addBatch in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • clearParameters

        public void clearParameters()
                             throws java.sql.SQLException
        Specified by:
        clearParameters in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • execute

        public boolean execute()
                        throws java.sql.SQLException
        Specified by:
        execute in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • executeQuery

        public java.sql.ResultSet executeQuery()
                                        throws java.sql.SQLException
        Specified by:
        executeQuery in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • close

        public void close()
                   throws java.sql.SQLException
        Specified by:
        close in interface java.sql.Statement
        Overrides:
        close in class JDBCStatement
        Throws:
        java.sql.SQLException
      • executeUpdate

        public int executeUpdate()
                          throws java.sql.SQLException
        Specified by:
        executeUpdate in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • getMetaData

        public java.sql.ResultSetMetaData getMetaData()
                                               throws java.sql.SQLException
        Specified by:
        getMetaData in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • getParameterMetaData

        public java.sql.ParameterMetaData getParameterMetaData()
                                                        throws java.sql.SQLException
        Specified by:
        getParameterMetaData in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setArray

        public void setArray(int parameterIndex,
                    java.sql.Array x)
                      throws java.sql.SQLException
        Not implemented.
        Specified by:
        setArray in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setAsciiStream

        public void setAsciiStream(int parameterIndex,
                          java.io.InputStream x,
                          int length)
                            throws java.sql.SQLException
        Specified by:
        setAsciiStream in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setBigDecimal

        public void setBigDecimal(int parameterIndex,
                         java.math.BigDecimal x)
                           throws java.sql.SQLException
        Specified by:
        setBigDecimal in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setBinaryStream

        public void setBinaryStream(int parameterIndex,
                           java.io.InputStream x,
                           int length)
                             throws java.sql.SQLException
        Specified by:
        setBinaryStream in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setBlob

        public void setBlob(int parameterIndex,
                   java.sql.Blob x)
                     throws java.sql.SQLException
        Not implemented.
        Specified by:
        setBlob in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setBoolean

        public void setBoolean(int parameterIndex,
                      boolean x)
                        throws java.sql.SQLException
        Specified by:
        setBoolean in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setByte

        public void setByte(int parameterIndex,
                   byte x)
                     throws java.sql.SQLException
        Specified by:
        setByte in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setBytes

        public void setBytes(int parameterIndex,
                    byte[] x)
                      throws java.sql.SQLException
        Specified by:
        setBytes in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setCharacterStream

        public void setCharacterStream(int parameterIndex,
                              java.io.Reader x,
                              int length)
                                throws java.sql.SQLException
        Specified by:
        setCharacterStream in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setClob

        public void setClob(int parameterIndex,
                   java.sql.Clob x)
                     throws java.sql.SQLException
        Not implemented.
        Specified by:
        setClob in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setDate

        public void setDate(int parameterIndex,
                   java.sql.Date x)
                     throws java.sql.SQLException
        Specified by:
        setDate in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setDate

        public void setDate(int parameterIndex,
                   java.sql.Date x,
                   java.util.Calendar cal)
                     throws java.sql.SQLException
        Specified by:
        setDate in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setDouble

        public void setDouble(int parameterIndex,
                     double x)
                       throws java.sql.SQLException
        Specified by:
        setDouble in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setFloat

        public void setFloat(int parameterIndex,
                    float x)
                      throws java.sql.SQLException
        Specified by:
        setFloat in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setInt

        public void setInt(int parameterIndex,
                  int x)
                    throws java.sql.SQLException
        Specified by:
        setInt in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setLong

        public void setLong(int parameterIndex,
                   long x)
                     throws java.sql.SQLException
        Specified by:
        setLong in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setNull

        public void setNull(int parameterIndex,
                   int sqlType)
                     throws java.sql.SQLException
        Specified by:
        setNull in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setNull

        public void setNull(int parameterIndex,
                   int sqlType,
                   java.lang.String typeName)
                     throws java.sql.SQLException
        Specified by:
        setNull in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setObject

        public void setObject(int parameterIndex,
                     java.lang.Object x)
                       throws java.sql.SQLException
        Specified by:
        setObject in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setObject

        public void setObject(int parameterIndex,
                     java.lang.Object x,
                     int targetSQLType)
                       throws java.sql.SQLException
        Not implemented.
        Specified by:
        setObject in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setObject

        public void setObject(int parameterIndex,
                     java.lang.Object x,
                     int targetSQLType,
                     int scale)
                       throws java.sql.SQLException
        Not implemented.
        Specified by:
        setObject in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setRef

        public void setRef(int parameterIndex,
                  java.sql.Ref x)
                    throws java.sql.SQLException
        Not implemented.
        Specified by:
        setRef in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setShort

        public void setShort(int parameterIndex,
                    short x)
                      throws java.sql.SQLException
        Specified by:
        setShort in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setString

        public void setString(int parameterIndex,
                     java.lang.String x)
                       throws java.sql.SQLException
        Specified by:
        setString in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setTime

        public void setTime(int parameterIndex,
                   java.sql.Time x)
                     throws java.sql.SQLException
        Specified by:
        setTime in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setTime

        public void setTime(int parameterIndex,
                   java.sql.Time x,
                   java.util.Calendar cal)
                     throws java.sql.SQLException
        Specified by:
        setTime in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setTimestamp

        public void setTimestamp(int parameterIndex,
                        java.sql.Timestamp x)
                          throws java.sql.SQLException
        Specified by:
        setTimestamp in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setTimestamp

        public void setTimestamp(int parameterIndex,
                        java.sql.Timestamp x,
                        java.util.Calendar cal)
                          throws java.sql.SQLException
        Specified by:
        setTimestamp in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setUnicodeStream

        public void setUnicodeStream(int parameterIndex,
                            java.io.InputStream x,
                            int length)
                              throws java.sql.SQLException
        Specified by:
        setUnicodeStream in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setURL

        public void setURL(int parameterIndex,
                  java.net.URL x)
                    throws java.sql.SQLException
        Specified by:
        setURL in interface java.sql.PreparedStatement
        Throws:
        java.sql.SQLException
      • setAsciiStream

        public void setAsciiStream(int parameterIndex,
                          java.io.InputStream arg1)
                            throws java.sql.SQLException
        Specified by:
        setAsciiStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setAsciiStream

        public void setAsciiStream(int parameterIndex,
                          java.io.InputStream arg1,
                          long arg2)
                            throws java.sql.SQLException
        Specified by:
        setAsciiStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setBinaryStream

        public void setBinaryStream(int parameterIndex,
                           java.io.InputStream arg1)
                             throws java.sql.SQLException
        Specified by:
        setBinaryStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setBinaryStream

        public void setBinaryStream(int parameterIndex,
                           java.io.InputStream arg1,
                           long arg2)
                             throws java.sql.SQLException
        Specified by:
        setBinaryStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setBlob

        public void setBlob(int parameterIndex,
                   java.io.InputStream arg1)
                     throws java.sql.SQLException
        Specified by:
        setBlob in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setBlob

        public void setBlob(int parameterIndex,
                   java.io.InputStream arg1,
                   long arg2)
                     throws java.sql.SQLException
        Specified by:
        setBlob in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setCharacterStream

        public void setCharacterStream(int parameterIndex,
                              java.io.Reader arg1)
                                throws java.sql.SQLException
        Specified by:
        setCharacterStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setCharacterStream

        public void setCharacterStream(int parameterIndex,
                              java.io.Reader arg1,
                              long arg2)
                                throws java.sql.SQLException
        Specified by:
        setCharacterStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setClob

        public void setClob(int parameterIndex,
                   java.io.Reader arg1)
                     throws java.sql.SQLException
        Specified by:
        setClob in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setClob

        public void setClob(int parameterIndex,
                   java.io.Reader arg1,
                   long arg2)
                     throws java.sql.SQLException
        Specified by:
        setClob in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setNCharacterStream

        public void setNCharacterStream(int parameterIndex,
                               java.io.Reader arg1)
                                 throws java.sql.SQLException
        Specified by:
        setNCharacterStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setNCharacterStream

        public void setNCharacterStream(int parameterIndex,
                               java.io.Reader arg1,
                               long arg2)
                                 throws java.sql.SQLException
        Specified by:
        setNCharacterStream in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setNClob

        public void setNClob(int parameterIndex,
                    java.io.Reader arg1)
                      throws java.sql.SQLException
        Specified by:
        setNClob in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException
      • setNClob

        public void setNClob(int parameterIndex,
                    java.io.Reader arg1,
                    long arg2)
                      throws java.sql.SQLException
        Specified by:
        setNClob in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        arg2 -
        Throws:
        java.sql.SQLException
      • setNString

        public void setNString(int parameterIndex,
                      java.lang.String arg1)
                        throws java.sql.SQLException
        Specified by:
        setNString in interface java.sql.PreparedStatement
        Parameters:
        parameterIndex -
        arg1 -
        Throws:
        java.sql.SQLException