110,534
社区成员
发帖
与我相关
我的任务
分享
public static ArrayList getReferee1()
{
MySqlConnection myconn = new MySqlConnection(strcon);
myconn.Open();
MySqlCommand cmd = new MySqlCommand("select email from referee1", myconn);
MySqlDataReader reader = cmd.ExecuteReader();
ArrayList al = new ArrayList();
try
{
if (reader.HasRows)
{
while (reader.Read())
{
al.Add(reader["email"].ToString());
}
}
return al;
}
catch (Exception)
{
return null;
}
finally
{
myconn.Close();
}
}
finally
{
if(myconn != null)//请加这个判断
{
myconn.Close();
}
}
finally
{
reader.Close();
cmd.Dispose();
myconn.Dispose();
myconn.Close();
}