TSQLServer

class TSQLServer : public TObject

    public:

             virtual void ~TSQLServer()
           static TClass* Class()
             virtual void Close(Option_t* option)
       static TSQLServer* Connect(const char* db, const char* uid, const char* pw)
            virtual Int_t CreateDataBase(const char* dbname)
            virtual Int_t DropDataBase(const char* dbname)
      virtual TSQLResult* GetColumns(const char* dbname, const char* table, const char* wild = "0")
      virtual TSQLResult* GetDataBases(const char* wild = "0")
              const char* GetDBMS() const
              const char* GetHost() const
                    Int_t GetPort() const
      virtual TSQLResult* GetTables(const char* dbname, const char* wild = "0")
          virtual TClass* IsA() const
                   Bool_t IsConnected() const
      virtual TSQLResult* Query(const char* sql)
            virtual Int_t Reload()
            virtual Int_t SelectDataBase(const char* dbname)
      virtual const char* ServerInfo() const
             virtual void ShowMembers(TMemberInspector& insp, char* parent)
            virtual Int_t Shutdown()
             virtual void Streamer(TBuffer& b)
                     void StreamerNVirtual(TBuffer& b)

Data Members

    protected:

      TString fType  type of DBMS (MySQL, Oracle, SysBase, ...)
      TString fHost  host to which we are connected
      TString fDB    currently selected DB
        Int_t fPort  port to which we are connected

Class Description

                                                                      
 TSQLServer                                                           
                                                                      
 Abstract base class defining interface to a SQL server.              
                                                                      
 To open a connection to a server use the static method Connect().    
 The db argument of Connect() is of the form:                         
    <dbms>://<host>[:<port>][/<database>], e.g.                       
 mysql://pcroot.cern.ch:3456/test, oracle://srv1.cern.ch/main, ...    
 Depending on the <dbms> specified an appropriate plugin library      
 will be loaded which will provide the real interface.                
                                                                      
 Related classes are TSQLResult and TSQLRow.                          
                                                                      

 The db should be of the form:  <dbms>://<host>[:<port>][/<database>],
 e.g.:  mysql://pcroot.cern.ch:3456/test, oracle://srv1.cern.ch/main,
 pgsql://... or sapdb://...
 The uid is the username and pw the password that should be used for
 the connection. Depending on the <dbms> the shared library (plugin)
 for the selected system will be loaded. When the connection could not
 be opened 0 is returned.

Inline Functions

               void Close(Option_t* option)
        TSQLResult* Query(const char* sql)
              Int_t SelectDataBase(const char* dbname)
        TSQLResult* GetDataBases(const char* wild = "0")
        TSQLResult* GetTables(const char* dbname, const char* wild = "0")
        TSQLResult* GetColumns(const char* dbname, const char* table, const char* wild = "0")
              Int_t CreateDataBase(const char* dbname)
              Int_t DropDataBase(const char* dbname)
              Int_t Reload()
              Int_t Shutdown()
        const char* ServerInfo() const
             Bool_t IsConnected() const
        const char* GetDBMS() const
        const char* GetHost() const
              Int_t GetPort() const
            TClass* Class()
            TClass* IsA() const
               void ShowMembers(TMemberInspector& insp, char* parent)
               void Streamer(TBuffer& b)
               void StreamerNVirtual(TBuffer& b)
               void ~TSQLServer()