Для анализа работоспособности подсистемы учёта и поиска электронной литературы необходимо провести тестирование на некотором подмножестве исходных данных и сравнить результаты, выдаваемые подсистемой с заранее известными необходимыми результатами.

Проведём тестирование на следующем подмножестве исходных данных, внесённых в базу данных:

работа №1: Заглавие: рейтинговые системы оценки успеваемости учащихся. Руководитель: С.А. Кольцов, Дата конференции 17.11.2008, студент: Горбанев Игорь Анатольевич, Группа ИТ-041 Дата завершения 05.11.2008.

работа №2: Заглавие: Изучение Access, Руководитель: Д.Е. Пачевский, Дата конференции 11.11.2008, студент: Иванов Иван Иванович, Группа ИТ-041 Дата завершения 07.11.2008.

работа №3: Заглавие: Реляционные БД, Руководитель: М.В. Паринов, Дата конференции 17.11.2008, студент: Петров Петр Петрович, Группа ИТ-042 Дата завершения 20.10.2008.

работа №4: Заглавие: Системы учета, Руководитель: М.В. Паринов, Дата конференции 17.11.2008, студент: Иванов Петр Петрович, Группа ИТ-042 Дата завершения 18.10.2008.

На странице поиска составим список из следующих критериев:

(Фамилия руководителя "Кольцов")

После нажатия на кнопку "найти" система возвращает список из одной работы - 1. То есть система вернула верный результат: работа 1 удовлетворяет указанному критерию.

Следующий критерий для поиска: дата конференции 17.11.2008

Результат: работы 1,2 и 4. Результат верный.

Тестирование форм добавления записей в таблицы и просмотра/редактирования таблиц также показало, что они работают правильно, то есть при добавлении и или редактировании изменения корректно вносятся в базу данных. Таким образом, можно заключить, что подсистема выполняет требуемые от нее функции в полном объеме и без ошибок.

Заключение

using System;

using System. Drawing;

using System. Collections;

using System.componentModel;

using System. Windows. Forms;

using System. Data;

namespace Kursovoi

{

// / <summary>

// / Summary description for Form1.

// / </summary>

public class Form1: System. Windows. Forms. Form

{

private System. Windows. Forms. Button button1;

private System. Windows. Forms. Button button2;

private System. Windows. Forms. Button button3;

// / <summary>

// / Required designer variable.

// / </summary>

private System.componentModel. Container components = null;

public Form1 ()

{

//

// Required for Windows Form Designer support

//

InitializeComponent ();

//

// TODO: Add any constructor code after InitializeComponent call

//

}

// / <summary>

// / Clean up any resources being used.

// / </summary>

protected override void Dispose (bool disposing)

{

if (disposing)

{

if (components! = null)

{

components. Dispose ();

}

}

base. Dispose (disposing);

}

// / <summary>

// / The main entry point for the application.

// / </summary>

[STAThread]

static void Main ()

{

Application.run (new Form1 ());

}

private void button1_Click (object sender, System. EventArgs e)

{

Form2 f2 = new Form2 ();

f2. ShowDialog ();

f2. Dispose ();

}

private void button3_Click (object sender, System. EventArgs e)

{

Form4 f4 = new Form4 ();

f4. ShowDialog ();

f4. Dispose ();

}

private void button2_Click (object sender, System. EventArgs e)

{

Form3 f3 = new Form3 ();

f3. ShowDialog ();

f3. Dispose ();

}

private void Form1_Load (object sender, System. EventArgs e)

{

}

}

}

Form2:

using System;

using System. Drawing;

using System. Collections;

using System.componentModel;

using System. Windows. Forms;

using System. Data;

namespace Kursovoi

