站内搜索
最近浏览
- WinCE Security...
- xdebug配置说明
- VC++ 获取文件的创建、修...
- ASP进度条
- 简单代理服务器C代码实现(S...
- 程序设计竞赛试题选(02)
- 如何在ASP程序中打印Acc...
- UTF-8和16进制区间
- ASP实用技巧:强制刷新和判...
- 运行中程序删除自己的方法
- asp提高首页性能的一个技巧
- [J2EE]J2EE 应用服务器技术
- VB变量命名规范
- C语言常见错误小结
- (摘自网络)如何在IIS中调...
推荐文章
热文排行
用SDK来操作数据库啊(VC++)
一个简单的例子:
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
#include <stdio.h>
#include <string>
using namespace std;
void insert() ;
void main(void)
{
insert();
}
void insert()
{
CoInitialize(NULL);
try
{
_ConnectionPtr pConn("ADODB.Connection");
_RecordsetPtr pRst("ADODB.Recordset");
// update data source & initila catalog , user id , pasword
pConn->Open("Provider=sqloledb;Data Source=192.168.53.141;Initial Catalog=MY_DB;User Id=sa;Password=;", "", "", adConnectUnspecified);
char tmp[256]={0,};
char level[2]={0,};
// update loginid, pass
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('SAUser','SAUser1','%c','','')" ,8); // 1000
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('CAUser','CAUser1','%c','','')" ,2); // 10
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('DAUser','DAUser1','%c','','')" ,4); // 100
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('CDAUser','CDAUser1','%c','','')" ,6); // 110
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
pRst->Close();
pConn->Close();
}
catch (_com_error &e)
{
printf("Description = '%s'\n", (char*) e.Description());
}
::CoUninitialize();
}
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
#include <stdio.h>
#include <string>
using namespace std;
void insert() ;
void main(void)
{
insert();
}
void insert()
{
CoInitialize(NULL);
try
{
_ConnectionPtr pConn("ADODB.Connection");
_RecordsetPtr pRst("ADODB.Recordset");
// update data source & initila catalog , user id , pasword
pConn->Open("Provider=sqloledb;Data Source=192.168.53.141;Initial Catalog=MY_DB;User Id=sa;Password=;", "", "", adConnectUnspecified);
char tmp[256]={0,};
char level[2]={0,};
// update loginid, pass
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('SAUser','SAUser1','%c','','')" ,8); // 1000
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('CAUser','CAUser1','%c','','')" ,2); // 10
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('DAUser','DAUser1','%c','','')" ,4); // 100
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
sprintf(tmp,"insert into Admin_User(loginid,pass,user_level,login_flag,dn) values('CDAUser','CDAUser1','%c','','')" ,6); // 110
pConn->Execute(_bstr_t(tmp),NULL,adExecuteNoRecords);
pRst->Close();
pConn->Close();
}
catch (_com_error &e)
{
printf("Description = '%s'\n", (char*) e.Description());
}
::CoUninitialize();
}
[wangjy17908]
添加时间:2008-06-20