quess_importdlg.h

把excel2003表格内容导入mysql5数据库

// quess_importDlg.h : 头文件
//
#include "CApplication.h"
#include "CRange.h"
#include "CWorkbook.h"
#include "CWorkbooks.h"
#include "CWorksheet.h"
#include "CWorksheets.h"

#include "mysql.h"
#include "winsock.h"
#pragma comment(lib,"libmySQL.lib")


#pragma once


// Cquess_importDlg 对话框
class Cquess_importDlg : public CDialog
{
// 构造
public:
	Cquess_importDlg(CWnd* pParent = NULL);	// 标准构造函数

// 对话框数据
	enum { IDD = IDD_QUESS_IMPORT_DIALOG };

	protected:
	virtual void DoDataExchange(CDataExchange* pDX);	// DDX/DDV 支持


// 实现
protected:
	HICON m_hIcon;

	// 生成的消息映射函数
	virtual BOOL OnInitDialog();
	afx_msg void OnSysCommand(UINT nID, LPARAM lParam);
	afx_msg void OnPaint();
	afx_msg HCURSOR OnQueryDragIcon();
	DECLARE_MESSAGE_MAP()
public:
	afx_msg void OnBnClickedExcelTest();
	CApplication myExcel;
	CWorkbook myBook;
	CWorkbooks myBooks;
    CWorksheets mySheets;
    CWorksheet mySheet;
    CRange myRange;
    VARIANT ret_all,ret_test;
	afx_msg void OnBnClickedButtonPath();
	CString m_FullPath;
	CString m_DbUserName;
	CString m_DbPassword;
	MYSQL db_mysql;
	bool conn;
	afx_msg void OnBnClickedConnMysql();
	int m_start_line;
	int m_stop_line;
	afx_msg void OnDestroy();
};