{

// / <summary>

// / Summary description for Form2.

// / </summary>

public class Form2: System. Windows. Forms. Form

{

private System. Windows. Forms. TabControl tabControl1;

private System. Windows. Forms. TabPage tabPage1;

private System. Windows. Forms. TabPage tabPage2;

private System. Windows. Forms. TabPage tabPage3;

private System. Windows. Forms. TabPage tabPage4;

private System. Windows. Forms. Label label3;

private System. Windows. Forms. Label label1;

private System. Windows. Forms. Label label2;

private System. Windows. Forms. TextBox textBox3;

private System. Windows. Forms. TextBox textBox2;

private System. Windows. Forms. TextBox textBox1;

private System. Windows. Forms. Label label4;

private System. Windows. Forms.comboBox comboBoxGR;

private System. Windows. Forms. Button button1;

private System. Windows. Forms. ListBox listBox1;

private System. Windows. Forms. DataGrid dataGrid1;

private System. Windows. Forms. TextBox textBoxr1;

private System. Windows. Forms. Label label5;

private System. Windows. Forms. Label label6;

private System. Windows. Forms. Label label7;

private System. Windows. Forms. TextBox textBoxr3;

private System. Windows. Forms. Label label8;

private System. Windows. Forms. TextBox textBoxr4;

private System. Windows. Forms. GroupBox groupBox1;

private System. Windows. Forms.comboBox comboBoxGR1;

private System. Windows. Forms. Label label9;

private System. Windows. Forms. Label label10;

private System. Windows. Forms. Label label11;

private System. Windows. Forms. Label label12;

private System. Windows. Forms.comboBox comboBoxfam;

private System. Windows. Forms.comboBox comboBoxname;

private System. Windows. Forms.comboBox comboBoxotch;

private System. Windows. Forms. TextBox textBox4;

private System. Windows. Forms. TextBox textBox5;

private System. Windows. Forms. Label label13;

private System. Windows. Forms. Button button2;

private System. Windows. Forms. GroupBox groupBox4;

private System. Windows. Forms. Button button3;

private System. Windows. Forms. Button button4;

private System. Windows. Forms. GroupBox groupBox2;

private System. Windows. Forms. GroupBox groupBox3;

private System. Windows. Forms. DateTimePicker dateTimePicker1;

private System. Windows. Forms. DateTimePicker dateTimePicker2;

private System. Windows. Forms.comboBox comboBox1;

private System. Windows. Forms.comboBox comboBox2;

private System. Data. OleDb. OleDbDataAdapter oleDbDataAdapter2;

private System. Data. OleDb. OleDbCommand oleDbDeleteCommand2;

private System. Data. OleDb. OleDbConnection oleDbConnection1;

private System. Data. OleDb. OleDbCommand oleDbInsertCommand2;

private System. Data. OleDb. OleDbCommand oleDbSelectCommand2;

private System. Data. OleDb. OleDbCommand oleDbUpdateCommand2;

private System. Data. OleDb. OleDbCommand oleDbDeleteCommand1;

private System. Data. SqlClient. SqlConnection sqlConnection1;

private System. Data. OleDb. OleDbCommand oleDbInsertCommand3;

private System. Data. OleDb. OleDbCommand oleDbUpdateCommand1;

private System. Data. OleDb. OleDbDataAdapter oleDbDataAdapter3;

private System. Data. OleDb. OleDbCommand oleDbDeleteCommand3;

private System. Data. OleDb. OleDbCommand oleDbSelectCommand3;

private System. Data. OleDb. OleDbCommand oleDbUpdateCommand3;

private Kursovoi. DataSet1stud dataSet1stud1;

private System. Data. OleDb. OleDbDataAdapter oleDbDataAdapter4;

private System. Data. OleDb. OleDbCommand oleDbDeleteCommand4;

private System. Data. OleDb. OleDbCommand oleDbInsertCommand4;

private System. Data. OleDb. OleDbCommand oleDbSelectCommand4;

private System. Data. OleDb. OleDbCommand oleDbUpdateCommand4;

private Kursovoi. DataSet1rab dataSet1rab1;

private Kursovoi. DataSet1prep dataSet1prep1;

private Kursovoi. DataSet1confs dataSet1confs1;

private System. Data. OleDb. OleDbCommand oleDbSelectCommand1;

private Kursovoi. DataSet1groups dataSet1groups2;

private System. Data. OleDb. OleDbCommand oleDbInsertCommand1;

private System. Data. OleDb. OleDbDataAdapter oleDbDataAdapter1;

private System. Data. OleDb. OleDbDataAdapter oleDbDataAdapter5;

private System. Data. OleDb. OleDbCommand oleDbDeleteCommand5;

private System. Data. OleDb. OleDbCommand oleDbInsertCommand5;

private System. Data. OleDb. OleDbCommand oleDbSelectCommand5;

private System. Data. OleDb. OleDbCommand oleDbUpdateCommand5;

private System. Windows. Forms. TabPage tabPage5;

private System. Windows. Forms. TextBox textBox6;

private System. Windows. Forms. TextBox textBox7;

private System. Windows. Forms. TextBox textBox8;

private System. Windows. Forms. Label label14;

private System. Windows. Forms. Label label15;

private System. Windows. Forms. Label label16;

private System. Windows. Forms. Button button5;

// / <summary>

// / Required designer variable.

// / </summary>

private System.componentModel. Container components = null;

public Form2 ()

{

//

// Required for Windows Form Designer support

//

InitializeComponent ();

//

// TODO: Add any constructor code after InitializeComponent call

//

}

// / <summary>

// / Clean up any resources being used.

// / </summary>

protected override void Dispose (bool disposing)

{

if (disposing)

{

if (components! = null)

{

components. Dispose ();

}

}

base. Dispose (disposing);

}

private void button1_Click (object sender, System. EventArgs e)

{

pos=this. BindingContext [this. dataSet1groups2,"groups"]. Position;

DataRow NRow=this. dataSet1stud1. Tables ["students"]. NewRow ();

NRow ["Код"] =this. dataSet1stud1. Tables [0]. Rows. Count+1;

NRow ["Фамилия"] =this. textBox1. Text;

NRow ["Имя"] =this. textBox2. Text;

NRow ["Отчество"] =this. textBox3. Text;

NRow ["ГрупИД"] =Convert. ToInt32 (this. dataSet1groups2. Tables ["groups"]. Rows [pos] ["КодГруппы"]);

dataSet1stud1. Tables ["students"]. Rows. Add (NRow);

oleDbDataAdapter1. Update (dataSet1stud1,"students");

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,0,0,"students");

Close ();

MessageBox. Show ("Данные обновлены");

}

private void Form2_Load (object sender, System. EventArgs e)

{

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,0,0,"students");

this. oleDbDataAdapter2. Fill (this. dataSet1groups2,0,0,"groups");

this. oleDbDataAdapter3. Fill (this. dataSet1confs1,0,0,"conferentions");

this. oleDbDataAdapter4. Fill (this. dataSet1rab1,0,0,"Raboty");

this. oleDbDataAdapter5. Fill (this. dataSet1prep1,0,0,"prepods");

}

