public void initBus() { MysqlUtil mysql = new MysqlUtil(); mysql.GetConnection(); var rdr = mysql.ReadData("SELECT * FROM businfo;"); busLinkList = new LinkList <Bus>(); if (rdr.HasRows) { //busList = new List<Bus>(); while (rdr.Read()) { Console.WriteLine("{0} {1} {2}", rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetString(2)); Bus bus = new Bus(); bus.ID = rdr.GetInt32(0); bus.BusNo = rdr.GetInt32(1); //busList.Add(bus); busLinkList.Add(bus); } } mysql.Close(); }
public void initManager() { MysqlUtil mysql = new MysqlUtil(); mysql.GetConnection(); var rdr = mysql.ReadData("SELECT * FROM manager;"); managerLinkLists = new LinkList <ManagerAccount>(); if (rdr.HasRows) { //managerLists = new List<ManagerAccount>(); while (rdr.Read()) { Console.WriteLine("{0} {1} {2} {3}", rdr.GetInt32(0), rdr.GetString(1), rdr.GetString(2), rdr.GetString(3)); ManagerAccount manager = new ManagerAccount(); manager.ID = rdr.GetInt32(0); manager.Username = rdr.GetString(1); manager.Password = rdr.GetString(2); manager.Level = rdr.GetInt32(3); //managerLists.Add(manager); managerLinkLists.Add(manager); } } mysql.Close(); }
public void initStation() { MysqlUtil mysql = new MysqlUtil(); mysql.GetConnection(); var rdr = mysql.ReadData("SELECT * FROM station;"); stationLinkList = new LinkList <Station>(); if (rdr.HasRows) { //stationList = new List<Station>(); while (rdr.Read()) { Console.WriteLine("{0} {1} {2}", rdr.GetInt32(0), rdr.GetString(1), rdr.GetInt32(2)); Station station = new Station(); station.ID = rdr.GetInt32(0); station.Name = rdr.GetString(1); station.Distance = rdr.GetInt32(2); //stationList.Add(station); stationLinkList.Add(station); } } mysql.Close(); }