邮箱注册的链接激活功能.docx

Regist.aspx 页面：用户名： 密码： 确认密码：邮箱：.cs后台代码：protected void Button1_Click(object sender, EventArgs e) User user = new User(); user.User_Name = this.txtName.Text.Trim(); user.User_PassWord = this.txtPwd.Text.Trim(); string pwd1 = this.txtPwd1.Text.Trim(); user.User_Email = this.txtEmail.Text.Trim(); /将信息写入到数据库 bool res = UserManager.Regist(user); if (res) /向用户邮箱发送注册链接 SendEmail(); else Response.Write(alert(失败！); return; / / / 邮箱服务器 / 发件人的帐号 / 发件人密码? / 收件人帐号 / 主题 / 内容 public void SendSMTPEMail(string strSmtpServer, string strFrom, string strFromPass, string strto, string strSubject, string strBody) SmtpClient client = new SmtpClient(strSmtpServer); client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential(strFrom, strFromPass); client.DeliveryMethod = SmtpDeliveryMethod.Network; MailMessage message = new MailMessage(strFrom, strto, strSubject, strBody); message.BodyEncoding = System.Text.Encoding.UTF8; message.IsBodyHtml = true; client.Send(message); private void SendEmail() string name = System.Web.HttpUtility.UrlEncode(this.txtName.Text, System.Text.Encoding.Unicode); string flag = 0; string email = this.txtEmail.Text; string str = string.Format(http:/localhost:53659/RegistSuccess.aspx?email=0&name=1&flag=2, email, name, flag); /激活码链接 SendSMTPEMail(, , 密码, txtEmail.Text, 感谢您注册,请验证邮箱（邮箱注册）, 请点击下面的链接完成邮箱验证 + str + 如链接点击无效，您可以将链接复制到浏览器中直接打开); Response.Write(alert(已向您的邮箱中发送一条链接，请激活您的账号); RegistSuccess.aspx 页： 恭喜您注册成功！.cs 页：protected void Page_Load(object sender, EventArgs e) if (!IsPostBack) string flag = Request.QueryStringflag; string name = Request.QueryStringname; if (flag = 0) bool result = UserManager.UpdateActive(name); if (!result) Response.Write(alert(shibai！?); Response.Redirect(Regist.aspx); 数据库表：中文描述表名：用户表Users序号字段名数据类型是否主键是否为空中文描述1User_IDint是否2User_Namenvarchar(10)否否用户名3User_PassWordnvarchar(20)否否密码4User_Emailnvarchar(50)否否邮箱5IsActivateint否否是否被激活（0：未激活、1：已激活）1、 点击注册，将用户信息写入到数据库DLL层： DBHelper类：using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.SqlClient;using System.Configuration;namespace TravelDAL public static class DBHelper private static SqlConnection connection; public static SqlConnection Connection get string connectionString = ConfigurationManager.ConnectionStringsdb.ConnectionString; if (connection = null) connection = new SqlConnection(connectionString); connection.Open(); else if (connection.State = ConnectionState.Closed) connection.Open(); else if (connection.State = ConnectionState.Broken) connection.Close(); connection.Open(); return connection; public static int ExecuteNonQuery(string sql, params SqlParameter values) SqlCommand cmd = new SqlCommand(sql, Connection); cmd.Parameters.AddRange(values); return cmd.ExecuteNonQuery(); Userservers类 ，编写方法#region 添加用户 public static bool AddUser(User user) string sql = insert into Users values(UserName,Password, email, Isactive); SqlParameter para = new SqlParameter new SqlParameter(UserName,user.User_Name), new SqlParameter(Password,user.User_PassWord), new SqlParameter(email,user.User_Email), new SqlParameter(Isactive,user.User_IsActivate=0), ; int res = DBHelper.ExecuteNonQuery(sql, para); if (res0) return true; return false; #region 根据name更新用户状态为可用 public static bool UpdateIsActivate(string name) string sql = update users set IsActivate=1 where User_Name=+name+; int result = DBHelper.ExecuteNonQuery(sql); if (result=1) return true; return false; #endregion2、 BLL层UserManager类：#region 用户注册 public static bool Regist(User user) return UserService.AddUser(user); #endregionpublic static bool UpdateActive(string name) return UserService.Updat