学生菜单

来源：互联网发布：node 编辑：程序博客网时间：2024/04/30 11:55
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication2{    class Program    {        private string conn = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";        static void Main(string[] args)        {            Program a = new Program();            Console.WriteLine("输入用户名:");            string name = Console.ReadLine();            Console.WriteLine("请输入密码:");            string mima = Console.ReadLine();            bool b = a.show(name, mima);            if (b)            {                Console.WriteLine("登陆成功!");                            }            else            {                Console.WriteLine("登录失败");            }            Console.ReadLine();        }        public bool show(string name, string pass)        {            SqlConnection con = new SqlConnection(conn);            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;        }        public void show()        {            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("===========================================");                Console.WriteLine("请选择:");                int num = int.Parse(Console.ReadLine());                switch (num)                {                    case 1:                        Console.WriteLine("1、统计学生人数");                        continue;                    case 2:                        Console.WriteLine("2、查看学生名单");                        continue;                    case 3:                        Console.WriteLine("3、按学号查询学生姓名");                        continue;                    case 4:                        Console.WriteLine("4、按姓名查询学生信息");                        continue;                    case 5:                        Console.WriteLine("5、修改学生出入日期");                        continue;                    case 6:                        Console.WriteLine("6、删除学生记录");                        continue;                    case 7:                        Console.WriteLine("7、新增年级记录");                        continue;                    case 0:                        Console.WriteLine("0、退出");                        break;                    default:                        Console.WriteLine("输入错误!");                        continue;                }                break;            } while (true);        }    }}
1 0