using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;//导入sql工具包
namespace 登录功能
{
class Program
{
static void Main(string[] args)
{
//连接字符串
String connstr = “Data Source=DESKTOP-6RN6CLN;Initial Catalog=yyy;Integrated Security=True”;
//获得对象
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
//接收数据
Console.WriteLine("请输入账号名:");
String userName1 = Console.ReadLine();
Console.WriteLine("请输入密码:");
String userPwd1 = Console.ReadLine();
//执行
string sql = "select count(*) from 登录系统 where userName='"+userName1+"' and userPwd='"+userPwd1+"'";
Console.WriteLine(sql);
SqlCommand cmd = new SqlCommand(sql, conn);
Console.WriteLine(cmd);
int num = (int)cmd.ExecuteScalar();
//判断
if(num==0){
Console.WriteLine("账号或密码错误,登陆失败");
}else if(num==1){
Console.WriteLine("登陆成功");
}
//暂停
Console.ReadKey();
}
}
}