c# mysql慢_C＃ - 爲什麼我的服務器中的MySQL服務器速度很慢？

class DBConnect public MySqlConnection connection; 私人字符串服務器; 私人字符串數據庫; 私人字符串uid; 私人字符串密碼;

//Constructor

public DBConnect()

{

Initialize();

}

//Initialize values

public void Initialize()

{

server = "localhost";

database = "db_sea_horses";

uid = "root";

password = " " ;

//password = "123";

string connectionString;

connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

connection = new MySqlConnection(connectionString);

}

//open connection to database

public bool OpenConnection()

{

try

{

connection.Open();

return true;

}

catch (MySqlException ex)

{ //0: Cannot connect to server.

//1045: Invalid user name and/or password.

switch (ex.Number)

{

case 0:

MessageBox.Show("Cannot connect to server. Contact administrator");

break;

case 1045:

MessageBox.Show("Invalid username/password, please try again");

break;

}

return false;

}

}

//Close connection

public bool CloseConnection()

{

try

{

connection.Close();

return true;

}

catch (MySqlException ex)

{

MessageBox.Show(ex.Message);

return false;

}

}

}

類DBmethods：DBCONNECT { 數據集dataset2;

public void input_sql(string query)

{

try

{

//open connection

if (this.OpenConnection() == true)

{

//create command and assign the query and connection from the constructor

MySqlCommand cmd = new MySqlCommand(query, connection);

//Execute command

int x = cmd.ExecuteNonQuery();

//close connection

this.CloseConnection();

}

}

catch(MySqlException myex)

{

MessageBox.Show(ex.Message);

}

}

///

/ select

/

public DataSet output_sql(string query,String table_name)

{

//Open connection

this.OpenConnection();

DataSet dataset = new DataSet();

MySqlDataAdapter adapter = new MySqlDataAdapter();

adapter.SelectCommand = new MySqlCommand(query, connection);

adapter.Fill(dataset, table_name);

//close Connection

this.CloseConnection();

//return list to be displayed

return dataset;

}

}

}

方法調用示例

1)插入/更新/刪除語句

DBmethods DBM =新DBmethods(); dbm。input_sql(「你可以執行插入/更新/刪除查詢」);

2)選擇語句

的DataSet DS = dbm.output_sql( ' 「 」storage_bunkers「) 」從那裏JOB_ID LIKE + itemname.Text +％「 ％storage_bunkers選擇*」'; DataView myView =((DataTable)ds.Tables [「storage_bunkers」])。DefaultView; dataGridView1.DataSource = myView;