C#第十四章使用ADO.NET查询和操作数据上机练习1-5

C#第十四章上机练习1-5

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DataReader
{
   
    class Program
    {
   
        static void Main(string[] args)
        {
   
            Class1 s = new Class1();  
            Console.WriteLine("请输入用户名：");
            string name = Console.ReadLine();   //输入用户名
            Console.WriteLine("请输入密码：");
            string pass = Console.ReadLine();   //输入密码
            string mess = "";       
            //调用方法并传实参
            s.UserBool(name, pass, ref mess);

            Console.ReadLine();
        }
    }
}

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

namespace DataReader
{
   
    class Class1
    {
        
        string sql = "Data Source=.;Initial Catalog=MySchool;User ID=teng;Password=1314";     
        #region 显示菜单
        public void shwo()
        {
   
            int num = 0; 
            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.退出");
                num = int.Parse(Console.ReadLine());      
                switch (num)
                {
   
                    case 1:
                        GetStudentAmost();      
                        continue;
                    case 2:
                        GetStudnetTwo();
                        continue;
                    case 3:
                        ShowStudentName();
                        continue;
                    case 4:
                        ShowStudentInfoByName();
                        continue;
                    case 5:
                        UpdateStuBornDate();
                        continue;
                    case 6:
                        ShwoShanChu();
                        continue;
                    case 7:
                        InputGrade();
                        continue;
                    case 0:
                        break;
                    default:
                        Console.WriteLine("输入无效！");
                        continue;
                }
                break;
            } while (true);        
        }
        #endregion  
        #region 登录密码
        public bool UserBool(string name, string pass, ref string mess)
        {
           
            SqlConnection cn = new SqlConnection(sql);
            try
            {
             
                string strSql = "select COUNT(*) from Admin where LoginId='" + name + "' and LoginPwd='" + pass + "'";       
                cn.Open();             
                SqlCommand cm = new SqlCommand(strSql, cn);
                int iRet = (int)cm.ExecuteScalar(); 
                if (iRet == 1)
                {
   
                    mess = "登陆成功！";
                    Console.WriteLine(mess);
                    shwo();     
                    return true;
                }
                else
                {
   
                    mess =<