?? 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();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -