三层

来源：互联网发布：中美抗苏知乎编辑：程序博客网时间：2024/06/10 01:13

UI层（显示层）

public static void Main()        {            Application.EnableVisualStyles();            Application.SetCompatibleTextRenderingDefault(false);            Application.Run(new Form1());

BLL层（业务逻辑层）

namespace Login.BLL{    public class LoginManager    {        public Login.Model.UserInfo UserLogin(string userName, string password)        {                        Login.DAL.UserDAO uDao = new Login.DAL.UserDAO();            Login.Model.UserInfo user= uDao.SelectUser(userName, password);            if (user != null)//登录成功            {                Login.DAL.ScoreDAO sDao = new Login.DAL.ScoreDAO();                sDao.UpdateScore(userName, 10);                return user;            }            else             {                throw new Exception("登录失败");            }        }    }}

DAL层（数据访问层）

namespace Login.DAL{    public class UserDAO    {        public Login.Model.UserInfo  SelectUser(string userName, string password)        {            using (SqlConnection conn = new SqlConnection(DBUtil.ConnString))             {                SqlCommand cmd = conn.CreateCommand();                cmd.CommandText = @"SELECT ID,UserName, Password, Email From USERS WHERE UserName = @UserName AND Password = @Password";                cmd.CommandType = CommandType.Text;                cmd.Parameters.Add (new SqlParameter ("@UserName",userName));                cmd.Parameters.Add (new SqlParameter("@Password",password));                conn.Open();                SqlDataReader reader = cmd.ExecuteReader();                Login.Model.UserInfo user = null;                while(reader.Read ())                {                    if (user == null)                    {                        user = new Login.Model.UserInfo();                    }                    user.ID = reader.GetInt32(0);                    user.UserName = reader.GetString(1);                    user.Password = reader.GetString(2); //不需要从数据库取                    if (!reader.IsDBNull(3))                    {                        user.Email = reader.GetString(3);                    }                                    }                return user;            }                    }    }}

关系

······未完

阅读全文

0 0