代码展示
运行结果
源码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
// 导入一下sql工具包
using System.Data.SqlClient;
namespace ConsoleApplication11
{
class Program
{
static void Main(string[] args)
{
// 连接字符串
String connStr = "Data Source=.;Initial Catalog=User;Persist Security Info=True;User ID=sa;Password=cnm.040513";
// 获得连对象
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
Console.WriteLine("连接已经打开");
// 接收用户名数据
Console.WriteLine("请输入用户名:");
String userName = Console.ReadLine();
// 接收密码数据
Console.WriteLine("请输入密码:");
String pwd = Console.ReadLine();
// 需要一个执法者
String sql = "select count(*) from [user] where userinfo='" + userName + "' and pwd = '" + pwd + "'";
Console.WriteLine(sql);
SqlCommand cmd = new SqlCommand(sql, conn);
Console.WriteLine(cmd);
int num =(int) cmd.ExecuteScalar();
if (num == 0)
{
Console.WriteLine("用户名或密码错误");
}
else
{
Console.WriteLine("登陆成功");
}
// 暂停
Console.ReadKey();
}
}
}