14 上机练习4

来源：互联网发布：宁波行知实验小学照片编辑：程序博客网时间：2024/05/29 15:23

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;namespace MySchoolBase{     class Class2    {        private const string strConn = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True";                     public void Login()        {            string Name = "admin";            string Pwd = "0";            string strMsg = "李佳乐最美";            Console.WriteLine("请输入用户名：");            Name = Console.ReadLine();            Console.WriteLine("请输入密码：");            Pwd = Console.ReadLine();                       bool iRet = CheckUserInfo(Name, Pwd, ref strMsg);            if (iRet)            {                Console.WriteLine("登录成功！");                ShowMenu();            }            else            {                Console.WriteLine("登录失败：" + strMsg);            }        }        public bool CheckUserInfo(string userName, string pwd, ref string strMsg)        {            SqlConnection conn = new SqlConnection(strConn);            try            {                string strSql = "select count(*) from Admin where LoginId='" + userName + "' and LoginPwd='" + pwd + "'";                conn.Open();                SqlCommand comm = new SqlCommand(strSql, conn);                int iRet = (int)comm.ExecuteScalar();                if (iRet != 1)                {                    strMsg = "输入无效！";                    return false;                }                else                {                    return true;                }            }            catch (Exception)            {                strMsg = "发生异常！";                return false;            }            finally            {                conn.Close();            }        }

using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace MySchoolBase{    class Program    {        static void Main(string[] args)        {            Class2 manger = new Class2();            manger.Login();            Console.ReadLine();        }    }}

0 0