第十四章

来源：互联网发布：淘宝禁售拉卡拉编辑：程序博客网时间：2024/05/01 19:43
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication1{                                                                                                                                                                                    class Program    {         string add = "Data Source=.;Initial Catalog=MySchoool;Integrated Security=True;";                static void Main(string[] args)        {            Program rr = new Program();            rr.show();                               }          public bool pub(string name,string pass,ref string mm){              SqlConnection connection = new SqlConnection(add);            try            {                                connection.Open();                string ss = "SELECT COUNT (*)FROM [MySchoool].[dbo].[Admin] where LoginId='" + name + "' and LoginPwd='" + pass + "'";                Console.WriteLine(ss);                SqlCommand comm = new SqlCommand(ss, connection);                int i = (int)comm.ExecuteScalar();                if (i > 0)                {                    mm="成功啦";                    return true;                                    }                else                {                    mm = "你是大笨蛋!";                    return false;                 }            }            catch (Exception ex)            {                mm = "错啦!!!";                Console.WriteLine(ex.Message);                return false;            }            finally            {                connection.Close();                Console.WriteLine("关闭成功啦!你脑子有病啊");                Console.ReadLine();            }                                        }          public void show(){              Console.WriteLine("请输入用户名:");              string ming = Console.ReadLine();              Console.WriteLine("请输入密码:");              string pass = Console.ReadLine();              string mm = "";              bool pp = pub(ming, pass, ref mm);              if (pp)              {                  Console.WriteLine(mm);                  xuan();              }              else              {                  Console.WriteLine(mm);              }                              }          public void xuan() {               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("8.退出");               int xuan = int.Parse(Console.ReadLine());         switch(xuan){             case 1:                 shuliang();                 break;             case 2:                 Console.WriteLine("2.查看学生名单");                 break;             case 3:                 Console.WriteLine("3.按学号查询学生姓名");                 break;             case 4:                 Console.WriteLine("5.修改学生出生日期");                 break;             case 5:                 Console.WriteLine("4.按姓名查询学生信息");                 break;             case 6:                 Console.WriteLine("6.删除学生记录");                 break;             case 7:                 Console.WriteLine("7.新增年纪记录");                 break;             case 8:                 Console.WriteLine("8.退出");                 break;                                    }                        }while(true);                                        }          public void shuliang() {              SqlConnection connection = new SqlConnection(add);              string ss = "SELECT COUNT (*)FROM [MySchoool].[dbo].[Admin]";              try{               connection.Open();                              Console.WriteLine(ss);                SqlCommand comm = new SqlCommand(ss, connection);                int iet = (int)comm.ExecuteScalar();                int i = (int)comm.ExecuteScalar();                if (i > 0)                {                                    Console.WriteLine("学生人数有"+i+"人");                                    }                            }            catch (Exception ex)            {                                Console.WriteLine(ex.Message);                            }            finally            {                connection.Close();                Console.WriteLine("关闭成功啦!你脑子有病啊");                Console.ReadLine();            }          }            }    }
0 0