C#连接MySQL实现登录注册案例

一. 下载mysql-connector-net-8.0.13.msi，并引入 mysql.data.dll

MySQL :: Begin Your Download

点击项目，右键，添加引用，找到对应的目录

 二. 新建窗体

编写数据库连接串

 三. 登录按钮 代码实现

        private void button2_Click(object sender, EventArgs e)
        {
            MySqlConnection m_conn = null;
            try
            {

                //创建MySqlConnection 

                m_conn = new MySqlConnection(connStr);
                //打开数据库连接
                m_conn.Open();

                //添加
                string sql = "select * from mydatabase.user where username='{0}' and password='{1}'";

                //填充SQL语句
                sql = string.Format(sql, textBox1.Text, textBox2.Text);

                //创建SqlCommand对象
                MySqlCommand cmd = new MySqlCommand(sql, m_conn);
                cmd.CommandTimeout = 12000;

                //执行SQL语句
                int returnvalue = (int)cmd.ExecuteScalar();
                //判断SQL语句是否执行成功
                if (returnvalue != -1)
                {
                    MessageBox.Show("登录成功！");
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("登录失败！" + ex.Message);
            }
            finally
            {
                if (m_conn != null)
                {
                    //关闭数据库连接
                    m_conn.Close();
                }
            }
        }

 四. 注册按钮 代码实现

     private void button1_Click(object sender, EventArgs e)
        {

            MySqlConnection m_conn = null;

            try
            {
             
                //创建MySqlConnection 

                m_conn = new MySqlConnection(connStr);
                //打开数据库连接
                m_conn.Open();

                //判断用户名是否重复
                string checkNameSql = "select count(*) from mydatabase.user where username='{0}'";
                checkNameSql = string.Format(checkNameSql, textBox1.Text);
                //创建SqlCommand对象
                MySqlCommand cmd = new MySqlCommand(checkNameSql, m_conn);
                //执行SQL语句
                int isRepeatName = (int)cmd.ExecuteScalar();
                if (isRepeatName != 0)
                {
                    //用户名重复，则不执行注册操作
                    MessageBox.Show("用户名已存在！");
                    return;
                }

                //添加
                string sql = "insert into mydatabase.user(username,password) values('{0}','{1}')";

                //填充SQL语句
                sql = string.Format(sql, textBox1.Text, textBox2.Text);

                //创建SqlCommand对象
                MySqlCommand cmd2 = new MySqlCommand(sql, m_conn);
              
                //执行SQL语句
                int returnvalue = cmd2.ExecuteNonQuery();
                //判断SQL语句是否执行成功
                if (returnvalue != -1)
                {
                    MessageBox.Show("注册成功！");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("注册失败！" + ex.Message);
            }finally
            {
                if (m_conn != null)
                {
                    //关闭数据库连接
                    m_conn.Close();
                }
            }
        }

五. 运行效果