int pos,pos2;

string yacheyka,yacheyka2,fam,name;

string st="'";

private void comboBoxGR_SelectedIndexChanged (object sender, System. EventArgs e)

{

this. BindingContext [this. dataSet1groups2,"groups"]. Position=this.comboBoxGR. SelectedIndex;

pos=this. BindingContext [this. dataSet1groups2,"groups"]. Position;

yacheyka=this. dataSet1groups2. Tables ["groups"]. Rows [pos] ["КодГруппы"]. ToString ();

}

private void comboBoxGR1_SelectedIndexChanged (object sender, System. EventArgs e)

{

pos=Convert. ToInt32 (this.comboBoxGR1. SelectedIndex);

yacheyka=this. dataSet1groups2. Tables ["groups"]. Rows [pos] ["КодГруппы"]. ToString ();

this. textBoxr3. Text=yacheyka;

oleDbDataAdapter1. SelectCommand.commandText="SELECT * FROM students WHERE ГрупИД="+st+yacheyka+st;

this. dataSet1stud1. Clear ();

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,"students");

}

private void comboBoxfam_Leave (object sender, System. EventArgs e)

{

pos=Convert. ToInt32 (this.comboBoxGR1. SelectedIndex);

yacheyka=this. dataSet1groups2. Tables [0]. Rows [pos] ["КодГруппы"]. ToString ();

fam=this.comboBoxfam. Text. ToString ();

oleDbDataAdapter1. SelectCommand.commandText="SELECT * FROM students WHERE Фамилия = "+st+fam+st+"AND ГрупИД="+st+yacheyka+st;

this. dataSet1stud1. Clear ();

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,"students");

}

private void comboBoxfam_Enter (object sender, System. EventArgs e)

{

pos=Convert. ToInt32 (this.comboBoxGR1. SelectedIndex);

yacheyka=this. dataSet1groups2. Tables ["groups"]. Rows [pos] ["КодГруппы"]. ToString ();

this. textBoxr3. Text=yacheyka;

oleDbDataAdapter1. SelectCommand.commandText="SELECT * FROM students WHERE ГрупИД="+yacheyka;

// oleDbDataAdapter1. SelectCommand.commandText="SELECT * FROM students WHERE Имя="+st+"фывц"+st;

this. dataSet1stud1. Clear ();

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,"students");

}

private void comboBoxname_Leave (object sender, System. EventArgs e)

{

pos=Convert. ToInt32 (this.comboBoxGR1. SelectedIndex);

yacheyka=this. dataSet1groups2. Tables ["groups"]. Rows [pos] ["КодГруппы"]. ToString ();

this. textBoxr4. Text=fam=this.comboBoxfam. Text. ToString ();

name=this.comboBoxname. Text. ToString ();

oleDbDataAdapter1. SelectCommand.commandText="SELECT * FROM students WHERE ГрупИД="+st+yacheyka+st+"AND Фамилия="+st+fam+st+"AND Имя="+st+name+st;

this. dataSet1stud1. Clear ();

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,"students");

}

private void comboBoxname_Enter (object sender, System. EventArgs e)

