?? dao_multithreading.shtml.htm
字號:
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Author" CONTENT="Zafir Anjum">
<TITLE>Database - DAO multi-threading tips</TITLE>
</HEAD>
<body background="../fancyhome/back.gif" tppabs="http://www.codeguru.com/fancyhome/back.gif" bgcolor="#FFFFFF" link="#B50029" vlink="#8E2323" alink="#FF0000" bgproperties="fixed">
<table WIDTH="100%">
<tr WIDTH="100%">
<td><A HREF="http://209.66.99.126/cgi/ads.cgi?advert=catalyst"><IMG SRC="../banners/catalyst.jpg" tppabs="http://www.codeguru.com/banners/catalyst.jpg" HEIGHT=60 WIDTH=468 ALT="Catalyst Development" BORDER=2></A><BR><SMALL><A HREF="http://209.66.99.126/cgi/ads.cgi?advert=catalyst">Click here for Free ActiveX Control</A></SMALL><td>
</tr>
</table>
<CENTER>
<H3>
<FONT COLOR="#AOAO99">DAO multi-threading tips</FONT></H3></CENTER>
<CENTER>
<H3><HR></H3></CENTER>
<p>This article was contributed by <a href="mailto:johnb@post4.tele.dk">John Bundgaard</a>.
<br>Looks like DAO 3.5 has some support for multi-threading.
<P>As stated by the MFC 4.2 documentation, the Dao database classes are not thread-safe, and that is indeed true.
<P>I recently developed a server application the uses IO completion ports, which by nature, are using a number of threads. Because of that, I had to figure out a way to use DAO in different threads simultaneously.
Here is how I did it:
<PRE><TT><FONT COLOR="#990000">
//
// used a global critical section to prevent multiple threads initializing
// the Dao database simultaneous.
//
CCriticalSection cs;
//
// Some thread function
// (In my server app, 4 thread using this function is started)
//
UINT MyThreadFunc (LPVOID pParam)
{
CSingleLock lock(&cs, TRUE);
//
// Initialize MFC Dao support
//
AfxDaoInit();
CDaoDatabase db;
CSomeDaoRecordset set(&db);
//
// Open the database and recordset.
//
try
{
db.Open(_T("database.mdb"));
set.Open(dbOpenTable);
set.SetCurrentIndex(_T("PrimaryKey"));
}
catch(CException* pe)
{
pe->ReportError();
pe->Delete();
return 0;
}
//
// Allow other threads to initialize Dao
//
lock.Unlock();
//
// OK the database and recordset is now open
//
while( bRunThisThread )
{
//
// NOTE: You do NOT need to lock out other threads vhile calling
// database functions here.
//
WaitForClientRequest();
ParseRequest();
DoDatabaseIO();
}
//
// Now, lock the critical section again
//
lock.Lock();
//
// Close recordset and database.
rs.Close();
db.Close();
// IMPORTANT: do NOT call AfxDaoTerm() !!!!
return 0;
}
</FONT></TT></PRE>
<P>Now, when your application terminates, it will generate a protection error. To prevent that modify your CMyApp::ExitInstance().
<PRE><TT><FONT COLOR="#990000">
int CMyApp::ExitInstance()
{
//
// Insert your own cleanup code here
//
AfxDaoInit();
AfxDaoTerm();
return m_msgCur.wParam;
}
</FONT></TT></PRE>
<P>Notes:
<br>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -