www.pudn.com > MySQLMan.rar > MySQLManDlg.cpp
// MySQLManDlg.cpp : implementation file // #include "stdafx.h" #include "MySQLMan.h" #include "MySQLManDlg.h" #include#include #include #include "mysql.h" #include "mysql_com.h" #include "mysql_version.h" #include "errmsg.h" #include "mysqld_error.h" #define DEFALT_SQL_STMT "SELECT * FROM db" #ifndef offsetof #define offsetof(TYPE, MEMBER) ((size_t) &((TYPE *)0)->MEMBER) #endif #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CAboutDlg dialog used for App About class CAboutDlg : public CDialog { public: CAboutDlg(); // Dialog Data //{{AFX_DATA(CAboutDlg) enum { IDD = IDD_ABOUTBOX }; //}}AFX_DATA // ClassWizard generated virtual function overrides //{{AFX_VIRTUAL(CAboutDlg) protected: virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support //}}AFX_VIRTUAL // Implementation protected: //{{AFX_MSG(CAboutDlg) //}}AFX_MSG DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { //{{AFX_DATA_INIT(CAboutDlg) //}}AFX_DATA_INIT } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CAboutDlg) //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) //{{AFX_MSG_MAP(CAboutDlg) // No message handlers //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CMySQLManDlg dialog CMySQLManDlg::CMySQLManDlg(CWnd* pParent /*=NULL*/) : CDialog(CMySQLManDlg::IDD, pParent) { //{{AFX_DATA_INIT(CMySQLManDlg) m_host = _T(""); m_user = _T(""); m_pwd = _T(""); m_database = _T(""); m_port = _T(""); m_sqlstr = _T(""); //}}AFX_DATA_INIT // Note that LoadIcon does not require a subsequent DestroyIcon in Win32 m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME); } void CMySQLManDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CMySQLManDlg) DDX_Control(pDX, IDC_LIST, m_List); DDX_Text(pDX, IDC_EDIT1, m_host); DDX_Text(pDX, IDC_EDIT2, m_user); DDX_Text(pDX, IDC_EDIT3, m_pwd); DDX_Text(pDX, IDC_EDIT4, m_database); DDX_Text(pDX, IDC_EDIT5, m_port); DDX_Text(pDX, IDC_SQL, m_sqlstr); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CMySQLManDlg, CDialog) //{{AFX_MSG_MAP(CMySQLManDlg) ON_WM_SYSCOMMAND() ON_WM_PAINT() ON_WM_QUERYDRAGICON() ON_BN_CLICKED(IDC_BUTTON_Connect, OnBUTTONConnect) ON_BN_CLICKED(IDC_BUTTON_SQLEXEC, OnButtonSqlexec) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CMySQLManDlg message handlers BOOL CMySQLManDlg::OnInitDialog() { CDialog::OnInitDialog(); // Add "About..." menu item to system menu. // IDM_ABOUTBOX must be in the system command range. ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX); ASSERT(IDM_ABOUTBOX < 0xF000); CMenu* pSysMenu = GetSystemMenu(FALSE); if (pSysMenu != NULL) { CString strAboutMenu; strAboutMenu.LoadString(IDS_ABOUTBOX); if (!strAboutMenu.IsEmpty()) { pSysMenu->AppendMenu(MF_SEPARATOR); pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu); } } // Set the icon for this dialog. The framework does this automatically // when the application's main window is not a dialog SetIcon(m_hIcon, TRUE); // Set big icon SetIcon(m_hIcon, FALSE); // Set small icon // TODO: Add extra initialization here return TRUE; // return TRUE unless you set the focus to a control } void CMySQLManDlg::OnSysCommand(UINT nID, LPARAM lParam) { if ((nID & 0xFFF0) == IDM_ABOUTBOX) { CAboutDlg dlgAbout; dlgAbout.DoModal(); } else { CDialog::OnSysCommand(nID, lParam); } } // If you add a minimize button to your dialog, you will need the code below // to draw the icon. For MFC applications using the document/view model, // this is automatically done for you by the framework. void CMySQLManDlg::OnPaint() { if (IsIconic()) { CPaintDC dc(this); // device context for painting SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0); // Center icon in client rectangle int cxIcon = GetSystemMetrics(SM_CXICON); int cyIcon = GetSystemMetrics(SM_CYICON); CRect rect; GetClientRect(&rect); int x = (rect.Width() - cxIcon + 1) / 2; int y = (rect.Height() - cyIcon + 1) / 2; // Draw the icon dc.DrawIcon(x, y, m_hIcon); } else { CDialog::OnPaint(); } } // The system calls this to obtain the cursor to display while the user drags // the minimized window. HCURSOR CMySQLManDlg::OnQueryDragIcon() { return (HCURSOR) m_hIcon; } ///////////////////////////////////////////////// ///// ================ ///// ///// Global Variables ///// ///// ================ ///// ///////////////////////////////////////////////// char strSQL[ 200 ]; char strDB[ 50 ] ; MYSQL *CONN ; MYSQL_RES * res ; MYSQL_FIELD * fd ; MYSQL_ROW row ; BOOL ConnState=false; void CMySQLManDlg::OnBUTTONConnect() { UpdateData(true); int ret=0; //return value CString messages; int errorno=0; ////////////////////////////////////////////////////////////////////// int len; const char* user;const char* pwd; len=m_user.GetLength(); if (len==0) user=NULL; else user=m_user.GetBuffer(len); len=m_pwd.GetLength(); if (len==0) user=NULL; else pwd=m_pwd.GetBuffer(len); if (m_database=="") m_database="mysql"; strcpy( strDB, m_database ) ; if ( (CONN = mysql_init((MYSQL*) 0)) && mysql_real_connect( CONN, NULL, NULL, NULL, strDB, MYSQL_PORT,NULL, 0 ) ) { if ( mysql_select_db( CONN, strDB ) ) { messages=strDB; messages="Can't select the database :"+messages; AfxMessageBox(messages); mysql_close( CONN ) ; return ; } ConnState=true; } else { messages=MYSQL_PORT; messages="Can't connect to the mysql server on port:"+messages; AfxMessageBox(messages); mysql_close( CONN ) ; return ; } if (ConnState) GetDlgItem(IDC_BUTTON_SQLEXEC)->EnableWindow(TRUE); messages=strDB; m_List.AddString("连接到数据库"+messages); } void CMySQLManDlg::OnButtonSqlexec() { UpdateData(TRUE); int ret=0; int errorno=0; CString err; //strcpy(m_sqlstr,"CREATE TABLE tab1(id INT,name CHAR(20))"); if (m_sqlstr!="") ret=mysql_query( CONN, m_sqlstr ); else { AfxMessageBox("Sql String is empty!"); return; } if (ret) { errorno=mysql_errno( CONN ); switch (errorno) { case CR_COMMANDS_OUT_OF_SYNC: AfxMessageBox("COMMAND_OUT_OF_SYNC"); break; return; case CR_SERVER_GONE_ERROR: AfxMessageBox("ERVER_GONE_ERROR"); break; return; case CR_SERVER_LOST: AfxMessageBox("SERVER_LOST"); break; return; case CR_UNKNOWN_ERROR: AfxMessageBox("UNKNOWN_ERROR"); break; return; default: err.Format("%d",errorno); AfxMessageBox("FT! Error No."+err); break; return; } } }