<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();
}
}
}
}