AD0.NET一个简单的用户登陆控制台程序

<1>一个简单的用户登陆

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace ConsoleApplication1{    class Program    {        //int errorPaw = 0;        static void Main(string[] args)        {            string strConn = "Data Source=Fan-VAIO;InitialCatalog=sales;Integrated Security=True";            Program pr = new Program();            Console.WriteLine("请输入用户名：");            string userName = Console.ReadLine();            Console.WriteLine("请输入密码：");            string userPaw = Console.ReadLine();            using (SqlConnection conn = new SqlConnection(strConn))            {                conn.Open();                using (SqlCommand cmd = conn.CreateCommand())                {                    cmd.CommandText = "select * from t_user where name='" + userName + "'";                    SqlDataReader reader = cmd.ExecuteReader();                    if (reader.Read())                    {                        string adoPaw = reader.GetString(reader.GetOrdinal("password"));                        if (userPaw == adoPaw)                        {                            Console.WriteLine("登陆成功");                        }                        else                        {                            Console.WriteLine("密码错误,请输入正确的密码");                        }                        // pr.errorPaw++;                        Console.WriteLine("请输入密码");                        userPaw = Console.ReadLine();                        if (userPaw == adoPaw)                        {                            Console.WriteLine("登陆成功");                        }                        else                        {                            Console.WriteLine("密码错误,请输入正确的密码");                        }                        //pr.errorPaw++;                        //pr.ErrorPaw();                        Console.WriteLine("请输入密码");                        userPaw = Console.ReadLine();                        if (userPaw == adoPaw)                        {                            Console.WriteLine("登陆成功");                        }                        else                        {                            Console.WriteLine("密码错误，因输入次数过多，请稍后再试");                            Console.ReadKey();                            return;                        }                    }                    else                    {                        Console.WriteLine("用户名不存在");                    }                }                Console.ReadKey();            }        }    }}