数据库综合实验代码展示

登录界面

登录界面代码

namespace StudentManagementSystem
{
    
    public partial class LoginForm : Form
    {
        public LoginForm()
        {
            InitializeComponent();
        }
        public string code;
        
        public static string EncryptWithMD5(string source)
        {
            byte[] sor = Encoding.UTF8.GetBytes(source);
            MD5 md5 = MD5.Create();
            byte[] result = md5.ComputeHash(sor);
            StringBuilder strbul = new StringBuilder(40);
            for (int i = 0; i < result.Length; i++)
            {
                strbul.Append(result[i].ToString("x2"));//加密结果"x2"结果为32位,"x3"结果为48位,"x4"结果为64位
            }
            return strbul.ToString();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            string username = UserNametext.Text.Trim();  //取出账号
            string password = EncryptWithMD5(Passwordtext.Text.Trim());  //取出密码并加密

            //if (username == "admin")
            //password = "123";//测试用例，便于初始化时候的 admin 密码 123可以顺利登陆。程序完成后可注释掉这行代码。

            //string connstr = ConfigurationManager.ConnectionStrings["connectionString"].ToString(); //读取连接字符串
            string myConnString = "Data Source=.;Initial Catalog=curricula_variable_system;Persist Security Info=True;User ID=sa;Password=";

            SqlConnection sqlConnection = new SqlConnection(myConnString);  //实例化连接对象
            sqlConnection.Open();

            string sql = "select UserID,UserPassword from SysUser where UserID = '" + username + "' and UserPassword = '" + password + "'";                                            //编写SQL命令
            SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);

            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            if (sqlDataReader.HasRows && textBox3.Text == code&&comboBox1.SelectedIndex==0)
            {
                common.id = UserNametext.Text.Trim();
                MessageBox.Show("欢迎使用！");             //登录成功
                StudentForm form2 = new StudentForm();
                form2.Show();
                this.Hide();
            }
            else if (sqlDataReader.HasRows && textBox3.Text == code && comboBox1.SelectedIndex == 1)
            {
                common.id = UserNametext.Text.Trim();
                MessageBox.Show("欢迎使用！");             //登录成功
                ManagerForm form2 = new ManagerForm();
                form2.Show();
                this.Hide();
            }
            else
            {
                MessageBox.Show("登录失败！");
                code = null;
                Random ran = new Random();
                int number;
                char code1;
                //取五个数 
                for (int i = 0; i < 5; i++)
                {
                    number = ran.Next();
                    if (number % 2 == 0)
                        code1 = (char)('0' + (char)(number % 10));
                    else
                        code1 = (char)('A' + (char)(number % 26)); //转化为字符 

                    this.code += code1.ToString();
                }

                linkLabel1.Text = code;
                return;
            }
            sqlDataReader.Close();
            sql = "insert into SysLog values ( '" + username + "' , '" + DateTime.Now + "' , '" + "Login" + "')";                                            //编写SQL命令
            sqlCommand = new SqlCommand(sql, sqlConnection);
            sqlCommand.ExecuteNonQuery();
            sqlConnection.Close();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Application.Exit();
        }

        private void LoginForm_Load(object sender, EventArgs e)
        {
            Random ran = new Random(); 
            int number;
            char code1;
            //取五个数 
            for (int i = 0; i < 5; i++)
            {
                number = ran.Next();
                if (number % 2 == 0)
                    code1 = (char)('0' + (char)(number % 10));
                else
                    code1 = (char)('A' + (char)(number % 26)); //转化为字符 

                this.code += code1.ToString();
            }

            linkLabel1.Text = code;

        }
        //点击验证码可以刷新
        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            code = null;
            Random ran = new Random();
            int number;
            char code1;
            //取五个数 
            for (int i = 0; i < 5