本软件基于C#,SQL Server,功能,用户注册,登录,输入希望生成试题的总数n点击“生成试题”按钮便可随机生成n道加减乘除的算式。答题过程总可点击“当前得分”查看已答题目是否正确。中途可退出。下次登录后点击“继续答题”按钮便可继续上次的答题。
注册面板对应的代码如下:
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Windows.Forms;
- using System.Data.SqlClient;
- namespace BriansApplication1
- {
- public partial class Register : Form
- {
- public Register()
- {
- InitializeComponent();
- }
- private void tbROK_Click(object sender, EventArgs e)
- {
- string mysql, mystr;
- SqlConnection myconn = new SqlConnection();
- SqlCommand mycmd = new SqlCommand();
- mystr = "Data Source=.\\SQLEXPRESS;Initial Catalog=Student;Integrated Security=True";
- myconn.ConnectionString = mystr;
- myconn.Open();
- mysql = string.Format("insert into student ([id],[name]) values('" + tbRID.Text + "','" + tbRName.Text + "') ");
- mycmd.CommandText = mysql;
- mycmd.Connection = myconn;
- SqlDataReader myreader = mycmd.ExecuteReader();
- if (!myreader.Read())
- {
- MessageBox.Show("注册成功!");
- }
- else
- {
- MessageBox.Show("注册失败,再次尝试!");
- }
- myconn.Close();
- Login login = new Login();
- login.tbID.Text = this.tbRID.Text;
- login.tbName.Text = this.tbRName.Text;
- login.Show();
- this.Dispose();
- }
- private void Register_Load(object sender, EventArgs e)
- {
- }
- private void btRCancel_Click(object sender, EventArgs e)
- {
- this.Dispose();
- Login login = new Login();
- login.Visible = true;
- }
- }
- }
登录界面对应的代码如下:
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Text;
- using System.Windows.Forms;
- using System.Threading;
- using System.Data.SqlClient;
- using System.Data.OleDb;
- namespace BriansApplication1
- {
- public partial class Login : Form
- {
- public Login()
- {
- InitializeComponent();
- }
- private void btLogin_Click(object sender, EventArgs e)
- {
- if (tbID.Text == "")
- {
- MessageBox.Show("学号不能为空,请再次输入!");
- }
- else if (tbName.Text == "")
- {
- MessageBox.Show("密码不能为空,请再次输入!");
- }
- else
- {
- string mysql, mystr;
- SqlConnection myconn = new SqlConnection();
- SqlCommand mycmd = new SqlCommand();
- mystr = "Data Source=.\\SQLEXPRESS;Initial Catalog=Student;Integrated Security=True";
- myconn.ConnectionString = mystr;
- myconn.Open();
- mysql = string.Format("select test from student where student.id='{0}' and student.name='{1}'", tbID.Text.Trim(), tbName.Text.Trim());
- mycmd.CommandText = mysql;
- mycmd.Connection = myconn;
- SqlDataReader myreader = mycmd.ExecuteReader();
- if (myreader.Read())
- {
- TestPaper test = new TestPaper(tbID.Text);
- try
- {
- string temp = myreader.GetString(0);
- if(temp != null)
- {
- test.btCreate.Hide();
- test.tbCount.Enabled = false;
- }
- }
- catch
- {
- test.btContinue.Hide();
- }
- test.Show();
- }
- else
- {
- MessageBox.Show("用户不存在,请注册!");
- }
- myreader.Close();
- myconn.Close();
- }
- }
- private void btClose_Click(object sender, EventArgs e)
- {
- Application.Exit();
- }
- private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)//注册
- {
- this.Visible = false;
- Register register = new Register();
- register.Show();
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- }
- }
- }
转载于:https://blog.51cto.com/huamm/1049977