执行SQL文件代码,C代码库,德仔网

代码语言
代码分类
【C】执行SQL文件
作者:章毅明 / 发布于2013/8/5/ 839

	// ExecuteSQLfile.cpp : Defines the entry point for the console application.
	//

	#include "stdafx.h"
	#include "ExecuteSQLfile.h"
	#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
	no_namespace rename("EOF", "EndOfFile")

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

	/////////////////////////////////////////////////////////////////////////////
	// The one and only application object

	CWinApp theApp;

	using namespace std;

	int _tmain(int argc, TCHAR* argv[], TCHAR* envp[])
	{
	int nRetCode = 0;
	
	// initialize MFC and print and error on failure
	if (!AfxWinInit(::GetModuleHandle(NULL), NULL, ::GetCommandLine(), 0))
	{
	 // TODO: change error code to suit your needs
	 cerr << _T("Fatal Error: MFC initialization failed") << endl;
	 nRetCode = 1;
	}
	else
	{
	 CFileDialog dlg(TRUE,NULL,NULL,OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,_T("SQL Files(*.sql)|*.sql|All Files(*.*)|*.*|"));
	 if(dlg.DoModal()==IDOK)
	 {
	 OFSTRUCT of;
	 HANDLE rfile=(HANDLE)OpenFile(dlg.GetPathName(),&of,OF_READ);
	 if ( rfile != (HANDLE)HFILE_ERROR )
	 {
	 DWORD filesize=GetFileSize(rfile,NULL);
	 char* buffer=new char[filesize+1];
	 DWORD readsize;
	 ReadFile(rfile,buffer,filesize,&readsize,NULL);
	 buffer[filesize]=0;
	 CoInitialize(NULL);
	 //_bstr_t varSource="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%%1"; //*.mdb
	 //_bstr_t varSource="Data Source=localhost;Initial Catalog=DB1;User Id=sa;Password=sa;";
	 //_bstr_t varSource="Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";
	 //_bstr_t varSource="Provider=SQLNCLI11;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;";
	 //_bstr_t varSource="Provider=SQLNCLI11;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;";
	 _bstr_t varSource="Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;";
	 //_bstr_t varSource="Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;";
	 //_bstr_t varSource="Provider=SQLNCLI10;Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;";
	 //_bstr_t varSource="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=%%1;Data Source=localhost";";
	 _ConnectionPtr m_pConnection(_uuidof(Connection));
	 if(m_pConnection==NULL) return 1;
	 _variant_t RecordAffected;
	 try
	 {
	 m_pConnection->Execute((_bstr_t)buffer,&RecordAffected,adCmdUnknown); //adCmdText
	 }
	 catch(_com_error e)
	 {
	 AfxMessageBox(e.Description());
	 }
	 CoUninitialize();
	 delete buffer;
	 CloseHandle(rfile);
	 }
	 }
	}
	
	return nRetCode;
	}
试试其它关键字
　执行SQL文件　
同语言下
可能有用的
章毅明贡献的其它代码(8)