首先打开vs软件
新建项目
创建web中的mvc项目
再右击解决方案创建类库项目
分别创建DAL层和BLL层再把DAL层和BLL层的类重命名
在mvc项目中的Models文件夹创建model类
在DAL创建ADO.NET实体数据模型后把DAL层中App.Config文件中的链接字符串复制到mvc项目的Web.config文件中

ADO.NET实体数据模型

DAL层中的类开始打代码
登录

 /// <summary>
        /// 登录
        /// </summary>
        /// <param name="studentname">登录名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int Login(string studentname, string phone)
        {
            using (zzqEntities1 db = new zzqEntities1())
            {
                int stu = db.student.Where(s => s.Studentname == studentname && s.Studentaddress =="启用" && s.phone == phone).Count();
                return stu;
            }
        
        }

查询

   /// <summary>
        /// 查询
        /// </summary>
        /// <returns></returns>
        public static  List<student>  studentSelect() { 
            using (zzqEntities1 db = new zzqEntities1()) {
                List<student> stu = new List<student>();
                stu = db.student.ToList();
                return stu;
            }
         
        }

添加

 /// <summary>
        /// 添加
        /// </summary>
        /// <param name="studentname">姓名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int Insert(string studentname, string studentaddress, string phone) {
            using (zzqEntities1 db = new zzqEntities1())
            {
                var stu = new student() { Studentname = studentname, Studentaddress = studentaddress, phone = phone };
                db.student.Add(stu);
                return db.SaveChanges(); 
            }
        
        }

删除

  /// <summary>
        /// 删除
        /// </summary>
        /// <param name="studentid">编号</param>
        /// <returns></returns>
        public static int Delete(int id)
        {
            using (zzqEntities1 db = new zzqEntities1())
            {
                var stu = new student() { Studentid = id };
                db.student.Attach(stu);
                db.student.Remove(stu);
                return db.SaveChanges();
            }
        }

修改

  /// <summary>
        /// 查询编号
        /// </summary>
        /// <param name="studentid">编号</param>
        /// <returns></returns>
        public static List<student> updateSelect(int id)
        {
            using (zzqEntities1 db = new zzqEntities1())
            {
                var st = db.student.Where(x => x.Studentid == id).ToList();
                return st;
            }
        }
   /// <summary>
        /// 修改
        /// </summary>
        /// <param name="studentid">编号</param>
        /// <param name="studentname">姓名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int update(int id, string studentname, string studentaddress, string phone)
        {
            using (zzqEntities1 db = new zzqEntities1())
            {
                var st = db.student.Where(x => x.Studentid == id).FirstOrDefault();
                st.Studentid = id;
                st.Studentname = studentname;
                st.Studentaddress = studentaddress;
                st.phone = phone;
                return db.SaveChanges();
            }
        
        }

BLL层

using DAL;
引用DAL层

登录

   /// <summary>
        /// 登录
        /// </summary>
        /// <param name="studentname"></param>
        /// <param name=&quo