调用措施
豫备使命:
登录数据库,点击天生,将DBCo妹妹文件夹复制到运用挨次目录,在cpp文件头削减如下:
#include ".DBCo妹妹DBTablesMyInfoOperator.h"
#include ".DBCo妹妹DBTablesRecordOperator.h"
#include ".DBCo妹妹DBTablesRecordViewOperator.h"
#include ".DBCo妹妹DBCo妹妹.h"
点击“工程”菜单,抉择“削减到工程”,将DBCo妹妹内所有cpp文件削减(搜罗DBTables下cpp文件)
调用示例
衔接数据库
void __fastcall TForm1::FormCreate(TObject *Sender)
{
WideString wstrConnStr="Provider=SQlolEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=mytest";
if(DBCo妹妹::Instance().ConnectDB(wstrConnStr))
{
DBGrid1->DataSource=DBCo妹妹::Instance().Tables<RecordViewOperator>(DBCo妹妹::RecordView)->Source();
}
}
新增一条记实
void __fastcall TForm1::SpeedButton1Click(TObject *Sender)
{
DBCo妹妹::Instance().Tables<MyInfoOperator>(DBCo妹妹::MyInfo)->New(LabeledEdit2->Text,LabeledEdit3->Text.ToDouble(),"admin",Now());
}
}
删除了一条记实
void __fastcall TForm1::SpeedButton3Click(TObject *Sender)
{
if(DBGrid1->DataSource->DataSet->RecordCount)
{
int nID=DBGrid1->DataSource->DataSet->Fields->Fields[0]->AsInteger;
String strCondition="ID="+String(nID);
DBCo妹妹::Instance().Tables<RecordOperator>(DBCo妹妹::Record)->Delete(strCondition);
}
}
更新一条记实
void __fastcall TForm1::SpeedButton2Click(TObject *Sender)
{
if(DBGrid1->DataSource->DataSet->RecordCount)
{
int nID=DBGrid1->DataSource->DataSet->Fields->Fields[1]->AsInteger;
String strName=LabeledEdit2->Text;
float fMoney=LabeledEdit3->Text.ToDouble();
String strCondition="ID="+String(nID);
DBCo妹妹::Instance().Tables<MyInfoOperator>(DBCo妹妹::MyInfo)->Update(strName,fMoney,"admin",Now(),strCondition);
}
}
取患上数据源
DBGrid1->DataSource=DBCo妹妹::Instance().Tables<RecordViewOperator>(DBCo妹妹::RecordView)->Source();