面向对象课程设计日志（六）

最新推荐文章于 2024-07-08 21:23:20 发布
最新推荐文章于 2024-07-08 21:23:20 发布
阅读量234 收藏
点赞数
分类专栏： 课程设计日志 图形用户界面 文章标签： c++ visual studio 面向对象编程
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45941960/article/details/108809351
版权

目录

学习新单词

设计中的技巧：

“RorL.h”

“Study.h”

实现效果：

复习测试

设计中的技巧

“Review.h”

成果展示

生词表

设计中的技巧

“Study.h”

成果展示

  1. 学习新单词

    1. 设计中的技巧：

      1. 顺序或随机学习的选择窗口可以在学习窗口的构造函数中弹出供选择，用一个变量记录选择状态。
      2. 随机学习时保证不重复：可以用一个vector打乱顺序作为乱序的“顺序”。

    2. “RorL.h”

      1. 引入全局变量learningMode, learnflag;
      2. 组件声明： 
        private: System::Windows::Forms::Label^ label1; //“请选择学习模式：”
private: System::Windows::Forms::Button^ button1; //“顺序”或“汉译英”
private: System::Windows::Forms::Button^ button2; //“随机”或“英译汉”

         

      3. 事件方法
        1. 界面加载 
          private: System::Void RorL_Load(System::Object^ sender, System::EventArgs^ e) {
	if (!learnflag) {//判断选择情况：学习新单词还是复习测试
	    String^ EtoC = "汉译英";
	    this->button1->Text = EtoC;
	    String^ CtoE = "英译汉";
	    this->button2->Text = CtoE;
    }
}

           

        2. 单击“顺序”或“汉译英”

          private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
	learningMode = true;
	this->Close();
}

           

        3. 单击“随机”或“英译汉”

          private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e) {
	learningMode = false;
	this->Close();
}

           

    3. “Study.h”

      1. 头文件引入”Word.h”; “RorL.h”; “MySQLDbConn.h”; “User.h”; <algorithm>（打乱顺序的random_shuffle函数）; <time.h>（读取日期）; <stdlib.h>; <string> （to_string函数）

      2. 引入全局变量member, wordlist, userConnect, word, temp, learnflag
      3. 组件声明 
        private: System::Windows::Forms::Label^ label1; //显示单词
