ch2:用wxODBC写的一个简单的电话本程序

wxODBC数据库编程需要几步：

（1）配置连接信息

[Access 2003]
wxString info = wxT("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=filename.mdb");
[SQL Server 2000]
wxString info = wxT("Driver={SQL Server};Server=IP;Database=filename;Uid=sa;Pwd=sa;");

看上去和asp里面差不多。

 

（2）连接数据库

wxDbConnectInf dbi;
dbi.SetConnectionStr(info);
dbi.AllocHenv();
wxDb* db = new wxDb(dbi.GetHenv());    
if (!db->Open(&dbi))//判断是否获得连接
{
         wxMessageBox(wxT("不能连接数据库!"));
}

（3）创建表对象

wxChar FirstName[50+1]; //table的数据成员，用来绑定数据库表中字段
wxChar LastName[50+1];
wxDbTable* table = new wxDbTable(db, wxT("tablename"),2,wxT(""), !wxDB_QUERY_ONLY, wxT(""));//创建表对象

table->SetColDefs(0, wxT("FIRST_NAME"), DB_DATA_TYPE_VARCHAR, FirstName,
        SQL_C_WXCHAR, sizeof(FirstName), true, true);//绑定操作
table->SetColDefs(1, wxT("LAST_NAME"), DB_DATA_TYPE_VARCHAR, LastName,
        SQL_C_WXCHAR, sizeof(LastName), true, true);
table->CreateTable();

这里主要是创建表对象，并且将表的字段和变量绑定。

 

（4）进行表操作：打开，查询，删除，插入……

打开表：

if (!table->Open())
{
 wxMessageBox(wxT("TABLE OPEN ERROR: "));
}

删除表：

table->DropTable();

插入：

wxStrcpy(FirstName, wxT("JULIAN"));//FirstName所绑定的字段将添加一条"JULIAN"记录

wxStrcpy(LastName, wxT("SMART"));

if (!table->Insert())

{ 

        wxMessageBox(wxT("Insert error!"));

}

table->GetDb()->CommitTrans();//更新数据库时必须ComitTrans()

删除：

if (!table->DeleteWhere(wxT("name='wenbin'")))//这里面其实就是SQL的查询语句，不同的数据库不一样
{
 wxMessageBox(wxT("DELETION ERROR:"));
}

查询：

table->SetWhereClause(wxT("FIRST_NAME<>NULL"));//where从句

table->SetOrderByClause(wxT("LAST_NAME"));//order从句

table->SetFromClause(wxT(""));//from从句，这里是from table

if (!table->Query())//查询并判断结果
{
 wxMessageBox("QUERY ERROR");
}

int n=0;
while (table->GetNext())//这是将查询结果显示在ListCtrl控件上，GetNext()每次提取一条记录
{
        listctrl->InsertItem(n,FirstName);
        listctrl->SetItem(n,1,LastName);
        n++;
}

 

还有其他的操作参考其他资料了。。

 

下面是代码：

完整代码下载：http://ishare.iask.sina.com.cn/f/7885928.html

main.cpp

