遇到的难题 通过odbc来查询数据库一个表,然后将查询结果插入到别一个表中如何写代码? rt 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 /*SQLColumn.h*/#ifndef __SQLCOLUMN#define __SQLCOLUMN#include "sqlext.h"class CSQLColumn {public: CSQLColumn(); ~CSQLColumn();public: CString m_svValue; int m_nCol; int m_nType;};#endif //__SQLCOLUMN /*SQLDirect.h*/#ifndef __SQLDIRECT#define __SQLDIRECT#include "sqlcolumn.h"#pragma comment(lib, "odbc32.lib")class CSQLDirect {public: CSQLDirect(); CSQLDirect( LPCSTR, LPCSTR, LPCSTR ); ~CSQLDirect(); void InitODBC( void ); void GetError( CString& ); void Close( void ); int ExecuteSQL( LPCSTR ); int Connect( LPCSTR, LPCSTR, LPCSTR ); int Fetch( void ); int GetColumnID( CString,CString ); int GetColumnType( int ); CString GetCol( int ); CString GetCol( CString,CString = _T("") ); CString GetColumnName( int ); int GetNumColumns(); inline void CSQLDirect::SupressErrors( bool bSupress = true ) { m_bSupressErrors=bSupress; }private: void KillCols( void ); void AddColumn( int,CString ); void DisplayError( void ); int FindColumn( int ); CSQLColumn* GetColumn( int );private: HENV m_hEnv; HDBC m_hDBC; HSTMT m_hStmt; CPtrArray m_ColArray; bool m_bSupressErrors;};#endif // __SQL /*SQLColumn.cpp*/#include "stdafx.h"#include "sqlcolumn.h"CSQLColumn::CSQLColumn(){ m_nCol=0; m_nType=SQL_C_DEFAULT; m_svValue="";}CSQLColumn::~CSQLColumn(){} m_pConnection.CreateInstance(__uuidof(Connection))失败 临时表 如何获取某路径下的长中文文件名(windows系统) 怎样才能在编辑栏中输入字符,并在程序中获取到 客户端无法查询服务器端文件内容怎么办? 重定向问题:局域网里重定向只能改变某台机上不了某个网站(IP),不能使其不能上网吗 散分了!!!---顺便谈谈技术无用论 得到鼠标当前 坐标是哪个函数? 如何获取特定网页 ? VS2010创建不了新项目 请问高手:如果在一个应用程序的对话框中加一个按钮? 我是初学者,请问MSDN是干什么的呀?
#ifndef __SQLCOLUMN#define __SQLCOLUMN#include "sqlext.h"
class CSQLColumn {
public:
CSQLColumn();
~CSQLColumn();public:
CString m_svValue;
int m_nCol;
int m_nType;
};#endif //__SQLCOLUMN
#define __SQLDIRECT#include "sqlcolumn.h"#pragma comment(lib, "odbc32.lib")class CSQLDirect {
public:
CSQLDirect();
CSQLDirect( LPCSTR, LPCSTR, LPCSTR );
~CSQLDirect(); void InitODBC( void );
void GetError( CString& );
void Close( void );
int ExecuteSQL( LPCSTR );
int Connect( LPCSTR, LPCSTR, LPCSTR );
int Fetch( void );
int GetColumnID( CString,CString );
int GetColumnType( int );
CString GetCol( int );
CString GetCol( CString,CString = _T("") );
CString GetColumnName( int );
int GetNumColumns(); inline void CSQLDirect::SupressErrors( bool bSupress = true ) { m_bSupressErrors=bSupress; }private:
void KillCols( void );
void AddColumn( int,CString );
void DisplayError( void );
int FindColumn( int );
CSQLColumn* GetColumn( int );private:
HENV m_hEnv;
HDBC m_hDBC;
HSTMT m_hStmt;
CPtrArray m_ColArray;
bool m_bSupressErrors;
};#endif // __SQL
#include "stdafx.h"
#include "sqlcolumn.h"CSQLColumn::CSQLColumn()
{
m_nCol=0;
m_nType=SQL_C_DEFAULT;
m_svValue="";
}CSQLColumn::~CSQLColumn()
{
}