private: System::Windows::Forms::Label^ label2; //“翻译：”
private: System::Windows::Forms::Label^ label3; //中文
private: System::Windows::Forms::Label^ label4; //“词性：”
private: System::Windows::Forms::Label^ label5; //词性
private: System::Windows::Forms::Button^ button1; //“下一个”按钮
    int times = 1; // 记录学习的单词个数

         

      4. 事件方法
        1. 构造函数： 
          Study(void)
{
	InitializeComponent();
	learnflag = true;
	//选择学习模式
	RorL form;
	form.ShowDialog();
}

           

        2. 界面加载 
          private: System::Void Study_Load(System::Object^ sender, System::EventArgs^ e) {
	char** w;
	w = wordlist.GetRow();
	int id = atoi(w[0]);
	string wd = w[1];
	string ch = w[2];
	string ty = w[3];
	word.SetWord(id,wd,ch,ty,false);
	
    String^ wrd = gcnew String(word.Getword().c_str());
	this->label1->Text = wrd;
	String^ chi = gcnew String(word.GetChinese().c_str());
	this->label3->Text = chi;
	String^ typ = gcnew String(word.GetType().c_str());
	this->label5->Text = typ;
}

           

        3. 单击“下一个”按钮

          private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
	if (times < stoi(member.GetUserDailyPlan()) && wordlist.GetNextRow() != NULL) {
		char** w;
		if (learningMode) {
		    //顺序学习
		    w = wordlist.GetNextRow();
		    int id = atoi(w[0]);
		    string wd = w[1];
		    string ch = w[2];
		    string ty = w[3];
		    word.SetWord(id, wd, ch, ty, false);
	 
		    String^ wrd = gcnew String(word.Getword().c_str());
		    this->label1->Text = wrd;
		    String^ chi = gcnew String(word.GetChinese().c_str());
		    this->label3->Text = chi;
		    String^ typ = gcnew String(word.GetType().c_str());
		    this->label5->Text = typ;
		}
		else {//随机学习
		    if (times == 1) {
		        //打乱顺序
		        random_shuffle(temp.begin(), temp.end());
		    }
		//获取单词
		    w = wordlist.GetRandomRow(temp[times] %wordlist.GetListLength());
		    int id = atoi(w[0]);
		    string wd = w[1];
		    string ch = w[2];
		    string ty = w[3];
		    word.SetWord(id, wd, ch, ty, false);
	 
		    String^ wrd = gcnew String(word.Getword().c_str());
		    this->label1->Text = wrd;
	 
		    String^ chi = gcnew String(word.GetChinese().c_str());
		    this->label3->Text = chi;
	 
		    String^ typ = gcnew String(word.GetType().c_str());
		    this->label5->Text = typ;
		}
		times++;
	}
	else {
		System::Windows::Forms::MessageBox::Show("学习完成，休息一下吧！", "学习完成");
		time_t tt = time(NULL);
		tm* t = localtime(&tt);
		string year = to_string(t->tm_year + 1900);
		string month = to_string(t->tm_mon + 1);
		string day = to_string(t->tm_mday);
		string sqlInsert = "insert into " + member.GetUsername() + "(year, month, day) values('" + year + "', '" + month + "', '" + day + "');";
		const char* Sql = nullptr;
		Sql = sqlInsert.c_str();
		if (userConnect.ExecuteSql(Sql)) {
	    }
		else {
		    System::Windows::Forms::MessageBox::Show("连接失败，请重试！", "连接失败！");
	 
		}
				Study::Close();
	}
}

           

    4. 实现效果：

      1. 在主界面单击“学习新单词”按钮后，会弹出学习模式选择

        Caption

      2. 学习界面

        Caption

      3. 学习够指定计划数的单词，或单词表浏览完毕后弹出提示

        Caption

  2. 复习测试

    1. 设计中的技巧

      1. 测试使用选择题的形式，分为英译汉、汉译英两种模式，选择窗口可以重用上一个的“RorL.h”，只需更改文字显示即可。
      2. 正确选项使用3以内随机数确定，其余选项从单词表中选取。
      3. 每选对一个单词（单击“下一个”）后，将该单词移动到对应已背完单词表：“用户名+finish”。
      4. 没有选对的单词（单击“下一个”）后，将该单词复制到对应生词表：“用户名+newword”。
      5. 当未检测单词数量不够选项数量时，从已背完单词表读取。
      6. 选择对错应有提示。
      7. 最后，在日计划完成或单词表计划完成后，将已记忆单词和生词表单词输出为文件。

    2. “Review.h”

      1. 头文件引入”Word.h”; ”RorL.h”; “MySQLDbConn.h”; “User.h”; <algorithm>; <time.h>; <string>; <fstream>; <iostrream>
      2. 引入全局变量：member, wordlist, userConnect, word, temp, learnMode;
      3. 组件声明： 
        private: System::Windows::Forms::Label^ label1; //单词或中文
private: System::Windows::Forms::Button^ button1; //选项A
private: System::Windows::Forms::Button^ button2; //选项B
private: System::Windows::Forms::Button^ button3; //选项C
private: System::Windows::Forms::Button^ button4; //“下一个”按钮
    int times = 0; //测试次数
	int choice; // 正确选项号
	bool test; //单词学习状态
