TSQLServer


class description - source file - inheritance tree

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.                          
                                                                      


TSQLServer* Connect(const char *db, const char *uid, const char *pw)
 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()


Author: Fons Rademakers 25/11/99
Last update: root/net:$Name: $:$Id: TSQLServer.cxx,v 1.5 2002/07/16 13:59:19 rdm Exp $
Copyright (C) 1995-2000, Rene Brun and Fons Rademakers. *


ROOT page - Class index - Top of the page

This page has been automatically generated. If you have any comments or suggestions about the page layout send a mail to ROOT support, or contact the developers with any questions or problems regarding ROOT.