c#注册功能

tao6111 2009-06-08 01:49:45

有用户名（html控件文本框）、密码（html空间 pwd）；确定按扭（服务器端控件）取消按扭（html控件）
实现：要实现分层（三层或三层以上都可以），可以写入数据库的具体代码，详细点好

...全文

112 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

tao6111 2009-06-12

打赏
举报

我只要dal层的代码

y82907966 2009-06-12

打赏
举报

LZ你太变态了...

y82907966 2009-06-12

打赏
举报

我倒....这样的啊.....昏厥....

niitnanfeng 2009-06-08

打赏
举报

6楼的看清楚了人家的需求没？真有意思。

beifang1986 2009-06-08

打赏
举报

最简单的：在程序开发机上导出注册表，在需要使用的客户机上导入

y82907966 2009-06-08

打赏
举报

MODEL层：



     using System;

using System.Collections.Generic;

using System.Text;



namespace Models

{

    //[DBTable("Users")]

    [Serializable()]

    public class User

    {

        private int id;

        private string loginId = String.Empty;

        private string loginPwd = String.Empty;

        private string name = String.Empty;

        private string qQ = String.Empty;

        private string mail = String.Empty;



        public User() { }

        //[DBField("Id")]

        public int Id

        {

            get { return this.id; }

            set { this.id = value; }

        }

        //[DBField("LoginId")]

        public string LoginId

        {

            get { return this.loginId; }

            set { this.loginId = value; }

        }



        //[DBField("LoginPwd")]

        public string LoginPwd

        {

            get { return this.loginPwd; }

            set { this.loginPwd = value; }

        }



        //[DBField("Name")]

        public string Name

        {

            get { return this.name; }

            set { this.name = value; }

        }



        //[DBField("QQ")]

        public string QQ

        {

            get { return this.qQ; }

            set { this.qQ = value; }

        }



        //[DBField("Mail")]

        public string Mail

        {

            get { return this.mail; }

            set { this.mail = value; }

        }

    }

}

DBHelper类：



namespace DAL

{

    public static class DBHelper

    {



        private static SqlConnection connection;

        /// <summary>

        /// 

        /// </summary>

        public static SqlConnection Connection

        {

            get

            {

                string connectionString = ConfigurationManager.ConnectionStrings["CON"].ConnectionString;

                if (connection == null)

                {

                    connection = new SqlConnection(connectionString);

                    connection.Open();

                }

                else if (connection.State == System.Data.ConnectionState.Closed)

                {

                    connection.Open();

                }

                else if (connection.State == System.Data.ConnectionState.Broken)

                {

                    connection.Close();

                    connection.Open();

                }

                return connection;

            }

        }

        /// <summary>

        /// 执行并返回影响行数

        /// </summary>

        /// <param name="safeSql"></param>

        /// <returns></returns>

        public static int ExecuteCommand(string safeSql)

        {

            SqlCommand cmd = new SqlCommand(safeSql, Connection);

            int result = cmd.ExecuteNonQuery();

            return result;

        }

        /// <summary>

        /// 执行并返回影响行数

        /// </summary>

        /// <param name="sql"></param>

        /// <param name="values"></param>

        /// <returns></returns>

        public static int ExecuteCommand(string sql, params SqlParameter[] values)

        {

            SqlCommand cmd = new SqlCommand(sql, Connection);

            cmd.Parameters.AddRange(values);

            return cmd.ExecuteNonQuery();

        }

        /// <summary>

        /// 执行并返回执行结果中的第一列

        /// </summary>

        /// <param name="safeSql"></param>

        /// <returns></returns>

        public static int GetScalar(string safeSql)

        {

            SqlCommand cmd = new SqlCommand(safeSql, Connection);

            int result = Convert.ToInt32(cmd.ExecuteScalar());

            return result;

        }

        /// <summary>

        /// 执行并返回执行结果中的第一列

        /// </summary>

        /// <param name="sql"></param>

        /// <param name="values"></param>

        /// <returns></returns>

        public static int GetScalar(string sql, params SqlParameter[] values)

        {

            SqlCommand cmd = new SqlCommand(sql, Connection);

            cmd.Parameters.AddRange(values);

            int result = Convert.ToInt32(cmd.ExecuteScalar());

            return result;

        }

        /// <summary>

        /// 根据sql语句获得sqldatareader

        /// </summary>

        /// <param name="safeSql"></param>

        /// <returns></returns>

        public static SqlDataReader GetReader(string safeSql)

        {

            SqlCommand cmd = new SqlCommand(safeSql, Connection);

            SqlDataReader reader = cmd.ExecuteReader();

            return reader;

        }

        /// <summary>

        /// 根据sql语句获得sqldatareader

        /// </summary>

        /// <param name="sql"></param>

        /// <param name="values"></param>

        /// <returns></returns>

        public static SqlDataReader GetReader(string sql, params SqlParameter[] values)

        {

            SqlCommand cmd = new SqlCommand(sql, Connection);

            cmd.Parameters.AddRange(values);

            SqlDataReader reader = cmd.ExecuteReader();

            return reader;

        }

        /// <summary>

