//获取球队信息
public static Team getTeamInfo(string teamName)
{
Team team = new Team();
//执行查询数据库操作
DBUtility dbutility = new DBUtility();
string SQL = "select ID,teamName,teamLeader,teamManager,teamCoach from player where teamName='" + teamName+"'";
try
{
dbutility.openConnection();
MySqlDataReader rd = dbutility.ExecuteQuery(SQL);
while (rd.Read())
{
team.setID(Convert.ToInt32(rd[0]));
team.setName(Convert.ToString(rd[1]));
team.setLeader(Convert.ToString(rd[2]));
team.setManager(Convert.ToString(rd[3]));
team.setCoach(Convert.ToString(rd[4]));
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return team;
}