private: System::Windows::Forms::Label^ label2; //“A.”
private: System::Windows::Forms::Label^ label3; //“B.”
private: System::Windows::Forms::Label^ label4; //“C.”

         

      4. 事件方法
        1. 界面加载： 
          private: System::Void Review_Load(System::Object^ sender, System::EventArgs^ e) {
	if (learningMode) {
    //汉译英
		char** w;
		w = wordlist.GetNextRow();
		int id = atoi(w[0]);
		string wd = w[1];
		string ch = w[2];
		string ty = w[3];
		word.SetWord(id, wd, ch, ty, false);
 
		String^ wrd = gcnew String(word.Getword().c_str());
		this->label1->Text = wrd;
//随机选项设置
	    choice = rand() % 3 + 1;
		switch (choice)
		{
		    case 1: {
				if (wordlist.GetListLength() <= 3) {  //当列表中的数据不够提供选项时，从已测列表中读取；
					string sqlSelectw = "select * from " + member.GetUsername() + "finish";
					const char* Sqlwd = sqlSelectw.c_str();
					userConnect.ExecuteQuerySql(Sqlwd);
					string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
					w = userConnect.GetNextRow(); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
					w = userConnect.GetNextRow(); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
				}
				else {
					string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
					w = wordlist.GetNextRow(); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
					w = wordlist.GetNextRow(); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
				}
			}
			case 2: {
				if (wordlist.GetListLength() <= 3) {
					string sqlSelectw = "select * from " + member.GetUsername() + "finish";
					const char* Sqlwd = sqlSelectw.c_str();
					userConnect.ExecuteQuerySql(Sqlwd);
					string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
					w = userConnect.GetNextRow(); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
					w = userConnect.GetNextRow(); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
				}
				else {
					string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
					w = wordlist.GetNextRow(); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
					w = wordlist.GetNextRow(); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
				}
			}
			case 3: {
				if (wordlist.GetListLength() <= 3) {
					string sqlSelectw = "select * from " + member.GetUsername() + "finish";
					const char* Sqlwd = sqlSelectw.c_str();
					userConnect.ExecuteQuerySql(Sqlwd);
					string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
					w = userConnect.GetNextRow(); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
					w = userConnect.GetNextRow(); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
				}
				else {
					string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
					w = wordlist.GetNextRow(); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
					w = wordlist.GetNextRow(); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
				}
			}
	    default:
	    break;
	    }
	}
	else {
    //英译汉
	    char** w;
	    w = wordlist.GetNextRow();
	    int id = atoi(w[0]);
	    string wd = w[1];
	    string ch = w[2];
	    string ty = w[3];
	    word.SetWord(id, wd, ch, ty, false);
	    String^ chi = gcnew String(word.GetChinese().c_str());
	    this->label1->Text = chi;
    //随机选项设置
	    choice = rand() % 3 + 1;
	    switch (choice)
	    {
			case 1: {
				if (wordlist.GetListLength() <= 3) {
					string sqlSelectw = "select * from " + member.GetUsername() + "finish";
					const char* Sqlwd = sqlSelectw.c_str();
					userConnect.ExecuteQuerySql(Sqlwd);
					string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
					w = userConnect.GetNextRow(); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
					w = userConnect.GetNextRow(); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
				}
				else {
					string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
					w = wordlist.GetNextRow(); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
					w = wordlist.GetNextRow(); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
				}
			}
			case 2: {
				if (wordlist.GetListLength() <= 3) {
					string sqlSelectw = "select * from " + member.GetUsername() + "finish";
					const char* Sqlwd = sqlSelectw.c_str();
					userConnect.ExecuteQuerySql(Sqlwd);
					string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
					w = userConnect.GetNextRow(); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
					w = userConnect.GetNextRow(); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
				}
				else {
					string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
					w = wordlist.GetNextRow(); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
					w = wordlist.GetNextRow(); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
				}
			}
			case 3: {
				if (wordlist.GetListLength() <= 3) {
					string sqlSelectw = "select * from " + member.GetUsername() + "finish";
					const char* Sqlwd = sqlSelectw.c_str();
					userConnect.ExecuteQuerySql(Sqlwd);
					string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
					w = userConnect.GetNextRow(); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
					w = userConnect.GetNextRow(); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
				}
				else {
					string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
		w = wordlist.GetNextRow(); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
					w = wordlist.GetNextRow(); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
				}
			}
	    default:
	    break;
	    }
	}
	times++;
}

           

        2. 单击选项A

          private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
	switch (choice)
	{
		case 1: {
	//选对了
		    String^ correct = "O"; this->label2->Text = correct; this->label2->ForeColor = Color::Green; word.SetTest(true);
		    int id = word.GetNum(); string wid = to_string(id);
	//更改数据库内容
		    string sqlInsert = "insert into " + member.GetUsername() + "finish(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    string deletesql = "delete from " + member.GetUserCurrentPlan() + " where id = " + wid;
		    Sql = deletesql.c_str();
		    string sqlSelectw = "select * from " + member.GetUserCurrentPlan();
		    const char* Sqlw = sqlSelectw.c_str();
		    if(!wordlist.ExecuteQuerySql(Sqlw)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error!", "Error");
		    }
		    if (wordlist.GetListLength() <= 0) {
		        string sqlUpdate = "update " + member.GetUsername() + " set history = '" + member.GetUserCurrentPlan() + "'; where name = '" + member.GetUsername() + "'";
		        const char* Sqlu = sqlUpdate.c_str();
		        userConnect.ExecuteSql(Sqlu);
		        System::Windows::Forms::MessageBox::Show("恭喜你本计划已学习完成！", "学习完成");
		    }
		    else if (!wordlist.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
	    }
		case 2: {
		    String^ correct = "X"; this->label2->Text = correct; this->label2->ForeColor = Color::Red; 
		    this->button2->ForeColor = Color::Green;
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "newword(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
	    }
		case 3: {
		    String^ correct = "X"; this->label2->Text = correct; this->label2->ForeColor = Color::Red; 
		    this->button3->ForeColor = Color::Green;
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "newword(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
		}
		default:
		break;
	}
}

           

        3. 单击选项B

          private: System::Void button2_Click(System::Object^ sender, System::EventArgs^ e) {
	switch (choice)
	{
		case 2: {
		    String^ correct = "O"; this->label3->Text = correct; this->label3->ForeColor = Color::Green; word.SetTest(true);
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "finish(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    string deletesql = "delete from " + member.GetUserCurrentPlan() + " where id = " + wid;
		    Sql = deletesql.c_str();
		    string sqlSelectw = "select * from " + member.GetUserCurrentPlan();
		    const char* Sqlw = sqlSelectw.c_str();
		    if (!wordlist.ExecuteQuerySql(Sqlw)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error!", "Error");
		    }
		    if (wordlist.GetListLength() <= 0) {
		        string sqlUpdate = "update " + member.GetUsername() + " set history = '" + member.GetUserCurrentPlan() + "'; where name = '" + member.GetUsername() + "'";
		        const char* Sqlu = sqlUpdate.c_str();
		        userConnect.ExecuteSql(Sqlu);
		        System::Windows::Forms::MessageBox::Show("恭喜你本计划已学习完成！", "学习完成");
		    }
		    else if (!wordlist.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
		}
		case 1: {
		    String^ correct = "X"; this->label3->Text = correct; this->label3->ForeColor = Color::Red; 
		    this->button1->ForeColor = Color::Green;
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "newword(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
		}
		case 3: {
		    String^ correct = "X"; this->label3->Text = correct; this->label3->ForeColor = Color::Red; 
		    this->button3->ForeColor = Color::Green;
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "newword(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
		}
		default:
		break;
	}
}

           

        4. 单击选项C

          private: System::Void button3_Click(System::Object^ sender, System::EventArgs^ e) {
	switch (choice)
	{
		case 3: {
		    String^ correct = "O"; this->label4->Text = correct; this->label4->ForeColor = Color::Green; word.SetTest(true);
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "finish(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    string deletesql = "delete from " + member.GetUserCurrentPlan() + " where id = " + wid;
		    Sql = deletesql.c_str();
		    string sqlSelectw = "select * from " + member.GetUserCurrentPlan();
		    const char* Sqlw = sqlSelectw.c_str();
		    if (!wordlist.ExecuteQuerySql(Sqlw)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error!", "Error");
		    }
		    if (wordlist.GetListLength() <= 0) {
		        string sqlUpdate = "update " + member.GetUsername() + " set history = '" + member.GetUserCurrentPlan() + "'; where name = '" + member.GetUsername() + "'";
		        const char* Sqlu = sqlUpdate.c_str();
		        userConnect.ExecuteSql(Sqlu);
		        System::Windows::Forms::MessageBox::Show("恭喜你本计划已学习完成！", "学习完成");
		    }
		    else if (!wordlist.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
		}
		case 2: {
		    String^ correct = "X"; this->label4->Text = correct; this->label4->ForeColor = Color::Red;
		    this->button2->ForeColor = Color::Green;
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "newword(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
	    	}
		    break;
		}
		case 1: {
		    String^ correct = "X"; this->label4->Text = correct; this->label4->ForeColor = Color::Red;
		    this->button1->ForeColor = Color::Green;
		    int id = word.GetNum(); string wid = to_string(id);
		    string sqlInsert = "insert into " + member.GetUsername() + "newword(id, word, chinese, type) values(" + wid + ", '" + word.Getword() + "', '" + word.GetChinese() + "', '" + word.GetType() + "');";
		    const char* Sql = nullptr;
		    Sql = sqlInsert.c_str();
		    if (!userConnect.ExecuteSql(Sql)) {
		        System::Windows::Forms::MessageBox::Show("Connection Error", "Error!");
		    }
		    break;
		}
		default:
		break;
	}
}

           

        5. 单击“下一个”按钮

          private: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e) {
	//恢复按钮和提示
	this->label2->Text = "A."; this->label2->ForeColor = Color::Black;
	this->label3->Text = "B."; this->label3->ForeColor = Color::Black;
	this->label4->Text = "C."; this->label4->ForeColor = Color::Black;
	this->button1->ForeColor = Color::Black;
	this->button2->ForeColor = Color::Black;
	this->button3->ForeColor = Color::Black;
	if (word.GetTest()) {
	//输出上一个单词
		ofstream outfile;
		string write = to_string(word.GetNum()) + "\t" + word.Getword() + "\t" + word.GetChinese() + "\t" + word.GetType() + "\n";
		outfile.open("E:\\DATA\\Finish_wordlist.txt", ios::out | ios::app);
		    if (!outfile.is_open()) {
		        System::Windows::Forms::MessageBox::Show("文件创建失败，请重试！", "文件创建失败！");
		    }
		    else {
		    outfile << write;
		    outfile.close();
		    }
		}
		else {
		    ofstream outfile;
		    string write = to_string(word.GetNum()) + "\t" + word.Getword() + "\t" + word.GetChinese() + "\t" + word.GetType() + "\n";
		    outfile.open("E:\\DATA\\New_wordlist.txt", ios::out | ios::app);
		    if (!outfile.is_open()) {
		        System::Windows::Forms::MessageBox::Show("文件创建失败，请重试！", "文件创建失败！");
		    }
		    else {
		        outfile << write;
		        outfile.close();
		    }
		}
		if (times < stoi(member.GetUserDailyPlan())) {
		    if (learningMode) {
		        string sqlSelectw = "select * from " + member.GetUserCurrentPlan();
		        const char* Sqlw = sqlSelectw.c_str();
		        wordlist.ExecuteQuerySql(Sqlw);
		            if (wordlist.GetListLength() > 0) {
					    if (wordlist.GetListLength() >= 3) {
						    char** w;
						    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength());
						    int id = atoi(w[0]);
						    string wd = w[1];
						    string ch = w[2];
						    string ty = w[3];
						    word.SetWord(id, wd, ch, ty, false);
	 
						    String^ wrd = gcnew String(word.Getword().c_str());
						    this->label1->Text = wrd;
						    choice = rand() % 3 + 1;
						    switch (choice)
						    {
						    case 1: {
							    string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
						    	w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
						    }
						    case 2: {
							    string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
						}
						case 3: {
							string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
							w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
							w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
						}
						default:
							break;
						}
					}
					else {
						sqlSelectw = "select * from " + member.GetUsername() + "finish";
						const char* Sqlwd = sqlSelectw.c_str();
						userConnect.ExecuteQuerySql(Sqlwd);
						char** w;
						w = wordlist.GetRandomRow((times++) % wordlist.GetListLength());
						int id = atoi(w[0]);
						string wd = w[1];
						string ch = w[2];
						string ty = w[3];
						word.SetWord(id, wd, ch, ty, false);
	 
						String^ wrd = gcnew String(word.Getword().c_str());
						this->label1->Text = wrd;
						choice = rand() % 3 + 1;
						switch (choice)
						{
						case 1: {
							string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
							w = userConnect.GetNextRow(); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
							w = userConnect.GetNextRow(); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
						}
						case 2: {
						string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
							w = userConnect.GetNextRow(); string choice1 = w[2]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
							w = userConnect.GetNextRow(); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
						}
						case 3: {
							string answer = w[2]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
							w = userConnect.GetNextRow(); string choice2 = w[2]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
							w = userConnect.GetNextRow(); string choice3 = w[2]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
						}
						default:
							break;
						}
					}
		        }
		        else {
		            string sqlUpdate = "update " + member.GetUsername() + " set history = '" + member.GetUserCurrentPlan() + "'; where name = '" + member.GetUsername() + "'";
		            const char* Sqlu = sqlUpdate.c_str();
		            userConnect.ExecuteSql(Sqlu);
		            System::Windows::Forms::MessageBox::Show("恭喜你本计划已学习完成！", "学习完成");
					Review::Close();
		        }
		    }
		    else {
		        string sqlSelectw = "select * from " + member.GetUserCurrentPlan();
		        const char* Sqlw = sqlSelectw.c_str();
		        wordlist.ExecuteQuerySql(Sqlw);
		            if (wordlist.GetListLength()) {
					    if (wordlist.GetListLength() >= 3) {
						    char** w;
						    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength());
						    int id = atoi(w[0]);
						    string wd = w[1];
						    string ch = w[2];
						    string ty = w[3];
						    word.SetWord(id, wd, ch, ty, false);
	 
						    String^ wrd = gcnew String(word.GetChinese().c_str());
						    this->label1->Text = wrd;
						    choice = rand() % 3 + 1;
						    switch (choice)
						    {
						    case 1: {
							    string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
						    }
						    case 2: {
							    string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
						    }
						    case 3: {
							    string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
							    w = wordlist.GetRandomRow((times++) % wordlist.GetListLength()); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
						    }
						    default:
							break;
						}
					}
					else {
						sqlSelectw = "select * from " + member.GetUsername() + "finish";
						const char* Sqlwd = sqlSelectw.c_str();
						userConnect.ExecuteQuerySql(Sqlwd);
						char** w;
						w = wordlist.GetRandomRow((times++) % wordlist.GetListLength());
						int id = atoi(w[0]);
						string wd = w[1];
						string ch = w[2];
						string ty = w[3];
						word.SetWord(id, wd, ch, ty, false);
	 
						String^ wrd = gcnew String(word.GetChinese().c_str());
						this->label1->Text = wrd;
						choice = rand() % 3 + 1;
						switch (choice)
						{
						case 1: {
							string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button1->Text = an;
							w = userConnect.GetNextRow(); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button2->Text = ch1;
							w = userConnect.GetNextRow(); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button3->Text = ch2; break;
			}
						case 2: {
							string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button2->Text = an;
							w = userConnect.GetNextRow(); string choice1 = w[1]; String^ ch1 = gcnew String(choice1.c_str()); this->button3->Text = ch1;
							w = userConnect.GetNextRow(); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button1->Text = ch3; break;
						}
						case 3: {
							string answer = w[1]; String^ an = gcnew String(answer.c_str()); this->button3->Text = an;
							w = userConnect.GetNextRow(); string choice2 = w[1]; String^ ch2 = gcnew String(choice2.c_str()); this->button1->Text = ch2;
							w = userConnect.GetNextRow(); string choice3 = w[1]; String^ ch3 = gcnew String(choice3.c_str()); this->button2->Text = ch3; break;
						}
						default:
						break;
					}
				}
	        }
	        else {
	            string sqlUpdate = "update " + member.GetUsername() + " set history = '" + member.GetUserCurrentPlan() + "'; where name = '" + member.GetUsername() + "'";
	            const char* Sqlu = sqlUpdate.c_str();
	            userConnect.ExecuteSql(Sqlu);
	            System::Windows::Forms::MessageBox::Show("恭喜你本计划已学习完成！", "学习完成");
				Review::Close();
	        }
        }
	}
	else {
	    System::Windows::Forms::MessageBox::Show("学习完成，休息一下吧！", "学习完成");
		Review::Close();
	}
}

           

    3. 成果展示

      1. 单击“复习旧单词”按钮后，选择测试模式

        Caption

      2. 汉译英模式

        Caption

      3. 英译汉模式

        Caption

      4. 选择正确与错误都会在选项上有所提示

      5. 用户记忆完的单词会存在“用户名+finish”中

        Caption

      6. 生词表的单词会存在“用户名+newword”中

        Caption

      7. 已记忆的单词会存在“Finish_wordlist.txt”

        Caption

      8. 生词表的单词会存在“New_wordlist.txt”；

        Caption

  3. 生词表

    1. 设计中的技巧

      1. 套用学习新单词的界面设计，功能相似。

    2. “Study.h”

      1. 头文件：同”Study.h”
      2. 引入全局变量：同”Study.h”
      3. 组件声明：同”Study.h”
      4. 事件方法：与”Study.h”基本相同
        1. 界面加载 
          private: System::Void Study1_Load(System::Object^ sender, System::EventArgs^ e) {
	string sqlSelect = "select * from " + member.GetUsername() + "newword";
	const char* Sql = sqlSelect.c_str();
	if (!userConnect.ExecuteQuerySql(Sql)) {
	    System::Windows::Forms::MessageBox::Show("Connection Error!", "Error");
	}
	else {
	    char** w;
	    w = userConnect.GetRow();
	    if (w != NULL) {
	        int id = atoi(w[0]);
	        string wd = w[1];
	        string ch = w[2];
	        string ty = w[3];
	        word.SetWord(id, wd, ch, ty, false);
 
	        String^ wrd = gcnew String(word.Getword().c_str());
	        this->label1->Text = wrd;
 
	        String^ chi = gcnew String(word.GetChinese().c_str());
	        this->label3->Text = chi;
 
	        String^ typ = gcnew String(word.GetType().c_str());
	        this->label5->Text = typ;
	    }    
	    else {
	        System::Windows::Forms::MessageBox::Show("没有生词！请回吧！", "无生词");
		    Study1::Close();
	    }
	}
	times++;
}

           

        2. 单击“下一个”按钮

          private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) {
	int count = userConnect.GetListLength();
	if (times < count && times < stoi(member.GetUserDailyPlan())) {
		char** w;
		w = userConnect.GetNextRow();
		int id = atoi(w[0]);
		string wd = w[1];
		string ch = w[2];
		string ty = w[3];
		word.SetWord(id, wd, ch, ty, false);
	 
		String^ wrd = gcnew String(word.Getword().c_str());
		this->label1->Text = wrd;
	 
		String^ chi = gcnew String(word.GetChinese().c_str());
		this->label3->Text = chi;
	 
		String^ typ = gcnew String(word.GetType().c_str());
		this->label5->Text = typ;
	 
		times++;
	}
	else {
		System::Windows::Forms::MessageBox::Show("学习完成，休息一下吧！", "学习完成");
	}
}

           

    3. 成果展示

      1. 生词表学习与学习新单词模式一样

        Caption