        /// 根据sql语句获得DataTable

        /// </summary>

        /// <param name="safeSql"></param>

        /// <returns></returns>

        public static DataTable GetDataSet(string safeSql)

        {

            DataSet ds = new DataSet();

            SqlCommand cmd = new SqlCommand(safeSql, Connection);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            da.Fill(ds);

            return ds.Tables[0];

        }

        /// <summary>

        /// 根据sql语句获得DataTable

        /// </summary>

        /// <param name="sql"></param>

        /// <param name="values"></param>

        /// <returns></returns>

        public static DataTable GetDataSet(string sql, params SqlParameter[] values)

        {

            DataSet ds = new DataSet();

            SqlCommand cmd = new SqlCommand(sql, Connection);

            cmd.Parameters.AddRange(values);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            da.Fill(ds);

            return ds.Tables[0];

        }

    }

}

WEB.config



   

  <connectionStrings>

    <add name="CON" connectionString="Data Source=localhost;Initial Catalog=CON;User ID=用户名;password=密码" />

  </connectionStrings>

ypf222140 2009-06-08

打赏
举报

protected void btnRegister_Click(object sender, ImageClickEventArgs e)
{
User user = new User();
user.LoginId = this.txtLoginId.Text;
user.LoginPwd = this.txtLoginPwd.Text;
user.Name = this.txtName.Text;

user.QQ = this.txtQQ.Text;
user.Mail = this.txtEmail.Text;

if (!UserManager.Register(user))
{
this.ltMain.Text = "<script>alert('用户名已使用！请重新选择！')</script>";
}
else
{
this.ltMain.Text = "<script>alert('注册成功！');window.location='default.aspx'</script>";
}

}

y82907966 2009-06-08

打赏
举报

BLL层：



   public static class UserManager

    {

        /// <summary>

        /// 添加新用户

        /// </summary>

        /// <param name="user"></param>

        /// <returns></returns>

        public static User AddUser(User user)

        {

            return UserService.AddUser(user);

        }

    ｝

y82907966 2009-06-08

打赏
举报

后台：



    protected void btnRegister_Click(object sender, ImageClickEventArgs e)

    {

        User user = new User();

        user.LoginId = this.txtLoginId.Text;

        user.LoginPwd = this.txtLoginPwd.Text;

        user.Name = this.txtName.Text;

        

        user.QQ = this.txtQQ.Text;

        user.Mail = this.txtEmail.Text;



        if (!UserManager.Register(user))

        {

            this.ltMain.Text = "<script>alert('用户名已使用！请重新选择！')</script>";

        }

        else

        {

            this.ltMain.Text = "<script>alert('注册成功！');window.location='default.aspx'</script>";

        }



    }

y82907966 2009-06-08

打赏
举报

前台页面:



   <table width="60%" height="22" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td width="2" bgcolor="#DDDDCC"> </td>

    <td><div align="center">

      <table height="61" cellpadding="0" cellspacing="0">

        <tr>

          <td height="33" colspan="6"><p class="STYLE2">注册新帐户</p></td>

        </tr>

        <tr>

          <td width="24%" align="center" valign="top" style="height: 26px">用户名</td>

          <td valign="top" width="37%" align="left" style="height: 26px">

          <asp:TextBox ID="txtLoginId" runat="server"></asp:TextBox>

          </td>          

        </tr>

        <tr>

          <td width="24%" height="26" align="center" valign="top">

              昵称：</td>

          <td valign="top" width="37%" align="left">

          <asp:TextBox ID="txtName" runat="server"></asp:TextBox>

          </td>          

        </tr>

        <tr>

          <td width="24%" height="26" align="center" valign="top">密码：</td>

          <td valign="top" width="37%" align="left">

          <asp:TextBox ID="txtLoginPwd" runat="server" TextMode="Password"></asp:TextBox> 

          </td>          

        </tr>

        <tr>

          <td width="24%" height="26" align="center" valign="top">确认密码：</td>

          <td valign="top" width="37%" align="left">

          <asp:TextBox ID="txtPwdAgain" runat="server" TextMode="Password"></asp:TextBox> 

          </td>          

        </tr>

         <tr>

          <td width="24%" height="26" align="center" valign="top">Email：</td>

          <td valign="top" width="37%" align="left">

              <asp:TextBox ID="txtEmail" runat="server"></asp:TextBox>

               

          </td>          

        </tr>

        <tr>

          <td width="24%" height="26" align="center" valign="top">

              QQ：</td>

          <td valign="top" width="37%" align="left">

             <asp:TextBox ID="txtQQ" runat="server"></asp:TextBox>

               

          </td>          

        </tr>

        <tr>

          <td colspan="2" align="center"><asp:ImageButton id="btnRegister"  runat="server" ImageUrl="images/finish.jpg" OnClick="btnRegister_Click"></asp:ImageButton><asp:Literal id="ltMain" runat="server"></asp:Literal></td>           

        </tr>

      </table>

      <div class="STYLE5">---------------------------------------------------------</div>

    </div>	

    </td>

    <td width="2" bgcolor="#DDDDCC"> </td>

  </tr>

</table>