db.cpp

数据库操作程序,不错的,

// DB.cpp : Defines the class behaviors for the application.
//

#include "stdafx.h"
#include "DB.h"
#include "LANDDLG.h"
#include "MainFrm.h"
#include "DBSet.h"
#include "DBDoc.h"
#include "DBView.h"
#include "odbcinst.h"
#include "PWSet.h"
#include "LOGINDLG.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
bool showflag;
CString m_quanxian;
bool changeflag;
/////////////////////////////////////////////////////////////////////////////
// CDBApp

BEGIN_MESSAGE_MAP(CDBApp, CWinApp)
	//{{AFX_MSG_MAP(CDBApp)
	ON_COMMAND(ID_APP_ABOUT, OnAppAbout)
		// NOTE - the ClassWizard will add and remove mapping macros here.
		//    DO NOT EDIT what you see in these blocks of generated code!
	//}}AFX_MSG_MAP
	// Standard print setup command
	ON_COMMAND(ID_FILE_PRINT_SETUP, CWinApp::OnFilePrintSetup)
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDBApp construction

CDBApp::CDBApp()
{
	showflag=false;
	changeflag=false;
	// TODO: add construction code here,
	// Place all significant initialization in InitInstance
}

/////////////////////////////////////////////////////////////////////////////
// The one and only CDBApp object

CDBApp theApp;

/////////////////////////////////////////////////////////////////////////////
// CDBApp initialization

BOOL CDBApp::InitInstance()
{
	AfxEnableControlContainer();
	m_Skin.LoadSkinFile("xpgrean.smf");
	m_Skin.SetDialogSkin("Dialog");
	//////////////////////////////////  ACCESS配置数据源
	CString sPath;//保存数据库文件路径名
	GetModuleFileName(NULL,sPath.GetBufferSetLength (MAX_PATH+1),MAX_PATH);//为sPath分配存储空间
	sPath.ReleaseBuffer();
	int nPos;
	nPos=sPath.ReverseFind('\\');
	sPath=sPath.Left(nPos);//获取文件的Debug路径
        nPos=sPath.ReverseFind('\\');
	sPath=sPath.Left(nPos);//获取文件的工程文件夹路径
	CString lpszFileName = sPath + "\\xxx.mdb";//保存数据库文件名称                          //需要修改hc
	CFileFind  fFind;
	if(!fFind.FindFile(lpszFileName))
	{
		::AfxMessageBox("没有找到数据库xxx");
		exit(0);
	}
	CString szDesc;//保存对数据源的描述
	szDesc.Format( "DSN=xxx;FIL=Microsoft Access;DEFAULTDIR=%s;DBQ=%s;" ,sPath,lpszFileName);      //需要修改hc
	//添加数据源
	if(!::SQLConfigDataSource(NULL,ODBC_ADD_DSN, "Microsoft Access Driver (*.mdb)",(LPCSTR)szDesc))
	{
		::AfxMessageBox("32位ODBC数据源配置错误!");
		exit(0);
	}

	free((void*)m_pszAppName);//先释放原有的
    m_pszAppName=_tcsdup(_T("提醒？"));//设置程序名称 

//////////////////////////////////  ACCESS配置数据源
	bool passflag=false;
	PWSet mySet;
	mySet.Open();
	LANDDLG mydlg;
	for(int i=0;i<=2;i++)
	{
aa:	if(mydlg.DoModal()==IDOK)
	{
		while(!mySet.IsEOF())
		{
			if(mySet.m_sno==mydlg.m_sno&&mySet.m_password==mydlg.m_password)
			{
				m_quanxian=mySet.m_authority;
				passflag=true;
				break;
			}
			else
				mySet.MoveNext();
		}

		if(passflag)
			break;
		else
		{
			AfxMessageBox("用户或密码错误,请重试");
		}

	}
	else
		return false;
	}
	if(!passflag)
	{
		if(AfxMessageBox(_T("三次登录错误!程序即将终止,你需要注册账号吗"),MB_YESNO|MB_ICONINFORMATION)==IDYES)
		{

bb:			LOGINDLG mydlg;
			if(mydlg.DoModal()==IDOK)
			{
				if(mydlg.m_sno==""||mydlg.m_password=="")
				{
					AfxMessageBox("请输入ID号或密码");
					goto  bb;
				}
				if(mydlg.m_password!=mydlg.m_passwordagain)
				{
					AfxMessageBox("两次密码不一致");
					goto  bb;
				}
				mySet.AddNew();
				mySet.m_sno=mydlg.m_sno;
				mySet.m_password=mydlg.m_password;
				mySet.m_authority="非管理员";
				mySet.Update();
				mySet.Requery();
				goto aa;
			}
			else
				return false;
		}
		else
			return false;

	}



	// Standard initialization
	// If you are not using these features and wish to reduce the size
	//  of your final executable, you should remove from the following
	//  the specific initialization routines you do not need.

#ifdef _AFXDLL
	Enable3dControls();			// Call this when using MFC in a shared DLL
#else
	Enable3dControlsStatic();	// Call this when linking to MFC statically
#endif

	// Change the registry key under which our settings are stored.
	// TODO: You should modify this string to be something appropriate
	// such as the name of your company or organization.
	SetRegistryKey(_T("Local AppWizard-Generated Applications"));

	LoadStdProfileSettings();  // Load standard INI file options (including MRU)

	// Register the application's document templates.  Document templates
	//  serve as the connection between documents, frame windows and views.

	CSingleDocTemplate* pDocTemplate;
	pDocTemplate = new CSingleDocTemplate(
		IDR_MAINFRAME,
		RUNTIME_CLASS(CDBDoc),
		RUNTIME_CLASS(CMainFrame),       // main SDI frame window
		RUNTIME_CLASS(CDBView));
	AddDocTemplate(pDocTemplate);

	// Parse command line for standard shell commands, DDE, file open
	CCommandLineInfo cmdInfo;
	ParseCommandLine(cmdInfo);

	// Dispatch commands specified on the command line
	if (!ProcessShellCommand(cmdInfo))
		return FALSE;

	// The one and only window has been initialized, so show and update it.
	m_pMainWnd->ShowWindow(SW_SHOW);
	m_pMainWnd->UpdateWindow();

	m_Skin.SetWindowSkin(m_pMainWnd->m_hWnd, "MainFrame");


	return TRUE;
}


/////////////////////////////////////////////////////////////////////////////
// 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)
		// No message handlers
	//}}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()

// App command to run the dialog
void CDBApp::OnAppAbout()
{
	CAboutDlg aboutDlg;
	aboutDlg.DoModal();
}

/////////////////////////////////////////////////////////////////////////////
// CDBApp message handlers