//*****************************************************//Description:wxDb的简单应用：电话本 //Author: wenbin//Date:2010-05-14//Environment:wxDev-C++,windows xp //E-mail:ox_man@qq.com//*****************************************************#include "wx/wx.h"#include "wx/dbtable.h"#include "wx/db.h"#include "wx/listctrl.h"#include "wx/statline.h"#include "wx/stattext.h"//-----------------------------------------------------class MyApp:public wxApp{ virtual bool OnInit();};//-----------------------------------------------------class MyFrame:public wxFrame{public: MyFrame(const wxString& title);//初始化 void OnQuit(wxCommandEvent& event);//退出 void OnRefresh(wxCommandEvent& event);//刷新，读取全部信息 void OnSearch(wxCommandEvent& event);//查询函数 void OnInsert(wxCommandEvent& event);//插入函数 void OnDelete(wxCommandEvent& event);//删除函数 private: wxToolBar* toolbar; wxTextCtrl* s_name;//查询姓名 wxTextCtrl* i_name;//插入姓名 wxTextCtrl* i_phone;//插入电话 wxTextCtrl* i_note;//插入备忘 wxTextCtrl* d_name;//删除姓名 wxListCtrl* listctrl;//表格指针 wxDb* db;//数据库指针 DECLARE_EVENT_TABLE()};BEGIN_EVENT_TABLE(MyFrame,wxFrame) EVT_MENU(wxID_EXIT,MyFrame::OnQuit) EVT_MENU(1000,MyFrame::OnRefresh) EVT_MENU(1001,MyFrame::OnRefresh) EVT_BUTTON(1500,MyFrame::OnSearch) EVT_BUTTON(1501,MyFrame::OnInsert) EVT_BUTTON(1502,MyFrame::OnDelete)END_EVENT_TABLE()//-----------------------------------------------------IMPLEMENT_APP(MyApp)//-----------------------------------------------------bool MyApp::OnInit(){ wxImage::AddHandler(new wxPNGHandler);//png句柄 MyFrame* frame = new MyFrame(wxT("电话本"));//创建MyFrame实例 frame->Show(true);//显示 return true;}//-----------------------------------------------------void MyFrame::OnQuit(wxCommandEvent& event){ Close();//退出 }//-----------------------------------------------------void MyFrame::OnSearch(wxCommandEvent& event){ listctrl->DeleteAllItems();//清空list wxDbTable *table = NULL; table = new wxDbTable(db,wxT("info"),3);//创建表对象 // wxDbTable* table = new wxDbTable(db, wxT("info"),3,wxT(""), !wxDB_QUERY_ONLY, wxT("")); wxChar name[50+1]; //table的数据成员，用来绑定数据库表中字段 wxChar phone[50+1]; wxChar note[50+1]; table->SetColDefs(0, wxT("姓名"), DB_DATA_TYPE_VARCHAR, name, SQL_C_WXCHAR, sizeof(name), true, true); table->SetColDefs(1, wxT("电话"), DB_DATA_TYPE_VARCHAR, phone, SQL_C_WXCHAR, sizeof(phone), true, true); table->SetColDefs(2, wxT("备注"), DB_DATA_TYPE_VARCHAR, note, SQL_C_WXCHAR, sizeof(note), true, true); if (!table->Open())//打开表 { wxMessageBox(wxT("表打开错误")); } wxString s_t =wxT("姓名='")+s_name->GetValue()+wxT("'");//where语句，SQL语句 table->SetWhereClause(s_t);//where从句// table->SetOrderByClause(wxT("姓名"));//order从句 table->SetFromClause(wxT(""));//from从句，这里是from table if (!table->Query())//查询并判断结果 { wxMessageBox("查询出错"); } int n=0; while (table->GetNext())//将查询结果显示在list中 { listctrl->InsertItem(n,name); listctrl->SetItem(n,1,phone); listctrl->SetItem(n,2,note); n++; } s_name->Clear();//清除查询内容 }//-----------------------------------------------------void MyFrame::OnInsert(wxCommandEvent& event){ wxDbTable *table = NULL; table = new wxDbTable(db,wxT("info"),3);//创建表对象 wxChar name[50+1]; //table的数据成员，用来绑定数据库表中字段 wxChar phone[50+1]; wxChar note[50+1]; table->SetColDefs(0, wxT("姓名"), DB_DATA_TYPE_VARCHAR, name, SQL_C_WXCHAR, sizeof(name), true, true); table->SetColDefs(1, wxT("电话"), DB_DATA_TYPE_VARCHAR, phone, SQL_C_WXCHAR, sizeof(phone), true, true); table->SetColDefs(2, wxT("备注"), DB_DATA_TYPE_VARCHAR, note, SQL_C_WXCHAR, sizeof(note), true, true); if (!table->Open())//打开表 { wxMessageBox(wxT("表打开错误")); } wxStrcpy(name, i_name->GetValue());//添加一条记录 wxStrcpy(phone, i_phone->GetValue()); wxStrcpy(note, i_note->GetValue() ); if (!table->Insert())//插入并判断结果 { wxMessageBox(wxT("插入出错")); } table->GetDb()->CommitTrans();//更新数据库时必须ComitTrans() i_name->Clear();//清除插入信息 i_phone->Clear(); i_note->Clear(); listctrl->DeleteAllItems();//清空list if (!table->Query())//查询并判断结果 { wxMessageBox("查询出错"); } int n=0; while (table->GetNext()) { listctrl->InsertItem(n,name); listctrl->SetItem(n,1,phone); listctrl->SetItem(n,2,note); n++; }}//-----------------------------------------------------void MyFrame::OnDelete(wxCommandEvent& event){ wxDbTable *table = NULL; table = new wxDbTable(db,wxT("info"),3); wxChar name[50+1]; //table的数据成员，用来绑定数据库表中字段 wxChar phone[50+1]; wxChar note[50+1]; table->SetColDefs(0, wxT("姓名"), DB_DATA_TYPE_VARCHAR, name, SQL_C_WXCHAR, sizeof(name), true, true); table->SetColDefs(1, wxT("电话"), DB_DATA_TYPE_VARCHAR, phone, SQL_C_WXCHAR, sizeof(phone), true, true); table->SetColDefs(2, wxT("备注"), DB_DATA_TYPE_VARCHAR, note, SQL_C_WXCHAR, sizeof(note), true, true); if (!table->Open()) { wxMessageBox(wxT("表打开错误")); } wxString d_t =wxT("姓名='")+d_name->GetValue()+wxT("'");//SQL语句 if (!table->DeleteWhere(d_t)) { wxMessageBox(wxT("删除出错")); } table->GetDb()->CommitTrans();//更新数据库 d_name->Clear();//清除删除信息 listctrl->DeleteAllItems();//清空list if (!table->Query())//查询并判断结果 { wxMessageBox("查询出错"); } int n=0; while (table->GetNext()) { listctrl->InsertItem(n,name); listctrl->SetItem(n,1,phone); listctrl->SetItem(n,2,note); n++; }}//-----------------------------------------------------void MyFrame::OnRefresh(wxCommandEvent& event){ listctrl->DeleteAllItems(); wxDbTable *table = NULL; table = new wxDbTable(db,wxT("info"),3); wxChar name[50+1]; //table的数据成员，用来绑定数据库表中字段 wxChar phone[50+1]; wxChar note[50+1]; table->SetColDefs(0, wxT("姓名"), DB_DATA_TYPE_VARCHAR, name, SQL_C_WXCHAR, sizeof(name), true, true); table->SetColDefs(1, wxT("电话"), DB_DATA_TYPE_VARCHAR, phone, SQL_C_WXCHAR, sizeof(phone), true, true); table->SetColDefs(2, wxT("备注"), DB_DATA_TYPE_VARCHAR, note, SQL_C_WXCHAR, sizeof(note), true, true); if (!table->Open())//打开表 { wxMessageBox(wxT("表打开错误")); } if (!table->Query())//查询并判断结果 { wxMessageBox("查询出错"); } int n=0; while (table->GetNext()) { listctrl->InsertItem(n,name); listctrl->SetItem(n,1,phone); listctrl->SetItem(n,2,note); n++; } wxDELETE(table);//删除已使用完table}//-----------------------------------------------------MyFrame::MyFrame(const wxString& title) :wxFrame(NULL,wxID_ANY,title,wxPoint(500,100),wxSize(600,400),wxMINIMIZE_BOX | wxSYSTEM_MENU | wxCAPTION | wxCLOSE_BOX){ SetIcon(wxICON(logo)); //工具栏(添加图像) toolbar = CreateToolBar(wxTB_FLAT ,-1,wxT("toolbar")); toolbar->AddSeparator(); wxImage image(wxT("image/home.png")); wxBitmap bitmap(image); toolbar->AddTool(1000,bitmap,wxT("主页")); wxImage image2(wxT("image/refresh.png")); wxBitmap bitmap2(image2); toolbar->AddTool(1001,bitmap2,wxT("刷新")); wxImage image3(wxT("image/quit.png")); wxBitmap bitmap3(image3); toolbar->AddTool(wxID_EXIT,bitmap3,wxT("退出")); toolbar->Realize(); //菜单栏 wxMenu* fileMenu = new wxMenu; fileMenu->Append(wxID_EXIT,wxT("退出[&E]"),wxT("退出程序")); wxMenuBar* menuBar = new wxMenuBar(); menuBar->Append(fileMenu,wxT("开始[&B]")); SetMenuBar(menuBar); //状态栏 CreateStatusBar(1); SetStatusText(wxT("欢迎使用本软件")); //panel wxPanel* panel = new wxPanel(this,-1); //staticline wxStaticLine* staticline =new wxStaticLine(panel,wxID_STATIC,wxDefaultPosition,wxSize(600,-1)); //查询界面 wxStaticText* t1 =new wxStaticText(panel,wxID_STATIC,wxT("[姓名]"),wxPoint(405,2)) ; s_name = new wxTextCtrl(panel,1001,wxEmptyString,wxPoint(402,20),wxSize(189,20)); wxButton* b_search = new wxButton(panel,1500,wxT("查询"),wxPoint(517,40)); //插入界面 wxStaticText* t2 =new wxStaticText(panel,wxID_STATIC,wxT("[姓名]"),wxPoint(405,61)) ; i_name = new wxTextCtrl(panel,1001,wxEmptyString,wxPoint(402,80),wxSize(189,20)); wxStaticText* t3 =new wxStaticText(panel,wxID_STATIC,wxT("[电话]"),wxPoint(405,101)) ; i_phone = new wxTextCtrl(panel,1001,wxEmptyString,wxPoint(402,119),wxSize(189,20)); wxStaticText* t4 =new wxStaticText(panel,wxID_STATIC,wxT("[备注]"),wxPoint(405,140)) ; i_note = new wxTextCtrl(panel,1001,wxEmptyString,wxPoint(402,158),wxSize(189,20)); wxButton* b_insert = new wxButton(panel,1501,wxT("插入"),wxPoint(517,178)); //删除界面 wxStaticText* t5 =new wxStaticText(panel,wxID_STATIC,wxT("[姓名]"),wxPoint(405,198)) ; d_name = new wxTextCtrl(panel,1001,wxEmptyString,wxPoint(402,216),wxSize(189,20)); wxButton* b_delete = new wxButton(panel,1502,wxT("删除"),wxPoint(517,236)); //list设置 listctrl = new wxListCtrl(panel,1002,wxPoint(1,2),wxSize(400,288),wxLC_REPORT ); wxListItem itemCol; itemCol.SetText(wxT("姓名")); listctrl->InsertColumn(0,itemCol); listctrl->SetColumnWidth (0, 75); wxListItem itemCol4; itemCol4.SetText(wxT("电话")); listctrl->InsertColumn(1,itemCol4); listctrl->SetColumnWidth (1, 120); wxListItem itemCol5; itemCol5.SetText(wxT("备注")); listctrl->InsertColumn(2,itemCol5); listctrl->SetColumnWidth (2, 180); //连接数据库 wxString s = wxT("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=info.mdb"); wxDbConnectInf dbi; dbi.SetConnectionStr(s); dbi.AllocHenv(); db = new wxDb(dbi.GetHenv()); if (!db->Open(&dbi))//判断是否获得连接 { wxMessageBox(wxT("不能连接数据库")); }}//----------------------------------------------------- 

main.rc

logo ICON "main.ico"#include "wx/msw/wx.rc"