C# Class KBS2.Handlers.DatabaseHandler

ファイルを表示 Open project: Railec/SE1cKBS2 Class Usage Examples

Public Methods

Method	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

Method	Description
DatabaseHandler ( ) : System
KeyWord ( string query ) : string

Method Details

DeleteSQL() public method

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.
return	void

GetInstance() public static method

public static GetInstance ( ) : DatabaseHandler
return	DatabaseHandler

InsertSql() public method

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.
return	long

SelectSQL() public method

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

SelectSingleSQL() public method

public SelectSingleSQL ( string query ) : object
query	string	The string with the query in it.
return	object

Sql() public method

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

UpdateSQL() public method

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.
return	void

getConnection() public method

public getConnection ( ) : MySqlConnection
return	MySql.Data.MySqlClient.MySqlConnection

getReader() public method

public getReader ( String query ) : MySqlDataReader
query	String
return	MySql.Data.MySqlClient.MySqlDataReader