个人作业

计划：需要一周时间

需求分析：作为一个观众需要知道每一场的比赛得分情况，分数详细，列出局分以便了解比赛的战况。

生成设计文档：需要一个查询界面，和比赛得分的详细记录

设计复审：暂时没有和组员审核

代码规范：Visual Studio 2010

具体设计：1.观众查询界面

 

具体代码：

public partial class Spectator : Form
{
public Spectator()
{
InitializeComponent();
}
private void Spectator_Load(object sender, EventArgs e)
{
groupBox1.Visible = false;
}

private void btnSelect_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(comboBox1.Text))
{
groupBox1.Visible = true;
string sql = "select Team from Team where tName='%" + comboBox1.SelectedText + "%'";
SqlDataReader read = SqlHelper.ExecuteReader(sql, null);
if (read.Read())
{
int id = read.GetInt32(2);
string sql1 = "select * from JuFen where tId='%" + id + "%'";
SqlDataReader reader = SqlHelper.ExecuteReader(sql1, null);
if (reader.Read())
{
txtAfirst.Text = reader.GetString(2);
txtASec.Text = reader.GetString(2);
txtAThi.Text = reader.GetString(2);
txtAfou.Text = reader.GetString(2);
txtAfive.Text = reader.GetString(2);
txtBfirst.Text = reader.GetString(3);
txtBSec.Text = reader.GetString(3);
txtBThi.Text = reader.GetString(3);
txtBfou.Text = reader.GetString(3);
txtBfive.Text = reader.GetString(3);
}
}
}
else
{
MessageBox.Show("请输入要查询的比赛队伍！");
groupBox1.Visible = false;
}
}
private void labFirst_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
first a = new first();
a.Show();
}

private void comboBox1_TextChanged(object sender, EventArgs e)
{
comboBox1.DroppedDown = true;
string sql = "select tName from Team where tName like '%"+comboBox1.Text.Trim()+"%'";
SqlDataReader read = SqlHelper.ExecuteReader(sql, null);
if (read.Read())
{
comboBox1.Items.Add(read.HasRows);
}
}

代码还未全部写出来

代码复审：还未写完

测试：测试出错

测试报告：数据库连接出错

计算工作量：1天

事后总结：漏洞百出，需要进一步学习