À©µµ¿ì ÇÁ·Î±×·¡¹Ö ÀÚ·á |
---|
Á¦¸ñ | [MFC] ODBC 1999/01/16 (17:04) |
À̸§ | ±èÈ¿¿ø |
¹øÈ£ | 77 |
Á¶È¸ | 556 |
º»¹® |
ClassWizard¿¡¼, Add Class.. -> New¸¦ ¼±ÅÃÇÏ°í, BaseClass¸¦ CRecordsetÀ¸·Î ¼³Á¤Çϸé odbcÈÀÏÀ» ºÒ·¯ µéÀϼö ÀÖ´Ù. (¹Ì¸®, WindowsÀÇ Á¦¾îÆÇÀÇ ODBC¿¡¼, Ãß°¡°¡ µÇ¾î ÀÖ¾î¾ß ÇÑ´Ù.) Recordset type ¿µ¿ª¿¡. SnapShop°ú Dynaset¿É¼ÇÀÌ Àִµ¥, Snapshot¿É¼ÇÀº ´ÙÁßÀÇ »ç¿ëÀÚ°¡ ÇϳªÀÇ µ¥ÀÌŸº£À̽º ÈÀÏ¿¡ Á¢±ÙÇÒ¶§, ¿¹¸¦ µé¾î, A°¡ Á¢±ÙÇÏ°í Á¶È¸ÇÏ´Â °úÁ¤¿¡¼, B°¡ ÀÔ·ÂÇÑ µ¥ÀÌÅ͸¦ A´Â Áï½Ã Á¶È¸ÇÒ¼ö ¾ø°í, ÀÚ½ÅÀÌ ÀÔ·ÂÇÑ µ¥ÀÌŸ¿Í ±âÁ¸¿¡ OpenÇÒ ´ç½ÃÀÇ µ¥ÀÌÅ͸¸À» Á¶È¸/È®ÀÎÇÒ ¼ö ÀÖ´Ù. DynasetÀº ¹Ý´ë·Î, ´Ù¸¥ »ç¿ëÀÚµéÀÌ µ¿½Ã¿¡ ÀÔ·ÂÇÑ µ¥ÀÌŸµéµµ Áï½Ã °»½ÅÇÏ¿© Á¶È¸/È®ÀÎÇÒ ¼ö ÀÖ´Ù. <stdafx.h>Çì´õ ÆÄÀÏ¿¡´Â #include <afxdb.h> ¸¦ Ãß°¡ÇÏ¿©, odbc class °ü·Ã Çì´õ ÆÄÀÏÀ» ºÒ·¯µé¿©¾ß ÇÑ´Ù. // Example BOOL CCITYDLG::OnInitDialog() { CDialog::OnInitDialog(); CString MsgStr; CCITYDB rsCity(NULL); rsCity.Open(); if(rsCity.IsBOF()){ MsgStr="ÇØ´ç ½Ã±º¿¡ ´ëÇÑ ÀԷ»çÇ×ÀÌ ¾ø½À´Ï´Ù."; MsgStr=MsgStr+"È®ÀÎÇϽðí ÁøÇàÇϽʽÿä !!!"; AfxMessageBox(MsgStr, MB_OKCANCEL, MB_ICONEXCLAMATION); } else { rsCity.MoveFirst(); SetDlgItemText(IDC_CITY_CODE_TEXT,rsCity.m_Code); SetDlgItemText(IDC_CITY_NAME_TEXT,rsCity.m_Name); SetDlgItemText(IDC_CITY_MADEDATE_TEXT,rsCity.m_MadeDate); } |