Beispiel #1
0
        public static void AddStudent()
        {
            Console.WriteLine("是否添加一列,Y/N");
            Console.WriteLine("请输入姓名:");
            var name = Console.ReadLine();

            Console.WriteLine("请输入性别:");
            var sex = Console.ReadLine();

            Console.WriteLine("请输入年龄:");
            int age;

            while (!int.TryParse(Console.ReadLine(), out age))
            {
                Console.WriteLine("输入有效的年龄");
            }
            Console.WriteLine("请输入密码:");
            var pwd = Console.ReadLine();
            var stu = new Students()
            {
                stu_Name = name, stu_sex = sex, stu_age = age, stu_Pwd = pwd
            };

            if (iStudentDA.AddStudents(stu))
            {
                Console.WriteLine("添加成功");
                GetAllStudent();
                Console.WriteLine("是否继续添加,Y/N");
                if (Console.ReadLine() == "Y")
                {
                    Console.WriteLine("请选择对应的数据库操作:A(数据库1),B(数据库2)");
                    var key01 = Console.ReadLine();
                    if (key01 == "A")
                    {
                        iStudentDA = new StudentManage("StuAndCourse");
                    }
                    else if (key01 == "B")
                    {
                        iStudentDA = new StudentManage("StuAndCourse_Copy1");
                    }
                    else
                    {
                        Console.WriteLine("没有对应的数据库操作!");
                        Console.ReadKey();
                    }
                    AddStudent();
                }
            }
            else
            {
                Console.WriteLine("添加失败");
            }
        }
Beispiel #2
0
        static void Main(string[] args)
        {
            Console.WriteLine("请选择对应的数据库操作:A(数据库1),B(数据库2)");
            var key01 = Console.ReadLine();

            if (key01 == "A")
            {
                iStudentDA = new StudentManage("StuAndCourse");
            }
            else if (key01 == "B")
            {
                iStudentDA = new StudentManage("StuAndCourse_Copy1");
            }
            else
            {
                Console.WriteLine("没有对应的数据库操作!");
                Console.ReadKey();
            }
            GetAllStudent();
            Console.WriteLine("请选择操作,I(添加),U(更新),D(删除),Q(查询所有)");
            var key        = Console.ReadLine();
            var isContinue = true;

            while (isContinue)
            {
                if (key == "I")
                {
                    AddStudent();
                }
                else if (key == "U")
                {
                    UpdateStudent();
                }
                else if (key == "D")
                {
                    DeleteStudent();
                }
                else if (key == "Q")
                {
                    GetAllStudent();
                }
                else
                {
                    Console.WriteLine("输入的操作不合法,请重新输入");
                    isContinue = true;
                }
                isContinue = false;
            }
        }
Beispiel #3
0
        public static void DeleteStudent()
        {
            Console.WriteLine("请输入删除的对象ID");
            int id;

            while (!int.TryParse(Console.ReadLine(), out id))
            {
                Console.WriteLine("ID无效");
            }
            try
            {
                if (iStudentDA.DeleteStudents(id))
                {
                    Console.WriteLine("删除成功");
                    GetAllStudent();
                    Console.WriteLine("是否继续删除,Y/N");
                    if (Console.ReadLine() == "Y")
                    {
                        Console.WriteLine("请选择对应的数据库操作:A(数据库1),B(数据库2)");
                        var key01 = Console.ReadLine();
                        if (key01 == "A")
                        {
                            iStudentDA = new StudentManage("StuAndCourse");
                        }
                        else if (key01 == "B")
                        {
                            iStudentDA = new StudentManage("StuAndCourse_Copy1");
                        }
                        else
                        {
                            Console.WriteLine("没有对应的数据库操作!");
                            Console.ReadKey();
                        }
                        DeleteStudent();
                    }
                }
                else
                {
                    Console.WriteLine("删除失败");
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("删除失败,{0}", ex.Message);
                GetAllStudent();
            }
        }
Beispiel #4
0
        public static void UpdateStudent()
        {
            Console.WriteLine("请输入要更新的对象ID");
            int id;

            while (int.TryParse(Console.ReadLine(), out id))
            {
                if (iStudentDA.GetById(id) == null)
                {
                    Console.WriteLine("更新失败,不存在此对象,请重新输入");
                    continue;
                }
                Console.WriteLine("ID无效");
                Console.WriteLine("请输入姓名:");
                var name = Console.ReadLine();
                Console.WriteLine("请输入性别:");
                var sex = Console.ReadLine();
                Console.WriteLine("请输入年龄:");
                int age;
                while (!int.TryParse(Console.ReadLine(), out age))
                {
                    Console.WriteLine("输入有效的年龄");
                }
                Console.WriteLine("请输入密码:");
                var pwd = Console.ReadLine();
                var stu = new Students()
                {
                    ID = id, stu_Name = name, stu_sex = sex, stu_age = age, stu_Pwd = pwd
                };
                try
                {
                    if (iStudentDA.UpdateStudents(stu))
                    {
                        Console.WriteLine("更新成功");
                        GetAllStudent();
                        Console.WriteLine("是否继续更新,Y/N");
                        if (Console.ReadLine() == "Y")
                        {
                            Console.WriteLine("请选择对应的数据库操作:A(数据库1),B(数据库2)");
                            var key01 = Console.ReadLine();
                            if (key01 == "A")
                            {
                                iStudentDA = new StudentManage("StuAndCourse");
                            }
                            else if (key01 == "B")
                            {
                                iStudentDA = new StudentManage("StuAndCourse_Copy1");
                            }
                            else
                            {
                                Console.WriteLine("没有对应的数据库操作!");
                                Console.ReadKey();
                            }
                            UpdateStudent();
                        }
                    }
                    else
                    {
                        Console.WriteLine("更新失败");
                    }
                }
                catch (Exception ex)
                {
                    Console.WriteLine("更新失败,{0}", ex.Message);
                }
            }
        }