°Ë±¦Êé¿â > ÎÄѧÆäËûµç×ÓÊé > SQL 21ÈÕ×Ôѧͨ(V3.0)(PDF¸ñʽ) >

µÚ93²¿·Ö

SQL 21ÈÕ×Ôѧͨ(V3.0)(PDF¸ñʽ)-µÚ93²¿·Ö

С˵£º SQL 21ÈÕ×Ôѧͨ(V3.0)(PDF¸ñʽ) ×ÖÊý£º ÿҳ4000×Ö

°´¼üÅÌÉÏ·½Ïò¼ü ¡û »ò ¡ú ¿É¿ìËÙÉÏÏ·­Ò³£¬°´¼üÅÌÉ쵀 Enter ¼ü¿É»Øµ½±¾ÊéĿ¼ҳ£¬°´¼üÅÌÉÏ·½Ïò¼ü ¡ü ¿É»Øµ½±¾Ò³¶¥²¿£¡
¡ª¡ª¡ª¡ªÎ´ÔĶÁÍꣿ¼ÓÈëÊéÇ©ÒѱãÏ´μÌÐøÔĶÁ£¡






¡¡¸½¼þ¡¡B¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÔÚµÚ¡¡14¡¡ÌìÖеġ¡C£«£«Ô´´úÂëÇåµ¥¡¡



//¡¡tyssqvw¡£h¡¡£º¡¡interface¡¡of¡¡the¡¡CTyssqlView¡¡class¡¡



//¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



class¡¡CTyssqlSet£»¡¡



class¡¡CTyssqlView¡¡£º¡¡public¡¡CRecordView¡¡



£û¡¡



protected£º¡¡//¡¡create¡¡from¡¡serialization¡¡only¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlView£¨£©£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_DYNCREATE£¨CTyssqlView£©¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£û£ûAFX_DATA£¨CTyssqlView£©¡¡



¡¡¡¡¡¡¡¡enum¡¡£û¡¡IDD¡¡=¡¡IDD_TYSSQL_FORM¡¡£ý£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlSet*¡¡¡¡m_pSet£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£ý£ýAFX_DATA¡¡



//¡¡Attributes¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlDoc*¡¡¡¡GetDocument£¨£©£»¡¡



//¡¡Operations¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡CRecordset*¡¡¡¡OnGetRecordset£¨£©£»¡¡



//¡¡Implementation¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡~CTyssqlView£¨£©£»¡¡



#ifdef¡¡_DEBUG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡AssertValid£¨£©¡¡¡¡const£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡Dump£¨CDumpContext&¡¡¡¡dc£©¡¡¡¡const£»¡¡



#endif¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡504¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡505¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

SQL¡¡21¡¡¡¡ÈÕ×Ôѧͨ£¨V1¡£0£©¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·­ÒëÈË¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡±¿Öí¡¡



protected£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡DoDataExchange£¨CDataExchange*¡¡¡¡pDX£©£»//¡¡¡¡DDX/DDV¡¡¡¡support¡¡



¡¡¡¡¡¡¡¡virtual¡¡void¡¡OnInitialUpdate£¨£©£»¡¡//¡¡called¡¡first¡¡time¡¡after¡¡construct¡¡



//¡¡Generated¡¡message¡¡map¡¡functions¡¡



protected£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£û£ûAFX_MSG£¨CTyssqlView£©¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡NOTE¡¡¡¡¡¡the¡¡¡¡ClassWizard¡¡¡¡will¡¡¡¡add¡¡¡¡and¡¡¡¡remove¡¡¡¡member¡¡¡¡functions¡¡¡¡here¡£¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DO¡¡¡¡NOT¡¡¡¡EDIT¡¡¡¡what¡¡¡¡you¡¡¡¡see¡¡¡¡in¡¡¡¡these¡¡¡¡blocks¡¡¡¡of¡¡¡¡generated¡¡¡¡code¡¡¡¡£¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£ý£ýAFX_MSG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_MESSAGE_MAP£¨£©¡¡



