C# 클래스 ALFA.MySQLDatabaseInternal

This wrapper class shields callers of MySQLDatabase from needing to immediately demand that the MySql.Data.dll assembly be loaded.

상속: IDisposable

파일 보기 프로젝트 열기: ALandFarAway/ALFA-Base-Resources 1 사용 예제들

공개 메소드들

메소드	설명
ACR_SQLEncodeSpecialChars ( string s ) : string	This routine escapes characters for a SQL query.
ACR_SQLExecute ( string SQL ) : void	This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first. The query must not return any results.
ACR_SQLFetch ( ) : bool	This routine fetches the next rowset from the database.
ACR_SQLGetAffectedRows ( ) : int	This routine returns the number of rows affected by a query.
ACR_SQLGetData ( ) : string	This routine returns the first column of data from the current SQL rowset.
ACR_SQLGetData ( int ColumnIndex ) : string	This routine returns the specified column of data from the current SQL rowset.
ACR_SQLQuery ( string SQL ) : void	This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first.
Dispose ( ) : void	Dispose the object.

비공개 메소드들

메소드	설명
ACR_SQLNextResult ( ) : bool	This routine advances to the next result set of a multi-result query.
ConnectDatabase ( ) : void	Connect a dedicated connection to the database.
Dispose ( bool Disposing ) : void	Dispose the object.
MySQLDatabaseInternal ( string ConnectionString = null, bool Dedicated = false ) : System	Create a new MySQLDatabaseInternal object.
PrepareSQL ( string SQL ) : string	Prepare a query string for execution. Currently, this prepends a USE DatabaseName; statement to improve latency (see discussion below with DatabaseName).
SetupConnectionString ( ) : void	This method sets up the database connection string based on the default connection information set for the MySQL plugin. The pool size of 3 is based on : - One connection for polling for input by the GameWorldManager synchronization thread. - One connection for background ad-hoc queries kicked off by the server communicator on work items (account record lookup, etc.). - One connection for miscellaneous use.

메소드 상세

ACR_SQLEncodeSpecialChars() 공개 메소드

This routine escapes characters for a SQL query.

public ACR_SQLEncodeSpecialChars ( string s ) : string
s	string	Supplies the string to escape.
리턴	string

ACR_SQLExecute() 공개 메소드

This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first. The query must not return any results.

public ACR_SQLExecute ( string SQL ) : void
SQL	string	Supplies the SQL query text to execute.
리턴	void

ACR_SQLFetch() 공개 메소드

This routine fetches the next rowset from the database.

public ACR_SQLFetch ( ) : bool
리턴	bool

ACR_SQLGetAffectedRows() 공개 메소드

This routine returns the number of rows affected by a query.

public ACR_SQLGetAffectedRows ( ) : int
리턴	int

ACR_SQLGetData() 공개 메소드

This routine returns the first column of data from the current SQL rowset.

public ACR_SQLGetData ( ) : string
리턴	string

ACR_SQLGetData() 공개 메소드

This routine returns the specified column of data from the current SQL rowset.

public ACR_SQLGetData ( int ColumnIndex ) : string
ColumnIndex	int	Supplies the zero-based column index to /// retrieve.
리턴	string

ACR_SQLQuery() 공개 메소드

This routine performs a synchronous SQL query. If there were pending asynchronous queries in the queue, the pending queries are drained first.

public ACR_SQLQuery ( string SQL ) : void
SQL	string	Supplies the SQL query text to execute.
리턴	void

Dispose() 공개 메소드

Dispose the object.

public Dispose ( ) : void
리턴	void