C#十四章例子三

来源：互联网发布：游轮上的网络编辑：程序博客网时间：2024/04/29 08:51
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;namespace ConsoleApplication1{    class Program    {        private const string strConn = @"Data Source=.;Initial Catalog=MySchool;Integrated Security=True";        static void Main(string[] args)        {            Program p = new Program();            string userName = "admin";            string pwd = "0";            string strMsg = "用来保存信息";            bool y = p.CheckUserInfo(userName ,pwd, ref strMsg);            if (y)            {                Console.WriteLine(strMsg);            }            else            {                Console.WriteLine(strMsg);            }            Console.ReadLine();        }        public bool CheckUserInfo(string userName, string pwd, ref string strMsg)        {            string connString = "Data Source=.;Initial Catalog=MySchool;Integrated Security=True;";            SqlConnection a = new SqlConnection(connString);            try            {                string strSql = "SELECT COUNT(*) FROM [MySchool].[dbo].[Admin] where LoginId='" + userName + "'and LoginPwd='" + pwd + "'";                Console.WriteLine(strSql);                a.Open();                Console.WriteLine("打开成功");                SqlCommand comm = new SqlCommand(strSql, a);                int iRet = (int)comm.ExecuteScalar();                if (iRet != 1)                {                    strMsg = "输入无效";                    return false;                }                else                {                    return true;                }            }            catch (Exception)            {                strMsg = "异常";                return false;            }            finally            {                a.Close();            }        }    }}
0 0
C#十四章 例子三

C#十四章例子三
