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

最新推荐文章于 2018-12-04 17:24:36 发布

wangjingjing1014

最新推荐文章于 2018-12-04 17:24:36 发布

阅读量514

点赞数

本文链接：https://blog.csdn.net/wangjingjing1014/article/details/8465217

版权

注册页前台以及图片：

--------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>
                     </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>
                     </td>
            </tr>
            <tr>
                <td class="style1">
                    邮箱地址：</td>
                <td class="style2">
                    <asp:TextBox ID="TextBox3" runat="server" Width="167px"></asp:TextBox>
                </td>
                <td>
                     </td>
            </tr>
            <tr>
                <td class="style1">
                    <asp:Button ID="Button1" runat="server" Text="注册" οnclick="Button1_Click"
                        Width="82px" />
                </td>
                <td class="style2">
                     </td>
                <td>
                     </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">

再建一个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("用户不存在，还没注册成功！");
            }
        }
    }
}

wangjingjing1014

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
实现用户注册时，向其油箱发送激活码邮件，并进行状态处理

注册页前台以及图片：--------region.aspx-----http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml"> .style1 { width: 90px;
复制链接

扫一扫