数据库第十四章上机练习4

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace ConsoleApplication4
{
    class Program
    {
        static void Main(string[] args)
        {
            Program a = new Program();
            a.a();
            Console.ReadLine();
        }
        private const string strconn = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";
        public void a()
        {
            Console.WriteLine("请输入用户名:");
            string name = Console.ReadLine();
            Console.WriteLine("请输入密码:");
            string pwd=Console.ReadLine();
            string msg = string.Empty;
            bool ret =show(name, pwd);
            if (ret)
            {
                Console.WriteLine("登录成功！");
                Show();
            }
            else
            {
                Console.WriteLine("登录失败：" + msg);
            }
        }
        public void Show()
        {
            string option = "";
            do
            {
                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("=================================");
                option = Console.ReadLine();
                switch (option)
                {
                    case "1":
                        continue;
                    case "2":
                        continue;
                    case "3":
                        continue;
                    case "4":
                        continue;
                    case "5":
                        continue;
                    case "6":
                        continue;
                    case "7":
                        continue;
                    case "0":
                        break;
                    default:
                        continue;
                }
                break;
            } while (true);
        }


        public bool show(string name, string pass)
        {
            SqlConnection con = new SqlConnection(strconn);
            try
            {
                con.Open();
                string ss = @"SELECT COUNT(*) AS 个数 FROM [MySchool].[dbo].[Admin]
                 where LoginId= " + name + " and LoginPwd=" + pass + "";
                SqlCommand comm = new SqlCommand(ss, con);
                int i = (int)comm.ExecuteScalar();
                if (i > 0)
                {
                    return true;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                con.Close();
            }

            return false;
         
    }

    }
}