{

pos=Convert. ToInt32 (this.comboBoxGR1. SelectedIndex);

yacheyka=this. dataSet1groups2. Tables ["groups"]. Rows [pos] ["КодГруппы"]. ToString ();

this. textBoxr4. Text=fam=this.comboBoxfam. Text. ToString ();

oleDbDataAdapter1. SelectCommand.commandText="SELECT * FROM students WHERE ГрупИД="+st+yacheyka+st+"AND Фамилия="+st+fam+st;

this. dataSet1stud1. Clear ();

this. oleDbDataAdapter1. Fill (this. dataSet1stud1,"students");

}

private void button2_Click (object sender, System. EventArgs e)

{

DataRow NRow=this. dataSet1groups2. Tables ["groups"]. NewRow ();

NRow ["НазваниеГруппы"] =this. textBox5. Text;

NRow ["КодГруппы"] =this. dataSet1groups2. Tables [0]. Rows. Count+1;

dataSet1groups2. Tables ["groups"]. Rows. Add (NRow);

oleDbDataAdapter2. Update (dataSet1groups2,"groups");

this. oleDbDataAdapter2. Fill (this. dataSet1groups2,0,0,"groups");

Close ();

MessageBox. Show ("Данные обновлены");

}

private void button3_Click (object sender, System. EventArgs e)

{

DataRow NRow=this. dataSet1confs1. Tables ["conferentions"]. NewRow ();

NRow ["Код"] =this. dataSet1confs1. Tables [0]. Rows. Count+1;

NRow ["Дата"] =this. dateTimePicker1. Text;

dataSet1confs1. Tables ["conferentions"]. Rows. Add (NRow);

oleDbDataAdapter3. Update (dataSet1confs1,"conferentions");

this. oleDbDataAdapter3. Fill (this. dataSet1confs1,0,0,"conferentions");

Close ();

MessageBox. Show ("Данные обновлены");

}

int pos1,pos3;

private void button4_Click (object sender, System. EventArgs e)

{

pos1=this. BindingContext [this. dataSet1prep1,"prepods"]. Position;

pos2=this. BindingContext [this. dataSet1stud1,"students"]. Position;

pos3=this. BindingContext [this. dataSet1confs1,"conferentions"]. Position;

DataRow NRow=this. dataSet1rab1. Tables ["Raboty"]. NewRow ();

NRow ["Тема"] =this. textBoxr1. Text;

NRow ["РуководительИД"] =this.comboBox2. SelectedIndex+1;

NRow ["КонфИД"] =this.comboBox1. SelectedIndex+1;

NRow ["СтудИД"] =this. dataSet1stud1. Tables [0]. Rows [this. BindingContext [this. dataSet1stud1,"students"]. Position] ["Код"];

NRow ["ДатаСдачи"] =this. dateTimePicker2. Text;

NRow ["Код"] =this. dataSet1rab1. Tables ["Raboty"]. Rows. Count;

dataSet1rab1. Tables ["Raboty"]. Rows. Add (NRow);

oleDbDataAdapter4. Update (dataSet1rab1,"Raboty");

this. oleDbDataAdapter4. Fill (this. dataSet1rab1,0,0,"Raboty");

Close ();

// this. textBoxr1. Text+=this. dateTimePicker2. Text. TrimEnd ('0');

MessageBox. Show ("Данные обновлены");

}

private void comboBox2_SelectedIndexChanged (object sender, System. EventArgs e)

{

this. textBoxr1. Text=this. BindingContext [this. dataSet1prep1,"prepods"]. Position. ToString ();

}

}}}

Form3:

using System;

using System. Drawing;

using System. Collections;

using System.componentModel;

using System. Windows. Forms;

namespace Kursovoi

{

// / <summary>

// / Summary description for Form3.

// / </summary>

public class Form3: System. Windows. Forms. Form

{

private System. Windows. Forms. TabControl tabControl1;

private System. Windows. Forms. TabPage tabPage1;

private System. Windows. Forms. TabPage tabPage2;

private System. Windows. Forms. TabPage tabPage3;

private System. Windows. Forms. TabPage tabPage4;

private System. Windows. Forms. TabPage tabPage5;

private System. Windows. Forms. CheckBox checkBox1;

private System. Windows. Forms. CheckBox checkBox2;

private System. Windows. Forms. CheckBox checkBox3;

private System. Windows. Forms. TextBox textBox1;

private System. Windows. Forms. TextBox textBox2;

private System. Windows. Forms. TextBox textBox3;

private System. Windows. Forms. DataGrid dataGrid1;

private System. Windows. Forms. Button button1;

private System. Windows. Forms. Label label1;

private System. Windows. Forms. TextBox textBox4;