[大数据]九、忘记密码功能的实现

一、页面设计

login页面，和第二篇博文(用户登录和注册)页面基本一样，只不过多了一个按钮
其中忘记密码？点我找回 为button3

retrieve_password页面

change_password页面

页面如下：

二、数据库

因为是忘记密码，也就是修改密码而已，数据表仍为yy_user不变
id设置为主键自增

随便添加些数据

三、代码如下

login页面代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;

namespace fiber_yy
{
    
    public partial class login : Form
    {
        public string name = "";

        public static string str_conn = "server=CY-20190824RMES;Initial Catalog=fiber_yy;User ID=sa;pwd=beyond";
        SqlConnection conn = new SqlConnection(str_conn);
        public string identification = null;

        public login()
        {
            InitializeComponent();
            
        }


        private void button1_Click(object sender, EventArgs e)//登录
        {
            conn.Open();
            string sex = "";
            string phone = "";
            string day = DateTime.Now.ToLocalTime().ToString();

            //string time = DateTime.Now.ToLongTimeString().ToString();

            string username = textBox1.Text;
            string password = textBox2.Text;
            string identify = textBox3.Text;

            if (username.Equals("") || password.Equals("") || identify.Equals(""))
            {
                MessageBox.Show("提示：请输入用户名、密码、验证码！", "警告");
            }

            else
            {
                string sqlSel = "select count(*) from yy_user where username = '" + username + "' and password = '" + password + "'";
                SqlCommand cmd = new SqlCommand(sqlSel, conn);

                if (Convert.ToInt32(cmd.ExecuteScalar()) > 0 )//账号密码正确
                {
                    string sql = "select username,sex,phone from yy_user where username = '" + username + "'";
                    SqlCommand com = new SqlCommand(sql, conn);
                    SqlDataReader read = com.ExecuteReader();
                    while (read.Read())//获取yy_user表中的username,sex,phone
                    {
                        //int number = Convert.ToInt32(read["username"]);//查询列名1的数据,方法为: read(变量名)["列名"]; 该方法返回的是object类型
                        name = read["username"].ToString();
                        //MessageBox.Show(name);
                        sex = read["sex"].ToString();
                        //MessageBox.Show(sex);
                        phone = read["phone"].ToString();
                        //MessageBox.Show(phone);
                    }
                    read.Close();


                    if (identify==identification)//判断验证码是否输入正确
                    {
                        string INSERT_sql = string.Format("INSERT INTO yy_user_record VALUES ('{0}','{1}','{2}','{3}')", name,sex,phone, DateTime.Now.ToLocalTime());
                        SqlCommand INSERT_cmd = new SqlCommand(INSERT_sql, conn);
                        int count = INSERT_cmd.ExecuteNonQuery();
                        if (count > 0)
                        {
                            MessageBox.Show(name);
                            MessageBox.Show("记录用户登录！");
                            new main_page().Show();
                            this.Hide();
                        }
                        else
                        {
                            MessageBox.Show("记录用户失败");
                        }

                    }
                    else 
                    {
                        MessageBox.Show("验证码输入错误");
                    }
                                        
                }
                else
                {
                    MessageBox.Show("请检查账号密码");
                }
            }

        }

        private void pictureBox1_Click(object sender, EventArgs e)
        {
            Random r = new Random();
            string str = null;
            for (int i = 0; i < 5; i++)
            {
                int n = r.Next(0, 10);
                str += n;//包括字符串在内
            }
            identification = str;
            Bitmap b = new Bitmap(100, 15);
            Graphics g = Graphics.FromImage(b);

            for (int i = 0; i < 5; i++)
            {
                String[] fonts = { "宋体", "黑体", "隶书", "仿宋", "微软雅黑" };//字体数组
                Color[] colors = { Color.Red, Color.Black, Color.Blue,Color.YellowGreen ,Color.Green };//颜色数组
                Font f = new Font(fonts[r.Next(0, 5)], 25, FontStyle.Bold);
                SolidBrush s = new SolidBrush(colors[r.Next(0, 5)]);//定义一个单独的画笔，使每个字符的颜色随机
                Point p = new Point(i * 20, 0);//每个字符间隔20
                g.DrawString(str[i].ToString(), Font, s, p);
            }

            for (int a = 0; a < 5; a++)
            {
                Point p1 = new Point(r.Next(0, b.Width), r.Next(0, b.Height));
                Point p2 = new Point(r.Next(0, b.Width), r.Next(0, b.Height));//线的两点不能超过图片的长和宽
                Pen pen = new Pen(Brushes.Cyan);//青色线段
                g.DrawLine(pen, p1, p2);
            }

            pictureBox1.Image = b;

        }

        private void button2_Click(object sender, EventArgs e)
        {
            
            new Form1().Show();
            this.Hide();
        }

        private void button3_Click(object sender, EventArgs e)
        {
            new retrieve_password().Show();
            this.Hide();
        }
    }
}

retrieve_password页面代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;

