Main | License | Installation | FAQ | Screenshots | Contact | Links | Sf.net | Freshmeat.net | KDE-Apps.org

MySQLNetwork Class Reference
[MySQL C++ Wrappers]

#include <mysqlNetwork.hpp>

Inheritance diagram for MySQLNetwork:

[legend]

Public Member Functions
	MySQLNetwork (const std::string &_userName, const std::string &_passWord, const std::string &_serverName, int _portNumber) throw (Error)
virtual	~MySQLNetwork (void)
const std::string &	getServerName (void) const
int	getPortNumber (void) const
virtual void	connect (const std::string &database, MYSQL *m) throw (Error)
Protected Attributes
std::string	serverName
int	portNumber

---

Detailed Description

Store information for connecting to a MySQL server over the network.

Date:

Sun Feb 19 2006

Author:

Jan Wedekind (wedesoft@users.sourceforge.net)

Definition at line 27 of file mysqlNetwork.hpp.

---

Constructor & Destructor Documentation

MySQLNetwork::MySQLNetwork	(	const std::string &	_userName,
		const std::string &	_passWord,
		const std::string &	_serverName,
		int	_portNumber
	)			throw (Error)

Constructor. Store information for connecting to a MySQL server over the network.

Parameters:

	_userName	Name of database user.
	_passWord	Password of database-user.
	_serverName	Name of the server hosting the database (for example localhost).
	_portNumber	Server-port.

Definition at line 22 of file mysqlNetwork.cpp.

                                                           :
  MySQLServer( _userName, _passWord ), serverName(_serverName),
  portNumber( _portNumber )
{
  connect( "", &connection );
}

MySQLNetwork::~MySQLNetwork

(

void

)

[virtual]

Definition at line 72 of file mysqlNetwork.cpp.

References MySQLServer::connection.

{
  mysql_close( &connection );
}

---

Member Function Documentation

const std::string& MySQLNetwork::getServerName

(

void

)

const [inline]

Definition at line 44 of file mysqlNetwork.hpp.

References serverName.

{ return serverName; }

int MySQLNetwork::getPortNumber

(

void

)

const [inline]

Definition at line 46 of file mysqlNetwork.hpp.

References portNumber.

{ return portNumber; }

void MySQLNetwork::connect	(	const std::string &	database,
		MYSQL *	m
	)			throw (Error) [virtual]

Implements MySQLServer.

Definition at line 33 of file mysqlNetwork.cpp.

References ERRORMACRO.

{
  mysql_init( m );

  const int timeout = 10;// seconds
  mysql_options( m, MYSQL_OPT_CONNECT_TIMEOUT,
                 (const char *)&timeout );

  try {

    // Specifying an alternative port will lead to a crash in the library :-(
    ERRORMACRO( mysql_real_connect( m,
                                    serverName.c_str(), userName.c_str(),
                                    passWord.empty() ? (const char *)NULL :
                                                       passWord.c_str(),
                                    database.empty() ? (const char *)NULL :
                                                       database.c_str(),
                                    portNumber != MYSQL_PORT ? portNumber : 0,
                                    NULL, 0 ),
                Error, , "Error connecting to server '"
                << serverName << "' as user '" << userName << "' "
                << ( passWord.empty() ? "without" : "with" ) << " password: "
                << mysql_error( m ) );

    // Set character-set of connection to UTF-8.
    // If the server is older than MySQL 4.1, the resulting error-message is
    // being ignored.
    mysql_query( m, "SET NAMES utf8;" );

  } catch ( Error &e ) {

    mysql_close( m );
    throw e;

  };
};

---

Field Documentation

std::string MySQLNetwork::serverName [protected]

Definition at line 51 of file mysqlNetwork.hpp.

Referenced by getServerName().

int MySQLNetwork::portNumber [protected]

Definition at line 53 of file mysqlNetwork.hpp.

Referenced by getPortNumber().

---

The documentation for this class was generated from the following files:

• mysqlNetwork.hpp
• mysqlNetwork.cpp

---