£ý£»¡¡



#ifndef¡¡_DEBUG¡¡¡¡//¡¡debug¡¡version¡¡in¡¡tyssqvw¡£cpp¡¡



inline¡¡CTyssqlDoc*¡¡CTyssqlView£º£ºGetDocument£¨£©¡¡



¡¡¡¡¡¡¡¡¡¡¡¡£û¡¡¡¡return¡¡¡¡£¨CTyssqlDoc*£©m_pDocument£»¡¡¡¡£ý¡¡



#endif¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



//¡¡tyssql¡£h¡¡£º¡¡main¡¡header¡¡file¡¡for¡¡the¡¡TYSSQL¡¡application¡¡



//¡¡



#ifndef¡¡__AFXWIN_H__¡¡



¡¡¡¡¡¡¡¡#error¡¡include¡¡'stdafx¡£h'¡¡before¡¡including¡¡this¡¡file¡¡for¡¡PCH¡¡



#endif¡¡



#include¡¡¡¡¡¨resource¡£h¡¨¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡main¡¡¡¡symbols¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



//¡¡CTyssqlApp£º¡¡



//¡¡See¡¡tyssql¡£cpp¡¡for¡¡the¡¡implementation¡¡of¡¡this¡¡class¡¡



//¡¡



class¡¡CTyssqlApp¡¡£º¡¡public¡¡CWinApp¡¡



£û¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlApp£¨£©£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡505¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡506¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

SQL¡¡21¡¡¡¡ÈÕ×Ôѧͨ£¨V1¡£0£©¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·­ÒëÈË¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡±¿Öí¡¡



//¡¡Overrides¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡BOOL¡¡¡¡InitInstance£¨£©£»¡¡



//¡¡Implementation¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£û£ûAFX_MSG£¨CTyssqlApp£©¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡afx_msg¡¡¡¡void¡¡¡¡OnAppAbout£¨£©£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡NOTE¡¡¡¡¡¡the¡¡¡¡ClassWizard¡¡¡¡will¡¡¡¡add¡¡¡¡and¡¡¡¡remove¡¡¡¡member¡¡¡¡functions¡¡¡¡here¡£¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DO¡¡¡¡NOT¡¡¡¡EDIT¡¡¡¡what¡¡¡¡you¡¡¡¡see¡¡¡¡in¡¡¡¡these¡¡¡¡blocks¡¡¡¡of¡¡¡¡generated¡¡¡¡code¡¡¡¡£¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£ý£ýAFX_MSG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_MESSAGE_MAP£¨£©¡¡



£ý£»¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



//¡¡tyssqset¡£h¡¡£º¡¡interface¡¡of¡¡the¡¡CTyssqlSet¡¡class¡¡



//¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



class¡¡CTyssqlSet¡¡£º¡¡public¡¡CRecordset¡¡



£û¡¡



DECLARE_DYNAMIC£¨CTyssqlSet£©¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlSet£¨CDatabase*¡¡¡¡pDatabase¡¡¡¡=¡¡¡¡NULL£©£»¡¡



//¡¡Field/Param¡¡Data¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£û£ûAFX_FIELD£¨CTyssqlSet£»¡¡¡¡CRecordset£©¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CString¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_NAME£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CString¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_ADDRESS£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CString¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_STATE£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CString¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_ZIP£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CString¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_PHONE£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CString¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_REMARKS£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£ý£ýAFX_FIELD¡¡



//¡¡Implementation¡¡



protected£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡506¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡507¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

SQL¡¡21¡¡¡¡ÈÕ×Ôѧͨ£¨V1¡£0£©¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·­ÒëÈË¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡±¿Öí¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡CString¡¡¡¡GetDefaultConnect£¨£©£»¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡Default¡¡¡¡connection¡¡¡¡string¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡CString¡¡¡¡GetDefaultSQL£¨£©£»¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡default¡¡¡¡SQL¡¡¡¡for¡¡¡¡Recordset¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡DoFieldExchange£¨CFieldExchange*¡¡¡¡pFX£©£»¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡RFX¡¡¡¡support¡¡



