//往数据库中添加赛事，并且返回新被添加的赛事
public static SeasonMatch addNewMatch(string name,string description,int switchNum,int serialNum)
{
SeasonMatch match = new SeasonMatch();
DBUtility dbutility = new DBUtility();
int matchID;
string SQL = "insert into matchinfo(seasonName,description,switchNum,serialNum) values('";
SQL=SQL+name + "','" + description + "'," + switchNum + "," + serialNum + ")";
try
{
dbutility.openConnection();
matchID = dbutility.ExecuteQuery_Last_Insert_ID(SQL);
// dbutility.ExecuteUpdate(SQL);
match.setID(matchID);
match.setName(name);
match.setDescription(description);
match.setSwitchNum(switchNum);
match.setSerialNum(serialNum);
}
catch (MySqlException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
dbutility.Close();
}
return match;
}