下期预告：查看历史记录。

 

King Stars
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
C#窗体的Load事件与Shown事件的区别
「 刘一哥与GIS的故事」
03-20 2万+
Load：在第一次显示窗体前发生。 private void Form1_Load(object sender, EventArgs e) { MessageBox.Show("You are in the Form.Shown event.");} Shown：只有在首次显示窗体时才会引发 Shown 事件；随后执行的最小化、最大化、还原、隐藏、显示或无效化和重新绘制操作都
面向对象课程设计教职工管理系统
06-13
总的来说，这个面向对象课程设计的教职工管理系统是一个综合性的学习资源，涵盖了软件工程的多个方面，不仅能让学生掌握面向对象编程技术，还能提升他们数据库设计、系统架构和项目管理的能力。通过实践这个项目，...
学习日记——面向对象
txyllyyj的博客
07-31 116
面向对象 编程思想——面向对象(OOP)与面向过程(POP)的区别 1.面向过程：面向过程是一种以过程为中心的编程思想解决问题的方法与步骤。 2.面向对象：找"对象"解决问题。Object Oriented 相关的数据和方法组织为一个整体，这个整体就是类。 3.面向对象基于面向过程的，面向对象以面向过程为基础。解决简单问题时，建议用面向过程，解决复杂问题时，建议用面向对象。 类与对象 类：具有共同特性的一类事物的总称 对象：具体的事物 对象创建的内存图 栈： 正在执行的方法 ，局部变量
2021-10-07大数据学习日志——Python基础——面向对象（上）（类和对象、魔方方法）（附练习题）
tingbaobaoo的博客
10-07 236
学习目标： 了解面向过程和面向对象的区别 知道类是由方法(函数)和属性(变量)构成 掌握类和对象的使用，例如：定义类、创建对象、对象调用方法，对象添加和使用属性 知道方法中 self 参数的作用 知道魔法方法的特点和使用 知道烤地瓜案例的需求和实现思路 知道搬家具案例的需求和实现思路 01_面向对象编程 学习目标： 了解面向过程和面向对象的区别 1.1 面向过程 把编程任务划分成一个一个的步骤，然后按照步骤分别去执行。 以小明起床上学为例，面向过程则做了如下 4 件事：起床、..
20210911面向对象java学习日志_接口和内部类
m0_51706126的博客
09-11 98
接口 普通类：只有具体实现 抽象类：具体实现和规范都有 接口：只有规范 接口就是规范，定义的是一组规则 接口的本质是契约 UsersService.java //锻炼抽象的思维 //不能定义方法 public interface UsersService { //接口中的所有定义都是抽象的 默认是 public abstract //接口中定义的属性，默认都是常量 public static final int AGE = 99; void ad
关于(object sender, System.EventArgs e)中参数sender和e的问题
pyrtvu的专栏
08-08 3191
（1）请具体解释一下(object sender, System.EventArgs e)的含义。 （2）既然在(object sender, System.EventArgs e)中sender和e都是参数，那么为什么每次在定义事件时它们都不变呢？我看到在很多事件代码中那些代
面向对象课程设计日志（一）
weixin_45941960的博客
09-19 1059
学习完C++面向对象课程后，通过VisualStudio进行图形用户界面设计，借助数据库管理进行课程设计，撰写日志作为记录。 本日志集中在编程前的准备。
面向对象课程设计日志（八）
weixin_45941960的博客
09-27 601
面向对象课程设计的最后一期，做个小小的总结，同时要感谢网上大佬们总结出的方法。希望大家喜欢这个系列。
面向对象程序设计（Java）课程设计--坦克大战
weixin_60761537的博客
06-17 1979
一、项目简介1.功能描述：这个坦克大战实现了我方坦克(玩家控制)以及多个敌方坦克(程序随机控制)的对战，当击毁所有敌方坦克之后游戏结束。可以进行新游戏和继续游戏的操作，游戏中，敌方坦克为蓝色坦克，其中键盘的w、s、a、d分别控制黄色坦克上下左右四个方向的移动，点击键盘的“j”为发射子弹，并且可以连发，击中坦克后会有爆炸效果，并且记录玩家得分。 二、团队成员负责模块：①（我方或敌方）坦克发射子弹②（我方或敌方）坦克消失（爆炸）③控制坦克移动范围④敌方坦克如何随机移动⑤我方如何进行多发子弹（Vector集合）①
《面向对象程序设计》实习教学大纲.docx
12-16
6. 第六天至第十天：C++面向对象遥感影像程序设计与实现。 7. 第十天：工作总结及实习成果上交。 本课程的考核内容包括： 1. 分析步骤的完整性、正确性 2. 实验中分析结果正确性 3. 实习出勤率 4. 实习日志（每天...
面向对象课程设计C++电梯
03-07
总结来说，这个C++电梯仿真课程设计是一个综合性的实践项目，它涵盖了面向对象编程的基本概念，C++语言的特性和使用，以及模拟和优化算法的应用。通过这个项目，你可以提升编程能力，理解面向对象设计思想，并锻炼...
面向对象分析与设计练习题
06-04
面向对象分析与设计练习题 以下是对给定文件的知识点解析： 1. 图书管理系统用例图 在图书管理系统中，借阅者可以通过网络查询书籍信息和预定书籍。借阅者能够借阅书籍和还书。图书管理员能够处理借阅者的借阅和...
C++面向对象程序设计-课程设计-1.pdf
02-27
本次《面向对象程序设计》的课程设计旨在让学生通过实践进一步理解和掌握面向对象编程和C++的技术。设计任务主要包括创建个人通信录管理系统、学生成绩排名系统、学生学籍管理系统和学生成绩管理系统，每个系统都...
C++初学者指南-3.自定义类型(第一部分)-析构函数
silencestarsky的博客
07-02 628
本文介绍了C++初学者指南中关于自定义类型和析构函数的重要内容。主要涵盖了特殊的成员函数如构造函数和析构函数的作用，RAII资源管理的重要性以及避免编写特殊成员函数的建议。
c++习题08-计算星期几
码到成龚的博客
07-03 595
问题描述 假设今天是星期日，那么过a^b天之后是星期几？ 输入描述 两个正整数a，b，中间用单个空格隔开。0
Android 开发中 C++ 和Java 日志调试
小羊子的技术专栏
07-04 913
Android 开发中 C++ 和Java 日志调试方法小结
机器人运动范围检测 c++
m0_61862494的博客
07-02 762
地上有一个m行n列的方格，一个机器人从坐标（0，0）的格子开始移动，它每次可以向上下左右移动一个格子，但不能进入行坐标和列坐标的位数之和大于k的格子，请问机器人能够到达多少个格子。这个算法的时间复杂度为O(mn)，其中m和n分别是网格的行数和列数。空间复杂度也是O(mn)，主要用于存储visited数组和BFS队列。这个实现使用了广度优先搜索（BFS）算法来解决问题。
数学系C++ 继承派生多态 （十四十三）
最新发布
m0_68339197的博客
07-08 213
可以使得派生类具有父类的各种属性和功能，而不需要再次编写相同的代码。类的继承：派生类继承了父类的特性（数据和函数）► 继承是可传递的：从父类继承的特性可以传递给新的子类► 继承方式：规定了如何访问从父类继承的成员► 继承方式有三种：public、protected、private► 派生类成员：从父类继承的成员+新增加的成员继承方式不同，访问控制不同 父类成员函数访问父类成员：正常访问 派生类成员函数访问派生类新增成员：正常访问 父类成员函数访问派生类新增成员：不能访问。
C++：CV::Point函数简介
Ethan_Rich的博客
07-08 225
cv::Point是 OpenCV 库中用于表示二维坐标系下点的一个基本数据类型。它提供了在图像处理、计算机视觉等领域中定位和操作点的能力。以下是关于cv::Point。
软件二班第9组.pptx
07-29
“软件二班第9组.pptx”是一个关于面向对象程序设计的课程设计，主要内容是构建一个门禁系统，涉及计算机科学与技术领域的知识。设计者为刘昌周，答辩流程涵盖问题分析、思路与理念、方法实现与设计、测试运行以及...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值