£ý£»¡¡



//¡¡tyssqdoc¡£h¡¡£º¡¡interface¡¡of¡¡the¡¡CTyssqlDoc¡¡class¡¡



//¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



class¡¡CTyssqlDoc¡¡£º¡¡public¡¡CDocument¡¡



£û¡¡



protected£º¡¡//¡¡create¡¡from¡¡serialization¡¡only¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlDoc£¨£©£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_DYNCREATE£¨CTyssqlDoc£©¡¡



//¡¡Attributes¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CTyssqlSet¡¡¡¡m_tyssqlSet£»¡¡



//¡¡Operations¡¡



public£º¡¡



//¡¡Implementation¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡~CTyssqlDoc£¨£©£»¡¡



#ifdef¡¡_DEBUG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡AssertValid£¨£©¡¡¡¡const£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡Dump£¨CDumpContext&¡¡¡¡dc£©¡¡¡¡const£»¡¡



#endif¡¡



protected£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡BOOL¡¡¡¡OnNewDocument£¨£©£»¡¡



//¡¡Generated¡¡message¡¡map¡¡functions¡¡



protected£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£û£ûAFX_MSG£¨CTyssqlDoc£©¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡NOTE¡¡¡¡¡¡the¡¡¡¡ClassWizard¡¡¡¡will¡¡¡¡add¡¡¡¡and¡¡¡¡remove¡¡¡¡member¡¡¡¡functions¡¡¡¡here¡£¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡507¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡508¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

SQL¡¡21¡¡¡¡ÈÕ×Ôѧͨ£¨V1¡£0£©¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·­ÒëÈË¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡±¿Öí¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DO¡¡¡¡NOT¡¡¡¡EDIT¡¡¡¡what¡¡¡¡you¡¡¡¡see¡¡¡¡in¡¡¡¡these¡¡¡¡blocks¡¡¡¡of¡¡¡¡generated¡¡¡¡code¡¡¡¡£¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£ý£ýAFX_MSG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_MESSAGE_MAP£¨£©¡¡



£ý£»¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



//¡¡stdafx¡£h¡¡£º¡¡include¡¡file¡¡for¡¡standard¡¡system¡¡include¡¡files£»¡¡



//¡¡¡¡or¡¡project¡¡specific¡¡include¡¡files¡¡that¡¡are¡¡used¡¡frequently£»¡¡but¡¡



//¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡are¡¡¡¡changed¡¡¡¡infrequently¡¡



//¡¡



#include¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡MFC¡¡¡¡core¡¡¡¡and¡¡¡¡standard¡¡¡¡ponents¡¡



#include¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡MFC¡¡¡¡extensions¡¡¡¡£¨including¡¡¡¡VB£©¡¡



#include¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡MFC¡¡¡¡database¡¡¡¡classes¡¡



////////////////////////////////////////////////////////////¡¡



//£û£ûNO_DEPENDENCIES£ý£ý¡¡



//¡¡App¡¡Studio¡¡generated¡¡include¡¡file¡£¡¡



//¡¡Used¡¡by¡¡TYSSQL¡£RC¡¡



//¡¡



#define¡¡¡¡IDR_MAINFRAME¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2¡¡



#define¡¡¡¡IDD_ABOUTBOX¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡100¡¡



#define¡¡¡¡IDD_TYSSQL_FORM¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡101¡¡



#define¡¡¡¡IDP_FAILED_OPEN_DATABASE¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡103¡¡



#define¡¡¡¡IDC_NAME¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡1000¡¡



#define¡¡¡¡IDC_ADDRESS¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡1001¡¡



#define¡¡¡¡IDC_STATE¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡1002¡¡



#define¡¡¡¡IDC_ZIP¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡1003¡¡



//¡¡Next¡¡default¡¡values¡¡for¡¡new¡¡objects¡¡



//¡¡



#ifdef¡¡APSTUDIO_INVOKED¡¡



#ifndef¡¡APSTUDIO_READONLY_SYMBOLS¡¡



