C#_ADO.NET验证用户登录

来源：互联网发布：淘宝女购物车猝死男友编辑：程序博客网时间：2024/04/28 19:38

模拟论坛登录账号

要求用户输入账号和密码从数据库中查找是否有此账号密码和账号匹配则显示登录成功否则
提示登录失败

SQL 建库代码

use mastergoif exists(select * from sysdatabases where name='LoginTest')drop database LoginTestgocreate database LoginTeston primary(Name='LoginTest_Data',FileName='D:\LoginTest.mdf',Size=5mb,Maxsize=10mb,FileGrowth=1mb)Log on(Name='LoginTest_Log',FileName='D:\LoginTest.ldf',size=5mb,Maxsize=10mb,FileGrowth=1mb)gouse LoginTestgoif exists(select * from sysobjects where name='LoginTable')drop table LoginTablegocreate table LoginTable(ID int IDENTITY PRIMARY KEY not null,UserId varchar(20) not null,Pwdvarchar(20) not null)goinsert into LoginTable(UserId,Pwd) values ('amd','123')go

C# 代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;namespace ADOLogin{    class Program    {        static void Main(string[] args)        {            //连接字符串            string conStr="Data Source=.;Initial Catalog=LoginTest;"+                "User ID=sa;Pwd=leeho";            //创建数据库连接对象            SqlConnection conn = new SqlConnection(conStr);            Console.WriteLine("请输入账号: ");            //获取用户输入账号            string userID = Console.ReadLine().Trim();            Console.WriteLine("请输入密码");            //获取用户输入密码            string pwd = Console.ReadLine().Trim();            //定义SQL操作语句            string sqlStr = string.Format("select count(1) from LoginTable where UserId='{0}' and Pwd='{1}'", userID, pwd);            //建立Command对象            SqlCommand comm = new SqlCommand(sqlStr,conn);            int result = 0;            try            {                //打开数据库连接                conn.Open();                //获取用户名和密码在数据库中匹配的个数                result = (int)comm.ExecuteScalar();            }            catch (Exception ex)            {                //输出异常                Console.WriteLine(ex.Message);            }            finally            {                //关闭数据库连接                conn.Close();            }            //如果没有找到匹配登录失败            if (result != 1)            {                Console.WriteLine("用户名或密码错误！登录失败！");            }            else            {                //数据库中 UseId列 值为amd Pwd列值为123                Console.WriteLine("登录成功");            }            Console.ReadKey();        }    }}