borrowbook.cpp

基于SQL2000下的图书馆管理系统

// borrowbook.cpp : implementation file
//

#include "stdafx.h"
#include "booksystem.h"
#include "borrowbook.h"
#include"sql.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// Cborrowbook dialog
SQL sql;

Cborrowbook::Cborrowbook(CWnd* pParent /*=NULL*/)
	: CDialog(Cborrowbook::IDD, pParent)
{
	//{{AFX_DATA_INIT(Cborrowbook)
	m_sno = _T("");
	m_sname = _T("");
	m_sclass = _T("");
	m_sbookname = _T("");
	//}}AFX_DATA_INIT
}


void Cborrowbook::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cborrowbook)
	DDX_Control(pDX, IDC_showlianjie, m_showlianjie);
	DDX_Text(pDX, IDC_sno, m_sno);
	DDX_Text(pDX, IDC_sname, m_sname);
	DDX_Text(pDX, IDC_sclass, m_sclass);
	DDX_Text(pDX, IDC_sbookname, m_sbookname);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cborrowbook, CDialog)
	//{{AFX_MSG_MAP(Cborrowbook)
	ON_BN_CLICKED(IDC_lianjieshujuku, Onlianjieshujuku)
	ON_BN_CLICKED(IDC_tijiao, Ontijiao)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cborrowbook message handlers

void Cborrowbook::Onlianjieshujuku() 
{
	// TODO: Add your control notification handler code here
	CString str;

	str="DRIVER={SQL Server};SERVER=(local);Database=book;UID=fatman;PWD=lucky";

	sql.m_db.OpenEx(str,0);

	if(sql.m_db.IsOpen())m_showlianjie.SetWindowText("Connect is ok");
	else m_showlianjie.SetWindowText("Oh,No!");	
	
}

void Cborrowbook::Ontijiao() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);

	CString str;
	str="insert into booksystem values ('"+m_sname+"','"+m_sclass+"','"+m_sno+"','"+m_sbookname+"')";

	sql.m_db.ExecuteSQL(str);
	if(sql.m_db.CanUpdate())
		MessageBox("Insert ok");
	else MessageBox("oh,no");
	
	
}

void Cborrowbook::OnButton3() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnOK();
	
}