2021-07-28 家庭财经系统(4)

IDEA换成Visual Studio 2019 ，原因是 IDEA 图形界面拖拉控件费劲。对于现在的我来说费劲。

查询数据库里所有表名字 show tables;

制作第二张表，用来存放用户名和密码。这里考虑有不同权限。

增加root超级用户和admin、administrator

设定密码如下：

root 密码 root@)@!)&@* (shift 20210728)

adminisator adminisator###

Li LiShuo

LiWei LiWei2008

先要去官网下载 mysql connector

今天是 2021.08.16 找到原因了。
开始引用需要全改成 using MySql 这样。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Common;
using MySql.Data.Types;

namespace _20210808
{
public partial class Home_financial_system_login_interfaceForm : Form
{
public Home_financial_system_login_interfaceForm()
{
InitializeComponent();
}

    private void login_button_Click(object sender, EventArgs e)
    {
        string loginname = username_textBox.Text.Trim();
        string loginpwd = password_textBox.Text.Trim();
        if (String.IsNullOrEmpty(loginname) || String.IsNullOrEmpty(loginpwd))
        {
            MessageBox.Show("用户名或密码不能为空！");
            return;
        }


        //"select * from user_name_password where Members_nickName = '" + strUName + "' and Members_passWord='" + strUPassWord + "'";
        MySqlConnection conn = new MySqlConnection("server=localhost;uid=root;pwd=song1984;database=lianxi");
        conn.Open();

        string sql = "SELECT Members_nickName,Members_passWord from user_name_password where Members_nickName=@username and Members_passWord=@pwd";
        MySqlCommand cmd = new MySqlCommand(sql, conn);//sql是需要执行的语句字符串，conn是连接对象
       // conn.Open();//打开conn


        cmd.Parameters.Add(new MySqlParameter("@username", MySqlDbType.VarChar));
        cmd.Parameters["@username"].Value = loginname;

        cmd.Parameters.Add(new MySqlParameter("@pwd", MySqlDbType.VarChar));
        cmd.Parameters["@pwd"].Value = loginpwd;
        //cmd.ExecuteNonQuery();

        MySqlDataReader check = cmd.ExecuteReader();//存储数据集



        if (!check.Read())
        {
            MessageBox.Show("用户不存在或密码错误！");
            username_textBox.Text = "";
            password_textBox.Text = "";
            conn.Close();
        }
        else if  (check["Members_passWord"].ToString().Trim() == loginpwd)
        {
            MessageBox.Show("登录成功！");
            conn.Close();

            Form2 new_form = new Form2();
            new_form.Owner = this;
            this.Hide();
            new_form.ShowDialog();
            Application.ExitThread();
        }





    }

    private void Home_financial_system_login_interfaceForm_Load(object sender, EventArgs e)
    {

    }

    private void close_button_Click(object sender, EventArgs e)
    {
        Close();
    }
}

}