MVC Web项目注册流程

一、实体类、工具类、数据访问层、业务逻辑层、表示层、第三方

第一步：创建Mishop02数据库、创建一张UserInfo用户信息表、相应的建立一个UserInfo实体类

//创建Mishop02数据库
create database Mishop02;

//选择数据库
Use Mishop02;

//创建UserInfo用户信息表
create table UserInfo(
UserId int identity primary key,
UserName varchar(50),
UserPwd varchar(50),
UserTel bigint,
UserEmail varchar(50),
UserDate date,
CreateTime datetime,
);

第二步：创建工具类SqlHelper连接数据库

1.在Web.config配置连接字符串、添加引用using System.Configuration;

 //连接字符串
 private string connString = System.Configuration.ConfigurationManager.AppSettings["connString"];

2.添加增删改方法

        /// <summary>
        /// 增删改方法
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public int ExcuteNoQuery(string sql, SqlParameter[] parameters)
        {
            int result = -1;
            SqlConnection sqlConnection = null;
            try
            {
                //创建连接对象
                sqlConnection = new SqlConnection(connString);
                //打开连接
                sqlConnection.Open();
                //创建操作对象
                SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
                //预处理
                if (parameters != null)
                {
                    sqlCommand.Parameters.AddRange(parameters);
                }
                //执行操作
                result = sqlCommand.ExecuteNonQuery();
                return result;
            }
            catch (Exception)
            {
                return result;
            }
            finally
            {
                //关闭连接
                sqlConnection.Close();
            }
        }

3.添加查询方法

        /// <summary>
        /// 查询方法
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="parameters"></param>
        /// <returns></returns>
        public int ExecuteReader(string sql, SqlParameter[] parameters)
        {
            int result = -1;
            SqlConnection sqlConnection = null;
            try
            {
                //创建连接对象
                sqlConnection = new SqlConnection(connString);
                //打开连接
                sqlConnection.Open();
                //创建操作对象
                SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
                //预处理
                if (parameters != null)
                {
                    sqlCommand.Parameters.AddRange(parameters);
                }
                //处理返回结果
                SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
                //如果查到了返回1，否则返回-1
                if (sqlDataReader.Read())
                {
                    result = 1;
                }
                return result;
            }
            catch (Exception)
            {
                return result;
            }
            finally
            {
                //关闭连接
                sqlConnection.Close();
            }
        }

第三步：创建数据访问层UserInfoRepository

1.添加用户注册增删改方法

        /// <summary>
        /// 用户注册增删改方法
        /// </summary>
        /// <param name="userInfo"></param>
        /// <returns></returns>
        public int AddUserInfo(UserInfo userInfo)
        {
            int result = -1;
            //sql语句
            string sql = "insert into UserInfo(UserName,UserPwd,UserTel,UserEmail,UserDate,CreateTime) values(@UserName,@UserPwd,@UserTel,null,null,@CreateTime)";
            //创建SqlParameter数组
            SqlParameter[] parameters = {
            new SqlParameter()
            {
                DbType = DbType.String,
                ParameterName = "@UserName",
                Value = userInfo.UserName
            },
            new SqlParameter()
            {
                DbType = DbType.String,
                ParameterName = "@UserPwd",
                Value = userInfo.UserPwd
            },
            new SqlParameter()
            {
                DbType = DbType.Int64,
                ParameterName = "@UserTel",
                Value = userInfo.UserTel
            },
            new SqlParameter()
            {