#define¡¡¡¡_APS_NEXT_RESOURCE_VALUE¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡102¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡508¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡509¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

SQL¡¡21¡¡¡¡ÈÕ×Ôѧͨ£¨V1¡£0£©¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·­ÒëÈË¡¡¡¡¡¡¡¡¡¡¡¡¡¡±¿Öí¡¡



#define¡¡¡¡_APS_NEXT_MAND_VALUE¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡32771¡¡



#define¡¡¡¡_APS_NEXT_CONTROL_VALUE¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡1004¡¡



#define¡¡¡¡_APS_NEXT_SYMED_VALUE¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡101¡¡



#endif¡¡



#endif¡¡



///////////////////////////////////////////////////¡¡



//¡¡mainfrm¡£h¡¡£º¡¡interface¡¡of¡¡the¡¡CMainFrame¡¡class¡¡



//¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



class¡¡CMainFrame¡¡£º¡¡public¡¡CFrameWnd¡¡



£û¡¡



protected£º¡¡//¡¡create¡¡from¡¡serialization¡¡only¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CMainFrame£¨£©£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_DYNCREATE£¨CMainFrame£©¡¡



//¡¡Attributes¡¡



public£º¡¡



//¡¡Operations¡¡



public£º¡¡



//¡¡Implementation¡¡



public£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡~CMainFrame£¨£©£»¡¡



#ifdef¡¡_DEBUG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡AssertValid£¨£©¡¡¡¡const£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡virtual¡¡¡¡void¡¡¡¡Dump£¨CDumpContext&¡¡¡¡dc£©¡¡¡¡const£»¡¡



#endif¡¡



protected£º¡¡¡¡//¡¡control¡¡bar¡¡embedded¡¡members¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CStatusBar¡¡¡¡¡¡¡¡m_wndStatusBar£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡CToolBar¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡m_wndToolBar£»¡¡



//¡¡Generated¡¡message¡¡map¡¡functions¡¡



protected£º¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡509¡¡


¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­Page¡¡510¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­

SQL¡¡21¡¡¡¡ÈÕ×Ôѧͨ£¨V1¡£0£©¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡·­ÒëÈË¡¡¡¡¡¡¡¡¡¡¡¡¡¡±¿Öí¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£û£ûAFX_MSG£¨CMainFrame£©¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡afx_msg¡¡¡¡int¡¡¡¡OnCreate£¨LPCREATESTRUCT¡¡¡¡lpCreateStruct£©£»¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡NOTE¡¡¡¡¡¡the¡¡¡¡ClassWizard¡¡¡¡will¡¡¡¡add¡¡¡¡and¡¡¡¡remove¡¡¡¡member¡¡¡¡functions¡¡¡¡here¡£¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DO¡¡¡¡NOT¡¡¡¡EDIT¡¡¡¡what¡¡¡¡you¡¡¡¡see¡¡¡¡in¡¡¡¡these¡¡¡¡blocks¡¡¡¡of¡¡¡¡generated¡¡¡¡code£¡¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//£ý£ýAFX_MSG¡¡



¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡DECLARE_MESSAGE_MAP£¨£©¡¡



£ý£»¡¡



/////////////////////////////////////////////////////////////////////////////¡¡



//¡¡tyssqvw¡£cpp¡¡£º¡¡implementation¡¡of¡¡the¡¡CTyssqlView¡¡class¡¡



//¡¡



#include¡¡¡¨stdafx¡£h¡¨¡¡



#include¡¡¡¨tyssql¡£h¡¨¡¡



#include¡¡¡¨tyssqset¡£h¡¨¡¡



#include¡¡¡¨tyssqdoc¡£h¡¨¡¡



#include¡¡¡¨tyssqvw¡£h¡¨¡¡



·µ»ØĿ¼ ÉÏÒ»Ò³ ÏÂÒ»Ò³ »Øµ½¶¥²¿ ÔÞ£¨0£© ²È£¨0£©

Äã¿ÉÄÜϲ»¶µÄ