实现MySchoolBase

最新推荐文章于 2021-03-05 16:11:53 发布

可爱的黄油手

最新推荐文章于 2021-03-05 16:11:53 发布

阅读量5.8k

点赞数 6

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/gengzhi1293443962/article/details/53393060

本文介绍了一个简单的学校管理系统的设计与实现，该系统使用C#语言开发，包括登录验证功能及基本的学生信息管理操作，如统计学生人数等。

class DBOperation
    {
        string a = "Data Source=.;Initial Catalog=MySchool;User ID=bdqn;Password=123";
        public bool CheckUserInfo(string name,string pwd) {
            bool b = true;
            SqlConnection conn = new SqlConnection(a);
            try
            {
                string str = "select count(*) from Admin where LoginId='" + name + "' and LoginPwd='" + pwd + "'";
                Console.WriteLine(str);
                conn.Open();
                SqlCommand comm = new SqlCommand(str, conn);
                int iRet = (int)comm.ExecuteScalar();
                if (iRet == 1)
                {
                    b = true;
                }
                else {

                    b = false;
                }

            }
            catch (Exception)
            {
                Console.WriteLine("发生异常");


            }
            finally {

                conn.Close();
            
            }




            return b;
        
        }


        public int GetStudentAmount() {

            SqlConnection conn = new SqlConnection(a);
            try
            {
                string strsql = "select count(*) from Student";
                conn.Open();
                SqlCommand comm = new SqlCommand(strsql, conn);
                int iRet = (int)comm.ExecuteScalar();
                return iRet;
            }
            catch (Exception)
            {
                return -1;

                throw;
            }
            finally {

                conn.Close();
            }
        
        
        
        }

    }
class SchoolManager
    {
        DBOperation d = new DBOperation();
        public void Login() {
            Console.WriteLine("请输入用户名:");
            string name = Console.ReadLine();
            Console.WriteLine("请输入密码:");
            string pwd = Console.ReadLine();
            bool r = d.CheckUserInfo(name, pwd);
            if (r)
            {

                Console.WriteLine("登陆成功!");
                caidan();
            }
            else {

                Console.WriteLine("登陆失败!");
            
            }
        
        }
        public void caidan() {
            Console.WriteLine("=================请选择操作数==================");
            Console.WriteLine("1. 统计学生人数");
            Console.WriteLine("2. 查看学生名单");
            Console.WriteLine("3. 按单号查询学生的姓名");
            Console.WriteLine("4. 按姓名查询学生信息");
            Console.WriteLine("5. 修改学生的出生日期");
            Console.WriteLine("6. 删除学生记录");
            Console.WriteLine("7. 新增年级记录");
            Console.WriteLine("0.退出");
            Console.WriteLine("===============================================");
            int z = int.Parse(Console.ReadLine());
            switch(z){
                case 1:
                    Console.WriteLine("在校学生人数:" +d.GetStudentAmount());
                    caidan();
                    break;
                case 2:
                    caidan();
                    break;
                case 3:
                    caidan();
                    break;
                case 4:
                    caidan();
                    break;
                case 5:
                    caidan();
                    break;
                case 6:
                    caidan();
                    break;
                case 7:
                    caidan();
                    break;
                case 0:
                    Console.WriteLine("谢谢使用");
                    break;
                default:
                    Console.WriteLine("输入错误");
                    break;
            
            
            
            
            
            
            }
        
        
        
        
        
        }
}

 static void Main(string[] args)
        {
            SchoolManager s = new SchoolManager();
            s.Login();
            Console.ReadLine();





        }