namespace fiber_yy
{
    public partial class retrieve_password : Form
    {
        public string name = "";
        public static string str_conn = "server=CY-20190824RMES;Initial Catalog=fiber_yy;User ID=sa;pwd=beyond";
        SqlConnection conn = new SqlConnection(str_conn);
        public string identification = null;
        public string phone = "";
        public string phone_db = "";
        public string username = "";
        public string username_db = "";
        public string identify = "";

        public retrieve_password()
        {
            InitializeComponent();
        }

        private void pictureBox1_Click(object sender, EventArgs e)
        {
            Random r = new Random();
            string str = null;
            for (int i = 0; i < 5; i++)
            {
                int n = r.Next(0, 10);
                str += n;//包括字符串在内
            }
            identification = str;
            Bitmap b = new Bitmap(100, 15);
            Graphics g = Graphics.FromImage(b);

            for (int i = 0; i < 5; i++)
            {
                String[] fonts = { "宋体", "黑体", "隶书", "仿宋", "微软雅黑" };//字体数组
                Color[] colors = { Color.Red, Color.Black, Color.Blue, Color.YellowGreen, Color.Green };//颜色数组
                Font f = new Font(fonts[r.Next(0, 5)], 25, FontStyle.Bold);
                SolidBrush s = new SolidBrush(colors[r.Next(0, 5)]);//定义一个单独的画笔，使每个字符的颜色随机
                Point p = new Point(i * 20, 0);//每个字符间隔20
                g.DrawString(str[i].ToString(), Font, s, p);
            }

            for (int a = 0; a < 5; a++)
            {
                Point p1 = new Point(r.Next(0, b.Width), r.Next(0, b.Height));
                Point p2 = new Point(r.Next(0, b.Width), r.Next(0, b.Height));//线的两点不能超过图片的长和宽
                Pen pen = new Pen(Brushes.Cyan);//青色线段
                g.DrawLine(pen, p1, p2);
            }

            pictureBox1.Image = b;

            
        }

        private void button1_Click(object sender, EventArgs e)
        {
            username = textBox1.Text;
            phone = textBox2.Text;
            identify = textBox3.Text;
            //MessageBox.Show(identify);
            //MessageBox.Show(identification);
            
            if (identify == identification)//判断验证码是否输入正确
            {
                conn.Open();
                string sql = "select username,phone from yy_user where username = '" + username + "'";
                SqlCommand com = new SqlCommand(sql, conn);
                SqlDataReader read = com.ExecuteReader();
                while (read.Read())//获取yy_user表中的username,sex,phone
                {
                    //int number = Convert.ToInt32(read["username"]);//查询列名1的数据,方法为: read(变量名)["列名"]; 该方法返回的是object类型
                    username_db = read["username"].ToString();
                    //MessageBox.Show(name);
                    //sex = read["sex"].ToString();
                    //MessageBox.Show(sex);
                    phone_db = read["phone"].ToString();
                    //MessageBox.Show(phone);
                }
                read.Close();
                MessageBox.Show(phone_db);
                if(phone_db==phone)
                {
                    //conn.Close();
                    MessageBox.Show("校验通过");
                    new change_password(username).Show();
                    this.Hide();
                }
                else 
                {
                    MessageBox.Show("注册手机号不对");
                }
            }
            else
            {
                MessageBox.Show("验证码输入错误");
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            new login().Show();
            this.Hide();
        }
    }
    
}

change_password页面代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
namespace fiber_yy
{
    public partial class change_password : Form
    {
        public string name = "";
        public static string str_conn = "server=CY-20190824RMES;Initial Catalog=fiber_yy;User ID=sa;pwd=beyond";
        SqlConnection conn = new SqlConnection(str_conn);
        //public string identification = null;
       
        public string password = "";
        public string password1 = "";

        public string username = "";
        //OleDbCommand cmd = new OleDbCommand();
        //cmd.Connection = conn;

        

        public change_password()
        {
            InitializeComponent();
        }


        public change_password(string yy)
        {
            InitializeComponent();
            username = yy;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            MessageBox.Show(username);

            password = textBox1.Text;
            password1 = textBox2.Text;

            if (password.Length <= 3 || password.Length >= 16)
            {
                label3.Text = "密码长度应该在3~16字符之间";
            }
            else if(password != password1)
            {
                label3.Text = "两次输入密码不一致";

                //MessageBox.Show("两次输入密码不一致");
            }
            else if(password==password1)
            {
                conn.Open();
                string sql = "update yy_user set password = '"+ password + "'   where username = '" + username + "'";
                SqlCommand com = new SqlCommand(sql, conn);

                com.ExecuteNonQuery();//返回值为操作的条数
                MessageBox.Show("修改成功");
                conn.Close();


                new login().Show();
                this.Hide();
            }
        }
    }
}

四、效果展示

程序运行

登录

忘记密码？点我找回


通过手机号来校验

验证码输入错误

调试时输出数据库中的注册手机号

与输入框中的手机号对比

校验成功，跳转到修改密码change_password页面

两次密码必须一致
调试时，获取登录用户的账号

新密码必须在3-16字符之间

修改成功

点击确定自动返回登录页面

原始数据库

右击yy_user表
选择前1000行
可看到密码已经修改成功