1 public List<Student> GetAllStudent()
2 {
3 string sql = "select StudentName,Birthday,StudentAddress,ClassId from Students";
4 SqlDataReader objReader=SQLHelper.getReader(sql);
5 List<Student> stuList = new List<Student>();
6 while (objReader.Read())
7 {
8 //封装对象
9 Student objStu = new Student()
10 {
11 StudentName = objReader["StudentName"].ToString(),
12 Birthday = Convert.ToDateTime(objReader["Birthday"]),
13 StudentAddress = objReader["StudentAddress"].ToString(),
14 ClassId = Convert.ToInt16(objReader["ClassId"])
15 };
16 stuList.Add(objStu);
17 }
18 objReader.Close();
19 return stuList;
20 }
1 static void Main(string[] args)
2 {
3 StudentService objstuService = new StudentService();
4 List<Student> stuList = objstuService.GetAllStudent();
5 if (stuList.Count != 0)
6 {
7 foreach (Student item in stuList )
8 Console.WriteLine(item.StudentName+" "+item.Birthday+" "+item.StudentAddress+" "+item.ClassId);
9 }
10 else
11 Console.WriteLine("没有要显示的数据");
12 Console.ReadLine();
13
14 }
