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); }