////////获取当前赛事的球队信息 /* * 查询数据库中的球队的基本信息,并且返回到一个线性表中 */ public static List<Schedule> getScheduleInfo(SeasonOfMatch season) { //声明实例 List<Schedule> list = new List<Schedule>(); //执行查询数据库操作 DBUtility dbutility = new DBUtility(); string SQL = "select seasonId,matchId,turn,gameDate,homeTeamName,guestTeamName from schedule where seasonId= " + season.getNumOfSeason(); try { dbutility.openConnection(); MySqlDataReader rd = dbutility.ExecuteQuery(SQL); while (rd.Read()) { Schedule s = new Schedule(); s.setSeasonId(Convert.ToInt32(rd[0])); s.setMatchId(Convert.ToInt32(rd[1])); s.setTurn(Convert.ToInt32(rd[2])); s.setGameDate(Convert.ToString(rd[3])); s.setHomeTeam(Convert.ToString(rd[4])); s.setGuestTeam(Convert.ToString(rd[5])); list.Add(s); } } catch (MySqlException ex) { Console.WriteLine(ex.ToString()); } finally { dbutility.Close(); } return list; }
//显示赛事的基本信息 public void showSeasonData() { //先清除DataGridView中的数据 if (dataGridView_seasons.Rows.Count > 0) { dataGridView_seasons.Rows.Clear(); } //取出数据 //此处应该判断一下当前选择赛事与赛季没有 List<SeasonOfMatch> list = SeasonInfoDAO.getSeasonsOfCertainMatch(SystemParam.getMatch().getName()); //往dataGridView中添加数据 for (int i = 0; i < list.Count; i++) { season = list[i]; //取出线性表中的赛事的信息 dataGridView_seasons.Rows.Add(season.getId().ToString(), season.getmatchName(), season.getSeasonDescription(), season.getNumOfSeason().ToString() ); } }
/**** *** 新增某一个赛季的信息 ****/ public static void addNewSeasonInfo(SeasonOfMatch season) { DBUtility dbutility = new DBUtility(); string sql = "insert into gameseason(id,matchname,numofseason,seasondescription,isCurrentSeason,numOfTurn) values('" + season.getId() +"','" + season.getmatchName() + "','" + season.getNumOfSeason() + "','" + season.getSeasonDescription() + "',"+1+","+season.getNumOfTurn()+")"; try { dbutility.openConnection(); dbutility.ExecuteUpdate(sql); } catch (MySqlException ex) { Console.WriteLine(ex.ToString()); } finally { dbutility.Close(); } }