rage.cpp

影碟租赁系统

// rage.cpp: implementation of the Crage class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "课程设计.h"
#include "rage.h"
#include "ADOConn.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

Crage::Crage()
{

}

Crage::~Crage()
{

}
void Crage::sql_delete(CString Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM WAGE WHERE ID=" + Id;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Crage::sql_insert()
{
   //连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	CString strid,strrage;
	strid.Format("%d",id);
	strrage.Format("%d",rage);
	_bstr_t vSQL;
	vSQL = "INSERT INTO WAGE values(" + strid + "," + strrage + ")" ;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
int Crage::sql_getrage(CString Id)
{
   	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT WAGE FROM WAGE WHERE ID=" + Id;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return 0;
	else
		return atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("WAGE"));

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}
void Crage::sql_update(CString Id)
{
    	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	CString strId,strwage;
	strId.Format("%d",id);
    strwage.Format("%d",rage);
	_bstr_t vSQL;
	vSQL = "UPDATE FILM SET ID=" + strId + ",WAGE='"
		+ strwage + "', WHERE ID=" + Id;
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}