C# Class KBS2.Handlers.DatabaseHandler

Afficher le fichier Open project: Railec/SE1cKBS2 Class Usage Examples

Méthodes publiques

Méthode	Description
DeleteSQL ( string tablename, string colummname, string value ) : void
GetInstance ( ) : DatabaseHandler
InsertSql ( string tablename, string value ) : long
SelectSQL ( string query ) : DataTable
SelectSingleSQL ( string query ) : object
Sql ( string query ) : long
UpdateSQL ( string tableName, string colummname, string value ) : void
getConnection ( ) : MySqlConnection
getReader ( String query ) : MySqlDataReader

Private Methods

Méthode	Description
DatabaseHandler ( ) : System
KeyWord ( string query ) : string

Method Details

DeleteSQL() public méthode

public DeleteSQL ( string tablename, string colummname, string value ) : void
tablename	string	The string with the name of the table in it.
colummname	string
value	string	The string with the value of the column name in it.
Résultat	void

GetInstance() public static méthode

public static GetInstance ( ) : DatabaseHandler
Résultat	DatabaseHandler

InsertSql() public méthode

public InsertSql ( string tablename, string value ) : long
tablename	string	The string with the name of the table in it.
value	string	The string with the value of the column name in it.
Résultat	long

SelectSQL() public méthode

public SelectSQL ( string query ) : DataTable
query	string	The string with the query in it.
Résultat	System.Data.DataTable

SelectSingleSQL() public méthode

public SelectSingleSQL ( string query ) : object
query	string	The string with the query in it.
Résultat	object

Sql() public méthode

public Sql ( string query ) : long
query	string	The string with the query in it, which is being excecuted.
Résultat	long

UpdateSQL() public méthode

public UpdateSQL ( string tableName, string colummname, string value ) : void
tableName	string
colummname	string
value	string	The string with the value of the column name in it.
Résultat	void

getConnection() public méthode

public getConnection ( ) : MySqlConnection
Résultat	MySql.Data.MySqlClient.MySqlConnection

getReader() public méthode

public getReader ( String query ) : MySqlDataReader
query	String
Résultat	MySql.Data.MySqlClient.MySqlDataReader