ocinum.h

一个通用的oracle OCI开发程序包

  // Greater than
  friend bool operator> (const COCINumber & lhs, const COCINumber & rhs);
  friend bool operator> (const COCINumber & lhs, int rhs);
  friend bool operator> (const COCINumber & lhs, unsigned int rhs);
  friend bool operator> (const COCINumber & lhs, short rhs);
  friend bool operator> (const COCINumber & lhs, unsigned short rhs);
  friend bool operator> (const COCINumber & lhs, long rhs);
  friend bool operator> (const COCINumber & lhs, unsigned long rhs);
  friend bool operator> (const COCINumber & lhs, float rhs);
  friend bool operator> (const COCINumber & lhs, double rhs);
  friend bool operator> (const COCINumber & lhs, long double rhs);
  friend bool operator> (int lhs             , const COCINumber & rhs);
  friend bool operator> (unsigned int lhs    , const COCINumber & rhs);
  friend bool operator> (short lhs           , const COCINumber & rhs);
  friend bool operator> (unsigned short lhs  , const COCINumber & rhs);
  friend bool operator> (long lhs            , const COCINumber & rhs);
  friend bool operator> (unsigned long lhs   , const COCINumber & rhs);
  friend bool operator> (float lhs           , const COCINumber & rhs);
  friend bool operator> (double lhs          , const COCINumber & rhs);
  friend bool operator> (long double lhs     , const COCINumber & rhs);

  // Greater than or equal
  friend bool operator>= (const COCINumber & lhs, const COCINumber & rhs);
  friend bool operator>= (const COCINumber & lhs, int rhs);
  friend bool operator>= (const COCINumber & lhs, unsigned int rhs);
  friend bool operator>= (const COCINumber & lhs, short rhs);
  friend bool operator>= (const COCINumber & lhs, unsigned short rhs);
  friend bool operator>= (const COCINumber & lhs, long rhs);
  friend bool operator>= (const COCINumber & lhs, unsigned long rhs);
  friend bool operator>= (const COCINumber & lhs, float rhs);
  friend bool operator>= (const COCINumber & lhs, double rhs);
  friend bool operator>= (const COCINumber & lhs, long double rhs);
  friend bool operator>= (int lhs             , const COCINumber & rhs);
  friend bool operator>= (unsigned int lhs    , const COCINumber & rhs);
  friend bool operator>= (short lhs           , const COCINumber & rhs);
  friend bool operator>= (unsigned short lhs  , const COCINumber & rhs);
  friend bool operator>= (long lhs            , const COCINumber & rhs);
  friend bool operator>= (unsigned long lhs   , const COCINumber & rhs);
  friend bool operator>= (float lhs           , const COCINumber & rhs);
  friend bool operator>= (double lhs          , const COCINumber & rhs);
  friend bool operator>= (long double lhs     , const COCINumber & rhs);


  // Less than
  friend bool operator< (const COCINumber & lhs, const COCINumber & rhs);
  friend bool operator< (const COCINumber & lhs, int rhs);
  friend bool operator< (const COCINumber & lhs, unsigned int rhs);
  friend bool operator< (const COCINumber & lhs, short rhs);
  friend bool operator< (const COCINumber & lhs, unsigned short rhs);
  friend bool operator< (const COCINumber & lhs, long rhs);
  friend bool operator< (const COCINumber & lhs, unsigned long rhs);
  friend bool operator< (const COCINumber & lhs, float rhs);
  friend bool operator< (const COCINumber & lhs, double rhs);
  friend bool operator< (const COCINumber & lhs, long double rhs);
  friend bool operator< (int lhs             , const COCINumber & rhs);
  friend bool operator< (unsigned int lhs    , const COCINumber & rhs);
  friend bool operator< (short lhs           , const COCINumber & rhs);
  friend bool operator< (unsigned short lhs  , const COCINumber & rhs);
  friend bool operator< (long lhs            , const COCINumber & rhs);
  friend bool operator< (unsigned long lhs   , const COCINumber & rhs);
  friend bool operator< (float lhs           , const COCINumber & rhs);
  friend bool operator< (double lhs          , const COCINumber & rhs);
  friend bool operator< (long double lhs     , const COCINumber & rhs);

  // Less than or equal
  friend bool operator<= (const COCINumber & lhs, const COCINumber & rhs);
  friend bool operator<= (const COCINumber & lhs, int rhs);
  friend bool operator<= (const COCINumber & lhs, unsigned int rhs);
  friend bool operator<= (const COCINumber & lhs, short rhs);
  friend bool operator<= (const COCINumber & lhs, unsigned short rhs);
  friend bool operator<= (const COCINumber & lhs, long rhs);
  friend bool operator<= (const COCINumber & lhs, unsigned long rhs);
  friend bool operator<= (const COCINumber & lhs, float rhs);
  friend bool operator<= (const COCINumber & lhs, double rhs);
  friend bool operator<= (const COCINumber & lhs, long double rhs);
  friend bool operator<= (int lhs             , const COCINumber & rhs);
  friend bool operator<= (unsigned int lhs    , const COCINumber & rhs);
  friend bool operator<= (short lhs           , const COCINumber & rhs);
  friend bool operator<= (unsigned short lhs  , const COCINumber & rhs);
  friend bool operator<= (long lhs            , const COCINumber & rhs);
  friend bool operator<= (unsigned long lhs   , const COCINumber & rhs);
  friend bool operator<= (float lhs           , const COCINumber & rhs);
  friend bool operator<= (double lhs          , const COCINumber & rhs);
  friend bool operator<= (long double lhs     , const COCINumber & rhs);

    ///////////////////////
  //
  //  Round a number to a specified decimal place
  //
  //  [in]  decplace  number of decimal digits to the right of the 
  //                  decimal point to round to. Negative values 
  //                  are allowed.
  //
  COCINumber & round(sword decplace);

  ///////////////////////
  //
  //  Truncate a number to a specified decimal place
  //
  //  [in]  decplace  number of decimal digits to the right of the 
  //                  decimal point to truncate at. Negative values
  //                  are allowed.
  //
  COCINumber & trunc(sword decplace);

  ///////////////////////
  //
  //  Get the square root of the number
  //
  COCINumber sqrt() const;

  ///////////////////////
  //
  //  Negate the number
  //
  COCINumber & neg();

  ///////////////////////
  //
  //  Get the sign of the number. Return value is 0 if the number is 0, -1
  //  if the number is < 0 and 1 if the number is > 0. If the number is null
  //  then a CEXDatatypeException (eCannotUseNull) exception is thrown.
  //
  sword sign() const;

  ///////////////////////
  //
  //  Set/Check if the number to zero. For IsZero(), if the number is null, a
  //  CEXDatatypeException (eCannotUseNull) exception is thrown.
  //
  COCINumber & set_zero();
  bool is_zero() const;

  ///////////////////////
  //
  //  Raises e to the specified Oracle number power
  //
  COCINumber exp() const;

  ///////////////////////
  //
  //  Rasies the number to the specified power
  //
  //  [in]  power  exponent to which the base is to be raised
  //
  COCINumber power(const COCINumber& power) const;

  ///////////////////////
  //
  //  Takes the number to a given integer power
  //
  //  [in]  exp    exponent to which the base is to be raised
  //
  COCINumber intpower(sword exp) const;

  ///////////////////////
  //
  //  Takes the logarithm with the specified base
  //
  //  [in]  base   base of the logarithm
  //
  COCINumber log(const COCINumber& base) const;

  ///////////////////////
  //
  //  Takes the natural logarithm (base e)
  //
  //  [in]  base   base of the logarithm
  //
  COCINumber ln() const;

  ///////////////////////
  //
  //  Various Trigonometric Functions
  //
  //  sin  - Takes the sine in radians of the number
  //  sinh - Takes the hyperbolic sine in radians of the number
  //  cos  - Takes the cosine in radians of the number
  //  cosh - Takes the hyperbolic cosine in radians of the number
  //  tan  - Takes the tangent in radians of the number
  //  tanh - Takes the hyperbolic tangent in radians of the number
  //  asin - Takes the arc sine in radians of the number
  //  acos - Takes the arc cossine in radians of the number
  //  atan - Takes the arc tangent in radians of the number
  //
  COCINumber sin() const;
  COCINumber sinh() const;
  COCINumber cos() const;
  COCINumber cosh() const;
  COCINumber tan() const;
  COCINumber tanh() const;
  COCINumber asin() const;
  COCINumber acos() const;
  COCINumber atan() const;





  friend sword compare(const COCINumber& lhs, const COCINumber& rhs);


  // Public helper functions
  OCINumber* get_oci_number(){return &m_Number;}
  const COCISession& get_session(){return m_Session;}

  bool is_null();
  void set_null();


private:
  const COCISession& m_Session;
  OCINumber m_Number;
  OCINumber* m_pNumber;

  OCINumber m_Null_Number;

};

#endif