mysql 数据库查询测试_如何测试以查看mySql数据库是否正常工作？

我是MySQL数据库的新手，我使用Visual Studio C＃连接到我的数据库。我有一个下面的选择方法。我如何运行它来检查它是否工作？如何测试以查看mySql数据库是否正常工作？

编辑的打开和关闭连接方法

//Open connection to database

private bool OpenConnection()

{

try

{

// connection.open();

return true;

}

catch (MySqlException ex)

{

//When handling errors, your application's response based

//on the error number.

//The two most common error numbers when connecting are as follows:

//0: Cannot connect to server.

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

switch (ex.Number)

{

case 0:

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

break;

case 1045:

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

break;

}

return false;

}

}

//Close connection

private bool CloseConnection()

{

try

{

connection.Close();

return true;

}

catch (MySqlException ex)

{

MessageBox.Show(ex.Message);

return false;

}

}

选择方法，该方法是在同一类作为关闭和打开连接如上所示

public List[] Select()

{

string query = "SELECT * FROM Questions";

//Create a list to store the result

List[] list = new List[3];

list[0] = new List();

list[1] = new List();

list[2] = new List();

list[3] = new List();

list[4] = new List();

list[5] = new List();

list[6] = new List();

list[7] = new List();

//Open connection

if (this.OpenConnection() == true)

{

//Create Command

MySqlCommand cmd = new MySqlCommand(query, connection);

//Create a data reader and Execute the command

MySqlDataReader dataReader = cmd.ExecuteReader();

//Read the data and store them in the list

while (dataReader.Read())

{

list[0].Add(dataReader["id"] + "");

list[1].Add(dataReader["difficulty"] + "");

list[2].Add(dataReader["qustions"] + "");

list[3].Add(dataReader["c_answer"] + "");

list[4].Add(dataReader["choiceA"] + "");

list[5].Add(dataReader["choiceB"] + "");

list[6].Add(dataReader["choiceC"] + "");

list[7].Add(dataReader["choiceD"] + "");

}

//close Data Reader

dataReader.Close();

//close Connection

this.CloseConnection();

//return list to be displayed

return list;

}

else

{

return list;

}

}

此方法是在一个单独的已获得所有数据库连接设置的类。现在我想从我的主类调用这个方法来测试它是否工作，我该怎么做？