database.cpp

原创的,数据库的前台应用程序,实现对数据库的查询,删除,修改,更新,生成报表等功能, 使用C++ BUIDER 和SQLSERVER开发平台.

         checkcertification->Enabled=true;
         checkcourse->Enabled=true;
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::checkpatternClick(TObject *Sender)
{
   if(checkpattern->Checked==true)
      {
         checkeid->Enabled=false;
         checkename->Enabled=false;
         checksex->Enabled=false;
         checkmarriage->Enabled=false;
         checksalary->Enabled=false;
         checkjobname->Enabled=false;
         checkapname->Enabled=false;
         checkmanager->Enabled=false;
         checkcertification->Enabled=false;
         checkmajoy->Enabled=false;
         checkcourse->Enabled=false;
      }
      if(checkpattern->Checked==false)
      {
         checkeid->Enabled=true;
         checkename->Enabled=true;
         checksex->Enabled=true;
         checkmarriage->Enabled=true;
         checksalary->Enabled=true;
         checkjobname->Enabled=true;
         checkapname->Enabled=true;
         checkmanager->Enabled=true;
         checkcertification->Enabled=true;
         checkmajoy->Enabled=true;
         checkcourse->Enabled=true;
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::checkapnameClick(TObject *Sender)
{
      if(checkapname->Checked==true)
      {
         checkeid->Enabled=false;
         checkename->Enabled=false;
         checksex->Enabled=false;
         checkmarriage->Enabled=false;
         checksalary->Enabled=false;
         checkjobname->Enabled=false;
         checkpattern->Enabled=false;
         checkcertification->Enabled=false;
         checkmajoy->Enabled=false;
         checkcourse->Enabled=false;
      }
      if(checkapname->Checked==false)
      {
         checkeid->Enabled=true;
         checkename->Enabled=true;
         checksex->Enabled=true;
         checkmarriage->Enabled=true;
         checksalary->Enabled=true;
         checkjobname->Enabled=true;
         checkpattern->Enabled=true;
         checkcertification->Enabled=true;
         checkmajoy->Enabled=true;
         checkcourse->Enabled=true;
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::checkmanagerClick(TObject *Sender)
{
      if(checkmanager->Checked==true)
      {
         checkeid->Enabled=false;
         checkename->Enabled=false;
         checksex->Enabled=false;
         checkmarriage->Enabled=false;
         checksalary->Enabled=false;
         checkjobname->Enabled=false;
         checkpattern->Enabled=false;
         checkcertification->Enabled=false;
         checkmajoy->Enabled=false;
         checkcourse->Enabled=false;
      }
      if(checkmanager->Checked==false)
      {
         checkeid->Enabled=true;
         checkename->Enabled=true;
         checksex->Enabled=true;
         checkmarriage->Enabled=true;
         checksalary->Enabled=true;
         checkjobname->Enabled=true;
         checkpattern->Enabled=true;
         checkcertification->Enabled=true;
         checkmajoy->Enabled=true;
         checkcourse->Enabled=true;
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::checkcertificationClick(TObject *Sender)
{
     if(checkcertification->Checked==true)
      {
         checkeid->Enabled=false;
         checkename->Enabled=false;
         checksex->Enabled=false;
         checkmarriage->Enabled=false;
         checksalary->Enabled=false;
         checkjobname->Enabled=false;
         checkapname->Enabled=false;
         checkmanager->Enabled=false;
         checkpattern->Enabled=false;
         checkcourse->Enabled=false;

      }
      if(checkcertification->Checked==false)
      {
         checkeid->Enabled=true;
         checkename->Enabled=true;
         checksex->Enabled=true;
         checkmarriage->Enabled=true;
         checksalary->Enabled=true;
         checkjobname->Enabled=true;
         checkapname->Enabled=true;
         checkmanager->Enabled=true;
         checkpattern->Enabled=true;
         checkcourse->Enabled=true;
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::checkmajoyClick(TObject *Sender)
{
  if(checkmajoy->Checked==true)
      {
         checkeid->Enabled=false;
         checkename->Enabled=false;
         checksex->Enabled=false;
         checkmarriage->Enabled=false;
         checksalary->Enabled=false;
         checkjobname->Enabled=false;
         checkapname->Enabled=false;
         checkmanager->Enabled=false;
         checkpattern->Enabled=false;
         checkcourse->Enabled=false;

      }
      if(checkmajoy->Checked==false)
      {
         checkeid->Enabled=true;
         checkename->Enabled=true;
         checksex->Enabled=true;
         checkmarriage->Enabled=true;
         checksalary->Enabled=true;
         checkjobname->Enabled=true;
         checkapname->Enabled=true;
         checkmanager->Enabled=true;
         checkpattern->Enabled=true;
         checkcourse->Enabled=true;

      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::connect1Click(TObject *Sender)
{
      if(Query1->Active==false||Table1->Active==false)
      {
           Query1->Active=true;
           Table1->Active=true;
           ShowMessage("数据库连接成功");
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::disconnect1Click(TObject *Sender)
{
    if(Query1->Active==true||Table1->Active==true)
      {
           Query1->Active=false;
           Table1->Active=false;
           ShowMessage("数据库断开连接");
      }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::accountClick(TObject *Sender)
{
   if(DataSource1->DataSet==Table1)
   ShowMessage("请选择需要查询的条件");
   else
   {
      int s;
      s=Query1->RecordCount;
      ShowMessage("您所统计的记录数目为"+IntToStr(s));
   }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::account1Click(TObject *Sender)
{
   account->Click();
}
//---------------------------------------------------------------------------


void __fastcall TForm1::eidClick(TObject *Sender)
{
   ShowMessage("请以e开头填写员工编号");
}
//---------------------------------------------------------------------------

void __fastcall TForm1::salaryClick(TObject *Sender)
{
    ShowMessage("请以>,=,<,>=,<=开头填写工资");        
}
//---------------------------------------------------------------------------

void __fastcall TForm1::formpreviewClick(TObject *Sender)
{
   if(DataSource1->DataSet==Table1)
   {
     Form2->QuickRep1->DataSet=Table1;
     Form2->QRDBText1->DataSet=Table1;
     Form2->QRDBText2->DataSet=Table1;
     Form2->QRDBText3->DataSet=Table1;
     Form2->QRDBText4->DataSet=Table1;
     Form2->QRDBText5->DataSet=Table1;
     int i=0;
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText1->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel1->Caption=Form2->QRDBText1->DataField;
     }
     else  Form2->QRLabel1->Caption="";
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText2->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel2->Caption=Form2->QRDBText2->DataField;
     }
     else  Form2->QRLabel2->Caption="";
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText3->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel3->Caption=Form2->QRDBText3->DataField;
      }
      else  Form2->QRLabel3->Caption="";
      if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText4->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel4->Caption=Form2->QRDBText4->DataField;
      }
     else  Form2->QRLabel4->Caption="";
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText5->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel5->Caption=Form2->QRDBText5->DataField;
     }
     else  Form2->QRLabel5->Caption="";
     Form2->QuickRep1->Preview();
   }



   if(DataSource1->DataSet==Query1)
   {
     Form2->QuickRep1->DataSet=Query1;
     Form2->QRDBText1->DataSet=Query1;
     Form2->QRDBText2->DataSet=Query1;
     Form2->QRDBText3->DataSet=Query1;
     Form2->QRDBText4->DataSet=Query1;
     Form2->QRDBText5->DataSet=Query1;
     int i=0;
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText1->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel1->Caption=Form2->QRDBText1->DataField;
     }
     else  Form2->QRLabel1->Caption="";
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText2->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel2->Caption=Form2->QRDBText2->DataField;
     }
     else  Form2->QRLabel2->Caption="";
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText3->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel3->Caption=Form2->QRDBText3->DataField;
      }
      else  Form2->QRLabel3->Caption="";
      if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText4->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel4->Caption=Form2->QRDBText4->DataField;
      }
     else  Form2->QRLabel4->Caption="";
     if(Form1->Table1->FieldCount>i)
     {
       Form2->QRDBText5->DataField=Form1->DBGrid1->Columns->Items[i++]->FieldName;
       Form2->QRLabel5->Caption=Form2->QRDBText5->DataField;
     }
     else  Form2->QRLabel5->Caption="";
     Form2->QuickRep1->Preview();
   }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::previewClick(TObject *Sender)
{
   formpreview->Click();          
}
//---------------------------------------------------------------------------

void __fastcall TForm1::checkcourseClick(TObject *Sender)
{
     if(checkcourse->Checked==true)
      {
         checkeid->Enabled=false;
         checkename->Enabled=false;
         checksex->Enabled=false;
         checkmarriage->Enabled=false;
         checksalary->Enabled=false;
         checkjobname->Enabled=false;
         checkapname->Enabled=false;
         checkmanager->Enabled=false;
         checkcertification->Enabled=false;
         checkmajoy->Enabled=false;
         checkpattern->Enabled=false;
      }
      if(checkcourse->Checked==false)
      {
         checkeid->Enabled=true;
         checkename->Enabled=true;
         checksex->Enabled=true;
         checkmarriage->Enabled=true;
         checksalary->Enabled=true;
         checkjobname->Enabled=true;
         checkapname->Enabled=true;
         checkmanager->Enabled=true;
         checkcertification->Enabled=true;
         checkmajoy->Enabled=true;
         checkpattern->Enabled=true;

      }
}
//---------------------------------------------------------------------------