实现用户注册时,向其油箱发送激活码邮件,并进行状态处理

来源:互联网 发布:emba 知乎 编辑:程序博客网 时间:2024/03/29 02:37

注册页前台以及图片:

--------region.aspx-----
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="region.aspx.cs" Inherits="ActiveRegister1.region" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
            width: 90px;
        }
        .style2
        {
            width: 162px;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <table style="width:80%;">
            <tr>
                <td class="style1">
                    用户名:</td>
                <td class="style2">
                    <asp:TextBox ID="TextBox1" runat="server" Width="170px"></asp:TextBox>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1">
                    密码:</td>
                <td class="style2">
                    <asp:TextBox ID="TextBox2" runat="server" style="margin-left: 0px"
                        Width="167px"></asp:TextBox>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1">
                    邮箱地址:</td>
                <td class="style2">
                    <asp:TextBox ID="TextBox3" runat="server" Width="167px"></asp:TextBox>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style1">
                    <asp:Button ID="Button1" runat="server" Text="注册" onclick="Button1_Click"
                        Width="82px" />
                </td>
                <td class="style2">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
   
    </div>
    </form>
</body>
</html>

后台:
--------region.aspx-----
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Net.Mail;
using System.Text;
using System.Net;

namespace ActiveRegister1
{
    public partial class region : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        public void sendMail(string email, string activeCode)
        {
            MailMessage msg = new MailMessage();
           
            msg.From = new MailAddress("elaineJJ123@126.com");
            msg.To.Add(email);
            msg.Subject = "请激活注册";

            StringBuilder contentBuilder = new StringBuilder();
            contentBuilder.Append("请单击以下连接完成激活!");
            contentBuilder.Append("<a href='http://localhost:3674/CheckActiveCode.aspx?activecode=" + activeCode + "&id=4'>激活</a>");

            msg.Body = contentBuilder.ToString();


            msg.IsBodyHtml = true;//页面形式
            SmtpClient client = new SmtpClient();
            client.Host = "smtp.126.com";//发件方服务器地址
            client.Port = 25;//发件方端口
            msg.IsBodyHtml = true;//页面形式

            NetworkCredential credential = new NetworkCredential();//证书
            credential.UserName = "elaineJJ123";
            credential.Password = "lovepeng123";

            client.Credentials = credential;
        
         
            client.Send(msg);
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            string userName = this.TextBox1.Text;
            string password = this.TextBox2.Text;
            string email = this.TextBox3.Text;
            string activeCode = Guid.NewGuid().ToString().Substring(0, 8);//生成激活码

            //连接数据库
            string conStr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
            int number;
            using (SqlConnection con = new SqlConnection(conStr))
            {
                string sql = "insert into T_Users (UserName,Password,Email,Active,ActiveCode) values (@username,@password,@email,@active,@activecode)";
                SqlParameter[] prams = new SqlParameter[]{
               
                new SqlParameter("@username",userName),
                new SqlParameter("@password",password),
                new SqlParameter("@email",email),
                new SqlParameter("@active",false),
                new SqlParameter("@activecode",@activeCode)
                };
                using (SqlCommand cmd = new SqlCommand(sql,con))
                {
                    con.Open();
                    cmd.Parameters.AddRange(prams);
                    number=cmd.ExecuteNonQuery();
                }
            }
            if (number > 0)
            {
                sendMail(email, activeCode);
                // sendMail(string email, string activeCode);//给注册用户发邮件
                Response.Redirect("regionMessage.aspx");
            }
            else
            {
                Response.Write("注册失败,请重新注册!!");
            }
        

        }

      
    }
}

新建一个regionMessage页面:
------regionMessage.aspx---------
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="regionMessage.aspx.cs" Inherits="ActiveRegister1.regionMessage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <h3>恭喜您,注册成功!!</h3>
    </div>
    </form>
</body>
</html>

再建一个CheckActiveCode页面:

前台没有内容

后台如下:
------CheckActiveCode.aspx.cs---------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;

namespace ActiveRegister1
{
    public partial class CheckActiveCode : System.Web.UI.Page
    {

      
        protected void Page_Load(object sender, EventArgs e)
        {
            //取出参数id
            int id=Convert.ToInt32(Request["id"]);
            string activeCode=Request["activecode"].ToString();

            //2判断id为id的记录是否存在
            //连接数据库
            string conStr = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
            int number;
            using (SqlConnection con = new SqlConnection(conStr))
            {
                string sql = "select count(*) from T_Users where id=@id";
                using (SqlCommand cmd = new SqlCommand(sql, con))
                {
                    con.Open();
                    cmd.Parameters.AddWithValue("@id",id);
                    number=Convert.ToInt32(cmd.ExecuteScalar());
                }
            }

            if (number > 0)
            {
            //如果该用户存在取出ActiveCode字段进行比较。如果一样,把Active字段修改为true
                //连接数据库

                string AC;

                using (SqlConnection con = new SqlConnection(conStr))
                {
                    string sql = "select ActiveCode from T_Users where id=@id";
                    using (SqlCommand cmd = new SqlCommand(sql, con))
                    {
                        con.Open();
                        cmd.Parameters.AddWithValue("@id", id);
                        AC = cmd.ExecuteScalar().ToString(); ;
                    }
                }


                if (activeCode == AC)
                {
                    Response.Write("激活成功!");
                    using (SqlConnection con = new SqlConnection(conStr))
                    {
                        string sql = "update T_Users set Active=1 where id=@id";
                        using (SqlCommand cmd = new SqlCommand(sql, con))
                        {
                            con.Open();
                            cmd.Parameters.AddWithValue("@id", id);
                            number = Convert.ToInt32(cmd.ExecuteScalar());

                        }

                    }

                }
                else
                {
                    Response.Write("用户已存在,但是激活码错误!");
                }
            }
            else
            {
                Response.Write("用户不存在,还没注册成功!");
            }
        }
    }
}