使用原生ADO进行数据库存取。

使用原生ADO进行数据存储,本例子能够显示,向下翻页,但向上翻页有问题。修改后的存储,删除等都存在问题,各位朋友修改一下,我只当起个抛砖引玉的作用。

//.cpp程序

//---------------------------------------------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "Unit1.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
#include <DAO_97.h>

TForm1 *Form1;
//---------------------------------------------------------------------------
__fastcall TForm1::TForm1(TComponent* Owner)
        : TForm(Owner)
{
}
//---------------------------------------------------------------------------

 

void __fastcall TForm1::Button1Click(TObject *Sender)
{
VConnect= CreateOleObject("ADODB.Connection");
// 打开连接
VConnect.OleFunction("Open","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D://ado//bcdemos.mdb;Persist Security Info=False");
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button2Click(TObject *Sender)
{
   VRecordSet=CreateOleObject("ADODB.RecordSet");
   VRecordSet.OlePropertySet("ActiveConnection",VConnect);
   // 设定指令类型与内容
   VRecordSet.OleFunction("Open","Select * from employee", VConnect); // 执行指令
   ShowRecord();
}
//---------------------------------------------------------------------------
void TForm1::ShowRecord()
{
   txtEmpNo->Text=VarToStr(VRecordSet.OlePropertyGet("Fields","EmpNo"));
   txtLastName->Text=VarToStr(VRecordSet.OlePropertyGet("Fields","LastName"));
   txtFirstName->Text=VarToStr(VRecordSet.OlePropertyGet("Fields","FirstName"));
   txtPhone->Text=VarToStr(VRecordSet.OlePropertyGet("Fields","PhoneExt"));
   txtHireDate->Text=VarToStr(VRecordSet.OlePropertyGet("Fields","HireDate"));
   txtSalary->Text=VarToStr(VRecordSet.OlePropertyGet("Fields","Salary"));
}
void __fastcall TForm1::Button3Click(TObject *Sender)
{
  VRecordSet.OleFunction("Update","LastName",txtLastName->Text);
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button4Click(TObject *Sender)
{
if (! VRecordSet.OlePropertyGet("BOF") ){
   VRecordSet.OleFunction("MoveFirst") ;
   ShowRecord();
   }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button6Click(TObject *Sender)
{
if (! VRecordSet.OlePropertyGet("BOF") ){
   VRecordSet.OleFunction("MovePrevious");
   ShowRecord();
   }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button7Click(TObject *Sender)
{
if (! VRecordSet.OlePropertyGet("EOF") ){
   VRecordSet.OleFunction("MoveNext");
   ShowRecord();
   }
}
//---------------------------------------------------------------------------

void __fastcall TForm1::Button5Click(TObject *Sender)
{
//if (! VRecordSet.OlePropertyGet("EOF") ){
   VRecordSet.OleFunction("MoveLast");
   ShowRecord();
//   }
}
//---------------------------------------------------------------------------

 

 

//.h程序

//---------------------------------------------------------------------------

#ifndef Unit1H
#define Unit1H
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include <ExtCtrls.hpp>
#include <Graphics.hpp>
#include <ADODB.hpp>
#include <Db.hpp>
#include <ComObj.hpp>
#include <DBGrids.hpp>
#include <Grids.hpp>
//---------------------------------------------------------------------------
class TForm1 : public TForm
{
__published: // IDE-managed Components
        TPanel *Panel1;
        TButton *Button1;
        TButton *Button2;
        TButton *Button3;
        TButton *Button4;
        TButton *Button5;
        TButton *Button6;
        TButton *Button7;
        TLabel *Label1;
        TEdit *txtEmpNo;
        TLabel *Label2;
        TEdit *txtLastName;
        TLabel *Label3;
        TEdit *txtFirstName;
        TLabel *Label4;
        TEdit *txtPhone;
        TLabel *Label5;
        TEdit *txtHireDate;
        TLabel *Label6;
        TEdit *txtSalary;
        void __fastcall Button1Click(TObject *Sender);
        void __fastcall Button2Click(TObject *Sender);
        void __fastcall Button3Click(TObject *Sender);
        void __fastcall Button4Click(TObject *Sender);
        void __fastcall Button6Click(TObject *Sender);
        void __fastcall Button7Click(TObject *Sender);
        void __fastcall Button5Click(TObject *Sender);
        void __fastcall FormCreate(TObject *Sender);
private: // User declarations
        Variant VConnect;
        Variant VRecordSet;
        void  ShowRecord();
public:  // User declarations
        __fastcall TForm1(TComponent* Owner);
};
//---------------------------------------------------------------------------
extern PACKAGE TForm1 *Form1;
//---------------------------------------------------------------------------
#endif

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值