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());
}