时间:2021-07-01 10:21:17 帮助过:30人阅读
using System; using System.Collections.Generic; using System.ComponentModel; using System.ComponentModel.DataAnnotations; using System.Linq; using System.Web; namespace Model { public class UserModel { [DisplayName("用户名")] [Required(ErrorMessage = "必填")] public string UserName { get; set; } [DisplayName("密码")] [Required(ErrorMessage = "必填")] [StringLength(20, MinimumLength = 6, ErrorMessage = "密码长度必须在{2} 和{1}个字符")] [DataType(DataType.Password)] public string UserPwd { get;set; } public string ConfirmPassword { get; set; } public string Message { get; set; } } }model代码
using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; using YL.MySQL; namespace DAL { public class UserDAL { //注册 public bool regst(string UserName, string UserPwd) { StringBuilder sql =new StringBuilder(); sql.Append("INSERT INTO Users (UserName,UserPwd) VALUES (@UserName,@UserPwd)" ); SqlParameter[] sqlparmeter = { new SqlParameter("@UserName",SqlDbType.NVarChar,50), new SqlParameter("@UserPwd",SqlDbType.NVarChar,50) }; sqlparmeter[0].Value = UserName; sqlparmeter[1].Value = UserPwd; var result = new MySqlAdoProvide().ExecuteNonQuery(MySqlHelper.connectionStringManager, sql.ToString(), sqlparmeter) > 0; return result; } //登陆 public Model.UserModel GetLogin(string UserName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select UserName,UserPwd " ); strSql.Append(" from Users "); strSql.Append(" where UserName=@UserName "); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar,50) }; parameters[0].Value = UserName; var data = new MySqlAdoProvide().ExecuteReader(dr => dr.GetEntity<Model.UserModel>(), MySqlHelper.connectionStringManager, strSql.ToString(), parameters).FirstOrDefault(); return data; } } }DAL代码
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace BLL { public class UserBLL { //构造函数 private DAL.UserDAL dal; public UserBLL() { dal = new DAL.UserDAL(); } //注册 public bool regst(string UserName, string UserPwd) { return dal.regst(UserName, UserPwd); } public Model.UserModel GetLogin(string UserName) { return dal.GetLogin(UserName); } } }BLL代码
MvcApplication8-HomeController代码 控制器代码
@model Model.UserModel @{ ViewBag.Title = "Index"; } <h2>登陆界面</h2> <div> @using(Html.BeginForm("Login","Home",FormMethod.Post)) { <div> @Html.TextBoxFor(m => m.UserName, new { @class = "form-control", @placeholder = "用户名" }) @Html.ValidationMessageFor(m => m.UserName) @Html.TextBoxFor(m => m.UserPwd, new { @class = "form-control", @placeholder = "密码" }) @Html.ValidationMessageFor(m => m.UserPwd) <button type="submit">登陆</button> @Html.ValidationMessageFor(m => m.Message) <a href="@Url.Action("regist")">注册一个新账号</a> </div> } </div>登陆界面代码
@model Model.UserModel @{ ViewBag.Title = "Index"; } <h2>注册界面</h2> <div> @using(Html.BeginForm("zc","Home",FormMethod.Post)) { <div> @Html.TextBoxFor(m => m.UserName, new { @placeholder = "用户名" }) @Html.ValidationMessageFor(m => m.UserName) @Html.TextBoxFor(m => m.UserPwd, new { @placeholder = "密码" }) @Html.ValidationMessageFor(m => m.UserPwd) @Html.TextBoxFor(m => m.ConfirmPassword, new { @placeholder="确认密码"}) @Html.ValidationMessageFor(m=>m.ConfirmPassword) @Html.ValidationMessageFor(m => m.Message) <button type="submit">注册</button> </div> } </div>注册界面代码
登陆+注册(三层+sql语句)
标签:xls mfc 技术分享 pmp erb apu oda eol pru