C#(三十二) —— 使用list集合封装多个同类型对象

using StudengManage.Models;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;

namespace StudengManage.DAL
{
    public class StudentService
    {
        public int addStudent(Student student)
        {
            string insertSql = "insert into Student(StudentId,StudentName,Gender,Birthday,studentIdNo,Age,PhoneNumber,StudentAddress,ClassId) " +
                "values({0},'{1}','{2}','{3}',{4},{5},'{6}','{7}',{8})";
            insertSql = string.Format(insertSql, student.StudentId, student.StudentName, student.Gender, student.Birthday, student.studentIdNo, student.Age
                , student.PhoneNumber, student.StudentAddress, student.ClassId);
            return SqlHelper.add(insertSql);
        }

        public Student queryStudentById(int stuId)
        {
            string querySql = "select * from Student where StudentId = {0}";
            querySql = string.Format(querySql, stuId);
            SqlDataReader sqlData = SqlHelper.query(querySql);
            Student stu = null;
            if (sqlData.Read())
            {
                stu = new Student()
                {
                    StudentName = sqlData["StudentName"].ToString(),
                    Birthday = Convert.ToDateTime(sqlData["Birthday"].ToString())

                };
            }
            sqlData.Close();
            return stu;

        }

        public List<Student> queryAllStudens()
        {
            string querySql = "select studentid,studentname,gender,birthday from student";
            SqlDataReader sqlData = SqlHelper.query(querySql);
            List<Student> list = new List<Student>();
            while (sqlData.Read())
            {
                //注意此处的添加部分的处理
                list.Add(new Student()
                {
                    StudentName = sqlData["StudentName"].ToString(),
                    Birthday = Convert.ToDateTime(sqlData["Birthday"].ToString())

                });

            }
            sqlData.Close();
            return list;
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;

namespace StudengManage.DAL
{
   public class SqlHelper
    {
        private static string connStr = "server = localhost;database = MyPhoneList; uid = 123; pwd = 123;";

        public static int add(string sql) {
            //连接对象
            SqlConnection sqlCon = new SqlConnection(connStr);
            //操作对象
            SqlCommand sqlCom = new SqlCommand(sql, sqlCon);
            //打开连接
            sqlCon.Open();
            //执行操作
            int result = sqlCom.ExecuteNonQuery();
            //关闭连接
            sqlCon.Close();
            //返回结果
            return result;
        }

        public static SqlDataReader query(string sql) {
            //连接对象
            SqlConnection sqlCon = new SqlConnection(connStr);
            //操作对象
            SqlCommand sqlcom = new SqlCommand(sql, sqlCon);
            //打开连接
            sqlCon.Open();
            //执行查找
            SqlDataReader sqlData = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
            return sqlData;
            
        }
    }
}

using System;

namespace StudengManage.Models
{
    public class Student
    {
        //学号
        public int StudentId { get; set; }
        public string StudentName { get; set; }
        public string Gender { get; set; }
        public DateTime Birthday { get; set; }
        //身份证号
        public decimal studentIdNo { get; set; }
        public int Age { get; set; }
        public string PhoneNumber { get; set; }
        public string StudentAddress { get; set; }
        public int ClassId { get; set; }

    }
}

using StudengManage.DAL;
using StudengManage.Models;
using System;
using System.Collections.Generic;

namespace StudengManage
{
    internal class Program
    {
        private static void Main(string[] args)
        {
            生成学生对象
            //Student stu = new Student();
            用户输入信息
            //Console.WriteLine("请输入学员学号：");
            //stu.StudentId = Convert.ToInt32(Console.ReadLine());
            //Console.WriteLine("请输入学员姓名：");
            //stu.StudentName = Console.ReadLine();
            //Console.WriteLine("请输入学员性别：");
            //stu.Gender = Console.ReadLine();
            //Console.WriteLine("请输入学员生日：");
            //stu.Birthday = Convert.ToDateTime(Console.ReadLine());
            //Console.WriteLine("请输入学员身份证号：");
            //stu.studentIdNo = Convert.ToInt64(Console.ReadLine());
            //Console.WriteLine("请输入学员年龄：");
            //stu.Age = Convert.ToInt32(Console.ReadLine());
            //Console.WriteLine("请输入学员联系方式：");
            //stu.PhoneNumber = Console.ReadLine();
            //Console.WriteLine("请输入学员地址：");
            //stu.StudentAddress = Console.ReadLine();
            //Console.WriteLine("请输入学员班级号：");
            //stu.ClassId = Convert.ToInt32(Console.ReadLine());
            进行添加
            //int result = new StudentService().addStudent(stu);
            //Console.WriteLine(result == 1 ? "成功" : "失败");

            StudentService stuSer = new StudentService();
            //Student stu = stuSer.queryStudentById(12345678);
            //Console.WriteLine(stu.StudentName);

            //使用list集合封装多个同类型对象
            List<Student> list = stuSer.queryAllStudens();
            foreach (Student stu in list)
            {
                Console.WriteLine("学生姓名：" + stu.StudentName + "\t学生学号" + stu.StudentId);
            }



            Console.ReadLine();
        }
    }
}