MyCode code generator

MyCode code generator automatically generates BCB version of database operation code (ADO) without manual writing. It only requires simple calls to perform tedious database operations.

call method

Preparation:

Log in to the database, click Generate, copy the DBComm folder to the application directory, and add the following to the cpp file header:

#include ".DBCommDBTablesMyInfoOperator.h"

#include ".DBCommDBTablesRecordOperator.h"

#include ".DBCommDBTablesRecordViewOperator.h"

#include ".DBCommDBComm.h"

Click the "Project" menu, select "Add to Project", and add all cpp files in DBComm (including cpp files under DBTables)

Call example

Connect to database

void __fastcall TForm1::FormCreate(TObject *Sender)

{

WideString wstrConnStr="Provider=SQlolEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=mytest";

if(DBComm::Instance().ConnectDB(wstrConnStr))

{

DBGrid1->DataSource=DBComm::Instance().Tables<RecordViewOperator>(DBComm::RecordView)->Source();

}

}

Add a new record

void __fastcall TForm1::SpeedButton1Click(TObject *Sender)

{

DBComm::Instance().Tables<MyInfoOperator>(DBComm::MyInfo)->New(LabeledEdit2->Text,LabeledEdit3->Text.ToDouble(),"admin",Now());

}

}

Delete a record

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

DBComm::Instance().Tables<RecordOperator>(DBComm::Record)->Delete(strCondition);

}

}

Update a record

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

DBComm::Instance().Tables<MyInfoOperator>(DBComm::MyInfo)->Update(strName,fMoney,"admin",Now(),strCondition);

}

}

Get data source

DBGrid1->DataSource=DBComm::Instance().Tables<RecordViewOperator>(DBComm::RecordView)->Source();