test.cpp

基于access数据库的图书馆管理系统

// TEST.cpp : implementation file
//

#include "stdafx.h"
#include "课程设计.h"
#include "TEST.h"

#include "column.h"
#include "columns.h"
#include "COMDEF.H"
#include "ADOConn.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CTEST dialog


CTEST::CTEST(CWnd* pParent /*=NULL*/)
	: CDialog(CTEST::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTEST)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CTEST::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTEST)
	DDX_Control(pDX, IDC_ADODC3, m_adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTEST, CDialog)
	//{{AFX_MSG_MAP(CTEST)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTEST message handlers

BOOL CTEST::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
/*    _variant_t vIndex;
	vIndex = long(0);
	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
	for (int i = 1; i<6; i++)
	{
		vIndex = long(i);
		m_datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
	}*/
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

CString CTEST::WSEEN_GetItem(int ColNum)
{
   CColumns cols = m_datagrid.GetColumns();
   VARIANT v_ColNum,v_Value;
   //设置列编号
   v_ColNum.vt = VT_I2;
   v_ColNum.intVal = ColNum;
   CColumn col = cols.GetItem(v_ColNum);
   v_Value = col.GetValue();
   return v_Value.bstrVal;
}

//DEL void CTEST::WSEEN_SetItem(int ColNum, BSTR  Kanum)
//DEL {
//DEL    CColumns cols = m_datagrid.GetColumns();
//DEL    VARIANT v_ColNum,v_Value;
//DEL    //设置列编号
//DEL    v_ColNum.vt = VT_I2;
//DEL    v_ColNum.intVal = ColNum;
//DEL    CColumn col = cols.GetItem(v_ColNum);
//DEL    v_Value.bstrVal = Kanum;
//DEL    col.SetValue(v_Value);
//DEL }

void CTEST::OnButton1() 
{
	// TODO: Add your control notification handler code here
    CString sql;
	sql = " 'zhoubo' ";
//	sql_update(sql);
//	sql_insert();
//	sql_delete(sql);
//	m_adodc.SetRecordSource("select *  from 借书卡表");
//	m_adodc.Refresh();
    sql = WSEEN_GetItem(2);
}

void CTEST::sql_insert()
{
  ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  CString name,num;
  num = "E04620129";
  num = "'"+num+"'";
  name = "'xu'";
  _bstr_t sql;
  sql = "insert into 借书卡表(卡号,持卡人) values("+num+","+name+")";
  m_adoconn.ExecuteSQL(sql);
  m_adoconn.ExitConnect();
}

void CTEST::sql_update(CString sql)
{
  ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  _bstr_t vsql;
  vsql = "update 借书卡表 set 持卡人 = " + sql + "where 卡号 = 'E04620122'";
  m_adoconn.ExecuteSQL(vsql);
  m_adoconn.ExitConnect();
}

void CTEST::sql_delete(CString sql)
{
   ADOConn m_adoconn;
  m_adoconn.OnInitDBConnect();
  _bstr_t vsql;
  vsql = "delete from 借书卡表 where 借书卡ID='9'";
  m_adoconn.ExecuteSQL(vsql);
  m_adoconn.ExitConnect();
}

void CTEST::WSEEN_GetValue()
{
//   m_datagrid.GetItem(0);

}