string pConStr = "datasource=127.0.0.1;username=root;password=shi123;database=test;charset=utf8";
            try
            {
                MySqlConnection pMysqlConnection = new MySqlConnection(pConStr);
                
                    //连接数据库
                pMysqlConnection.Open();
                //MessageBox.Show("success");
                //定义变量
                int pSID;
                string pName = textBox2.Text;
                int pChinese = Convert.ToInt32(textBox3.Text);
                int pMath = Convert.ToInt32(textBox4.Text);
                int pEnglish = Convert.ToInt32(textBox5.Text);
                pSID = Convert.ToInt32(textBox1.Text);
                //插入成绩单
                string pMysqlInsert1 = "INSERT INTO `成绩表`(`学号`,`语文`,`数学`,`英语`) VALUES(@pSID,@pChinese,@pMath,@pEnglish);";
                MySqlCommand pMysqlcommandInsert1 = new MySqlCommand(pMysqlInsert1, pMysqlConnection);
                pMysqlcommandInsert1.Parameters.AddWithValue("@pSID",pSID);
                pMysqlcommandInsert1.Parameters.AddWithValue("@pMath", pMath);
                pMysqlcommandInsert1.Parameters.AddWithValue("@pEnglish", pEnglish);
                //pMysqlcommandInsert1.Parameters.AddWithValue("@pName", pName);
                pMysqlcommandInsert1.Parameters.AddWithValue("@pChinese", pChinese);

                //插入花名册
                string pMysqlInsert2 = "INSERT INTO `花名册`(`学号`,`姓名`) VALUES(@pSID,@pName);";
                MySqlCommand pMysqlcommandInsert2 = new MySqlCommand(pMysqlInsert2, pMysqlConnection);
                pMysqlcommandInsert2.Parameters.AddWithValue("@pSID", pSID);
                pMysqlcommandInsert2.Parameters.AddWithValue("@pName", pName);
                

                MessageBox.Show("插入成功");
                pMysqlcommandInsert1.ExecuteNonQuery();
                pMysqlcommandInsert2.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

 

posted on 2018-07-31 21:49  xiaoshibushiyue  阅读(404)  评论(0)    收藏  举报