Example #1
0
        private void sign_in_Click(object sender, EventArgs e)
        {
            String username, password;

            username = txtName.Text;
            password = txtpsd.Text;

            String          myconn = "server = localhost;port=3306;user=root;password=123456;database=score"; //数据库实例连接字符串
            MySqlConnection sq     = new MySqlConnection(myconn);                                             //建立连接

            sq.Open();                                                                                        //打开数据库
            if (comboBox1.Text == "学生")
            {
                string       sql  = string.Format("select count(*) from student where sname='{0}'", username);
                MySqlCommand cmd  = new MySqlCommand(sql, sq);
                int          a    = Convert.ToInt32(cmd.ExecuteScalar());//返回一个值,看用户是否存在
                string       sql1 = string.Format("select count(*) from student where spassword='******'", password);
                MySqlCommand cmd1 = new MySqlCommand(sql1, sq);
                int          b    = Convert.ToInt32(cmd1.ExecuteScalar());
                if (a != 0 && b != 0)
                {
                    成绩查询 form = new 成绩查询();
                    form.Show();
                }
                else
                {
                    DialogResult dr = MessageBox.Show("请检查您的用户名或密码是否正确,或注册新用户!", "登录失败!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dr == DialogResult.Yes)//打开注册页面
                    {
                        注册 form2 = new 注册();
                        form2.Show();
                    }
                    else
                    {
                        this.Show();
                    }
                }
            }
            if (comboBox1.Text == "教师")
            {
                string       sql  = string.Format("select count(*) from techer where tname='{0}'", username);
                MySqlCommand cmd  = new MySqlCommand(sql, sq);
                int          a    = Convert.ToInt32(cmd.ExecuteScalar());//返回一个值,看用户是否存在
                string       sql1 = string.Format("select count(*) from techer where tpasswoed='{0}'", password);
                MySqlCommand cmd1 = new MySqlCommand(sql1, sq);
                int          b    = Convert.ToInt32(cmd1.ExecuteScalar());
                if (a != 0 && b != 0)
                {
                    教师 form = new 教师();
                    form.Show();
                }
                else
                {
                    DialogResult dr = MessageBox.Show("请检查您的用户名或密码是否正确,或注册新用户!", "登录失败!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dr == DialogResult.Yes)//打开注册页面
                    {
                        注册 form2 = new 注册();
                        form2.Show();
                    }
                    else
                    {
                        this.Show();
                    }
                }
            }
            if (comboBox1.Text == "管理员")
            {
                string       sql  = string.Format("select count(*) from master where mname='{0}'", username);
                MySqlCommand cmd  = new MySqlCommand(sql, sq);
                int          a    = Convert.ToInt32(cmd.ExecuteScalar());//返回一个值,看用户是否存在
                string       sql1 = string.Format("select count(*) from master where mpassword='******'", password);
                MySqlCommand cmd1 = new MySqlCommand(sql1, sq);
                int          b    = Convert.ToInt32(cmd1.ExecuteScalar());
                if (a != 0 && b != 0)
                {
                    管理员 form = new 管理员();
                    form.Show();
                }
                else
                {
                    DialogResult dr = MessageBox.Show("请检查您的用户名或密码是否正确,或注册新用户!", "登录失败!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                    if (dr == DialogResult.Yes)//打开注册页面
                    {
                        注册 form2 = new 注册();
                        form2.Show();
                    }
                    else
                    {
                        this.Show();
                    }
                }
            }
        }
Example #2
0
        private void button4_Click(object sender, EventArgs e)
        {
            成绩查询 form = new 成绩查询();

            form.Show();
        }