oci数据库连接 和 插入语句 的源代码

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

#include "stdafx.h"
#include <string.h>
#include <oci.h>

int main(int argc, char* argv[])
{
OCIEnv *env;
OCIStmt *inserts;
OCIServer *server;
OCIError *err;
OCISvcCtx *svc;
OCISession *session;
OCIBind *bname;
char dbname[50];
char name[50];
char pwds[50];
char sql[100];
strcpy(sql, "insert into youtianyu(name) values('mahaoyun')");
strcpy(dbname, "ORCL_192.168.178.82");
strcpy(name, "scott");
strcpy(pwds, "tiger");
int myresult;
myresult = OCIEnvCreate(&env, OCI_THREADED | OCI_OBJECT, (dvoid *)0, 0, 0, 0, (size_t)0, (dvoid **)0);
if (myresult != OCI_SUCCESS)
{
fprintf(stderr, "\n 001      create env false\n");
return 0;

}
else
{
fprintf(stderr, "\n 001      create env success\n");
}
myresult = OCIHandleAlloc((dvoid *)env, (dvoid **)&err, OCI_HTYPE_ERROR, 0, NULL);
if (myresult != OCI_SUCCESS)
{
fprintf(stderr, "\n 002      create err false\n");
return 0;
}
else
{
fprintf(stderr, "\n 002      create err success\n");
}
myresult = OCIHandleAlloc((dvoid *)env, (dvoid **)&server, OCI_HTYPE_SERVER, 0, NULL);
if (myresult != OCI_SUCCESS)
{
fprintf(stderr, "\n 003      create server false\n");
return 0;
}
else
{
fprintf(stderr, "\n 003      create server success\n");
}
myresult = OCIServerAttach(server, err, (text *)dbname, strlen(dbname), OCI_DEFAULT);
if (myresult != OCI_SUCCESS)
{
fprintf(stderr, "\n 004      connect server false\n");
return 0;