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();
Console.WriteLine("请输入登录名:");
string userName= Console.ReadLine();
Console.WriteLine("请输入密码:");
string pwd = Console.ReadLine();
string strMsg = "用来保存信息";
bool y = p.CheckUserInfo(userName ,pwd, ref strMsg);
if (y)
{
Console.WriteLine(strMsg);
}
else
{
Console.WriteLine("错误");
}
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();
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();
}
return false;
}
}
}
C#十四章上机练习三
最新推荐文章于 2017-09-27 22:38:55 发布