library: libCore #include "TSQLServer.h"

# TSQLServer

class description - source file - inheritance tree (.pdf)

## class TSQLServer : public TObject

| Inheritance Chart:

`TObject`

<-

`TSQLServer`

This is an abstract class, constructors will not be documented.
Look at the header to check for available constructors.

        public:

                      virtual ~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
                  TSQLServer& operator=(const TSQLServer&)
          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 ~TSQLServer()
                   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)
            TSQLServer& operator=(const TSQLServer&)

Author: Fons Rademakers 25/11/99
Last update: root/net:$Name: $:$Id: TSQLServer.cxx,v 1.8 2005/06/23 06:24:27 brun Exp $
Copyright (C) 1995-2000, Rene Brun and Fons Rademakers. *