public void test()
{
TeacherDB teacherDB = new TeacherDB();
//测试delete
Console.WriteLine(teacherDB.delete("teacher"));
//测试update
/*Teacher t1 = new Teacher();
t1.Id = "ABC111";
t1.Name = "zxcxzczxc";
Console.WriteLine(teacherDB.updata(t1));*/
/*
//测试insert
Teacher t1 = new Teacher();
t1.Id = "test1";
teacherDB.insert(t1);
*/
/*
//测试selectTeacherByUserName
Teacher t1 = new Teacher();
t1 = teacherDB.selectTeacherById("teacher");
MessageBox.Show(t1.ToString());
*/
/*
//测试selectAll
List<Teacher> all = teacherDB.selectAll();
foreach (Teacher t1 in all)
{
Console.WriteLine(t1.ToString());
}
*/
}
private void button3_Click(object sender, EventArgs e)
{
TeacherDB tdb = new TeacherDB();
if ("".Equals(textBox1.Text.ToString().Trim()))
{
MessageBox.Show("教工号不能为空!","警告!");
return;
}
if (tdb.delete(textBox1.Text.ToString().Trim())==0)
{
MessageBox.Show("用户名不存在!","警告!");
return;
}
TeacherSelect._getInstance().resetData();
SalarySelect._getInstance().resetData();
MessageBox.Show("删除成功!","消息!");
textBox1.Text = "";
//如果控件已经存在就删除重建;
Util.checkView(this);
}
